PREVIEW / stock_1hour / 2009-12-24

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-12-24.parquet
  size:    572 KB
  rows:    25,330
  symbols: 3,372

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
2009-12-24 07:00:00	AAPL	Stock	7.25	7.2589	7.2361	7.25	521920.0
2009-12-24 08:00:00	AAPL	Stock	7.25	7.2786	7.2429	7.2679	2981832.0
2009-12-24 09:00:00	AAPL	Stock	7.265	7.3911	7.2611	7.3832	120445948.0
2009-12-24 10:00:00	AAPL	Stock	7.3836	7.4286	7.3818	7.4073	128713620.0
2009-12-24 11:00:00	AAPL	Stock	7.4072	7.4768	7.4057	7.4643	123114572.0
2009-12-24 12:00:00	AAPL	Stock	7.4643	7.4722	7.4339	7.4646	116127900.0
2009-12-24 13:00:00	AAPL	Stock	7.4646	7.4714	7.4123	7.4671	4874996.0
2009-12-24 14:00:00	AAPL	Stock	7.4671	7.4696	7.4643	7.4679	315924.0
2009-12-24 15:00:00	AAPL	Stock	7.4643	7.4679	7.4643	7.4643	182616.0
2009-12-24 16:00:00	AAPL	Stock	7.4679	7.4679	7.4646	7.4679	78680.0
2009-12-24 07:00:00	MSFT	Stock	30.86	30.86	30.86	30.86	100.0
2009-12-24 08:00:00	MSFT	Stock	30.89	30.96	30.88	30.92	8700.0
2009-12-24 09:00:00	MSFT	Stock	30.92	30.96	30.76	30.94	1833435.0
2009-12-24 10:00:00	MSFT	Stock	30.94	30.99	30.91	30.982	2312468.0
2009-12-24 11:00:00	MSFT	Stock	30.99	31.0	30.98	31.0	2721380.0
2009-12-24 12:00:00	MSFT	Stock	31.0	31.0	30.96	31.0	3421231.0
2009-12-24 13:00:00	MSFT	Stock	31.0	31.06	30.97	31.0	391773.0
2009-12-24 14:00:00	MSFT	Stock	31.0	31.02	30.99	30.99	1498.0
2009-12-24 15:00:00	MSFT	Stock	30.99	31.0	30.98	31.0	2010.0
2009-12-24 16:00:00	MSFT	Stock	31.0	31.0	30.99	30.99	300.0
2009-12-24 08:00:00	NVDA	Stock	0.4542	0.4562	0.4522	0.4522	58800.0
2009-12-24 09:00:00	NVDA	Stock	0.4545	0.4545	0.4518	0.4532	26549960.0
2009-12-24 10:00:00	NVDA	Stock	0.4532	0.4552	0.4518	0.4528	42712800.0
2009-12-24 11:00:00	NVDA	Stock	0.4525	0.4528	0.4505	0.4518	25410160.0
2009-12-24 12:00:00	NVDA	Stock	0.4515	0.4528	0.4508	0.4522	38887720.0
2009-12-24 13:00:00	NVDA	Stock	0.4522	0.4532	0.4522	0.4525	2068000.0
2009-12-24 16:00:00	NVDA	Stock	0.4525	0.4525	0.4525	0.4525	8000.0
2009-12-24 07:00:00	AMZN	Stock	6.9705	6.974	6.97	6.974	6000.0
2009-12-24 08:00:00	AMZN	Stock	6.9715	6.999	6.962	6.962	1032320.0
2009-12-24 09:00:00	AMZN	Stock	6.9685	6.985	6.9035	6.9755	27954980.0
2009-12-24 10:00:00	AMZN	Stock	6.9762	6.98	6.921	6.925	21390860.0
2009-12-24 11:00:00	AMZN	Stock	6.925	6.926	6.877	6.9155	19317320.0
2009-12-24 12:00:00	AMZN	Stock	6.9155	6.983	6.8965	6.9125	32047120.0
2009-12-24 13:00:00	AMZN	Stock	6.9255	6.9332	6.92	6.93	561020.0
2009-12-24 14:00:00	AMZN	Stock	6.9275	6.9275	6.923	6.926	32820.0
2009-12-24 15:00:00	AMZN	Stock	6.9255	6.9335	6.9255	6.9325	88940.0
2009-12-24 16:00:00	AMZN	Stock	6.9345	6.9345	6.9255	6.9345	11800.0
2009-12-24 08:00:00	TLT	Stock	90.55	90.55	90.55	90.55	100.0
2009-12-24 09:00:00	TLT	Stock	90.33	90.36	90.25	90.292	174570.0
2009-12-24 10:00:00	TLT	Stock	90.3	90.31	90.12	90.17	535835.0
2009-12-24 11:00:00	TLT	Stock	90.1725	90.22	90.0	90.06	397571.0
2009-12-24 12:00:00	TLT	Stock	90.06	90.07	89.68	89.7	583866.0
2009-12-24 13:00:00	TLT	Stock	89.67	89.71	89.67	89.71	1757.0
2009-12-24 09:00:00	ES	Stock	26.02	26.18	26.02	26.13	27530.0
2009-12-24 10:00:00	ES	Stock	26.13	26.23	26.09	26.205	55472.0
2009-12-24 11:00:00	ES	Stock	26.2	26.205	26.12	26.18	58684.0
2009-12-24 12:00:00	ES	Stock	26.18	26.23	26.15	26.23	57192.0
2009-12-24 13:00:00	ES	Stock	26.23	26.23	26.1561	26.1561	8900.0
2009-12-24 09:00:00	CL	Stock	41.685	41.83	41.585	41.635	194014.0
2009-12-24 10:00:00	CL	Stock	41.635	41.795	41.5	41.5125	380938.0

> showing 50 of 25,330 rows — these rows as CSV

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