PREVIEW / stock_1hour / 2009-01-23

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-01-23.parquet
  size:    832 KB
  rows:    42,186
  symbols: 3,312

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-23 04:00:00	AAPL	Stock	3.1161	3.1161	3.1071	3.1071	17080.0
2009-01-23 06:00:00	AAPL	Stock	3.1018	3.1018	3.1018	3.1018	5600.0
2009-01-23 07:00:00	AAPL	Stock	3.1071	3.1214	3.1071	3.1075	130340.0
2009-01-23 08:00:00	AAPL	Stock	3.1079	3.1264	3.0893	3.0932	2280236.0
2009-01-23 09:00:00	AAPL	Stock	3.0932	3.1382	3.0893	3.0896	120135652.0
2009-01-23 10:00:00	AAPL	Stock	3.0911	3.1429	3.0896	3.1189	112955500.0
2009-01-23 11:00:00	AAPL	Stock	3.1189	3.1664	3.1189	3.1404	116214084.0
2009-01-23 12:00:00	AAPL	Stock	3.14	3.1943	3.1393	3.175	87346980.0
2009-01-23 13:00:00	AAPL	Stock	3.1746	3.2004	3.1679	3.1939	86171008.0
2009-01-23 14:00:00	AAPL	Stock	3.1946	3.2096	3.1575	3.1632	96395488.0
2009-01-23 15:00:00	AAPL	Stock	3.1632	3.1696	3.1429	3.1561	117333720.0
2009-01-23 16:00:00	AAPL	Stock	3.1561	3.194	3.1429	3.1486	17206924.0
2009-01-23 17:00:00	AAPL	Stock	3.1482	3.1507	3.1482	3.1507	7280.0
2009-01-23 18:00:00	AAPL	Stock	3.1557	3.1557	3.1486	3.1546	4303656.0
2009-01-23 19:00:00	AAPL	Stock	3.1546	3.1546	3.1457	3.15	92204.0
2009-01-23 04:00:00	MSFT	Stock	17.11	17.11	16.85	16.85	900.0
2009-01-23 06:00:00	MSFT	Stock	16.88	16.88	16.88	16.88	100.0
2009-01-23 07:00:00	MSFT	Stock	17.0	17.07	16.97	16.97	19615.0
2009-01-23 08:00:00	MSFT	Stock	16.97	17.05	16.77	16.8	399994.0
2009-01-23 09:00:00	MSFT	Stock	16.8	17.48	16.72	17.37	19358135.0
2009-01-23 10:00:00	MSFT	Stock	17.38	17.49	17.19	17.21	21753237.0
2009-01-23 11:00:00	MSFT	Stock	17.22	17.43	17.21	17.28	13630051.0
2009-01-23 12:00:00	MSFT	Stock	17.28	17.39	17.16	17.28	14876709.0
2009-01-23 13:00:00	MSFT	Stock	17.28	17.49	17.23	17.47	12415028.0
2009-01-23 14:00:00	MSFT	Stock	17.471	17.49	17.26	17.27	10258274.0
2009-01-23 15:00:00	MSFT	Stock	17.27	17.37	17.16	17.19	17050633.0
2009-01-23 16:00:00	MSFT	Stock	17.18	17.456	17.14	17.2	3822102.0
2009-01-23 17:00:00	MSFT	Stock	17.22	17.24	17.2	17.23	143948.0
2009-01-23 18:00:00	MSFT	Stock	17.24	17.25	17.19	17.25	193337.0
2009-01-23 19:00:00	MSFT	Stock	17.24	17.25	17.22	17.22	5700.0
2009-01-23 08:00:00	NVDA	Stock	0.18	0.18	0.18	0.18	26000.0
2009-01-23 09:00:00	NVDA	Stock	0.18	0.1898	0.18	0.1878	84919680.0
2009-01-23 10:00:00	NVDA	Stock	0.1878	0.1925	0.1875	0.1905	131654960.0
2009-01-23 11:00:00	NVDA	Stock	0.1908	0.1972	0.1908	0.195	90233120.0
2009-01-23 12:00:00	NVDA	Stock	0.1952	0.1962	0.1926	0.1935	50089760.0
2009-01-23 13:00:00	NVDA	Stock	0.1935	0.1975	0.1928	0.1975	68533800.0
2009-01-23 14:00:00	NVDA	Stock	0.1975	0.1985	0.192	0.1928	55858960.0
2009-01-23 15:00:00	NVDA	Stock	0.193	0.1948	0.1915	0.1928	129849480.0
2009-01-23 16:00:00	NVDA	Stock	0.192	0.1945	0.1883	0.1928	8093320.0
2009-01-23 17:00:00	NVDA	Stock	0.1926	0.1926	0.1926	0.1926	6296000.0
2009-01-23 18:00:00	NVDA	Stock	0.1928	0.1928	0.1928	0.1928	569040.0
2009-01-23 19:00:00	NVDA	Stock	0.1905	0.1905	0.1905	0.1905	4000.0
2009-01-23 07:00:00	AMZN	Stock	2.45	2.45	2.45	2.45	4000.0
2009-01-23 08:00:00	AMZN	Stock	2.4505	2.4505	2.415	2.415	311240.0
2009-01-23 09:00:00	AMZN	Stock	2.415	2.504	2.413	2.4895	14253960.0
2009-01-23 10:00:00	AMZN	Stock	2.4875	2.5265	2.4765	2.4955	21680720.0
2009-01-23 11:00:00	AMZN	Stock	2.496	2.547	2.493	2.502	16838920.0
2009-01-23 12:00:00	AMZN	Stock	2.503	2.545	2.5	2.516	14325220.0
2009-01-23 13:00:00	AMZN	Stock	2.515	2.561	2.503	2.56	12702000.0
2009-01-23 14:00:00	AMZN	Stock	2.561	2.571	2.5175	2.521	13330880.0

> showing 50 of 42,186 rows — these rows as CSV

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