PREVIEW / stock_30min / 2009-01-26

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-01-26.parquet
  size:    1.2 MB
  rows:    68,776
  symbols: 3,306

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2009-01-26 06:30:00	AAPL	Stock	3.1875	3.1875	3.1875	3.1875	28000.0
2009-01-26 07:00:00	AAPL	Stock	3.1875	3.1975	3.1875	3.1975	14000.0
2009-01-26 07:30:00	AAPL	Stock	3.1696	3.17	3.1543	3.1543	16800.0
2009-01-26 08:00:00	AAPL	Stock	3.1536	3.1707	3.1486	3.1632	123060.0
2009-01-26 08:30:00	AAPL	Stock	3.1607	3.1821	3.1607	3.1782	286944.0
2009-01-26 09:00:00	AAPL	Stock	3.1771	3.2029	3.1671	3.1743	2220820.0
2009-01-26 09:30:00	AAPL	Stock	3.1746	3.2275	3.165	3.2064	90230000.0
2009-01-26 10:00:00	AAPL	Stock	3.2057	3.2489	3.2057	3.2439	70185976.0
2009-01-26 10:30:00	AAPL	Stock	3.2443	3.2464	3.2082	3.2164	47087852.0
2009-01-26 11:00:00	AAPL	Stock	3.2161	3.2268	3.2054	3.2186	34410852.0
2009-01-26 11:30:00	AAPL	Stock	3.2191	3.2229	3.205	3.2117	28524272.0
2009-01-26 12:00:00	AAPL	Stock	3.2118	3.2379	3.2118	3.2346	35860636.0
2009-01-26 12:30:00	AAPL	Stock	3.2346	3.2361	3.2125	3.225	38743964.0
2009-01-26 13:00:00	AAPL	Stock	3.225	3.2318	3.2114	3.2207	40426540.0
2009-01-26 13:30:00	AAPL	Stock	3.2207	3.2211	3.1961	3.2007	40317312.0
2009-01-26 14:00:00	AAPL	Stock	3.1996	3.2018	3.1536	3.18	71574160.0
2009-01-26 14:30:00	AAPL	Stock	3.1814	3.2107	3.18	3.2061	50318576.0
2009-01-26 15:00:00	AAPL	Stock	3.2061	3.2268	3.2008	3.2132	52613820.0
2009-01-26 15:30:00	AAPL	Stock	3.2136	3.2186	3.1868	3.2018	67957372.0
2009-01-26 16:00:00	AAPL	Stock	3.2014	3.2268	3.1957	3.1957	12390728.0
2009-01-26 16:30:00	AAPL	Stock	3.1979	3.2111	3.1975	3.2018	634172.0
2009-01-26 17:00:00	AAPL	Stock	3.2018	3.2018	3.1971	3.2014	2795660.0
2009-01-26 17:30:00	AAPL	Stock	3.227	3.227	3.1982	3.2	44548.0
2009-01-26 18:00:00	AAPL	Stock	3.1982	3.2089	3.1982	3.2018	6851544.0
2009-01-26 18:30:00	AAPL	Stock	3.2068	3.2107	3.2014	3.21	122416.0
2009-01-26 19:00:00	AAPL	Stock	3.2064	3.21	3.2036	3.205	38948.0
2009-01-26 19:30:00	AAPL	Stock	3.205	3.2054	3.1961	3.1964	168812.0
2009-01-26 07:00:00	MSFT	Stock	17.3	17.3	17.29	17.3	2800.0
2009-01-26 07:30:00	MSFT	Stock	17.2	17.2	17.19	17.2	1496.0
2009-01-26 08:00:00	MSFT	Stock	17.25	17.25	17.15	17.2	12625.0
2009-01-26 08:30:00	MSFT	Stock	17.2	17.29	17.2	17.25	53592.0
2009-01-26 09:00:00	MSFT	Stock	17.27	17.35	17.22	17.26	114067.0
2009-01-26 09:30:00	MSFT	Stock	17.28	17.51	17.23	17.501	9180837.0
2009-01-26 10:00:00	MSFT	Stock	17.51	17.8	17.501	17.78	7821899.0
2009-01-26 10:30:00	MSFT	Stock	17.78	17.81	17.63	17.66	6999398.0
2009-01-26 11:00:00	MSFT	Stock	17.67	17.71	17.61	17.7	3834083.0
2009-01-26 11:30:00	MSFT	Stock	17.7	17.76	17.67	17.73	3918934.0
2009-01-26 12:00:00	MSFT	Stock	17.73	17.795	17.7	17.778	3926888.0
2009-01-26 12:30:00	MSFT	Stock	17.77	17.8	17.7	17.715	4137788.0
2009-01-26 13:00:00	MSFT	Stock	17.712	17.78	17.5	17.55	6076731.0
2009-01-26 13:30:00	MSFT	Stock	17.54	17.55	17.42	17.47	4050140.0
2009-01-26 14:00:00	MSFT	Stock	17.47	17.48	17.27	17.31	5674499.0
2009-01-26 14:30:00	MSFT	Stock	17.31	17.46	17.26	17.45	3904551.0
2009-01-26 15:00:00	MSFT	Stock	17.45	17.65	17.42	17.59	5366348.0
2009-01-26 15:30:00	MSFT	Stock	17.58	17.63	17.46	17.6	9175917.0
2009-01-26 16:00:00	MSFT	Stock	17.58	17.74	17.52	17.63	13938751.0
2009-01-26 16:30:00	MSFT	Stock	17.54	17.63	17.54	17.56	820773.0
2009-01-26 17:00:00	MSFT	Stock	17.54	17.57	17.53	17.57	500.0
2009-01-26 17:30:00	MSFT	Stock	17.645	17.645	17.56	17.56	30415.0
2009-01-26 18:00:00	MSFT	Stock	17.56	17.63	17.56	17.56	626054.0

> showing 50 of 68,776 rows — these rows as CSV

> unlock the full archive -- $79 one-time