PREVIEW / stock_1hour / 2006-06-22

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-06-22.parquet
  size:    591 KB
  rows:    28,438
  symbols: 2,281

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-06-22 07:00:00	AAPL	Stock	2.0732	2.075	2.0732	2.0732	81200.0
2006-06-22 08:00:00	AAPL	Stock	2.0711	2.0732	2.0646	2.0671	1518720.0
2006-06-22 09:00:00	AAPL	Stock	2.0679	2.1161	2.0664	2.1154	169696884.0
2006-06-22 10:00:00	AAPL	Stock	2.1154	2.1225	2.0957	2.1014	197140804.0
2006-06-22 11:00:00	AAPL	Stock	2.1014	2.1125	2.095	2.0997	122538864.0
2006-06-22 12:00:00	AAPL	Stock	2.0996	2.1081	2.09	2.0986	77898156.0
2006-06-22 13:00:00	AAPL	Stock	2.0979	2.1068	2.0932	2.1043	65772616.0
2006-06-22 14:00:00	AAPL	Stock	2.1043	2.1214	2.0982	2.1189	116072880.0
2006-06-22 15:00:00	AAPL	Stock	2.1189	2.1339	2.1125	2.1296	204244544.0
2006-06-22 16:00:00	AAPL	Stock	2.1296	2.1304	2.1271	2.1304	3908856.0
2006-06-22 17:00:00	AAPL	Stock	2.1282	2.1329	2.1282	2.1329	159600.0
2006-06-22 18:00:00	AAPL	Stock	2.1321	2.1364	2.1318	2.1364	284928.0
2006-06-22 07:00:00	MSFT	Stock	23.11	23.11	23.11	23.11	100.0
2006-06-22 08:00:00	MSFT	Stock	23.09	23.12	23.03	23.08	13223.0
2006-06-22 09:00:00	MSFT	Stock	23.1	23.17	23.03	23.12	10072936.0
2006-06-22 10:00:00	MSFT	Stock	23.12	23.13	22.99	23.03	13457736.0
2006-06-22 11:00:00	MSFT	Stock	23.02	23.03	22.86	22.95	12162243.0
2006-06-22 12:00:00	MSFT	Stock	22.96	22.96	22.79	22.85	7892375.0
2006-06-22 13:00:00	MSFT	Stock	22.85	22.89	22.79	22.82	5415708.0
2006-06-22 14:00:00	MSFT	Stock	22.82	22.91	22.78	22.84	7255534.0
2006-06-22 15:00:00	MSFT	Stock	22.85	23.1	22.84	22.88	13173582.0
2006-06-22 16:00:00	MSFT	Stock	22.87	22.963	22.81	22.89	735230.0
2006-06-22 17:00:00	MSFT	Stock	22.89	22.89	22.83	22.88	4016468.0
2006-06-22 18:00:00	MSFT	Stock	22.87	22.87	22.86	22.87	1600.0
2006-06-22 08:00:00	NVDA	Stock	0.3507	0.353	0.3507	0.3525	348000.0
2006-06-22 09:00:00	NVDA	Stock	0.3523	0.3533	0.3433	0.3457	42804960.0
2006-06-22 10:00:00	NVDA	Stock	0.3457	0.3458	0.3392	0.3412	83498280.0
2006-06-22 11:00:00	NVDA	Stock	0.3412	0.3425	0.3395	0.3398	47858640.0
2006-06-22 12:00:00	NVDA	Stock	0.34	0.3422	0.3397	0.3405	53632980.0
2006-06-22 13:00:00	NVDA	Stock	0.3403	0.3405	0.336	0.3368	56028360.0
2006-06-22 14:00:00	NVDA	Stock	0.3368	0.3405	0.336	0.3383	102710220.0
2006-06-22 15:00:00	NVDA	Stock	0.3383	0.3395	0.3368	0.338	122171760.0
2006-06-22 16:00:00	NVDA	Stock	0.3383	0.3417	0.3378	0.3417	4566000.0
2006-06-22 17:00:00	NVDA	Stock	0.3397	0.3397	0.3383	0.3383	27048000.0
2006-06-22 18:00:00	NVDA	Stock	0.3395	0.3395	0.3395	0.3395	12000.0
2006-06-22 08:00:00	AMZN	Stock	1.8325	1.8325	1.83	1.83	12000.0
2006-06-22 09:00:00	AMZN	Stock	1.826	1.8426	1.8195	1.834	17120180.0
2006-06-22 10:00:00	AMZN	Stock	1.8345	1.835	1.819	1.823	13332860.0
2006-06-22 11:00:00	AMZN	Stock	1.823	1.832	1.8205	1.831	7892280.0
2006-06-22 12:00:00	AMZN	Stock	1.831	1.8375	1.8175	1.819	10471080.0
2006-06-22 13:00:00	AMZN	Stock	1.8185	1.827	1.814	1.827	12190160.0
2006-06-22 14:00:00	AMZN	Stock	1.8255	1.832	1.8055	1.8145	13819060.0
2006-06-22 15:00:00	AMZN	Stock	1.8145	1.824	1.8085	1.8195	13683920.0
2006-06-22 16:00:00	AMZN	Stock	1.8195	1.8285	1.8185	1.82	355720.0
2006-06-22 09:00:00	CL	Stock	30.17	30.2	30.035	30.13	181200.0
2006-06-22 10:00:00	CL	Stock	30.135	30.15	30.02	30.07	258400.0
2006-06-22 11:00:00	CL	Stock	30.065	30.065	29.93	30.0035	362400.0
2006-06-22 12:00:00	CL	Stock	30.0	30.035	29.93	30.035	308000.0
2006-06-22 13:00:00	CL	Stock	30.03	30.04	29.925	30.035	339800.0
2006-06-22 14:00:00	CL	Stock	30.035	30.045	29.953	30.0	319800.0

> showing 50 of 28,438 rows — these rows as CSV

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