PREVIEW / stock_1hour / 2008-12-19

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-12-19.parquet
  size:    873 KB
  rows:    43,265
  symbols: 3,389

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-19 07:00:00	AAPL	Stock	3.1896	3.1896	3.1896	3.1896	40600.0
2008-12-19 08:00:00	AAPL	Stock	3.2111	3.2214	3.1786	3.2207	6494488.0
2008-12-19 09:00:00	AAPL	Stock	3.2214	3.2479	3.1939	3.2161	182170044.0
2008-12-19 10:00:00	AAPL	Stock	3.2168	3.23	3.2039	3.2096	109431560.0
2008-12-19 11:00:00	AAPL	Stock	3.2096	3.2171	3.1904	3.1921	73230836.0
2008-12-19 12:00:00	AAPL	Stock	3.1921	3.2	3.1764	3.1914	69898864.0
2008-12-19 13:00:00	AAPL	Stock	3.1911	3.2136	3.1714	3.2061	78930488.0
2008-12-19 14:00:00	AAPL	Stock	3.2057	3.2179	3.1779	3.205	76079388.0
2008-12-19 15:00:00	AAPL	Stock	3.2046	3.2114	3.1893	3.2107	137380488.0
2008-12-19 16:00:00	AAPL	Stock	3.2107	3.2161	3.2016	3.2139	52934448.0
2008-12-19 17:00:00	AAPL	Stock	3.2143	3.2154	3.2077	3.2143	2874676.0
2008-12-19 18:00:00	AAPL	Stock	3.2121	3.2125	3.2111	3.2118	70000.0
2008-12-19 19:00:00	AAPL	Stock	3.2139	3.2145	3.2125	3.2139	12974528.0
2008-12-19 07:00:00	MSFT	Stock	19.56	19.56	19.49	19.49	550.0
2008-12-19 08:00:00	MSFT	Stock	19.4	19.52	19.3	19.4	489370.0
2008-12-19 09:00:00	MSFT	Stock	19.39	19.7	19.25	19.55	6479802.0
2008-12-19 10:00:00	MSFT	Stock	19.55	19.8	19.51	19.67	13467028.0
2008-12-19 11:00:00	MSFT	Stock	19.67	19.69	19.495	19.54	7658823.0
2008-12-19 12:00:00	MSFT	Stock	19.54	19.568	19.28	19.31	6431941.0
2008-12-19 13:00:00	MSFT	Stock	19.32	19.5	19.31	19.47	6163593.0
2008-12-19 14:00:00	MSFT	Stock	19.47	19.55	19.21	19.25	7700264.0
2008-12-19 15:00:00	MSFT	Stock	19.26	19.29	19.11	19.12	18795243.0
2008-12-19 16:00:00	MSFT	Stock	19.11	19.543	19.1	19.12	23331235.0
2008-12-19 17:00:00	MSFT	Stock	19.12	19.436	19.11	19.15	1261759.0
2008-12-19 18:00:00	MSFT	Stock	19.15	19.16	19.15	19.16	22978.0
2008-12-19 19:00:00	MSFT	Stock	19.17	19.22	19.126	19.22	1879743.0
2008-12-19 09:00:00	NVDA	Stock	0.2163	0.2225	0.2125	0.2152	114703320.0
2008-12-19 10:00:00	NVDA	Stock	0.2152	0.221	0.215	0.2185	93866240.0
2008-12-19 11:00:00	NVDA	Stock	0.2188	0.2195	0.215	0.215	49551480.0
2008-12-19 12:00:00	NVDA	Stock	0.2152	0.216	0.213	0.2143	41099320.0
2008-12-19 13:00:00	NVDA	Stock	0.2144	0.2175	0.2143	0.2165	24498640.0
2008-12-19 14:00:00	NVDA	Stock	0.2163	0.2172	0.2145	0.2153	35047680.0
2008-12-19 15:00:00	NVDA	Stock	0.2155	0.2158	0.2122	0.213	106257200.0
2008-12-19 16:00:00	NVDA	Stock	0.2128	0.2145	0.2115	0.2131	28067240.0
2008-12-19 17:00:00	NVDA	Stock	0.213	0.2158	0.213	0.2158	1001040.0
2008-12-19 08:00:00	AMZN	Stock	2.56	2.58	2.55	2.5725	160140.0
2008-12-19 09:00:00	AMZN	Stock	2.5675	2.607	2.55	2.5795	36094060.0
2008-12-19 10:00:00	AMZN	Stock	2.5795	2.6495	2.575	2.615	24305900.0
2008-12-19 11:00:00	AMZN	Stock	2.6145	2.625	2.5905	2.5945	14035680.0
2008-12-19 12:00:00	AMZN	Stock	2.5945	2.598	2.5675	2.574	14762680.0
2008-12-19 13:00:00	AMZN	Stock	2.574	2.5765	2.56	2.5725	11833600.0
2008-12-19 14:00:00	AMZN	Stock	2.5735	2.588	2.559	2.57	10952860.0
2008-12-19 15:00:00	AMZN	Stock	2.57	2.604	2.546	2.565	54266260.0
2008-12-19 16:00:00	AMZN	Stock	2.565	2.578	2.5625	2.5778	6333680.0
2008-12-19 17:00:00	AMZN	Stock	2.578	2.582	2.569	2.5765	233960.0
2008-12-19 18:00:00	AMZN	Stock	2.5732	2.5765	2.5732	2.5765	26000.0
2008-12-19 19:00:00	AMZN	Stock	2.5765	2.5765	2.5765	2.5765	12000.0
2008-12-19 08:00:00	TLT	Stock	122.1	122.11	121.4	121.63	7994.0
2008-12-19 09:00:00	TLT	Stock	121.45	121.87	121.28	121.82	295980.0
2008-12-19 10:00:00	TLT	Stock	121.81	122.26	121.47	121.68	449649.0

> showing 50 of 43,265 rows — these rows as CSV

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