PREVIEW / stock_1hour / 2009-01-20

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-01-20.parquet
  size:    814 KB
  rows:    40,049
  symbols: 3,306

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-01-20 07:00:00	AAPL	Stock	2.9004	2.9179	2.9004	2.9179	53200.0
2009-01-20 08:00:00	AAPL	Stock	2.9179	2.9236	2.8857	2.8996	1892604.0
2009-01-20 09:00:00	AAPL	Stock	2.8996	2.9286	2.875	2.885	104587028.0
2009-01-20 10:00:00	AAPL	Stock	2.8854	2.8868	2.8318	2.8489	180110504.0
2009-01-20 11:00:00	AAPL	Stock	2.8493	2.8757	2.8393	2.8489	78008392.0
2009-01-20 12:00:00	AAPL	Stock	2.8486	2.8646	2.8389	2.8479	74972436.0
2009-01-20 13:00:00	AAPL	Stock	2.8475	2.8575	2.8071	2.82	118362020.0
2009-01-20 14:00:00	AAPL	Stock	2.82	2.8357	2.8039	2.8086	107985696.0
2009-01-20 15:00:00	AAPL	Stock	2.8079	2.8371	2.7946	2.7964	189797300.0
2009-01-20 16:00:00	AAPL	Stock	2.7936	2.8322	2.7927	2.8086	29531740.0
2009-01-20 17:00:00	AAPL	Stock	2.8086	2.8268	2.7929	2.825	2942660.0
2009-01-20 18:00:00	AAPL	Stock	2.8236	2.8286	2.7929	2.8264	9783564.0
2009-01-20 19:00:00	AAPL	Stock	2.8264	2.83	2.8179	2.83	678076.0
2009-01-20 07:00:00	MSFT	Stock	19.5	19.55	19.5	19.55	1898.0
2009-01-20 08:00:00	MSFT	Stock	19.54	19.56	19.4	19.45	13934.0
2009-01-20 09:00:00	MSFT	Stock	19.45	19.62	19.08	19.12	6445774.0
2009-01-20 10:00:00	MSFT	Stock	19.12	19.15	18.95	18.965	9312311.0
2009-01-20 11:00:00	MSFT	Stock	18.97	19.06	18.93	18.958	10309764.0
2009-01-20 12:00:00	MSFT	Stock	18.95	19.0	18.71	18.755	12280981.0
2009-01-20 13:00:00	MSFT	Stock	18.757	18.94	18.64	18.66	13272498.0
2009-01-20 14:00:00	MSFT	Stock	18.66	18.75	18.57	18.72	8617603.0
2009-01-20 15:00:00	MSFT	Stock	18.72	18.72	18.38	18.46	19534364.0
2009-01-20 16:00:00	MSFT	Stock	18.45	18.861	18.37	18.66	8441825.0
2009-01-20 17:00:00	MSFT	Stock	18.66	18.67	18.48	18.62	513926.0
2009-01-20 18:00:00	MSFT	Stock	18.62	18.68	18.48	18.68	33584.0
2009-01-20 19:00:00	MSFT	Stock	18.65	18.67	18.6	18.6	13150.0
2009-01-20 08:00:00	NVDA	Stock	0.1962	0.1962	0.1913	0.1962	228000.0
2009-01-20 09:00:00	NVDA	Stock	0.195	0.2	0.1885	0.19	66751880.0
2009-01-20 10:00:00	NVDA	Stock	0.19	0.1933	0.1888	0.19	84266560.0
2009-01-20 11:00:00	NVDA	Stock	0.19	0.1923	0.1883	0.1895	50140880.0
2009-01-20 12:00:00	NVDA	Stock	0.1895	0.1918	0.1878	0.1878	57647600.0
2009-01-20 13:00:00	NVDA	Stock	0.1878	0.189	0.1835	0.1845	76670480.0
2009-01-20 14:00:00	NVDA	Stock	0.1845	0.1855	0.1818	0.182	111975520.0
2009-01-20 15:00:00	NVDA	Stock	0.1823	0.1838	0.1788	0.1805	228245200.0
2009-01-20 16:00:00	NVDA	Stock	0.1808	0.1858	0.1803	0.181	12093960.0
2009-01-20 17:00:00	NVDA	Stock	0.183	0.183	0.1803	0.1813	1387320.0
2009-01-20 18:00:00	NVDA	Stock	0.1825	0.1838	0.1825	0.1838	24000.0
2009-01-20 19:00:00	NVDA	Stock	0.1838	0.1838	0.1815	0.1815	174400.0
2009-01-20 08:00:00	AMZN	Stock	2.5745	2.5745	2.55	2.55	102280.0
2009-01-20 09:00:00	AMZN	Stock	2.5355	2.585	2.4575	2.4585	19944800.0
2009-01-20 10:00:00	AMZN	Stock	2.459	2.482	2.419	2.4455	25229400.0
2009-01-20 11:00:00	AMZN	Stock	2.446	2.4865	2.4435	2.467	13814620.0
2009-01-20 12:00:00	AMZN	Stock	2.4663	2.492	2.457	2.4581	12950680.0
2009-01-20 13:00:00	AMZN	Stock	2.4565	2.475	2.437	2.4565	11552780.0
2009-01-20 14:00:00	AMZN	Stock	2.456	2.4705	2.4325	2.4466	11419660.0
2009-01-20 15:00:00	AMZN	Stock	2.4445	2.455	2.4135	2.4185	30600560.0
2009-01-20 16:00:00	AMZN	Stock	2.423	2.4612	2.422	2.425	3518640.0
2009-01-20 17:00:00	AMZN	Stock	2.4355	2.445	2.422	2.435	419680.0
2009-01-20 19:00:00	AMZN	Stock	2.4415	2.4415	2.4415	2.4415	3000.0
2009-01-20 04:00:00	TLT	Stock	114.0	114.0	114.0	114.0	100.0

> showing 50 of 40,049 rows — these rows as CSV

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