PREVIEW / stock_5min / 2006-06-09
file: by_date/stock_5min/2006/2006-06-09.parquet size: 3.1 MB rows: 224,370 symbols: 2,271
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 |
|---|---|---|---|---|---|---|---|
| 2006-06-09 07:10:00 | AAPL | Stock | 2.1821 | 2.1821 | 2.1821 | 2.1821 | 28000.0 |
| 2006-06-09 07:15:00 | AAPL | Stock | 2.1521 | 2.1521 | 2.1521 | 2.1521 | 14000.0 |
| 2006-06-09 07:25:00 | AAPL | Stock | 2.1839 | 2.1839 | 2.1839 | 2.1839 | 36400.0 |
| 2006-06-09 07:30:00 | AAPL | Stock | 2.1857 | 2.1857 | 2.1857 | 2.1857 | 11200.0 |
| 2006-06-09 07:45:00 | AAPL | Stock | 2.1875 | 2.1879 | 2.1875 | 2.1879 | 64960.0 |
| 2006-06-09 07:55:00 | AAPL | Stock | 2.1868 | 2.1868 | 2.1839 | 2.1839 | 5600.0 |
| 2006-06-09 08:00:00 | AAPL | Stock | 2.1864 | 2.1918 | 2.1839 | 2.1918 | 933660.0 |
| 2006-06-09 08:05:00 | AAPL | Stock | 2.1918 | 2.1964 | 2.1875 | 2.1875 | 781872.0 |
| 2006-06-09 08:10:00 | AAPL | Stock | 2.1875 | 2.1886 | 2.1875 | 2.1886 | 488012.0 |
| 2006-06-09 08:15:00 | AAPL | Stock | 2.1893 | 2.1943 | 2.18 | 2.1929 | 399812.0 |
| 2006-06-09 08:20:00 | AAPL | Stock | 2.1882 | 2.1921 | 2.1875 | 2.1893 | 1008280.0 |
| 2006-06-09 08:25:00 | AAPL | Stock | 2.1893 | 2.1893 | 2.185 | 2.1875 | 142660.0 |
| 2006-06-09 08:30:00 | AAPL | Stock | 2.1857 | 2.1882 | 2.1771 | 2.1857 | 283528.0 |
| 2006-06-09 08:35:00 | AAPL | Stock | 2.1843 | 2.1857 | 2.1821 | 2.1821 | 91700.0 |
| 2006-06-09 08:40:00 | AAPL | Stock | 2.1836 | 2.1836 | 2.1807 | 2.1821 | 53200.0 |
| 2006-06-09 08:45:00 | AAPL | Stock | 2.1821 | 2.1832 | 2.1796 | 2.1807 | 256452.0 |
| 2006-06-09 08:50:00 | AAPL | Stock | 2.1793 | 2.1821 | 2.1729 | 2.1807 | 373128.0 |
| 2006-06-09 08:55:00 | AAPL | Stock | 2.1811 | 2.1832 | 2.1804 | 2.1832 | 317800.0 |
| 2006-06-09 09:00:00 | AAPL | Stock | 2.1821 | 2.1821 | 2.1786 | 2.1786 | 168840.0 |
| 2006-06-09 09:05:00 | AAPL | Stock | 2.1789 | 2.1814 | 2.1789 | 2.1804 | 228200.0 |
| 2006-06-09 09:10:00 | AAPL | Stock | 2.1793 | 2.1814 | 2.1793 | 2.1814 | 173152.0 |
| 2006-06-09 09:15:00 | AAPL | Stock | 2.1793 | 2.1807 | 2.1786 | 2.1796 | 147000.0 |
| 2006-06-09 09:20:00 | AAPL | Stock | 2.1796 | 2.1814 | 2.1786 | 2.1804 | 419300.0 |
| 2006-06-09 09:25:00 | AAPL | Stock | 2.1793 | 2.1857 | 2.1789 | 2.1857 | 923972.0 |
| 2006-06-09 09:30:00 | AAPL | Stock | 2.185 | 2.1986 | 2.1846 | 2.1868 | 39888464.0 |
| 2006-06-09 09:35:00 | AAPL | Stock | 2.1871 | 2.1882 | 2.17 | 2.1769 | 29728328.0 |
| 2006-06-09 09:40:00 | AAPL | Stock | 2.1771 | 2.1843 | 2.1732 | 2.1786 | 21710248.0 |
| 2006-06-09 09:45:00 | AAPL | Stock | 2.1786 | 2.1846 | 2.1739 | 2.1818 | 25294192.0 |
| 2006-06-09 09:50:00 | AAPL | Stock | 2.1814 | 2.1821 | 2.1632 | 2.1761 | 26892964.0 |
| 2006-06-09 09:55:00 | AAPL | Stock | 2.1761 | 2.1764 | 2.1646 | 2.165 | 14216076.0 |
| 2006-06-09 10:00:00 | AAPL | Stock | 2.165 | 2.1664 | 2.15 | 2.1521 | 19966828.0 |
| 2006-06-09 10:05:00 | AAPL | Stock | 2.1525 | 2.1575 | 2.1454 | 2.1539 | 24210564.0 |
| 2006-06-09 10:10:00 | AAPL | Stock | 2.1539 | 2.1607 | 2.1486 | 2.1486 | 15378776.0 |
| 2006-06-09 10:15:00 | AAPL | Stock | 2.1486 | 2.1561 | 2.1443 | 2.1554 | 12573064.0 |
| 2006-06-09 10:20:00 | AAPL | Stock | 2.1554 | 2.1589 | 2.1504 | 2.1539 | 11608128.0 |
| 2006-06-09 10:25:00 | AAPL | Stock | 2.1539 | 2.1675 | 2.1511 | 2.1671 | 10564092.0 |
| 2006-06-09 10:30:00 | AAPL | Stock | 2.1671 | 2.17 | 2.1579 | 2.1586 | 11983888.0 |
| 2006-06-09 10:35:00 | AAPL | Stock | 2.1593 | 2.1653 | 2.1571 | 2.1604 | 7295764.0 |
| 2006-06-09 10:40:00 | AAPL | Stock | 2.1603 | 2.1654 | 2.1525 | 2.1546 | 11616836.0 |
| 2006-06-09 10:45:00 | AAPL | Stock | 2.155 | 2.1561 | 2.145 | 2.1475 | 14746032.0 |
| 2006-06-09 10:50:00 | AAPL | Stock | 2.1479 | 2.1661 | 2.13 | 2.1332 | 27147624.0 |
| 2006-06-09 10:55:00 | AAPL | Stock | 2.1332 | 2.1382 | 2.1271 | 2.135 | 21176232.0 |
| 2006-06-09 11:00:00 | AAPL | Stock | 2.135 | 2.1411 | 2.1321 | 2.1375 | 11945920.0 |
| 2006-06-09 11:05:00 | AAPL | Stock | 2.1375 | 2.1439 | 2.1371 | 2.14 | 12426092.0 |
| 2006-06-09 11:10:00 | AAPL | Stock | 2.1396 | 2.1425 | 2.1357 | 2.1364 | 7513352.0 |
| 2006-06-09 11:15:00 | AAPL | Stock | 2.1364 | 2.1375 | 2.1311 | 2.1375 | 7261576.0 |
| 2006-06-09 11:20:00 | AAPL | Stock | 2.1379 | 2.1446 | 2.1372 | 2.1425 | 8392692.0 |
| 2006-06-09 11:25:00 | AAPL | Stock | 2.1422 | 2.1475 | 2.1375 | 2.1475 | 6744724.0 |
| 2006-06-09 11:30:00 | AAPL | Stock | 2.1475 | 2.1514 | 2.1461 | 2.1468 | 9016756.0 |
| 2006-06-09 11:35:00 | AAPL | Stock | 2.1468 | 2.1507 | 2.145 | 2.1496 | 6276088.0 |
> showing 50 of 224,370 rows — these rows as CSV