PREVIEW / stock_5min / 2007-03-14
file: by_date/stock_5min/2007/2007-03-14.parquet size: 3.7 MB rows: 257,083 symbols: 2,547
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 |
|---|---|---|---|---|---|---|---|
| 2007-03-14 06:30:00 | AAPL | Stock | 3.1389 | 3.1389 | 3.1389 | 3.1389 | 22400.0 |
| 2007-03-14 07:10:00 | AAPL | Stock | 3.1404 | 3.1432 | 3.1404 | 3.1432 | 19600.0 |
| 2007-03-14 07:15:00 | AAPL | Stock | 3.1429 | 3.1429 | 3.1429 | 3.1429 | 19600.0 |
| 2007-03-14 07:20:00 | AAPL | Stock | 3.1429 | 3.1475 | 3.1429 | 3.1475 | 44800.0 |
| 2007-03-14 07:25:00 | AAPL | Stock | 3.1436 | 3.1436 | 3.1436 | 3.1436 | 30800.0 |
| 2007-03-14 07:35:00 | AAPL | Stock | 3.1479 | 3.1546 | 3.1475 | 3.1546 | 106400.0 |
| 2007-03-14 07:40:00 | AAPL | Stock | 3.1546 | 3.1546 | 3.1489 | 3.1529 | 380800.0 |
| 2007-03-14 07:45:00 | AAPL | Stock | 3.1536 | 3.1661 | 3.1536 | 3.1643 | 154000.0 |
| 2007-03-14 07:50:00 | AAPL | Stock | 3.1646 | 3.1746 | 3.1646 | 3.1746 | 198800.0 |
| 2007-03-14 07:55:00 | AAPL | Stock | 3.1732 | 3.1732 | 3.1625 | 3.1625 | 527184.0 |
| 2007-03-14 08:00:00 | AAPL | Stock | 3.1625 | 3.1625 | 3.1571 | 3.1607 | 379064.0 |
| 2007-03-14 08:05:00 | AAPL | Stock | 3.1589 | 3.1625 | 3.1539 | 3.1564 | 290416.0 |
| 2007-03-14 08:10:00 | AAPL | Stock | 3.1539 | 3.1546 | 3.1536 | 3.1543 | 100828.0 |
| 2007-03-14 08:15:00 | AAPL | Stock | 3.1543 | 3.1564 | 3.1536 | 3.1539 | 51800.0 |
| 2007-03-14 08:20:00 | AAPL | Stock | 3.1539 | 3.1539 | 3.15 | 3.1504 | 188160.0 |
| 2007-03-14 08:25:00 | AAPL | Stock | 3.1489 | 3.1489 | 3.1468 | 3.1482 | 158200.0 |
| 2007-03-14 08:30:00 | AAPL | Stock | 3.1536 | 3.1636 | 3.1536 | 3.1629 | 273700.0 |
| 2007-03-14 08:35:00 | AAPL | Stock | 3.1636 | 3.1664 | 3.1636 | 3.1643 | 100940.0 |
| 2007-03-14 08:40:00 | AAPL | Stock | 3.1646 | 3.1679 | 3.1646 | 3.1668 | 156408.0 |
| 2007-03-14 08:45:00 | AAPL | Stock | 3.1643 | 3.1664 | 3.1607 | 3.1607 | 121800.0 |
| 2007-03-14 08:50:00 | AAPL | Stock | 3.1643 | 3.1643 | 3.1586 | 3.1593 | 166600.0 |
| 2007-03-14 08:55:00 | AAPL | Stock | 3.1593 | 3.1611 | 3.1589 | 3.1611 | 632380.0 |
| 2007-03-14 09:00:00 | AAPL | Stock | 3.1611 | 3.1618 | 3.1607 | 3.1618 | 336504.0 |
| 2007-03-14 09:05:00 | AAPL | Stock | 3.1618 | 3.1618 | 3.1589 | 3.1607 | 329616.0 |
| 2007-03-14 09:10:00 | AAPL | Stock | 3.1607 | 3.1639 | 3.1607 | 3.1625 | 1143520.0 |
| 2007-03-14 09:15:00 | AAPL | Stock | 3.1643 | 3.1643 | 3.1639 | 3.1643 | 644616.0 |
| 2007-03-14 09:20:00 | AAPL | Stock | 3.1643 | 3.1646 | 3.1611 | 3.1625 | 1050000.0 |
| 2007-03-14 09:25:00 | AAPL | Stock | 3.1625 | 3.1654 | 3.1614 | 3.1643 | 889000.0 |
| 2007-03-14 09:30:00 | AAPL | Stock | 3.1643 | 3.1761 | 3.1625 | 3.1725 | 19398260.0 |
| 2007-03-14 09:35:00 | AAPL | Stock | 3.1725 | 3.1743 | 3.165 | 3.1689 | 14099848.0 |
| 2007-03-14 09:40:00 | AAPL | Stock | 3.1693 | 3.175 | 3.1611 | 3.1611 | 15867012.0 |
| 2007-03-14 09:45:00 | AAPL | Stock | 3.1611 | 3.1711 | 3.16 | 3.1639 | 14010752.0 |
| 2007-03-14 09:50:00 | AAPL | Stock | 3.1639 | 3.1707 | 3.1575 | 3.17 | 14226632.0 |
| 2007-03-14 09:55:00 | AAPL | Stock | 3.1696 | 3.1761 | 3.1643 | 3.1668 | 11575816.0 |
| 2007-03-14 10:00:00 | AAPL | Stock | 3.1668 | 3.1725 | 3.1618 | 3.1632 | 7833056.0 |
| 2007-03-14 10:05:00 | AAPL | Stock | 3.1632 | 3.17 | 3.1604 | 3.1675 | 14588868.0 |
| 2007-03-14 10:10:00 | AAPL | Stock | 3.1682 | 3.1932 | 3.1664 | 3.1929 | 24033660.0 |
| 2007-03-14 10:15:00 | AAPL | Stock | 3.1929 | 3.1929 | 3.1825 | 3.1868 | 14758716.0 |
| 2007-03-14 10:20:00 | AAPL | Stock | 3.1864 | 3.19 | 3.18 | 3.1864 | 13395396.0 |
| 2007-03-14 10:25:00 | AAPL | Stock | 3.1864 | 3.1879 | 3.1793 | 3.1814 | 8420104.0 |
| 2007-03-14 10:30:00 | AAPL | Stock | 3.1818 | 3.1896 | 3.18 | 3.1864 | 9791068.0 |
| 2007-03-14 10:35:00 | AAPL | Stock | 3.1864 | 3.1914 | 3.1811 | 3.1832 | 13049540.0 |
| 2007-03-14 10:40:00 | AAPL | Stock | 3.1836 | 3.1886 | 3.1804 | 3.1807 | 10253908.0 |
| 2007-03-14 10:45:00 | AAPL | Stock | 3.1807 | 3.1832 | 3.175 | 3.1829 | 12361972.0 |
| 2007-03-14 10:50:00 | AAPL | Stock | 3.1829 | 3.1829 | 3.1779 | 3.1811 | 6136592.0 |
| 2007-03-14 10:55:00 | AAPL | Stock | 3.1811 | 3.1821 | 3.1746 | 3.1746 | 5349008.0 |
| 2007-03-14 11:00:00 | AAPL | Stock | 3.1746 | 3.1779 | 3.1696 | 3.1711 | 7807380.0 |
| 2007-03-14 11:05:00 | AAPL | Stock | 3.1711 | 3.1775 | 3.1696 | 3.1736 | 6633200.0 |
| 2007-03-14 11:10:00 | AAPL | Stock | 3.1732 | 3.1757 | 3.1668 | 3.1714 | 6040356.0 |
| 2007-03-14 11:15:00 | AAPL | Stock | 3.1714 | 3.1743 | 3.1686 | 3.1721 | 4628820.0 |
> showing 50 of 257,083 rows — these rows as CSV