PREVIEW / stock_1hour / 2006-09-06

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-09-06.parquet
  size:    611 KB
  rows:    29,754
  symbols: 2,358

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-09-06 07:00:00	AAPL	Stock	2.5536	2.5554	2.5411	2.5411	298200.0
2006-09-06 08:00:00	AAPL	Stock	2.5504	2.5621	2.5375	2.5407	6205164.0
2006-09-06 09:00:00	AAPL	Stock	2.5407	2.5511	2.5196	2.5246	149603636.0
2006-09-06 10:00:00	AAPL	Stock	2.5246	2.5514	2.5232	2.5454	179073244.0
2006-09-06 11:00:00	AAPL	Stock	2.5454	2.5604	2.5293	2.5314	142568020.0
2006-09-06 12:00:00	AAPL	Stock	2.5314	2.5429	2.5286	2.5357	67130756.0
2006-09-06 13:00:00	AAPL	Stock	2.5357	2.5393	2.5232	2.5339	63502684.0
2006-09-06 14:00:00	AAPL	Stock	2.5336	2.5386	2.5021	2.5071	133448952.0
2006-09-06 15:00:00	AAPL	Stock	2.5068	2.5118	2.4893	2.5007	184508268.0
2006-09-06 16:00:00	AAPL	Stock	2.5011	2.5018	2.4975	2.5011	20753992.0
2006-09-06 17:00:00	AAPL	Stock	2.5011	2.5011	2.4975	2.5	550844.0
2006-09-06 18:00:00	AAPL	Stock	2.4986	2.5	2.4986	2.5	112728.0
2006-09-06 07:00:00	MSFT	Stock	25.57	25.57	25.57	25.57	100.0
2006-09-06 08:00:00	MSFT	Stock	25.6	25.63	25.57	25.6	3297305.0
2006-09-06 09:00:00	MSFT	Stock	25.61	25.72	25.48	25.64	17010269.0
2006-09-06 10:00:00	MSFT	Stock	25.64	25.68	25.6	25.62	5045143.0
2006-09-06 11:00:00	MSFT	Stock	25.63	25.64	25.58	25.6	3804549.0
2006-09-06 12:00:00	MSFT	Stock	25.6	25.66	25.58	25.64	2919829.0
2006-09-06 13:00:00	MSFT	Stock	25.64	25.68	25.59	25.64	2437139.0
2006-09-06 14:00:00	MSFT	Stock	25.64	25.7	25.59	25.61	5670390.0
2006-09-06 15:00:00	MSFT	Stock	25.61	25.64	25.56	25.6	9138663.0
2006-09-06 16:00:00	MSFT	Stock	25.61	25.63	25.6	25.61	136510.0
2006-09-06 17:00:00	MSFT	Stock	25.61	25.63	25.608	25.61	18737.0
2006-09-06 18:00:00	MSFT	Stock	25.61	25.63	25.61	25.61	1200.0
2006-09-06 08:00:00	NVDA	Stock	0.4692	0.4692	0.4668	0.4688	156000.0
2006-09-06 09:00:00	NVDA	Stock	0.4675	0.4683	0.4613	0.4622	49972440.0
2006-09-06 10:00:00	NVDA	Stock	0.4622	0.4667	0.4602	0.4602	72310200.0
2006-09-06 11:00:00	NVDA	Stock	0.4602	0.4625	0.46	0.4603	42355080.0
2006-09-06 12:00:00	NVDA	Stock	0.4602	0.461	0.457	0.4572	65776560.0
2006-09-06 13:00:00	NVDA	Stock	0.4572	0.459	0.4558	0.4582	65447460.0
2006-09-06 14:00:00	NVDA	Stock	0.4582	0.4593	0.4512	0.4518	69226320.0
2006-09-06 15:00:00	NVDA	Stock	0.452	0.4542	0.45	0.4512	92467800.0
2006-09-06 16:00:00	NVDA	Stock	0.4512	0.4512	0.45	0.45	241560.0
2006-09-06 17:00:00	NVDA	Stock	0.4512	0.4512	0.4372	0.4467	7308420.0
2006-09-06 18:00:00	NVDA	Stock	0.4457	0.4467	0.4445	0.4445	135000.0
2006-09-06 08:00:00	AMZN	Stock	1.5975	1.5975	1.5915	1.5925	260800.0
2006-09-06 09:00:00	AMZN	Stock	1.594	1.599	1.575	1.576	19434580.0
2006-09-06 10:00:00	AMZN	Stock	1.576	1.584	1.5605	1.57	31944680.0
2006-09-06 11:00:00	AMZN	Stock	1.5695	1.5705	1.5535	1.5535	19735880.0
2006-09-06 12:00:00	AMZN	Stock	1.5535	1.5555	1.5435	1.544	24695980.0
2006-09-06 13:00:00	AMZN	Stock	1.544	1.561	1.5415	1.55	25305180.0
2006-09-06 14:00:00	AMZN	Stock	1.55	1.5535	1.538	1.5415	19434980.0
2006-09-06 15:00:00	AMZN	Stock	1.5415	1.551	1.5325	1.539	35591480.0
2006-09-06 16:00:00	AMZN	Stock	1.54	1.5574	1.538	1.538	200720.0
2006-09-06 17:00:00	AMZN	Stock	1.535	1.541	1.535	1.535	48120.0
2006-09-06 18:00:00	AMZN	Stock	1.544	1.5445	1.544	1.5445	23500.0
2006-09-06 09:00:00	CL	Stock	30.325	30.4	30.265	30.29	252800.0
2006-09-06 10:00:00	CL	Stock	30.29	30.325	30.25	30.25	523600.0
2006-09-06 11:00:00	CL	Stock	30.26	30.35	30.245	30.325	341800.0
2006-09-06 12:00:00	CL	Stock	30.33	30.39	30.305	30.385	411000.0

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

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