PREVIEW / stock_5min / 2006-07-24
file: by_date/stock_5min/2006/2006-07-24.parquet size: 3.1 MB rows: 225,970 symbols: 2,319
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-07-24 08:05:00 | AAPL | Stock | 2.1857 | 2.1857 | 2.1839 | 2.1857 | 71372.0 |
| 2006-07-24 08:10:00 | AAPL | Stock | 2.1857 | 2.1857 | 2.1857 | 2.1857 | 36540.0 |
| 2006-07-24 08:15:00 | AAPL | Stock | 2.1857 | 2.1875 | 2.1839 | 2.1875 | 124180.0 |
| 2006-07-24 08:20:00 | AAPL | Stock | 2.1875 | 2.1893 | 2.1857 | 2.1857 | 165032.0 |
| 2006-07-24 08:25:00 | AAPL | Stock | 2.1846 | 2.1846 | 2.1789 | 2.1789 | 25900.0 |
| 2006-07-24 08:30:00 | AAPL | Stock | 2.1821 | 2.1857 | 2.1821 | 2.1839 | 60200.0 |
| 2006-07-24 08:35:00 | AAPL | Stock | 2.1839 | 2.1839 | 2.1821 | 2.1839 | 32200.0 |
| 2006-07-24 08:40:00 | AAPL | Stock | 2.1821 | 2.1821 | 2.1804 | 2.1804 | 35532.0 |
| 2006-07-24 08:45:00 | AAPL | Stock | 2.1814 | 2.1821 | 2.1786 | 2.1821 | 211596.0 |
| 2006-07-24 08:50:00 | AAPL | Stock | 2.1821 | 2.1829 | 2.1814 | 2.1814 | 156688.0 |
| 2006-07-24 08:55:00 | AAPL | Stock | 2.1821 | 2.1875 | 2.18 | 2.1875 | 392364.0 |
| 2006-07-24 09:00:00 | AAPL | Stock | 2.1875 | 2.1893 | 2.1875 | 2.1875 | 219520.0 |
| 2006-07-24 09:05:00 | AAPL | Stock | 2.1861 | 2.1893 | 2.1861 | 2.1893 | 201880.0 |
| 2006-07-24 09:10:00 | AAPL | Stock | 2.1893 | 2.1918 | 2.1893 | 2.1918 | 181384.0 |
| 2006-07-24 09:15:00 | AAPL | Stock | 2.1918 | 2.1939 | 2.1914 | 2.1939 | 391216.0 |
| 2006-07-24 09:20:00 | AAPL | Stock | 2.1946 | 2.1946 | 2.1918 | 2.1932 | 180796.0 |
| 2006-07-24 09:25:00 | AAPL | Stock | 2.1914 | 2.1968 | 2.1861 | 2.1882 | 1368472.0 |
| 2006-07-24 09:30:00 | AAPL | Stock | 2.1879 | 2.2179 | 2.1857 | 2.2093 | 35555492.0 |
| 2006-07-24 09:35:00 | AAPL | Stock | 2.2082 | 2.2171 | 2.2018 | 2.2031 | 24548664.0 |
| 2006-07-24 09:40:00 | AAPL | Stock | 2.2025 | 2.2068 | 2.1993 | 2.2029 | 17596152.0 |
| 2006-07-24 09:45:00 | AAPL | Stock | 2.2032 | 2.2039 | 2.1904 | 2.1925 | 16575412.0 |
| 2006-07-24 09:50:00 | AAPL | Stock | 2.1921 | 2.1921 | 2.1829 | 2.1846 | 15002848.0 |
| 2006-07-24 09:55:00 | AAPL | Stock | 2.1846 | 2.1879 | 2.1768 | 2.1829 | 17776836.0 |
| 2006-07-24 10:00:00 | AAPL | Stock | 2.1825 | 2.1882 | 2.1775 | 2.1806 | 13276424.0 |
| 2006-07-24 10:05:00 | AAPL | Stock | 2.1804 | 2.1811 | 2.17 | 2.1704 | 15885296.0 |
| 2006-07-24 10:10:00 | AAPL | Stock | 2.1704 | 2.175 | 2.1657 | 2.1739 | 16617020.0 |
| 2006-07-24 10:15:00 | AAPL | Stock | 2.1739 | 2.1864 | 2.1729 | 2.1832 | 13911352.0 |
| 2006-07-24 10:20:00 | AAPL | Stock | 2.1832 | 2.1911 | 2.1825 | 2.1864 | 12964448.0 |
| 2006-07-24 10:25:00 | AAPL | Stock | 2.1864 | 2.1929 | 2.1771 | 2.1779 | 13548444.0 |
| 2006-07-24 10:30:00 | AAPL | Stock | 2.1775 | 2.1857 | 2.1775 | 2.1821 | 7339864.0 |
| 2006-07-24 10:35:00 | AAPL | Stock | 2.1814 | 2.1825 | 2.1739 | 2.1764 | 6886684.0 |
| 2006-07-24 10:40:00 | AAPL | Stock | 2.1764 | 2.1789 | 2.17 | 2.1725 | 10738896.0 |
| 2006-07-24 10:45:00 | AAPL | Stock | 2.1721 | 2.1771 | 2.1693 | 2.1757 | 10208492.0 |
| 2006-07-24 10:50:00 | AAPL | Stock | 2.1757 | 2.1796 | 2.1718 | 2.1732 | 16767016.0 |
| 2006-07-24 10:55:00 | AAPL | Stock | 2.1729 | 2.1768 | 2.1718 | 2.1729 | 7342552.0 |
| 2006-07-24 11:00:00 | AAPL | Stock | 2.1729 | 2.1761 | 2.1639 | 2.165 | 16359700.0 |
| 2006-07-24 11:05:00 | AAPL | Stock | 2.165 | 2.1714 | 2.1646 | 2.1682 | 12048512.0 |
| 2006-07-24 11:10:00 | AAPL | Stock | 2.1682 | 2.175 | 2.1679 | 2.1736 | 9856196.0 |
| 2006-07-24 11:15:00 | AAPL | Stock | 2.1736 | 2.1746 | 2.1618 | 2.1625 | 9664676.0 |
| 2006-07-24 11:20:00 | AAPL | Stock | 2.1625 | 2.1714 | 2.1593 | 2.1636 | 14671888.0 |
| 2006-07-24 11:25:00 | AAPL | Stock | 2.1636 | 2.1682 | 2.1582 | 2.1661 | 12174596.0 |
| 2006-07-24 11:30:00 | AAPL | Stock | 2.1661 | 2.1696 | 2.1625 | 2.1659 | 8663228.0 |
| 2006-07-24 11:35:00 | AAPL | Stock | 2.1657 | 2.1696 | 2.1654 | 2.1671 | 7004284.0 |
| 2006-07-24 11:40:00 | AAPL | Stock | 2.1664 | 2.1782 | 2.1654 | 2.1779 | 10328304.0 |
| 2006-07-24 11:45:00 | AAPL | Stock | 2.1779 | 2.1857 | 2.1775 | 2.1789 | 15640772.0 |
| 2006-07-24 11:50:00 | AAPL | Stock | 2.1789 | 2.18 | 2.1725 | 2.1754 | 8095360.0 |
| 2006-07-24 11:55:00 | AAPL | Stock | 2.1754 | 2.1764 | 2.1725 | 2.175 | 4934244.0 |
| 2006-07-24 12:00:00 | AAPL | Stock | 2.1754 | 2.1771 | 2.1743 | 2.1768 | 4464964.0 |
| 2006-07-24 12:05:00 | AAPL | Stock | 2.1764 | 2.1764 | 2.1704 | 2.1736 | 8541624.0 |
| 2006-07-24 12:10:00 | AAPL | Stock | 2.1736 | 2.1764 | 2.1711 | 2.1754 | 4255804.0 |
> showing 50 of 225,970 rows — these rows as CSV