PREVIEW / stock_1hour / 2006-12-20

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-12-20.parquet
  size:    650 KB
  rows:    31,253
  symbols: 2,477

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-12-20 07:00:00	AAPL	Stock	3.0954	3.1071	3.0954	3.0964	107520.0
2006-12-20 08:00:00	AAPL	Stock	3.0971	3.0979	3.0864	3.0918	2126824.0
2006-12-20 09:00:00	AAPL	Stock	3.0918	3.0954	3.0629	3.0843	83835444.0
2006-12-20 10:00:00	AAPL	Stock	3.0843	3.0939	3.0621	3.0679	106886388.0
2006-12-20 11:00:00	AAPL	Stock	3.0679	3.0746	3.0529	3.07	74959220.0
2006-12-20 12:00:00	AAPL	Stock	3.07	3.0743	3.06	3.0704	34676600.0
2006-12-20 13:00:00	AAPL	Stock	3.0707	3.0732	3.0343	3.0493	90156024.0
2006-12-20 14:00:00	AAPL	Stock	3.0489	3.0611	3.0432	3.0446	60438560.0
2006-12-20 15:00:00	AAPL	Stock	3.045	3.0539	3.0264	3.0279	99623860.0
2006-12-20 16:00:00	AAPL	Stock	3.0275	3.0354	3.0269	3.0279	1710268.0
2006-12-20 17:00:00	AAPL	Stock	3.0271	3.0286	3.0268	3.0286	326956.0
2006-12-20 18:00:00	AAPL	Stock	3.0286	3.0286	3.0271	3.0271	128632.0
2006-12-20 19:00:00	AAPL	Stock	3.0279	3.0286	3.0271	3.0286	243488.0
2006-12-20 08:00:00	MSFT	Stock	29.96	29.99	29.96	29.98	5000.0
2006-12-20 09:00:00	MSFT	Stock	29.98	30.24	29.97	30.18	4955288.0
2006-12-20 10:00:00	MSFT	Stock	30.19	30.21	29.99	30.12	4794952.0
2006-12-20 11:00:00	MSFT	Stock	30.12	30.14	30.05	30.11	3222519.0
2006-12-20 12:00:00	MSFT	Stock	30.11	30.12	30.0	30.1	2330392.0
2006-12-20 13:00:00	MSFT	Stock	30.1	30.1	29.97	30.023	2870772.0
2006-12-20 14:00:00	MSFT	Stock	30.02	30.14	30.02	30.06	3711274.0
2006-12-20 15:00:00	MSFT	Stock	30.05	30.14	30.05	30.1	7444095.0
2006-12-20 16:00:00	MSFT	Stock	30.1	30.22	30.05	30.05	161998.0
2006-12-20 17:00:00	MSFT	Stock	30.07	30.08	30.04	30.04	8583.0
2006-12-20 19:00:00	MSFT	Stock	30.09	30.09	30.09	30.09	100.0
2006-12-20 08:00:00	NVDA	Stock	0.643	0.6475	0.643	0.6475	54000.0
2006-12-20 09:00:00	NVDA	Stock	0.645	0.6493	0.6413	0.6482	39223200.0
2006-12-20 10:00:00	NVDA	Stock	0.648	0.6487	0.6442	0.6455	39379140.0
2006-12-20 11:00:00	NVDA	Stock	0.6455	0.6492	0.6435	0.6492	35989740.0
2006-12-20 12:00:00	NVDA	Stock	0.6492	0.6492	0.644	0.6462	29479260.0
2006-12-20 13:00:00	NVDA	Stock	0.6463	0.6463	0.6372	0.6387	42248160.0
2006-12-20 14:00:00	NVDA	Stock	0.6388	0.6435	0.638	0.6385	55445160.0
2006-12-20 15:00:00	NVDA	Stock	0.6385	0.6408	0.6377	0.6377	51409800.0
2006-12-20 16:00:00	NVDA	Stock	0.6377	0.639	0.6373	0.6375	365220.0
2006-12-20 17:00:00	NVDA	Stock	0.6388	0.6397	0.6388	0.6397	54000.0
2006-12-20 19:00:00	NVDA	Stock	0.6377	0.6377	0.6377	0.6377	30000.0
2006-12-20 08:00:00	AMZN	Stock	1.9715	1.9715	1.9715	1.9715	6000.0
2006-12-20 09:00:00	AMZN	Stock	1.9685	1.997	1.9645	1.9965	16532700.0
2006-12-20 10:00:00	AMZN	Stock	1.9965	2.009	1.9945	2.009	35853840.0
2006-12-20 11:00:00	AMZN	Stock	2.009	2.015	2.001	2.005	23523240.0
2006-12-20 12:00:00	AMZN	Stock	2.005	2.0055	1.9975	2.002	14142900.0
2006-12-20 13:00:00	AMZN	Stock	2.002	2.002	1.9828	1.992	14679840.0
2006-12-20 14:00:00	AMZN	Stock	1.992	2.0025	1.9915	1.9965	13794400.0
2006-12-20 15:00:00	AMZN	Stock	1.9965	2.0035	1.9955	2.0	30182280.0
2006-12-20 16:00:00	AMZN	Stock	2.0005	2.004	1.9985	2.0	180940.0
2006-12-20 17:00:00	AMZN	Stock	2.0	2.0	2.0	2.0	25680.0
2006-12-20 09:00:00	CL	Stock	32.595	32.72	32.57	32.665	224400.0
2006-12-20 10:00:00	CL	Stock	32.665	32.685	32.595	32.635	568200.0
2006-12-20 11:00:00	CL	Stock	32.63	32.63	32.53	32.575	499200.0
2006-12-20 12:00:00	CL	Stock	32.575	32.605	32.54	32.565	352600.0
2006-12-20 13:00:00	CL	Stock	32.565	32.58	32.55	32.57	378200.0

> showing 50 of 31,253 rows — these rows as CSV

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