PREVIEW / stock_1hour / 2006-10-24

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-10-24.parquet
  size:    632 KB
  rows:    30,052
  symbols: 2,396

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-10-24 08:00:00	AAPL	Stock	2.9054	2.9071	2.9018	2.9043	946064.0
2006-10-24 09:00:00	AAPL	Stock	2.9029	2.9171	2.8936	2.9043	69136424.0
2006-10-24 10:00:00	AAPL	Stock	2.9021	2.9054	2.8746	2.8864	105477876.0
2006-10-24 11:00:00	AAPL	Stock	2.8868	2.8954	2.8836	2.8882	70312256.0
2006-10-24 12:00:00	AAPL	Stock	2.8882	2.8964	2.875	2.8771	54715416.0
2006-10-24 13:00:00	AAPL	Stock	2.8768	2.8961	2.8746	2.8925	39630052.0
2006-10-24 14:00:00	AAPL	Stock	2.8929	2.9125	2.8643	2.9046	62184500.0
2006-10-24 15:00:00	AAPL	Stock	2.905	2.9064	2.8943	2.8957	46167436.0
2006-10-24 16:00:00	AAPL	Stock	2.8957	2.9021	2.8946	2.9021	1657292.0
2006-10-24 17:00:00	AAPL	Stock	2.9029	2.9071	2.8946	2.9071	545048.0
2006-10-24 18:00:00	AAPL	Stock	2.9071	2.9071	2.9029	2.9029	16800.0
2006-10-24 19:00:00	AAPL	Stock	2.9029	2.9071	2.9029	2.9068	20972.0
2006-10-24 07:00:00	MSFT	Stock	28.42	28.42	28.42	28.42	100.0
2006-10-24 08:00:00	MSFT	Stock	28.43	28.43	28.38	28.38	5150.0
2006-10-24 09:00:00	MSFT	Stock	28.38	28.44	28.26	28.27	8265453.0
2006-10-24 10:00:00	MSFT	Stock	28.27	28.32	28.15	28.28	8851294.0
2006-10-24 11:00:00	MSFT	Stock	28.28	28.3	28.17	28.24	5506787.0
2006-10-24 12:00:00	MSFT	Stock	28.24	28.26	28.14	28.17	5414457.0
2006-10-24 13:00:00	MSFT	Stock	28.16	28.3	28.15	28.15	11057004.0
2006-10-24 14:00:00	MSFT	Stock	28.158	28.27	28.15	28.17	6412863.0
2006-10-24 15:00:00	MSFT	Stock	28.17	28.3	28.13	28.19	9648026.0
2006-10-24 16:00:00	MSFT	Stock	28.21	28.28	28.19	28.19	234763.0
2006-10-24 17:00:00	MSFT	Stock	28.28	28.28	28.13	28.15	55187.0
2006-10-24 18:00:00	MSFT	Stock	28.16	28.2	28.16	28.16	2184.0
2006-10-24 19:00:00	MSFT	Stock	28.16	28.16	28.15	28.16	1860.0
2006-10-24 07:00:00	NVDA	Stock	0.527	0.527	0.527	0.527	12000.0
2006-10-24 08:00:00	NVDA	Stock	0.5243	0.5247	0.5243	0.5247	150000.0
2006-10-24 09:00:00	NVDA	Stock	0.5283	0.5378	0.525	0.5323	51609420.0
2006-10-24 10:00:00	NVDA	Stock	0.5325	0.539	0.5307	0.534	85249740.0
2006-10-24 11:00:00	NVDA	Stock	0.5342	0.5355	0.5317	0.5337	36885840.0
2006-10-24 12:00:00	NVDA	Stock	0.5337	0.5352	0.5318	0.5322	41304060.0
2006-10-24 13:00:00	NVDA	Stock	0.5322	0.545	0.5322	0.5449	117518100.0
2006-10-24 14:00:00	NVDA	Stock	0.545	0.5477	0.5412	0.5415	90038040.0
2006-10-24 15:00:00	NVDA	Stock	0.5415	0.5437	0.5407	0.5418	75703320.0
2006-10-24 16:00:00	NVDA	Stock	0.542	0.545	0.5372	0.5433	2044020.0
2006-10-24 17:00:00	NVDA	Stock	0.5433	0.5433	0.5417	0.542	268380.0
2006-10-24 08:00:00	AMZN	Stock	1.6275	1.6375	1.6275	1.6305	157000.0
2006-10-24 09:00:00	AMZN	Stock	1.6305	1.7135	1.63	1.6885	60423020.0
2006-10-24 10:00:00	AMZN	Stock	1.689	1.695	1.6665	1.669	42900340.0
2006-10-24 11:00:00	AMZN	Stock	1.6685	1.6895	1.6642	1.6655	25034180.0
2006-10-24 12:00:00	AMZN	Stock	1.6665	1.675	1.659	1.6645	19770440.0
2006-10-24 13:00:00	AMZN	Stock	1.6642	1.6755	1.6555	1.656	23817900.0
2006-10-24 14:00:00	AMZN	Stock	1.6565	1.68	1.6565	1.679	30513200.0
2006-10-24 15:00:00	AMZN	Stock	1.6788	1.6955	1.6725	1.6895	87707400.0
2006-10-24 16:00:00	AMZN	Stock	1.6905	1.935	1.674	1.887	138701280.0
2006-10-24 17:00:00	AMZN	Stock	1.885	1.924	1.692	1.914	30101760.0
2006-10-24 18:00:00	AMZN	Stock	1.914	1.924	1.913	1.9135	5760760.0
2006-10-24 19:00:00	AMZN	Stock	1.9135	1.919	1.9135	1.919	538500.0
2006-10-24 09:00:00	CL	Stock	30.075	30.125	30.0	30.115	537800.0
2006-10-24 10:00:00	CL	Stock	30.1	30.25	30.095	30.235	796400.0

> showing 50 of 30,052 rows — these rows as CSV

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