PREVIEW / stock_1hour / 2006-07-24

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-07-24.parquet
  size:    601 KB
  rows:    29,129
  symbols: 2,319

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
2006-07-24 08:00:00	AAPL	Stock	2.1857	2.1893	2.1786	2.1875	1311604.0
2006-07-24 09:00:00	AAPL	Stock	2.1875	2.2179	2.1768	2.1829	129598672.0
2006-07-24 10:00:00	AAPL	Stock	2.1825	2.1929	2.1657	2.1729	145486488.0
2006-07-24 11:00:00	AAPL	Stock	2.1729	2.1857	2.1582	2.175	129441760.0
2006-07-24 12:00:00	AAPL	Stock	2.1754	2.18	2.1679	2.1757	64714244.0
2006-07-24 13:00:00	AAPL	Stock	2.1757	2.1832	2.1707	2.1786	62765248.0
2006-07-24 14:00:00	AAPL	Stock	2.1782	2.1911	2.1757	2.1879	59689028.0
2006-07-24 15:00:00	AAPL	Stock	2.1879	2.1961	2.1861	2.1961	99272432.0
2006-07-24 16:00:00	AAPL	Stock	2.1961	2.2057	2.1932	2.1979	13086304.0
2006-07-24 17:00:00	AAPL	Stock	2.1971	2.2046	2.1968	2.1971	423780.0
2006-07-24 18:00:00	AAPL	Stock	2.1968	2.1986	2.1961	2.1971	135296.0
2006-07-24 08:00:00	MSFT	Stock	23.95	24.03	23.92	24.0	123869.0
2006-07-24 09:00:00	MSFT	Stock	23.99	24.07	23.79	23.94	10100046.0
2006-07-24 10:00:00	MSFT	Stock	23.94	24.11	23.92	24.1	9909427.0
2006-07-24 11:00:00	MSFT	Stock	24.11	24.11	23.96	24.02	5139012.0
2006-07-24 12:00:00	MSFT	Stock	24.02	24.03	23.85	23.85	6734418.0
2006-07-24 13:00:00	MSFT	Stock	23.86	23.88	23.79	23.82	6404725.0
2006-07-24 14:00:00	MSFT	Stock	23.81	24.0	23.81	23.95	6264517.0
2006-07-24 15:00:00	MSFT	Stock	23.95	24.05	23.92	23.98	9984023.0
2006-07-24 16:00:00	MSFT	Stock	24.0	24.04	23.951	24.0	1455081.0
2006-07-24 17:00:00	MSFT	Stock	24.03	24.05	24.0	24.05	1281965.0
2006-07-24 18:00:00	MSFT	Stock	24.05	24.05	24.05	24.05	100.0
2006-07-24 06:00:00	NVDA	Stock	0.2933	0.2933	0.2933	0.2933	300000.0
2006-07-24 07:00:00	NVDA	Stock	0.2937	0.3017	0.29	0.29	443520.0
2006-07-24 08:00:00	NVDA	Stock	0.2903	0.3217	0.2873	0.3142	15261780.0
2006-07-24 09:00:00	NVDA	Stock	0.3128	0.32	0.305	0.3128	170297280.0
2006-07-24 10:00:00	NVDA	Stock	0.313	0.3202	0.3125	0.3188	167731920.0
2006-07-24 11:00:00	NVDA	Stock	0.3188	0.3335	0.3182	0.3248	161219700.0
2006-07-24 12:00:00	NVDA	Stock	0.3248	0.325	0.3173	0.3215	129586500.0
2006-07-24 13:00:00	NVDA	Stock	0.3215	0.3233	0.3202	0.3215	51939960.0
2006-07-24 14:00:00	NVDA	Stock	0.3213	0.323	0.3197	0.3228	82212120.0
2006-07-24 15:00:00	NVDA	Stock	0.3228	0.3273	0.3228	0.3263	146433960.0
2006-07-24 16:00:00	NVDA	Stock	0.3262	0.3323	0.3202	0.3308	9412560.0
2006-07-24 17:00:00	NVDA	Stock	0.3292	0.3333	0.3292	0.3333	27345780.0
2006-07-24 18:00:00	NVDA	Stock	0.3333	0.3333	0.3263	0.3312	497880.0
2006-07-24 08:00:00	AMZN	Stock	1.675	1.675	1.675	1.675	6000.0
2006-07-24 09:00:00	AMZN	Stock	1.6625	1.6935	1.6625	1.6765	14854340.0
2006-07-24 10:00:00	AMZN	Stock	1.676	1.7025	1.6725	1.6885	19044000.0
2006-07-24 11:00:00	AMZN	Stock	1.689	1.734	1.6855	1.724	31653120.0
2006-07-24 12:00:00	AMZN	Stock	1.725	1.725	1.7125	1.7185	12770120.0
2006-07-24 13:00:00	AMZN	Stock	1.7185	1.72	1.697	1.698	14865560.0
2006-07-24 14:00:00	AMZN	Stock	1.6985	1.717	1.695	1.7145	16486020.0
2006-07-24 15:00:00	AMZN	Stock	1.715	1.7265	1.709	1.7155	32618960.0
2006-07-24 16:00:00	AMZN	Stock	1.7155	1.7165	1.7059	1.7135	294020.0
2006-07-24 17:00:00	AMZN	Stock	1.7135	1.7325	1.7135	1.7325	128440.0
2006-07-24 18:00:00	AMZN	Stock	1.7155	1.718	1.7155	1.718	20380.0
2006-07-24 09:00:00	CL	Stock	31.05	31.15	30.75	31.12	339400.0
2006-07-24 10:00:00	CL	Stock	31.125	31.2	31.07	31.165	383200.0
2006-07-24 11:00:00	CL	Stock	31.165	31.19	31.07	31.125	514400.0
2006-07-24 12:00:00	CL	Stock	31.125	31.14	31.045	31.12	399000.0

> showing 50 of 29,129 rows — these rows as CSV

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