PREVIEW / stock_1hour / 2006-08-16

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-08-16.parquet
  size:    597 KB
  rows:    28,608
  symbols: 2,329

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-08-16 07:00:00	AAPL	Stock	2.375	2.3754	2.375	2.3754	33600.0
2006-08-16 08:00:00	AAPL	Stock	2.3732	2.3921	2.3714	2.3893	6223084.0
2006-08-16 09:00:00	AAPL	Stock	2.3889	2.4036	2.3714	2.3818	129177020.0
2006-08-16 10:00:00	AAPL	Stock	2.3814	2.39	2.3689	2.3871	116417336.0
2006-08-16 11:00:00	AAPL	Stock	2.3871	2.4025	2.3714	2.395	92052212.0
2006-08-16 12:00:00	AAPL	Stock	2.3954	2.43	2.3939	2.4139	147318080.0
2006-08-16 13:00:00	AAPL	Stock	2.4143	2.425	2.4007	2.4089	63009688.0
2006-08-16 14:00:00	AAPL	Stock	2.4093	2.4264	2.3986	2.4154	76873776.0
2006-08-16 15:00:00	AAPL	Stock	2.4154	2.4311	2.4143	2.4296	128764832.0
2006-08-16 16:00:00	AAPL	Stock	2.4293	2.4393	2.4215	2.43	7436408.0
2006-08-16 17:00:00	AAPL	Stock	2.4279	2.4357	2.4279	2.4357	3249960.0
2006-08-16 18:00:00	AAPL	Stock	2.4339	2.4357	2.4339	2.4357	210896.0
2006-08-16 08:00:00	MSFT	Stock	24.62	24.67	24.55	24.66	88824.0
2006-08-16 09:00:00	MSFT	Stock	24.65	24.65	24.47	24.58	7337919.0
2006-08-16 10:00:00	MSFT	Stock	24.58	24.64	24.53	24.6	10553189.0
2006-08-16 11:00:00	MSFT	Stock	24.6	24.637	24.56	24.623	7912210.0
2006-08-16 12:00:00	MSFT	Stock	24.62	24.72	24.59	24.65	6975065.0
2006-08-16 13:00:00	MSFT	Stock	24.65	24.72	24.6	24.693	3187458.0
2006-08-16 14:00:00	MSFT	Stock	24.69	24.73	24.62	24.69	5228546.0
2006-08-16 15:00:00	MSFT	Stock	24.69	24.73	24.68	24.73	9312702.0
2006-08-16 16:00:00	MSFT	Stock	24.72	24.75	24.7	24.73	142103.0
2006-08-16 17:00:00	MSFT	Stock	24.72	24.74	24.72	24.73	8500.0
2006-08-16 18:00:00	MSFT	Stock	24.73	24.75	24.73	24.75	3675.0
2006-08-16 08:00:00	NVDA	Stock	0.4267	0.4298	0.4238	0.4292	1175400.0
2006-08-16 09:00:00	NVDA	Stock	0.4303	0.4317	0.4177	0.4178	115511040.0
2006-08-16 10:00:00	NVDA	Stock	0.4178	0.4287	0.4167	0.4279	155067960.0
2006-08-16 11:00:00	NVDA	Stock	0.428	0.431	0.4258	0.4297	95751300.0
2006-08-16 12:00:00	NVDA	Stock	0.4297	0.4427	0.4295	0.4383	132936480.0
2006-08-16 13:00:00	NVDA	Stock	0.4385	0.4402	0.436	0.4383	97302420.0
2006-08-16 14:00:00	NVDA	Stock	0.4383	0.4512	0.4382	0.4505	174595680.0
2006-08-16 15:00:00	NVDA	Stock	0.4504	0.4577	0.4495	0.4562	209355900.0
2006-08-16 16:00:00	NVDA	Stock	0.4563	0.4577	0.4542	0.4577	10936980.0
2006-08-16 17:00:00	NVDA	Stock	0.4577	0.46	0.4567	0.4583	285000.0
2006-08-16 18:00:00	NVDA	Stock	0.4572	0.4572	0.4572	0.4572	12000.0
2006-08-16 08:00:00	AMZN	Stock	1.3945	1.404	1.3945	1.4035	185000.0
2006-08-16 09:00:00	AMZN	Stock	1.4035	1.407	1.3885	1.396	27333160.0
2006-08-16 10:00:00	AMZN	Stock	1.396	1.3965	1.376	1.384	22533120.0
2006-08-16 11:00:00	AMZN	Stock	1.3835	1.3885	1.381	1.387	10032460.0
2006-08-16 12:00:00	AMZN	Stock	1.387	1.39	1.386	1.3885	12649660.0
2006-08-16 13:00:00	AMZN	Stock	1.3885	1.3915	1.384	1.389	13592200.0
2006-08-16 14:00:00	AMZN	Stock	1.3885	1.3955	1.388	1.3925	24376400.0
2006-08-16 15:00:00	AMZN	Stock	1.3925	1.401	1.391	1.3975	34296380.0
2006-08-16 16:00:00	AMZN	Stock	1.396	1.3985	1.396	1.396	186000.0
2006-08-16 09:00:00	CL	Stock	29.95	30.045	29.825	29.895	411400.0
2006-08-16 10:00:00	CL	Stock	29.9	29.955	29.88	29.89	510800.0
2006-08-16 11:00:00	CL	Stock	29.885	29.925	29.825	29.834	604200.0
2006-08-16 12:00:00	CL	Stock	29.835	29.855	29.8	29.82	341000.0
2006-08-16 13:00:00	CL	Stock	29.82	29.83	29.785	29.82	389200.0
2006-08-16 14:00:00	CL	Stock	29.815	29.84	29.785	29.835	531600.0
2006-08-16 15:00:00	CL	Stock	29.835	29.945	29.835	29.89	954200.0

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

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