PREVIEW / stock_1hour / 2006-10-06

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-10-06.parquet
  size:    607 KB
  rows:    28,882
  symbols: 2,379

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-10-06 08:00:00	AAPL	Stock	2.6661	2.6714	2.6607	2.6611	1135372.0
2006-10-06 09:00:00	AAPL	Stock	2.6607	2.6679	2.6421	2.6664	75542488.0
2006-10-06 10:00:00	AAPL	Stock	2.6657	2.68	2.6561	2.6736	98054264.0
2006-10-06 11:00:00	AAPL	Stock	2.6732	2.6736	2.6525	2.6593	44536436.0
2006-10-06 12:00:00	AAPL	Stock	2.6593	2.6621	2.6482	2.6611	36963500.0
2006-10-06 13:00:00	AAPL	Stock	2.6611	2.6632	2.6504	2.6517	38174640.0
2006-10-06 14:00:00	AAPL	Stock	2.6516	2.655	2.6482	2.6493	51347576.0
2006-10-06 15:00:00	AAPL	Stock	2.6489	2.6589	2.6361	2.6504	106181684.0
2006-10-06 16:00:00	AAPL	Stock	2.6514	2.6589	2.6504	2.6536	1233820.0
2006-10-06 17:00:00	AAPL	Stock	2.6536	2.6564	2.6536	2.6539	102060.0
2006-10-06 18:00:00	AAPL	Stock	2.6536	2.6561	2.6536	2.6561	44800.0
2006-10-06 19:00:00	AAPL	Stock	2.6568	2.6568	2.6568	2.6568	5600.0
2006-10-06 07:00:00	MSFT	Stock	27.92	27.92	27.92	27.92	1000.0
2006-10-06 08:00:00	MSFT	Stock	27.92	27.92	27.8	27.8	35500.0
2006-10-06 09:00:00	MSFT	Stock	27.8	27.84	27.7	27.75	3855188.0
2006-10-06 10:00:00	MSFT	Stock	27.758	27.9	27.73	27.84	6033605.0
2006-10-06 11:00:00	MSFT	Stock	27.84	27.86	27.74	27.75	3314944.0
2006-10-06 12:00:00	MSFT	Stock	27.75	27.81	27.65	27.77	3208402.0
2006-10-06 13:00:00	MSFT	Stock	27.77	27.84	27.75	27.822	2262238.0
2006-10-06 14:00:00	MSFT	Stock	27.822	27.97	27.81	27.93	5288321.0
2006-10-06 15:00:00	MSFT	Stock	27.93	28.0	27.8	27.9	10617072.0
2006-10-06 16:00:00	MSFT	Stock	27.89	27.94	27.832	27.93	101750.0
2006-10-06 17:00:00	MSFT	Stock	27.94	27.94	27.876	27.876	1827.0
2006-10-06 18:00:00	MSFT	Stock	27.93	27.93	27.89	27.93	9300.0
2006-10-06 19:00:00	MSFT	Stock	27.89	27.89	27.88	27.88	812.0
2006-10-06 08:00:00	NVDA	Stock	0.5033	0.5117	0.5033	0.5063	1937400.0
2006-10-06 09:00:00	NVDA	Stock	0.5063	0.5167	0.5017	0.5152	112611120.0
2006-10-06 10:00:00	NVDA	Stock	0.5152	0.5208	0.5105	0.5155	175905960.0
2006-10-06 11:00:00	NVDA	Stock	0.5158	0.5182	0.5125	0.5134	49827300.0
2006-10-06 12:00:00	NVDA	Stock	0.5137	0.5138	0.5095	0.513	49038660.0
2006-10-06 13:00:00	NVDA	Stock	0.5133	0.5155	0.5128	0.5148	30169140.0
2006-10-06 14:00:00	NVDA	Stock	0.5147	0.5185	0.5137	0.5173	64864680.0
2006-10-06 15:00:00	NVDA	Stock	0.5173	0.5175	0.5123	0.515	90048000.0
2006-10-06 16:00:00	NVDA	Stock	0.5157	0.5175	0.515	0.5172	895020.0
2006-10-06 17:00:00	NVDA	Stock	0.5172	0.5172	0.5167	0.5168	72000.0
2006-10-06 19:00:00	NVDA	Stock	0.5167	0.5167	0.5167	0.5167	60000.0
2006-10-06 08:00:00	AMZN	Stock	1.665	1.665	1.654	1.654	92000.0
2006-10-06 09:00:00	AMZN	Stock	1.654	1.6609	1.6415	1.647	10096740.0
2006-10-06 10:00:00	AMZN	Stock	1.6474	1.6475	1.6275	1.632	14484580.0
2006-10-06 11:00:00	AMZN	Stock	1.6315	1.6365	1.6275	1.6295	9964080.0
2006-10-06 12:00:00	AMZN	Stock	1.6295	1.636	1.6275	1.6345	9718240.0
2006-10-06 13:00:00	AMZN	Stock	1.635	1.635	1.6285	1.633	7543540.0
2006-10-06 14:00:00	AMZN	Stock	1.6328	1.6415	1.63	1.6385	10359000.0
2006-10-06 15:00:00	AMZN	Stock	1.6385	1.639	1.625	1.63	15517500.0
2006-10-06 16:00:00	AMZN	Stock	1.6255	1.6315	1.6255	1.6295	226380.0
2006-10-06 08:00:00	CL	Stock	31.445	31.445	31.445	31.445	2000.0
2006-10-06 09:00:00	CL	Stock	31.35	31.43	31.25	31.37	198400.0
2006-10-06 10:00:00	CL	Stock	31.37	31.375	31.205	31.26	479400.0
2006-10-06 11:00:00	CL	Stock	31.27	31.48	31.23	31.395	478000.0
2006-10-06 12:00:00	CL	Stock	31.4	31.485	31.375	31.47	348600.0

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

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