PREVIEW / stock_1hour / 2006-05-08

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-05-08.parquet
  size:    623 KB
  rows:    29,420
  symbols: 2,266

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-08 05:00:00	AAPL	Stock	2.575	2.575	2.575	2.575	8400.0
2006-05-08 06:00:00	AAPL	Stock	2.5786	2.5839	2.5786	2.5839	22400.0
2006-05-08 07:00:00	AAPL	Stock	2.5893	2.5893	2.5893	2.5893	2800.0
2006-05-08 08:00:00	AAPL	Stock	2.5893	2.6186	2.5839	2.6111	10516212.0
2006-05-08 09:00:00	AAPL	Stock	2.61	2.6357	2.5829	2.5975	152119632.0
2006-05-08 10:00:00	AAPL	Stock	2.5979	2.6054	2.5889	2.5896	86579668.0
2006-05-08 11:00:00	AAPL	Stock	2.5893	2.5929	2.5682	2.5778	91624064.0
2006-05-08 12:00:00	AAPL	Stock	2.5771	2.595	2.5714	2.5925	55041140.0
2006-05-08 13:00:00	AAPL	Stock	2.5925	2.5928	2.5782	2.5857	38336648.0
2006-05-08 14:00:00	AAPL	Stock	2.5857	2.5929	2.5725	2.5775	51722020.0
2006-05-08 15:00:00	AAPL	Stock	2.5776	2.5793	2.5614	2.5661	98100128.0
2006-05-08 16:00:00	AAPL	Stock	2.5664	2.57	2.5489	2.55	3857280.0
2006-05-08 17:00:00	AAPL	Stock	2.55	2.5604	2.5489	2.5536	201796.0
2006-05-08 18:00:00	AAPL	Stock	2.5543	2.5561	2.5543	2.5554	70700.0
2006-05-08 07:00:00	MSFT	Stock	23.95	23.95	23.9	23.91	14800.0
2006-05-08 08:00:00	MSFT	Stock	23.93	23.94	23.85	23.85	814452.0
2006-05-08 09:00:00	MSFT	Stock	23.88	25.0	23.7	23.72	9408782.0
2006-05-08 10:00:00	MSFT	Stock	23.72	23.75	23.58	23.61	11241453.0
2006-05-08 11:00:00	MSFT	Stock	23.61	23.721	23.51	23.6	13187792.0
2006-05-08 12:00:00	MSFT	Stock	23.599	23.86	23.57	23.65	6837233.0
2006-05-08 13:00:00	MSFT	Stock	23.65	23.71	23.59	23.59	5893675.0
2006-05-08 14:00:00	MSFT	Stock	23.6	23.65	23.55	23.58	6402967.0
2006-05-08 15:00:00	MSFT	Stock	23.59	23.76	23.57	23.73	20976972.0
2006-05-08 16:00:00	MSFT	Stock	23.73	23.79	23.6	23.68	2685030.0
2006-05-08 17:00:00	MSFT	Stock	23.68	23.74	23.66	23.68	22411.0
2006-05-08 18:00:00	MSFT	Stock	23.7	23.7	23.68	23.68	3745.0
2006-05-08 08:00:00	NVDA	Stock	0.5213	0.523	0.52	0.52	131100.0
2006-05-08 09:00:00	NVDA	Stock	0.52	0.521	0.5142	0.5182	59617380.0
2006-05-08 10:00:00	NVDA	Stock	0.518	0.5313	0.5163	0.5267	131948280.0
2006-05-08 11:00:00	NVDA	Stock	0.5267	0.5313	0.5265	0.5273	80740680.0
2006-05-08 12:00:00	NVDA	Stock	0.5273	0.5283	0.5212	0.5225	47204820.0
2006-05-08 13:00:00	NVDA	Stock	0.5223	0.5233	0.519	0.519	34946640.0
2006-05-08 14:00:00	NVDA	Stock	0.5188	0.5212	0.5178	0.5202	42064980.0
2006-05-08 15:00:00	NVDA	Stock	0.5202	0.5233	0.5167	0.5188	82180140.0
2006-05-08 16:00:00	NVDA	Stock	0.5192	0.5225	0.5133	0.515	3557460.0
2006-05-08 17:00:00	NVDA	Stock	0.515	0.519	0.515	0.515	281100.0
2006-05-08 08:00:00	AMZN	Stock	1.745	1.75	1.745	1.747	16000.0
2006-05-08 09:00:00	AMZN	Stock	1.7445	1.7605	1.7315	1.76	12215800.0
2006-05-08 10:00:00	AMZN	Stock	1.7595	1.7655	1.732	1.7325	11855020.0
2006-05-08 11:00:00	AMZN	Stock	1.7325	1.75	1.727	1.7325	5250940.0
2006-05-08 12:00:00	AMZN	Stock	1.733	1.739	1.7325	1.7325	7526820.0
2006-05-08 13:00:00	AMZN	Stock	1.7325	1.733	1.7255	1.7315	14387620.0
2006-05-08 14:00:00	AMZN	Stock	1.7315	1.732	1.7235	1.727	9862880.0
2006-05-08 15:00:00	AMZN	Stock	1.727	1.7405	1.7245	1.735	19310880.0
2006-05-08 16:00:00	AMZN	Stock	1.7355	1.7355	1.7305	1.734	157000.0
2006-05-08 17:00:00	AMZN	Stock	1.734	1.734	1.725	1.725	20000.0
2006-05-08 18:00:00	AMZN	Stock	1.727	1.727	1.727	1.727	6840.0
2006-05-08 09:00:00	CL	Stock	30.075	30.35	30.075	30.325	502000.0
2006-05-08 10:00:00	CL	Stock	30.335	30.475	30.245	30.28	791200.0
2006-05-08 11:00:00	CL	Stock	30.28	30.365	30.26	30.305	367800.0

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

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