PREVIEW / stock_5min / 2005-11-07
file: by_date/stock_5min/2005/2005-11-07.parquet size: 2.8 MB rows: 206,259 symbols: 2,108
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 |
|---|---|---|---|---|---|---|---|
| 2005-11-07 06:50:00 | AAPL | Stock | 2.1982 | 2.1982 | 2.1982 | 2.1982 | 14000.0 |
| 2005-11-07 07:00:00 | AAPL | Stock | 2.1982 | 2.1982 | 2.1982 | 2.1982 | 14000.0 |
| 2005-11-07 07:05:00 | AAPL | Stock | 2.1911 | 2.1982 | 2.1911 | 2.1982 | 73528.0 |
| 2005-11-07 07:10:00 | AAPL | Stock | 2.1982 | 2.1982 | 2.1982 | 2.1982 | 2800.0 |
| 2005-11-07 07:15:00 | AAPL | Stock | 2.1982 | 2.1982 | 2.1982 | 2.1982 | 7672.0 |
| 2005-11-07 07:25:00 | AAPL | Stock | 2.2036 | 2.2036 | 2.2036 | 2.2036 | 56000.0 |
| 2005-11-07 07:30:00 | AAPL | Stock | 2.2075 | 2.2075 | 2.2054 | 2.2054 | 36400.0 |
| 2005-11-07 07:35:00 | AAPL | Stock | 2.2054 | 2.2054 | 2.2 | 2.2 | 77868.0 |
| 2005-11-07 07:40:00 | AAPL | Stock | 2.2 | 2.2 | 2.2 | 2.2 | 15400.0 |
| 2005-11-07 07:45:00 | AAPL | Stock | 2.2 | 2.2 | 2.2 | 2.2 | 98000.0 |
| 2005-11-07 07:55:00 | AAPL | Stock | 2.1971 | 2.1971 | 2.1875 | 2.1875 | 112000.0 |
| 2005-11-07 08:00:00 | AAPL | Stock | 2.1893 | 2.1968 | 2.1718 | 2.1779 | 1261484.0 |
| 2005-11-07 08:05:00 | AAPL | Stock | 2.175 | 2.1821 | 2.1571 | 2.1643 | 1196832.0 |
| 2005-11-07 08:10:00 | AAPL | Stock | 2.1632 | 2.1729 | 2.1575 | 2.1675 | 739536.0 |
| 2005-11-07 08:15:00 | AAPL | Stock | 2.1675 | 2.1714 | 2.1571 | 2.1711 | 668416.0 |
| 2005-11-07 08:20:00 | AAPL | Stock | 2.1729 | 2.1729 | 2.1654 | 2.1664 | 243320.0 |
| 2005-11-07 08:25:00 | AAPL | Stock | 2.1661 | 2.1661 | 2.1575 | 2.1593 | 1008952.0 |
| 2005-11-07 08:30:00 | AAPL | Stock | 2.1607 | 2.1625 | 2.1564 | 2.1596 | 766388.0 |
| 2005-11-07 08:35:00 | AAPL | Stock | 2.1589 | 2.1661 | 2.1586 | 2.1629 | 291480.0 |
| 2005-11-07 08:40:00 | AAPL | Stock | 2.1639 | 2.1696 | 2.1632 | 2.1679 | 938280.0 |
| 2005-11-07 08:45:00 | AAPL | Stock | 2.1679 | 2.1679 | 2.1643 | 2.1661 | 376600.0 |
| 2005-11-07 08:50:00 | AAPL | Stock | 2.1661 | 2.17 | 2.1661 | 2.1696 | 288736.0 |
| 2005-11-07 08:55:00 | AAPL | Stock | 2.1696 | 2.1696 | 2.1668 | 2.1689 | 348292.0 |
| 2005-11-07 09:00:00 | AAPL | Stock | 2.1686 | 2.1686 | 2.1671 | 2.1675 | 266084.0 |
| 2005-11-07 09:05:00 | AAPL | Stock | 2.1679 | 2.1682 | 2.1664 | 2.1679 | 467796.0 |
| 2005-11-07 09:10:00 | AAPL | Stock | 2.1679 | 2.1686 | 2.1611 | 2.1618 | 1048992.0 |
| 2005-11-07 09:15:00 | AAPL | Stock | 2.1618 | 2.1686 | 2.1614 | 2.1686 | 2108848.0 |
| 2005-11-07 09:20:00 | AAPL | Stock | 2.1686 | 2.1696 | 2.1604 | 2.1654 | 1405992.0 |
| 2005-11-07 09:25:00 | AAPL | Stock | 2.1682 | 2.1761 | 2.1618 | 2.1746 | 2494800.0 |
| 2005-11-07 09:30:00 | AAPL | Stock | 2.1732 | 2.1875 | 2.1664 | 2.1818 | 33366396.0 |
| 2005-11-07 09:35:00 | AAPL | Stock | 2.1821 | 2.2025 | 2.18 | 2.1971 | 26736584.0 |
| 2005-11-07 09:40:00 | AAPL | Stock | 2.1968 | 2.2 | 2.1864 | 2.1911 | 25723208.0 |
| 2005-11-07 09:45:00 | AAPL | Stock | 2.1911 | 2.1914 | 2.1771 | 2.1775 | 19487300.0 |
| 2005-11-07 09:50:00 | AAPL | Stock | 2.1771 | 2.1893 | 2.1732 | 2.1757 | 18384184.0 |
| 2005-11-07 09:55:00 | AAPL | Stock | 2.1754 | 2.1793 | 2.1707 | 2.1746 | 14512176.0 |
| 2005-11-07 10:00:00 | AAPL | Stock | 2.175 | 2.1764 | 2.1643 | 2.1725 | 19018748.0 |
| 2005-11-07 10:05:00 | AAPL | Stock | 2.1725 | 2.1793 | 2.1689 | 2.1793 | 9904664.0 |
| 2005-11-07 10:10:00 | AAPL | Stock | 2.1793 | 2.1857 | 2.1711 | 2.1721 | 14398664.0 |
| 2005-11-07 10:15:00 | AAPL | Stock | 2.1721 | 2.1754 | 2.1657 | 2.1696 | 11178272.0 |
| 2005-11-07 10:20:00 | AAPL | Stock | 2.1696 | 2.1696 | 2.1604 | 2.1657 | 12915476.0 |
| 2005-11-07 10:25:00 | AAPL | Stock | 2.1661 | 2.175 | 2.1625 | 2.1696 | 9767100.0 |
| 2005-11-07 10:30:00 | AAPL | Stock | 2.1686 | 2.1725 | 2.1679 | 2.1718 | 4420528.0 |
| 2005-11-07 10:35:00 | AAPL | Stock | 2.1714 | 2.1775 | 2.1711 | 2.1732 | 10138940.0 |
| 2005-11-07 10:40:00 | AAPL | Stock | 2.1732 | 2.1736 | 2.1686 | 2.1707 | 6521760.0 |
| 2005-11-07 10:45:00 | AAPL | Stock | 2.1711 | 2.1771 | 2.17 | 2.1729 | 7358652.0 |
| 2005-11-07 10:50:00 | AAPL | Stock | 2.1729 | 2.1768 | 2.1729 | 2.1736 | 3223304.0 |
| 2005-11-07 10:55:00 | AAPL | Stock | 2.1732 | 2.1811 | 2.1725 | 2.1804 | 6501096.0 |
| 2005-11-07 11:00:00 | AAPL | Stock | 2.1804 | 2.1818 | 2.1739 | 2.1757 | 6882372.0 |
| 2005-11-07 11:05:00 | AAPL | Stock | 2.1764 | 2.1782 | 2.1739 | 2.1747 | 3722040.0 |
| 2005-11-07 11:10:00 | AAPL | Stock | 2.1746 | 2.175 | 2.1679 | 2.1714 | 6004600.0 |
> showing 50 of 206,259 rows — these rows as CSV