PREVIEW / stock_1hour / 2008-12-18

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-12-18.parquet
  size:    802 KB
  rows:    40,570
  symbols: 3,348

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
2008-12-18 04:00:00	AAPL	Stock	3.2111	3.2111	3.2111	3.2111	5600.0
2008-12-18 05:00:00	AAPL	Stock	3.1929	3.1929	3.1929	3.1929	2800.0
2008-12-18 06:00:00	AAPL	Stock	3.2107	3.2107	3.2107	3.2107	2800.0
2008-12-18 07:00:00	AAPL	Stock	3.2064	3.2068	3.1789	3.1961	78456.0
2008-12-18 08:00:00	AAPL	Stock	3.1982	3.2064	3.1846	3.2004	1773688.0
2008-12-18 09:00:00	AAPL	Stock	3.2004	3.2321	3.1586	3.2186	136328388.0
2008-12-18 10:00:00	AAPL	Stock	3.22	3.2439	3.2036	3.2275	135957164.0
2008-12-18 11:00:00	AAPL	Stock	3.2272	3.2275	3.1918	3.2207	78089368.0
2008-12-18 12:00:00	AAPL	Stock	3.2214	3.2314	3.2089	3.2307	63973336.0
2008-12-18 13:00:00	AAPL	Stock	3.2307	3.2396	3.2036	3.2136	79955904.0
2008-12-18 14:00:00	AAPL	Stock	3.2136	3.2275	3.1989	3.2096	116103680.0
2008-12-18 15:00:00	AAPL	Stock	3.2086	3.2161	3.1689	3.1932	191294432.0
2008-12-18 16:00:00	AAPL	Stock	3.197	3.2679	3.1939	3.2036	42030632.0
2008-12-18 17:00:00	AAPL	Stock	3.2068	3.2089	3.1964	3.2036	598556.0
2008-12-18 18:00:00	AAPL	Stock	3.2036	3.2064	3.1939	3.1989	950908.0
2008-12-18 19:00:00	AAPL	Stock	3.1989	3.2096	3.1989	3.2096	305032.0
2008-12-18 07:00:00	MSFT	Stock	19.88	19.88	19.88	19.88	100.0
2008-12-18 08:00:00	MSFT	Stock	19.63	19.89	19.63	19.85	6480.0
2008-12-18 09:00:00	MSFT	Stock	19.84	20.02	19.72	19.81	6566566.0
2008-12-18 10:00:00	MSFT	Stock	19.802	19.93	19.77	19.826	12247869.0
2008-12-18 11:00:00	MSFT	Stock	19.82	19.86	19.75	19.86	6862266.0
2008-12-18 12:00:00	MSFT	Stock	19.86	19.87	19.77	19.77	5378534.0
2008-12-18 13:00:00	MSFT	Stock	19.78	19.8	19.47	19.48	8956589.0
2008-12-18 14:00:00	MSFT	Stock	19.48	19.58	19.35	19.448	10470428.0
2008-12-18 15:00:00	MSFT	Stock	19.45	19.45	18.99	19.31	22163508.0
2008-12-18 16:00:00	MSFT	Stock	19.33	19.754	19.205	19.3	6829941.0
2008-12-18 17:00:00	MSFT	Stock	19.39	19.43	19.35	19.43	5827.0
2008-12-18 18:00:00	MSFT	Stock	19.43	19.45	19.3	19.44	35946.0
2008-12-18 19:00:00	MSFT	Stock	19.44	19.45	19.4	19.41	5256.0
2008-12-18 07:00:00	NVDA	Stock	0.225	0.225	0.225	0.225	4000.0
2008-12-18 08:00:00	NVDA	Stock	0.2312	0.2345	0.2312	0.2345	44000.0
2008-12-18 09:00:00	NVDA	Stock	0.2325	0.2338	0.2215	0.223	67373240.0
2008-12-18 10:00:00	NVDA	Stock	0.2232	0.2255	0.22	0.2215	76114720.0
2008-12-18 11:00:00	NVDA	Stock	0.2215	0.2218	0.2188	0.221	43560480.0
2008-12-18 12:00:00	NVDA	Stock	0.221	0.221	0.2163	0.2163	67595840.0
2008-12-18 13:00:00	NVDA	Stock	0.2165	0.2165	0.2145	0.2145	42097480.0
2008-12-18 14:00:00	NVDA	Stock	0.2148	0.2158	0.2112	0.2144	70368720.0
2008-12-18 15:00:00	NVDA	Stock	0.2143	0.2143	0.2088	0.2115	154378280.0
2008-12-18 16:00:00	NVDA	Stock	0.2112	0.2172	0.211	0.213	7185960.0
2008-12-18 17:00:00	NVDA	Stock	0.213	0.213	0.213	0.213	16000.0
2008-12-18 18:00:00	NVDA	Stock	0.2143	0.2143	0.21	0.21	222000.0
2008-12-18 19:00:00	NVDA	Stock	0.2092	0.2092	0.2092	0.2092	76000.0
2008-12-18 08:00:00	AMZN	Stock	2.6285	2.665	2.6265	2.65	60000.0
2008-12-18 09:00:00	AMZN	Stock	2.65	2.706	2.637	2.6735	18290760.0
2008-12-18 10:00:00	AMZN	Stock	2.6725	2.719	2.6705	2.7135	24500080.0
2008-12-18 11:00:00	AMZN	Stock	2.713	2.7425	2.6715	2.717	18682060.0
2008-12-18 12:00:00	AMZN	Stock	2.719	2.7195	2.6955	2.707	11197800.0
2008-12-18 13:00:00	AMZN	Stock	2.7075	2.7164	2.6615	2.6708	10706220.0
2008-12-18 14:00:00	AMZN	Stock	2.67	2.6835	2.6385	2.653	13547900.0
2008-12-18 15:00:00	AMZN	Stock	2.6515	2.652	2.56	2.604	44998000.0

> showing 50 of 40,570 rows — these rows as CSV

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