PREVIEW / stock_1hour / 2006-05-09

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-05-09.parquet
  size:    612 KB
  rows:    29,351
  symbols: 2,264

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-09 07:00:00	AAPL	Stock	2.5607	2.575	2.5607	2.575	42000.0
2006-05-09 08:00:00	AAPL	Stock	2.575	2.575	2.5546	2.5664	1393672.0
2006-05-09 09:00:00	AAPL	Stock	2.5654	2.5914	2.5525	2.5746	83025068.0
2006-05-09 10:00:00	AAPL	Stock	2.5754	2.5811	2.5546	2.5564	93632448.0
2006-05-09 11:00:00	AAPL	Stock	2.5568	2.5729	2.5475	2.5546	72071076.0
2006-05-09 12:00:00	AAPL	Stock	2.5543	2.5568	2.5468	2.5486	37153592.0
2006-05-09 13:00:00	AAPL	Stock	2.5486	2.5496	2.5221	2.5279	96667452.0
2006-05-09 14:00:00	AAPL	Stock	2.5275	2.5432	2.5229	2.5393	70419580.0
2006-05-09 15:00:00	AAPL	Stock	2.5393	2.5425	2.5293	2.5368	66009580.0
2006-05-09 16:00:00	AAPL	Stock	2.5368	2.5504	2.5329	2.5407	2545704.0
2006-05-09 17:00:00	AAPL	Stock	2.5414	2.5421	2.5321	2.5375	602448.0
2006-05-09 18:00:00	AAPL	Stock	2.5357	2.5389	2.5357	2.5389	57400.0
2006-05-09 07:00:00	MSFT	Stock	23.77	23.77	23.77	23.77	100.0
2006-05-09 08:00:00	MSFT	Stock	23.76	23.76	23.66	23.7	1348986.0
2006-05-09 09:00:00	MSFT	Stock	23.7	24.0	23.5	23.55	10329124.0
2006-05-09 10:00:00	MSFT	Stock	23.55	23.78	23.49	23.78	18832379.0
2006-05-09 11:00:00	MSFT	Stock	23.78	23.88	23.74	23.8	9539361.0
2006-05-09 12:00:00	MSFT	Stock	23.8	23.84	23.71	23.738	6264874.0
2006-05-09 13:00:00	MSFT	Stock	23.73	23.8	23.65	23.72	4849967.0
2006-05-09 14:00:00	MSFT	Stock	23.72	23.8	23.68	23.74	7138367.0
2006-05-09 15:00:00	MSFT	Stock	23.74	23.754	23.62	23.63	9156228.0
2006-05-09 16:00:00	MSFT	Stock	23.63	23.718	23.579	23.65	6256996.0
2006-05-09 17:00:00	MSFT	Stock	23.65	23.68	23.62	23.66	140078.0
2006-05-09 18:00:00	MSFT	Stock	23.547	23.63	23.547	23.63	650778.0
2006-05-09 08:00:00	NVDA	Stock	0.5127	0.5167	0.51	0.5167	1133760.0
2006-05-09 09:00:00	NVDA	Stock	0.5152	0.521	0.51	0.5107	61739220.0
2006-05-09 10:00:00	NVDA	Stock	0.5107	0.5123	0.5067	0.5095	95966940.0
2006-05-09 11:00:00	NVDA	Stock	0.5097	0.5133	0.5075	0.5112	79980000.0
2006-05-09 12:00:00	NVDA	Stock	0.5112	0.5123	0.5095	0.51	39444720.0
2006-05-09 13:00:00	NVDA	Stock	0.5098	0.51	0.5073	0.508	38425200.0
2006-05-09 14:00:00	NVDA	Stock	0.508	0.5093	0.5065	0.5075	72673920.0
2006-05-09 15:00:00	NVDA	Stock	0.5077	0.5078	0.5025	0.5025	145109940.0
2006-05-09 16:00:00	NVDA	Stock	0.5038	0.5092	0.5023	0.5032	8359620.0
2006-05-09 17:00:00	NVDA	Stock	0.5038	0.5038	0.502	0.502	436440.0
2006-05-09 18:00:00	NVDA	Stock	0.5055	0.5055	0.5055	0.5055	60000.0
2006-05-09 09:00:00	AMZN	Stock	1.7255	1.7345	1.7105	1.722	7806060.0
2006-05-09 10:00:00	AMZN	Stock	1.7215	1.7565	1.7215	1.7345	18291660.0
2006-05-09 11:00:00	AMZN	Stock	1.7345	1.7515	1.7345	1.7465	9849600.0
2006-05-09 12:00:00	AMZN	Stock	1.7465	1.7475	1.721	1.724	7648820.0
2006-05-09 13:00:00	AMZN	Stock	1.724	1.7525	1.7235	1.733	11631440.0
2006-05-09 14:00:00	AMZN	Stock	1.7335	1.747	1.724	1.7325	13727060.0
2006-05-09 15:00:00	AMZN	Stock	1.732	1.763	1.726	1.7415	35383140.0
2006-05-09 16:00:00	AMZN	Stock	1.741	1.745	1.726	1.741	1633700.0
2006-05-09 18:00:00	AMZN	Stock	1.7445	1.7445	1.7418	1.7418	17840.0
2006-05-09 09:00:00	CL	Stock	30.405	30.465	30.21	30.295	504200.0
2006-05-09 10:00:00	CL	Stock	30.3	30.35	29.95	29.955	908600.0
2006-05-09 11:00:00	CL	Stock	29.96	29.965	29.73	29.915	860600.0
2006-05-09 12:00:00	CL	Stock	29.92	29.955	29.885	29.885	288400.0
2006-05-09 13:00:00	CL	Stock	29.895	29.955	29.865	29.95	195800.0
2006-05-09 14:00:00	CL	Stock	29.95	30.0	29.885	29.985	296600.0

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

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