PREVIEW / stock_1hour / 2009-01-13

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-01-13.parquet
  size:    801 KB
  rows:    39,418
  symbols: 3,315

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-13 04:00:00	AAPL	Stock	3.1414	3.1529	3.1414	3.1507	66416.0
2009-01-13 05:00:00	AAPL	Stock	3.1346	3.1346	3.1036	3.1036	46200.0
2009-01-13 06:00:00	AAPL	Stock	3.1286	3.1286	3.1286	3.1286	2800.0
2009-01-13 07:00:00	AAPL	Stock	3.1136	3.1268	3.1136	3.1268	240240.0
2009-01-13 08:00:00	AAPL	Stock	3.1386	3.1664	3.1286	3.1429	1604512.0
2009-01-13 09:00:00	AAPL	Stock	3.1411	3.205	3.1382	3.1882	101228848.0
2009-01-13 10:00:00	AAPL	Stock	3.1886	3.2004	3.1471	3.1686	109907028.0
2009-01-13 11:00:00	AAPL	Stock	3.1686	3.1718	3.1307	3.1514	98152796.0
2009-01-13 12:00:00	AAPL	Stock	3.1521	3.1593	3.1196	3.1218	76967940.0
2009-01-13 13:00:00	AAPL	Stock	3.1218	3.1768	3.0839	3.0875	92414224.0
2009-01-13 14:00:00	AAPL	Stock	3.0872	3.1429	3.0846	3.1296	115629584.0
2009-01-13 15:00:00	AAPL	Stock	3.1296	3.1418	3.1025	3.1318	175154756.0
2009-01-13 16:00:00	AAPL	Stock	3.1321	3.1786	3.1142	3.1282	20588988.0
2009-01-13 17:00:00	AAPL	Stock	3.1275	3.1354	3.125	3.13	102900.0
2009-01-13 18:00:00	AAPL	Stock	3.125	3.1339	3.125	3.1286	2259320.0
2009-01-13 19:00:00	AAPL	Stock	3.1339	3.14	3.1304	3.1386	350672.0
2009-01-13 07:00:00	MSFT	Stock	19.51	19.53	19.51	19.51	698.0
2009-01-13 08:00:00	MSFT	Stock	19.4	19.48	19.37	19.48	18893.0
2009-01-13 09:00:00	MSFT	Stock	19.48	19.91	19.45	19.85	8506131.0
2009-01-13 10:00:00	MSFT	Stock	19.85	19.93	19.67	19.9	10014224.0
2009-01-13 11:00:00	MSFT	Stock	19.9	19.98	19.79	19.93	7375433.0
2009-01-13 12:00:00	MSFT	Stock	19.94	19.99	19.8	19.8	6480215.0
2009-01-13 13:00:00	MSFT	Stock	19.8	19.84	19.62	19.66	4564034.0
2009-01-13 14:00:00	MSFT	Stock	19.66	19.86	19.57	19.78	7269985.0
2009-01-13 15:00:00	MSFT	Stock	19.78	19.92	19.62	19.86	16103673.0
2009-01-13 16:00:00	MSFT	Stock	19.86	19.88	19.718	19.88	4943865.0
2009-01-13 17:00:00	MSFT	Stock	19.82	19.87	19.82	19.87	1450.0
2009-01-13 18:00:00	MSFT	Stock	19.87	19.88	19.82	19.82	26966.0
2009-01-13 19:00:00	MSFT	Stock	19.84	19.87	19.84	19.87	3195.0
2009-01-13 08:00:00	NVDA	Stock	0.1875	0.1875	0.185	0.1875	247520.0
2009-01-13 09:00:00	NVDA	Stock	0.1858	0.1985	0.1703	0.1945	620175440.0
2009-01-13 10:00:00	NVDA	Stock	0.1942	0.197	0.189	0.193	391511240.0
2009-01-13 11:00:00	NVDA	Stock	0.193	0.1948	0.1903	0.1923	110271520.0
2009-01-13 12:00:00	NVDA	Stock	0.1921	0.1923	0.189	0.1898	95560520.0
2009-01-13 13:00:00	NVDA	Stock	0.1898	0.19	0.184	0.186	163069080.0
2009-01-13 14:00:00	NVDA	Stock	0.1861	0.1915	0.1838	0.19	168185640.0
2009-01-13 15:00:00	NVDA	Stock	0.1898	0.1933	0.1873	0.1913	245977640.0
2009-01-13 16:00:00	NVDA	Stock	0.1913	0.1935	0.1903	0.1903	7354960.0
2009-01-13 17:00:00	NVDA	Stock	0.1903	0.1905	0.1888	0.1888	302200.0
2009-01-13 18:00:00	NVDA	Stock	0.1888	0.1893	0.1853	0.1858	574800.0
2009-01-13 19:00:00	NVDA	Stock	0.185	0.1893	0.185	0.1893	99600.0
2009-01-13 08:00:00	AMZN	Stock	2.587	2.587	2.55	2.565	145000.0
2009-01-13 09:00:00	AMZN	Stock	2.563	2.6645	2.5375	2.645	25390480.0
2009-01-13 10:00:00	AMZN	Stock	2.6465	2.649	2.5775	2.607	21928560.0
2009-01-13 11:00:00	AMZN	Stock	2.607	2.6175	2.569	2.5935	14876960.0
2009-01-13 12:00:00	AMZN	Stock	2.5935	2.5975	2.5655	2.576	12368220.0
2009-01-13 13:00:00	AMZN	Stock	2.5765	2.5865	2.5375	2.5405	13462600.0
2009-01-13 14:00:00	AMZN	Stock	2.54	2.5815	2.5375	2.56	28422300.0
2009-01-13 15:00:00	AMZN	Stock	2.5595	2.585	2.5395	2.5725	34006900.0
2009-01-13 16:00:00	AMZN	Stock	2.572	2.582	2.567	2.5725	5160360.0

> showing 50 of 39,418 rows — these rows as CSV

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