PREVIEW / stock_1hour / 2010-01-04

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-01-04.parquet
  size:    920 KB
  rows:    43,718
  symbols: 3,455

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
2010-01-04 04:00:00	AAPL	Stock	7.5707	7.5886	7.5707	7.5886	8400.0
2010-01-04 05:00:00	AAPL	Stock	7.595	7.6	7.5921	7.5921	11200.0
2010-01-04 06:00:00	AAPL	Stock	7.5964	7.5964	7.5964	7.5964	2800.0
2010-01-04 07:00:00	AAPL	Stock	7.5818	7.6204	7.5818	7.6071	562912.0
2010-01-04 08:00:00	AAPL	Stock	7.6054	7.6104	7.5307	7.6071	5141136.0
2010-01-04 09:00:00	AAPL	Stock	7.6054	7.6586	7.5261	7.6179	121532376.0
2010-01-04 10:00:00	AAPL	Stock	7.62	7.6364	7.585	7.6196	104254248.0
2010-01-04 11:00:00	AAPL	Stock	7.6193	7.6414	7.6086	7.6371	53221168.0
2010-01-04 12:00:00	AAPL	Stock	7.6379	7.6529	7.625	7.6446	41791876.0
2010-01-04 13:00:00	AAPL	Stock	7.6443	7.6475	7.6257	7.6289	33373536.0
2010-01-04 14:00:00	AAPL	Stock	7.6289	7.6532	7.6264	7.6425	37359560.0
2010-01-04 15:00:00	AAPL	Stock	7.6421	7.6607	7.6386	7.6493	78596112.0
2010-01-04 16:00:00	AAPL	Stock	7.6507	7.6725	7.6213	7.6675	11594828.0
2010-01-04 17:00:00	AAPL	Stock	7.665	7.6729	7.6629	7.6729	734580.0
2010-01-04 18:00:00	AAPL	Stock	7.6729	7.6746	7.6432	7.6746	1015812.0
2010-01-04 19:00:00	AAPL	Stock	7.6732	7.6786	7.6643	7.6654	1098664.0
2010-01-04 04:00:00	MSFT	Stock	30.7	30.7	30.7	30.7	1000.0
2010-01-04 05:00:00	MSFT	Stock	30.73	30.75	30.73	30.75	1200.0
2010-01-04 06:00:00	MSFT	Stock	30.75	30.75	30.75	30.75	300.0
2010-01-04 07:00:00	MSFT	Stock	30.79	30.79	30.75	30.75	1200.0
2010-01-04 08:00:00	MSFT	Stock	30.71	30.79	30.48	30.68	453198.0
2010-01-04 09:00:00	MSFT	Stock	30.7	30.97	30.57	30.9	5329131.0
2010-01-04 10:00:00	MSFT	Stock	30.91	31.0	30.87	30.96	6109243.0
2010-01-04 11:00:00	MSFT	Stock	30.96	31.08	30.96	31.05	4574397.0
2010-01-04 12:00:00	MSFT	Stock	31.04	31.08	31.01	31.015	2668253.0
2010-01-04 13:00:00	MSFT	Stock	31.03	31.04	30.95	30.96	3189155.0
2010-01-04 14:00:00	MSFT	Stock	30.955	31.09	30.95	31.07	2958983.0
2010-01-04 15:00:00	MSFT	Stock	31.072	31.1	30.93	30.94	7331645.0
2010-01-04 16:00:00	MSFT	Stock	30.94	31.02	30.9	30.9	4632372.0
2010-01-04 17:00:00	MSFT	Stock	30.9	30.93	30.9	30.93	2013.0
2010-01-04 18:00:00	MSFT	Stock	30.95	30.95	30.9	30.92	10377.0
2010-01-04 19:00:00	MSFT	Stock	30.92	30.93	30.92	30.93	4505.0
2010-01-04 07:00:00	NVDA	Stock	0.464	0.464	0.462	0.462	220000.0
2010-01-04 08:00:00	NVDA	Stock	0.461	0.4625	0.4578	0.4598	2707040.0
2010-01-04 09:00:00	NVDA	Stock	0.4603	0.4655	0.4528	0.4593	198992640.0
2010-01-04 10:00:00	NVDA	Stock	0.4595	0.4643	0.4565	0.4622	166672600.0
2010-01-04 11:00:00	NVDA	Stock	0.4622	0.4638	0.46	0.46	100448080.0
2010-01-04 12:00:00	NVDA	Stock	0.4603	0.4628	0.4598	0.461	55557680.0
2010-01-04 13:00:00	NVDA	Stock	0.4608	0.4625	0.4596	0.462	78524640.0
2010-01-04 14:00:00	NVDA	Stock	0.4618	0.4652	0.4618	0.4645	55216560.0
2010-01-04 15:00:00	NVDA	Stock	0.4645	0.4646	0.461	0.4622	117806120.0
2010-01-04 16:00:00	NVDA	Stock	0.4622	0.4643	0.461	0.4622	10319400.0
2010-01-04 17:00:00	NVDA	Stock	0.4622	0.464	0.4622	0.464	197240.0
2010-01-04 18:00:00	NVDA	Stock	0.4615	0.4615	0.4598	0.46	273200.0
2010-01-04 19:00:00	NVDA	Stock	0.46	0.46	0.46	0.46	8000.0
2010-01-04 04:00:00	AMZN	Stock	6.7495	6.7495	6.749	6.749	4000.0
2010-01-04 05:00:00	AMZN	Stock	6.733	6.733	6.733	6.733	2000.0
2010-01-04 06:00:00	AMZN	Stock	6.75	6.75	6.75	6.75	2000.0
2010-01-04 07:00:00	AMZN	Stock	6.75	6.785	6.75	6.785	38000.0
2010-01-04 08:00:00	AMZN	Stock	6.775	6.815	6.726	6.8105	1031680.0

> showing 50 of 43,718 rows — these rows as CSV

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