PREVIEW / stock_5min / 2009-01-13
file: by_date/stock_5min/2009/2009-01-13.parquet size: 4.3 MB rows: 299,859 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:35:00 | AAPL | Stock | 3.1414 | 3.1529 | 3.1414 | 3.1529 | 62076.0 |
| 2009-01-13 04:40:00 | AAPL | Stock | 3.1507 | 3.1507 | 3.1507 | 3.1507 | 4340.0 |
| 2009-01-13 05:30:00 | AAPL | Stock | 3.1346 | 3.1346 | 3.1321 | 3.1321 | 40600.0 |
| 2009-01-13 05:40:00 | AAPL | Stock | 3.1071 | 3.1071 | 3.1071 | 3.1071 | 2800.0 |
| 2009-01-13 05:45:00 | AAPL | Stock | 3.1036 | 3.1036 | 3.1036 | 3.1036 | 2800.0 |
| 2009-01-13 06:25:00 | AAPL | Stock | 3.1286 | 3.1286 | 3.1286 | 3.1286 | 2800.0 |
| 2009-01-13 07:00:00 | AAPL | Stock | 3.1136 | 3.1211 | 3.1136 | 3.1211 | 92400.0 |
| 2009-01-13 07:05:00 | AAPL | Stock | 3.1196 | 3.1211 | 3.1196 | 3.1211 | 28000.0 |
| 2009-01-13 07:15:00 | AAPL | Stock | 3.1211 | 3.1211 | 3.1211 | 3.1211 | 2800.0 |
| 2009-01-13 07:30:00 | AAPL | Stock | 3.1232 | 3.1232 | 3.1232 | 3.1232 | 2800.0 |
| 2009-01-13 07:35:00 | AAPL | Stock | 3.1232 | 3.1268 | 3.1232 | 3.1232 | 47600.0 |
| 2009-01-13 07:40:00 | AAPL | Stock | 3.1179 | 3.1232 | 3.1179 | 3.1179 | 19040.0 |
| 2009-01-13 07:45:00 | AAPL | Stock | 3.1268 | 3.1268 | 3.1268 | 3.1268 | 47600.0 |
| 2009-01-13 08:00:00 | AAPL | Stock | 3.1386 | 3.1393 | 3.1293 | 3.1357 | 156744.0 |
| 2009-01-13 08:05:00 | AAPL | Stock | 3.1364 | 3.1411 | 3.1364 | 3.1407 | 94612.0 |
| 2009-01-13 08:10:00 | AAPL | Stock | 3.1375 | 3.1389 | 3.1304 | 3.1304 | 168308.0 |
| 2009-01-13 08:15:00 | AAPL | Stock | 3.1304 | 3.1321 | 3.1304 | 3.1318 | 45304.0 |
| 2009-01-13 08:20:00 | AAPL | Stock | 3.1321 | 3.1664 | 3.1304 | 3.1664 | 65772.0 |
| 2009-01-13 08:25:00 | AAPL | Stock | 3.1329 | 3.1339 | 3.1311 | 3.1311 | 28000.0 |
| 2009-01-13 08:30:00 | AAPL | Stock | 3.1325 | 3.1386 | 3.1286 | 3.1386 | 204652.0 |
| 2009-01-13 08:35:00 | AAPL | Stock | 3.1364 | 3.1654 | 3.1364 | 3.1429 | 240688.0 |
| 2009-01-13 08:40:00 | AAPL | Stock | 3.1382 | 3.1454 | 3.1321 | 3.1429 | 240800.0 |
| 2009-01-13 08:45:00 | AAPL | Stock | 3.1475 | 3.15 | 3.1429 | 3.1429 | 102032.0 |
| 2009-01-13 08:50:00 | AAPL | Stock | 3.1429 | 3.1518 | 3.1429 | 3.1518 | 127400.0 |
| 2009-01-13 08:55:00 | AAPL | Stock | 3.1489 | 3.1507 | 3.1429 | 3.1429 | 130200.0 |
| 2009-01-13 09:00:00 | AAPL | Stock | 3.1411 | 3.1454 | 3.1411 | 3.1429 | 113568.0 |
| 2009-01-13 09:05:00 | AAPL | Stock | 3.1429 | 3.1571 | 3.1421 | 3.1536 | 271404.0 |
| 2009-01-13 09:10:00 | AAPL | Stock | 3.1546 | 3.1571 | 3.1468 | 3.15 | 239792.0 |
| 2009-01-13 09:15:00 | AAPL | Stock | 3.1504 | 3.1546 | 3.1486 | 3.1486 | 130900.0 |
| 2009-01-13 09:20:00 | AAPL | Stock | 3.1518 | 3.1536 | 3.1464 | 3.1468 | 117600.0 |
| 2009-01-13 09:25:00 | AAPL | Stock | 3.1457 | 3.1554 | 3.1457 | 3.1518 | 575120.0 |
| 2009-01-13 09:30:00 | AAPL | Stock | 3.1514 | 3.1607 | 3.1382 | 3.1539 | 17016804.0 |
| 2009-01-13 09:35:00 | AAPL | Stock | 3.1527 | 3.1761 | 3.1525 | 3.1643 | 18937856.0 |
| 2009-01-13 09:40:00 | AAPL | Stock | 3.1643 | 3.1732 | 3.154 | 3.1679 | 15401428.0 |
| 2009-01-13 09:45:00 | AAPL | Stock | 3.1686 | 3.1982 | 3.1639 | 3.1914 | 20871368.0 |
| 2009-01-13 09:50:00 | AAPL | Stock | 3.1914 | 3.2036 | 3.1875 | 3.1921 | 16416092.0 |
| 2009-01-13 09:55:00 | AAPL | Stock | 3.1918 | 3.205 | 3.1864 | 3.1882 | 11136916.0 |
| 2009-01-13 10:00:00 | AAPL | Stock | 3.1886 | 3.1964 | 3.1814 | 3.1846 | 11927860.0 |
| 2009-01-13 10:05:00 | AAPL | Stock | 3.185 | 3.2004 | 3.1839 | 3.1889 | 11602416.0 |
| 2009-01-13 10:10:00 | AAPL | Stock | 3.1893 | 3.1946 | 3.1829 | 3.1879 | 8947820.0 |
| 2009-01-13 10:15:00 | AAPL | Stock | 3.1879 | 3.1961 | 3.1793 | 3.1818 | 8983436.0 |
| 2009-01-13 10:20:00 | AAPL | Stock | 3.1818 | 3.1821 | 3.1711 | 3.1729 | 9548980.0 |
| 2009-01-13 10:25:00 | AAPL | Stock | 3.172 | 3.1796 | 3.1696 | 3.1727 | 7125496.0 |
| 2009-01-13 10:30:00 | AAPL | Stock | 3.1714 | 3.1764 | 3.1636 | 3.1679 | 7334516.0 |
| 2009-01-13 10:35:00 | AAPL | Stock | 3.1675 | 3.1675 | 3.1554 | 3.1607 | 9398984.0 |
| 2009-01-13 10:40:00 | AAPL | Stock | 3.1607 | 3.1661 | 3.1475 | 3.1475 | 9366476.0 |
| 2009-01-13 10:45:00 | AAPL | Stock | 3.1471 | 3.1657 | 3.1471 | 3.1632 | 10557176.0 |
| 2009-01-13 10:50:00 | AAPL | Stock | 3.1629 | 3.1693 | 3.16 | 3.1689 | 7015204.0 |
| 2009-01-13 10:55:00 | AAPL | Stock | 3.1689 | 3.1743 | 3.1679 | 3.1686 | 8098664.0 |
| 2009-01-13 11:00:00 | AAPL | Stock | 3.1686 | 3.1711 | 3.1586 | 3.1593 | 6567596.0 |
> showing 50 of 299,859 rows — these rows as CSV