PREVIEW / stock_5min / 2006-05-31
file: by_date/stock_5min/2006/2006-05-31.parquet size: 3.2 MB rows: 230,326 symbols: 2,279
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-05-31 05:20:00 | AAPL | Stock | 2.1804 | 2.1804 | 2.1804 | 2.1804 | 28000.0 |
| 2006-05-31 07:10:00 | AAPL | Stock | 2.1839 | 2.1839 | 2.1839 | 2.1839 | 2800.0 |
| 2006-05-31 07:15:00 | AAPL | Stock | 2.1854 | 2.1854 | 2.1854 | 2.1854 | 2800.0 |
| 2006-05-31 07:35:00 | AAPL | Stock | 2.1893 | 2.1921 | 2.1893 | 2.1921 | 61600.0 |
| 2006-05-31 07:45:00 | AAPL | Stock | 2.1929 | 2.1929 | 2.1929 | 2.1929 | 14000.0 |
| 2006-05-31 08:00:00 | AAPL | Stock | 2.1929 | 2.1946 | 2.1896 | 2.1946 | 312760.0 |
| 2006-05-31 08:05:00 | AAPL | Stock | 2.1943 | 2.1964 | 2.1943 | 2.1946 | 98448.0 |
| 2006-05-31 08:10:00 | AAPL | Stock | 2.1986 | 2.2 | 2.1986 | 2.2 | 36400.0 |
| 2006-05-31 08:15:00 | AAPL | Stock | 2.1996 | 2.2014 | 2.1989 | 2.1996 | 190400.0 |
| 2006-05-31 08:20:00 | AAPL | Stock | 2.1986 | 2.1986 | 2.1893 | 2.1936 | 204960.0 |
| 2006-05-31 08:25:00 | AAPL | Stock | 2.1968 | 2.1982 | 2.1968 | 2.1982 | 16800.0 |
| 2006-05-31 08:30:00 | AAPL | Stock | 2.1982 | 2.1989 | 2.1968 | 2.1968 | 39200.0 |
| 2006-05-31 08:35:00 | AAPL | Stock | 2.1979 | 2.2 | 2.1979 | 2.1982 | 113400.0 |
| 2006-05-31 08:40:00 | AAPL | Stock | 2.1993 | 2.1993 | 2.1968 | 2.1982 | 51240.0 |
| 2006-05-31 08:45:00 | AAPL | Stock | 2.1989 | 2.1989 | 2.1989 | 2.1989 | 39200.0 |
| 2006-05-31 08:50:00 | AAPL | Stock | 2.1989 | 2.2025 | 2.1989 | 2.2 | 303128.0 |
| 2006-05-31 08:55:00 | AAPL | Stock | 2.2 | 2.2061 | 2.2 | 2.205 | 527436.0 |
| 2006-05-31 09:00:00 | AAPL | Stock | 2.2043 | 2.2057 | 2.2029 | 2.2029 | 416164.0 |
| 2006-05-31 09:05:00 | AAPL | Stock | 2.2029 | 2.2054 | 2.2029 | 2.2046 | 193620.0 |
| 2006-05-31 09:10:00 | AAPL | Stock | 2.2046 | 2.2082 | 2.2043 | 2.2082 | 615244.0 |
| 2006-05-31 09:15:00 | AAPL | Stock | 2.2071 | 2.2082 | 2.2032 | 2.2036 | 179200.0 |
| 2006-05-31 09:20:00 | AAPL | Stock | 2.2029 | 2.2029 | 2.1968 | 2.2 | 157360.0 |
| 2006-05-31 09:25:00 | AAPL | Stock | 2.1993 | 2.2107 | 2.1975 | 2.2004 | 976276.0 |
| 2006-05-31 09:30:00 | AAPL | Stock | 2.2055 | 2.2068 | 2.1871 | 2.1889 | 24312176.0 |
| 2006-05-31 09:35:00 | AAPL | Stock | 2.1893 | 2.1907 | 2.1718 | 2.1757 | 26598348.0 |
| 2006-05-31 09:40:00 | AAPL | Stock | 2.1757 | 2.1804 | 2.1596 | 2.1693 | 29854160.0 |
| 2006-05-31 09:45:00 | AAPL | Stock | 2.1689 | 2.1868 | 2.1657 | 2.1867 | 23535036.0 |
| 2006-05-31 09:50:00 | AAPL | Stock | 2.1861 | 2.1861 | 2.1775 | 2.1846 | 13600076.0 |
| 2006-05-31 09:55:00 | AAPL | Stock | 2.1843 | 2.185 | 2.1796 | 2.1821 | 11226768.0 |
| 2006-05-31 10:00:00 | AAPL | Stock | 2.1819 | 2.1861 | 2.1743 | 2.1757 | 11793488.0 |
| 2006-05-31 10:05:00 | AAPL | Stock | 2.175 | 2.175 | 2.1678 | 2.1718 | 10952620.0 |
| 2006-05-31 10:10:00 | AAPL | Stock | 2.1718 | 2.1754 | 2.1664 | 2.1696 | 13305040.0 |
| 2006-05-31 10:15:00 | AAPL | Stock | 2.1696 | 2.1704 | 2.1561 | 2.1571 | 19971196.0 |
| 2006-05-31 10:20:00 | AAPL | Stock | 2.1564 | 2.1636 | 2.1554 | 2.1625 | 16139984.0 |
| 2006-05-31 10:25:00 | AAPL | Stock | 2.1629 | 2.1661 | 2.16 | 2.1657 | 11450544.0 |
| 2006-05-31 10:30:00 | AAPL | Stock | 2.1654 | 2.1714 | 2.1643 | 2.1711 | 17494736.0 |
| 2006-05-31 10:35:00 | AAPL | Stock | 2.1711 | 2.1736 | 2.1671 | 2.1718 | 14892500.0 |
| 2006-05-31 10:40:00 | AAPL | Stock | 2.1718 | 2.1721 | 2.1682 | 2.1704 | 7192696.0 |
| 2006-05-31 10:45:00 | AAPL | Stock | 2.1707 | 2.1729 | 2.1707 | 2.1711 | 7269584.0 |
| 2006-05-31 10:50:00 | AAPL | Stock | 2.1714 | 2.1721 | 2.1693 | 2.17 | 4216240.0 |
| 2006-05-31 10:55:00 | AAPL | Stock | 2.1704 | 2.1704 | 2.1625 | 2.165 | 12002060.0 |
| 2006-05-31 11:00:00 | AAPL | Stock | 2.1643 | 2.1689 | 2.1643 | 2.1686 | 4941860.0 |
| 2006-05-31 11:05:00 | AAPL | Stock | 2.1686 | 2.17 | 2.1657 | 2.1664 | 9949352.0 |
| 2006-05-31 11:10:00 | AAPL | Stock | 2.1668 | 2.167 | 2.1582 | 2.1618 | 12054644.0 |
| 2006-05-31 11:15:00 | AAPL | Stock | 2.1618 | 2.1675 | 2.1614 | 2.1675 | 5023144.0 |
| 2006-05-31 11:20:00 | AAPL | Stock | 2.1671 | 2.1696 | 2.1654 | 2.1682 | 7468440.0 |
| 2006-05-31 11:25:00 | AAPL | Stock | 2.1679 | 2.1696 | 2.1675 | 2.1696 | 8500884.0 |
| 2006-05-31 11:30:00 | AAPL | Stock | 2.1696 | 2.1714 | 2.1646 | 2.1689 | 7494312.0 |
| 2006-05-31 11:35:00 | AAPL | Stock | 2.1682 | 2.1714 | 2.1671 | 2.1689 | 5110840.0 |
| 2006-05-31 11:40:00 | AAPL | Stock | 2.1686 | 2.1689 | 2.1646 | 2.1646 | 4569628.0 |
> showing 50 of 230,326 rows — these rows as CSV