PREVIEW / stock_1hour / 2006-05-04

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-05-04.parquet
  size:    599 KB
  rows:    28,306
  symbols: 2,261

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-04 08:00:00	AAPL	Stock	2.5393	2.55	2.5393	2.5443	1081052.0
2006-05-04 09:00:00	AAPL	Stock	2.5446	2.5996	2.5357	2.5979	170556400.0
2006-05-04 10:00:00	AAPL	Stock	2.5971	2.6032	2.5646	2.5657	165457460.0
2006-05-04 11:00:00	AAPL	Stock	2.5657	2.5854	2.5654	2.5775	70671720.0
2006-05-04 12:00:00	AAPL	Stock	2.5771	2.5789	2.5164	2.5371	157897992.0
2006-05-04 13:00:00	AAPL	Stock	2.5364	2.5596	2.5364	2.5561	73365208.0
2006-05-04 14:00:00	AAPL	Stock	2.5561	2.5639	2.5407	2.5532	80969308.0
2006-05-04 15:00:00	AAPL	Stock	2.5532	2.5564	2.5339	2.5397	79854852.0
2006-05-04 16:00:00	AAPL	Stock	2.5411	2.5411	2.5382	2.54	28857276.0
2006-05-04 17:00:00	AAPL	Stock	2.54	2.5411	2.5382	2.5407	228760.0
2006-05-04 18:00:00	AAPL	Stock	2.5393	2.5407	2.5393	2.5407	63000.0
2006-05-04 06:00:00	MSFT	Stock	23.36	23.36	23.36	23.36	200.0
2006-05-04 07:00:00	MSFT	Stock	23.36	23.36	23.27	23.3	26300.0
2006-05-04 08:00:00	MSFT	Stock	23.31	23.37	23.28	23.35	440285.0
2006-05-04 09:00:00	MSFT	Stock	23.35	23.67	23.14	23.49	23634899.0
2006-05-04 10:00:00	MSFT	Stock	23.49	23.55	23.26	23.3	32018953.0
2006-05-04 11:00:00	MSFT	Stock	23.3	23.36	23.2	23.32	23620464.0
2006-05-04 12:00:00	MSFT	Stock	23.32	23.42	23.27	23.38	20558732.0
2006-05-04 13:00:00	MSFT	Stock	23.38	23.48	23.35	23.45	14503624.0
2006-05-04 14:00:00	MSFT	Stock	23.46	23.55	23.42	23.48	21876243.0
2006-05-04 15:00:00	MSFT	Stock	23.48	23.51	23.42	23.44	21843093.0
2006-05-04 16:00:00	MSFT	Stock	23.43	23.54	23.27	23.46	8639592.0
2006-05-04 17:00:00	MSFT	Stock	23.49	23.56	23.44	23.55	60981.0
2006-05-04 18:00:00	MSFT	Stock	23.54	23.55	23.5	23.51	8594.0
2006-05-04 08:00:00	NVDA	Stock	0.5168	0.5168	0.5017	0.508	2900400.0
2006-05-04 09:00:00	NVDA	Stock	0.5078	0.5162	0.5048	0.5123	84874200.0
2006-05-04 10:00:00	NVDA	Stock	0.5123	0.5123	0.5087	0.5093	80667180.0
2006-05-04 11:00:00	NVDA	Stock	0.5095	0.5118	0.5085	0.5117	63309780.0
2006-05-04 12:00:00	NVDA	Stock	0.5117	0.5117	0.5085	0.5108	42490740.0
2006-05-04 13:00:00	NVDA	Stock	0.5108	0.5157	0.5108	0.5147	70120020.0
2006-05-04 14:00:00	NVDA	Stock	0.5145	0.52	0.51	0.517	62497980.0
2006-05-04 15:00:00	NVDA	Stock	0.517	0.5195	0.5133	0.5147	88512660.0
2006-05-04 16:00:00	NVDA	Stock	0.5133	0.5153	0.5133	0.5152	186240.0
2006-05-04 17:00:00	NVDA	Stock	0.515	0.5165	0.5142	0.5142	376500.0
2006-05-04 05:00:00	AMZN	Stock	1.72	1.725	1.72	1.725	32000.0
2006-05-04 07:00:00	AMZN	Stock	1.7325	1.7325	1.7275	1.7275	22000.0
2006-05-04 08:00:00	AMZN	Stock	1.7285	1.7285	1.72	1.7205	319060.0
2006-05-04 09:00:00	AMZN	Stock	1.722	1.736	1.7205	1.7305	32122200.0
2006-05-04 10:00:00	AMZN	Stock	1.73	1.735	1.719	1.7255	30256200.0
2006-05-04 11:00:00	AMZN	Stock	1.7255	1.73	1.7205	1.725	14414560.0
2006-05-04 12:00:00	AMZN	Stock	1.7248	1.7255	1.7215	1.725	7642520.0
2006-05-04 13:00:00	AMZN	Stock	1.725	1.732	1.724	1.7245	8665040.0
2006-05-04 14:00:00	AMZN	Stock	1.725	1.7285	1.722	1.726	9195780.0
2006-05-04 15:00:00	AMZN	Stock	1.7265	1.728	1.7195	1.724	13486760.0
2006-05-04 16:00:00	AMZN	Stock	1.724	1.7265	1.723	1.725	49940.0
2006-05-04 17:00:00	AMZN	Stock	1.725	1.725	1.725	1.725	20000.0
2006-05-04 08:00:00	CL	Stock	29.675	29.675	29.675	29.675	1200.0
2006-05-04 09:00:00	CL	Stock	29.545	29.85	29.545	29.8	356600.0
2006-05-04 10:00:00	CL	Stock	29.795	29.885	29.715	29.73	495200.0
2006-05-04 11:00:00	CL	Stock	29.715	29.97	29.675	29.96	768400.0

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

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