PREVIEW / stock_1hour / 2009-01-12

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-01-12.parquet
  size:    815 KB
  rows:    40,257
  symbols: 3,291

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-12 04:00:00	AAPL	Stock	3.235	3.235	3.235	3.235	5600.0
2009-01-12 08:00:00	AAPL	Stock	3.2321	3.2496	3.2196	3.2243	812000.0
2009-01-12 09:00:00	AAPL	Stock	3.2268	3.2496	3.1964	3.2304	81037012.0
2009-01-12 10:00:00	AAPL	Stock	3.2311	3.2321	3.1864	3.1904	91860748.0
2009-01-12 11:00:00	AAPL	Stock	3.1911	3.1986	3.1475	3.15	97773116.0
2009-01-12 12:00:00	AAPL	Stock	3.15	3.1689	3.1425	3.1532	67327708.0
2009-01-12 13:00:00	AAPL	Stock	3.1529	3.1614	3.1457	3.155	45617376.0
2009-01-12 14:00:00	AAPL	Stock	3.1555	3.1555	3.1268	3.1475	80933244.0
2009-01-12 15:00:00	AAPL	Stock	3.1479	3.1743	3.1307	3.1664	120174796.0
2009-01-12 16:00:00	AAPL	Stock	3.1645	3.1964	3.1636	3.1714	22767892.0
2009-01-12 17:00:00	AAPL	Stock	3.1736	3.1771	3.1689	3.1718	171640.0
2009-01-12 18:00:00	AAPL	Stock	3.1714	3.1746	3.1664	3.1739	2484860.0
2009-01-12 19:00:00	AAPL	Stock	3.1739	3.1786	3.1739	3.1786	315728.0
2009-01-12 20:00:00	AAPL	Stock	3.1618	3.1618	3.1618	3.1618	36400.0
2009-01-12 07:00:00	MSFT	Stock	19.53	19.53	19.53	19.53	225.0
2009-01-12 08:00:00	MSFT	Stock	19.64	19.7	19.57	19.7	14186.0
2009-01-12 09:00:00	MSFT	Stock	19.65	19.79	19.57	19.71	4456097.0
2009-01-12 10:00:00	MSFT	Stock	19.72	19.74	19.46	19.53	5672883.0
2009-01-12 11:00:00	MSFT	Stock	19.542	19.57	19.42	19.5	5843473.0
2009-01-12 12:00:00	MSFT	Stock	19.5	19.64	19.48	19.59	4964189.0
2009-01-12 13:00:00	MSFT	Stock	19.598	19.68	19.53	19.53	4153815.0
2009-01-12 14:00:00	MSFT	Stock	19.53	19.54	19.3	19.41	6919808.0
2009-01-12 15:00:00	MSFT	Stock	19.4	19.56	19.38	19.47	11203775.0
2009-01-12 16:00:00	MSFT	Stock	19.46	19.57	19.46	19.51	8683761.0
2009-01-12 17:00:00	MSFT	Stock	19.526	19.526	19.48	19.51	26051.0
2009-01-12 18:00:00	MSFT	Stock	19.48	19.51	19.48	19.51	200.0
2009-01-12 19:00:00	MSFT	Stock	19.51	19.56	19.5	19.56	1780.0
2009-01-12 20:00:00	MSFT	Stock	19.46	19.46	19.46	19.46	38900.0
2009-01-12 07:00:00	NVDA	Stock	0.2068	0.2068	0.1942	0.1942	8000.0
2009-01-12 08:00:00	NVDA	Stock	0.1988	0.1992	0.1975	0.1975	117160.0
2009-01-12 09:00:00	NVDA	Stock	0.1978	0.1992	0.189	0.1923	126778280.0
2009-01-12 10:00:00	NVDA	Stock	0.1923	0.1923	0.189	0.19	130621680.0
2009-01-12 11:00:00	NVDA	Stock	0.1903	0.1915	0.1888	0.1905	55033240.0
2009-01-12 12:00:00	NVDA	Stock	0.1905	0.193	0.19	0.1905	59340240.0
2009-01-12 13:00:00	NVDA	Stock	0.1907	0.1915	0.1888	0.1893	32718800.0
2009-01-12 14:00:00	NVDA	Stock	0.1894	0.1908	0.1875	0.19	83106000.0
2009-01-12 15:00:00	NVDA	Stock	0.1903	0.1913	0.1884	0.19	128203400.0
2009-01-12 16:00:00	NVDA	Stock	0.1905	0.194	0.1895	0.1895	11954640.0
2009-01-12 17:00:00	NVDA	Stock	0.1903	0.1903	0.1895	0.1895	15320.0
2009-01-12 18:00:00	NVDA	Stock	0.191	0.191	0.1895	0.1908	71000.0
2009-01-12 19:00:00	NVDA	Stock	0.1895	0.1895	0.1895	0.1895	19000.0
2009-01-12 07:00:00	AMZN	Stock	2.805	2.805	2.789	2.789	12000.0
2009-01-12 08:00:00	AMZN	Stock	2.754	2.759	2.748	2.748	119020.0
2009-01-12 09:00:00	AMZN	Stock	2.7465	2.75	2.64	2.6535	29225920.0
2009-01-12 10:00:00	AMZN	Stock	2.6535	2.655	2.6235	2.642	26190980.0
2009-01-12 11:00:00	AMZN	Stock	2.641	2.6505	2.5925	2.5935	22682280.0
2009-01-12 12:00:00	AMZN	Stock	2.5945	2.6085	2.5815	2.5995	15990100.0
2009-01-12 13:00:00	AMZN	Stock	2.6	2.6255	2.595	2.5995	13108300.0
2009-01-12 14:00:00	AMZN	Stock	2.599	2.5995	2.5435	2.581	27439820.0
2009-01-12 15:00:00	AMZN	Stock	2.581	2.6115	2.56	2.596	42697740.0

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

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