PREVIEW / stock_1hour / 2009-02-23

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-02-23.parquet
  size:    825 KB
  rows:    41,041
  symbols: 3,344

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-02-23 07:00:00	AAPL	Stock	3.2804	3.3071	3.2768	3.2768	79744.0
2009-02-23 08:00:00	AAPL	Stock	3.2679	3.2854	3.2593	3.2854	1175804.0
2009-02-23 09:00:00	AAPL	Stock	3.2854	3.2918	3.1696	3.1736	102612832.0
2009-02-23 10:00:00	AAPL	Stock	3.1745	3.1882	3.15	3.1554	129062360.0
2009-02-23 11:00:00	AAPL	Stock	3.1557	3.1732	3.1418	3.1446	87799404.0
2009-02-23 12:00:00	AAPL	Stock	3.1446	3.1529	3.125	3.1264	68041092.0
2009-02-23 13:00:00	AAPL	Stock	3.1261	3.1607	3.1254	3.1375	73556000.0
2009-02-23 14:00:00	AAPL	Stock	3.1368	3.1675	3.1107	3.1168	98887180.0
2009-02-23 15:00:00	AAPL	Stock	3.1168	3.1346	3.0896	3.1104	161440132.0
2009-02-23 16:00:00	AAPL	Stock	3.1104	3.1507	3.101	3.1054	22265432.0
2009-02-23 17:00:00	AAPL	Stock	3.1054	3.1177	3.105	3.1139	661388.0
2009-02-23 18:00:00	AAPL	Stock	3.1118	3.1121	3.1054	3.1054	34179936.0
2009-02-23 19:00:00	AAPL	Stock	3.1054	3.1107	3.1054	3.1071	213864.0
2009-02-23 04:00:00	MSFT	Stock	18.12	18.12	18.12	18.12	100.0
2009-02-23 05:00:00	MSFT	Stock	18.15	18.15	18.15	18.15	700.0
2009-02-23 06:00:00	MSFT	Stock	18.15	18.15	18.15	18.15	400.0
2009-02-23 07:00:00	MSFT	Stock	18.15	18.15	18.04	18.05	7270.0
2009-02-23 08:00:00	MSFT	Stock	18.06	18.15	18.04	18.1	43657.0
2009-02-23 09:00:00	MSFT	Stock	18.1	18.16	17.69	17.712	7364444.0
2009-02-23 10:00:00	MSFT	Stock	17.71	17.72	17.47	17.48	8522399.0
2009-02-23 11:00:00	MSFT	Stock	17.48	17.62	17.4	17.52	8792535.0
2009-02-23 12:00:00	MSFT	Stock	17.52	17.64	17.49	17.53	6544775.0
2009-02-23 13:00:00	MSFT	Stock	17.53	17.65	17.48	17.5	5661764.0
2009-02-23 14:00:00	MSFT	Stock	17.51	17.61	17.29	17.3	7666204.0
2009-02-23 15:00:00	MSFT	Stock	17.3	17.4	17.16	17.23	16053306.0
2009-02-23 16:00:00	MSFT	Stock	17.23	17.509	17.15	17.21	8532172.0
2009-02-23 17:00:00	MSFT	Stock	17.21	17.492	17.19	17.32	21773.0
2009-02-23 18:00:00	MSFT	Stock	17.32	17.32	17.21	17.25	8218.0
2009-02-23 19:00:00	MSFT	Stock	17.3	17.3	17.25	17.3	5060.0
2009-02-23 08:00:00	NVDA	Stock	0.1933	0.1933	0.1933	0.1933	4000.0
2009-02-23 09:00:00	NVDA	Stock	0.1933	0.1945	0.1888	0.1923	96416840.0
2009-02-23 10:00:00	NVDA	Stock	0.1923	0.1925	0.1853	0.1855	87981160.0
2009-02-23 11:00:00	NVDA	Stock	0.1858	0.1865	0.1828	0.183	59256600.0
2009-02-23 12:00:00	NVDA	Stock	0.183	0.1853	0.182	0.1825	75006920.0
2009-02-23 13:00:00	NVDA	Stock	0.1825	0.1863	0.1823	0.1825	70414200.0
2009-02-23 14:00:00	NVDA	Stock	0.1823	0.1841	0.1813	0.1815	81087240.0
2009-02-23 15:00:00	NVDA	Stock	0.1813	0.1838	0.1803	0.1815	186997080.0
2009-02-23 16:00:00	NVDA	Stock	0.1818	0.1851	0.1813	0.1815	6139800.0
2009-02-23 17:00:00	NVDA	Stock	0.1815	0.1818	0.1815	0.1818	1901080.0
2009-02-23 18:00:00	NVDA	Stock	0.1818	0.1818	0.1818	0.1818	24000.0
2009-02-23 19:00:00	NVDA	Stock	0.1838	0.1875	0.1838	0.1875	18000.0
2009-02-23 04:00:00	AMZN	Stock	3.24	3.24	3.24	3.24	8000.0
2009-02-23 07:00:00	AMZN	Stock	3.24	3.24	3.24	3.24	2000.0
2009-02-23 08:00:00	AMZN	Stock	3.2	3.229	3.193	3.196	87200.0
2009-02-23 09:00:00	AMZN	Stock	3.1975	3.2455	3.192	3.209	20418100.0
2009-02-23 10:00:00	AMZN	Stock	3.2085	3.2095	3.136	3.1365	23860800.0
2009-02-23 11:00:00	AMZN	Stock	3.139	3.1585	3.1055	3.1195	16084660.0
2009-02-23 12:00:00	AMZN	Stock	3.1195	3.14	3.093	3.096	16951880.0
2009-02-23 13:00:00	AMZN	Stock	3.096	3.124	3.089	3.0985	11574760.0
2009-02-23 14:00:00	AMZN	Stock	3.098	3.127	3.0875	3.095	18953360.0

> showing 50 of 41,041 rows — these rows as CSV

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