PREVIEW / stock_1hour / 2006-05-10

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-05-10.parquet
  size:    619 KB
  rows:    29,397
  symbols: 2,250

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-05-10 04:00:00	AAPL	Stock	2.5386	2.5386	2.5386	2.5386	64400.0
2006-05-10 08:00:00	AAPL	Stock	2.5393	2.5443	2.5357	2.54	367668.0
2006-05-10 09:00:00	AAPL	Stock	2.5407	2.5475	2.5179	2.5442	61153288.0
2006-05-10 10:00:00	AAPL	Stock	2.5444	2.5468	2.525	2.5286	65331168.0
2006-05-10 11:00:00	AAPL	Stock	2.5286	2.5375	2.5268	2.5336	26929532.0
2006-05-10 12:00:00	AAPL	Stock	2.5332	2.535	2.5243	2.5246	31187212.0
2006-05-10 13:00:00	AAPL	Stock	2.5246	2.5257	2.5086	2.5204	46251100.0
2006-05-10 14:00:00	AAPL	Stock	2.52	2.5264	2.4861	2.5114	132604472.0
2006-05-10 15:00:00	AAPL	Stock	2.5114	2.53	2.5079	2.5214	87308172.0
2006-05-10 16:00:00	AAPL	Stock	2.52	2.5268	2.5186	2.5246	963144.0
2006-05-10 17:00:00	AAPL	Stock	2.5232	2.5232	2.5212	2.5212	15260.0
2006-05-10 18:00:00	AAPL	Stock	2.5243	2.5243	2.5214	2.5214	106624.0
2006-05-10 08:00:00	MSFT	Stock	23.74	23.74	23.67	23.7	38909.0
2006-05-10 09:00:00	MSFT	Stock	23.7	23.76	23.63	23.69	5099179.0
2006-05-10 10:00:00	MSFT	Stock	23.68	23.72	23.62	23.66	7762998.0
2006-05-10 11:00:00	MSFT	Stock	23.66	23.75	23.66	23.67	7636626.0
2006-05-10 12:00:00	MSFT	Stock	23.67	23.7	23.61	23.64	9246296.0
2006-05-10 13:00:00	MSFT	Stock	23.65	23.7	23.59	23.64	12488439.0
2006-05-10 14:00:00	MSFT	Stock	23.65	23.74	23.59	23.67	14897725.0
2006-05-10 15:00:00	MSFT	Stock	23.66	23.79	23.59	23.751	16333182.0
2006-05-10 16:00:00	MSFT	Stock	23.75	23.78	23.72	23.72	1849601.0
2006-05-10 17:00:00	MSFT	Stock	23.71	23.76	23.7	23.758	9029.0
2006-05-10 18:00:00	MSFT	Stock	23.71	23.73	23.7	23.71	1261.0
2006-05-10 08:00:00	NVDA	Stock	0.5002	0.5002	0.4967	0.4975	1413780.0
2006-05-10 09:00:00	NVDA	Stock	0.4975	0.4998	0.491	0.4968	138610080.0
2006-05-10 10:00:00	NVDA	Stock	0.4967	0.503	0.4928	0.4938	110660340.0
2006-05-10 11:00:00	NVDA	Stock	0.4938	0.4947	0.4898	0.4908	90528180.0
2006-05-10 12:00:00	NVDA	Stock	0.4908	0.4938	0.489	0.4927	58346100.0
2006-05-10 13:00:00	NVDA	Stock	0.4928	0.4932	0.4903	0.4908	43379760.0
2006-05-10 14:00:00	NVDA	Stock	0.4907	0.4942	0.487	0.4925	120311880.0
2006-05-10 15:00:00	NVDA	Stock	0.4927	0.4947	0.49	0.4915	150950940.0
2006-05-10 16:00:00	NVDA	Stock	0.4917	0.4921	0.4917	0.4918	13010760.0
2006-05-10 17:00:00	NVDA	Stock	0.492	0.4953	0.4917	0.4953	564000.0
2006-05-10 18:00:00	NVDA	Stock	0.4953	0.4953	0.4915	0.4915	132000.0
2006-05-10 09:00:00	AMZN	Stock	1.743	1.75	1.7338	1.748	4727440.0
2006-05-10 10:00:00	AMZN	Stock	1.748	1.748	1.7295	1.73	6240080.0
2006-05-10 11:00:00	AMZN	Stock	1.73	1.7345	1.73	1.7325	3558980.0
2006-05-10 12:00:00	AMZN	Stock	1.732	1.7351	1.73	1.734	5376460.0
2006-05-10 13:00:00	AMZN	Stock	1.734	1.734	1.7255	1.729	3307480.0
2006-05-10 14:00:00	AMZN	Stock	1.729	1.732	1.71	1.723	21555400.0
2006-05-10 15:00:00	AMZN	Stock	1.7225	1.7265	1.705	1.708	19005860.0
2006-05-10 16:00:00	AMZN	Stock	1.707	1.708	1.705	1.705	290300.0
2006-05-10 09:00:00	CL	Stock	29.95	29.98	29.85	29.895	362400.0
2006-05-10 10:00:00	CL	Stock	29.9	29.905	29.715	29.75	666800.0
2006-05-10 11:00:00	CL	Stock	29.76	29.89	29.75	29.88	409200.0
2006-05-10 12:00:00	CL	Stock	29.885	29.965	29.865	29.9	301400.0
2006-05-10 13:00:00	CL	Stock	29.905	29.95	29.905	29.93	376000.0
2006-05-10 14:00:00	CL	Stock	29.93	29.94	29.8	29.84	783600.0
2006-05-10 15:00:00	CL	Stock	29.83	29.86	29.7	29.745	1059600.0

> showing 49 of 29,397 rows — these rows as CSV

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