PREVIEW / stock_5min / 2005-11-03
file: by_date/stock_5min/2005/2005-11-03.parquet size: 2.9 MB rows: 209,591 symbols: 2,095
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-03 08:00:00 | AAPL | Stock | 2.1557 | 2.1625 | 2.1518 | 2.1621 | 1426012.0 |
| 2005-11-03 08:05:00 | AAPL | Stock | 2.1607 | 2.1679 | 2.1607 | 2.1679 | 710640.0 |
| 2005-11-03 08:10:00 | AAPL | Stock | 2.1664 | 2.1754 | 2.1664 | 2.175 | 815584.0 |
| 2005-11-03 08:15:00 | AAPL | Stock | 2.1732 | 2.175 | 2.1714 | 2.1732 | 532700.0 |
| 2005-11-03 08:20:00 | AAPL | Stock | 2.1739 | 2.1754 | 2.1714 | 2.1714 | 353304.0 |
| 2005-11-03 08:25:00 | AAPL | Stock | 2.1714 | 2.1754 | 2.1668 | 2.1754 | 1032556.0 |
| 2005-11-03 08:30:00 | AAPL | Stock | 2.1714 | 2.1754 | 2.1714 | 2.1743 | 324576.0 |
| 2005-11-03 08:35:00 | AAPL | Stock | 2.1739 | 2.1746 | 2.1729 | 2.1729 | 289240.0 |
| 2005-11-03 08:40:00 | AAPL | Stock | 2.1729 | 2.1729 | 2.1711 | 2.1714 | 184268.0 |
| 2005-11-03 08:45:00 | AAPL | Stock | 2.1711 | 2.1729 | 2.1679 | 2.1714 | 657440.0 |
| 2005-11-03 08:50:00 | AAPL | Stock | 2.1714 | 2.1714 | 2.1711 | 2.1714 | 86800.0 |
| 2005-11-03 08:55:00 | AAPL | Stock | 2.1679 | 2.1721 | 2.1679 | 2.1711 | 1155420.0 |
| 2005-11-03 09:00:00 | AAPL | Stock | 2.1711 | 2.1714 | 2.1711 | 2.1711 | 173600.0 |
| 2005-11-03 09:05:00 | AAPL | Stock | 2.1714 | 2.1718 | 2.1711 | 2.1714 | 898100.0 |
| 2005-11-03 09:10:00 | AAPL | Stock | 2.1714 | 2.1714 | 2.1696 | 2.1714 | 364056.0 |
| 2005-11-03 09:15:00 | AAPL | Stock | 2.1711 | 2.1714 | 2.1682 | 2.1696 | 375900.0 |
| 2005-11-03 09:20:00 | AAPL | Stock | 2.1679 | 2.1682 | 2.1629 | 2.1657 | 574504.0 |
| 2005-11-03 09:25:00 | AAPL | Stock | 2.1621 | 2.1664 | 2.1468 | 2.1518 | 3916444.0 |
| 2005-11-03 09:30:00 | AAPL | Stock | 2.1521 | 2.1961 | 2.1454 | 2.1954 | 49110992.0 |
| 2005-11-03 09:35:00 | AAPL | Stock | 2.1956 | 2.2036 | 2.1804 | 2.1875 | 28245756.0 |
| 2005-11-03 09:40:00 | AAPL | Stock | 2.1874 | 2.1961 | 2.1818 | 2.1961 | 18153688.0 |
| 2005-11-03 09:45:00 | AAPL | Stock | 2.1964 | 2.205 | 2.1918 | 2.2007 | 22565788.0 |
| 2005-11-03 09:50:00 | AAPL | Stock | 2.2007 | 2.2046 | 2.1964 | 2.2029 | 20082972.0 |
| 2005-11-03 09:55:00 | AAPL | Stock | 2.2029 | 2.2032 | 2.1911 | 2.1982 | 22070076.0 |
| 2005-11-03 10:00:00 | AAPL | Stock | 2.1986 | 2.2046 | 2.1964 | 2.1979 | 20380192.0 |
| 2005-11-03 10:05:00 | AAPL | Stock | 2.1982 | 2.2139 | 2.1946 | 2.2068 | 25719876.0 |
| 2005-11-03 10:10:00 | AAPL | Stock | 2.2071 | 2.2086 | 2.2007 | 2.2025 | 16799720.0 |
| 2005-11-03 10:15:00 | AAPL | Stock | 2.2025 | 2.2029 | 2.1961 | 2.2011 | 14418152.0 |
| 2005-11-03 10:20:00 | AAPL | Stock | 2.2014 | 2.2029 | 2.1964 | 2.2011 | 8559544.0 |
| 2005-11-03 10:25:00 | AAPL | Stock | 2.2011 | 2.2014 | 2.1964 | 2.1996 | 10080756.0 |
| 2005-11-03 10:30:00 | AAPL | Stock | 2.1993 | 2.2061 | 2.1971 | 2.2039 | 12483968.0 |
| 2005-11-03 10:35:00 | AAPL | Stock | 2.2039 | 2.2118 | 2.2018 | 2.2086 | 15819832.0 |
| 2005-11-03 10:40:00 | AAPL | Stock | 2.2082 | 2.2118 | 2.2039 | 2.2118 | 9604364.0 |
| 2005-11-03 10:45:00 | AAPL | Stock | 2.2118 | 2.2218 | 2.2107 | 2.2143 | 23523724.0 |
| 2005-11-03 10:50:00 | AAPL | Stock | 2.2132 | 2.2193 | 2.2114 | 2.2182 | 10107972.0 |
| 2005-11-03 10:55:00 | AAPL | Stock | 2.2179 | 2.2186 | 2.2057 | 2.2061 | 12212872.0 |
| 2005-11-03 11:00:00 | AAPL | Stock | 2.2064 | 2.2146 | 2.2057 | 2.2129 | 12742296.0 |
| 2005-11-03 11:05:00 | AAPL | Stock | 2.2129 | 2.2143 | 2.2089 | 2.2118 | 10272360.0 |
| 2005-11-03 11:10:00 | AAPL | Stock | 2.2118 | 2.2143 | 2.2114 | 2.2114 | 5889324.0 |
| 2005-11-03 11:15:00 | AAPL | Stock | 2.2114 | 2.2182 | 2.2114 | 2.2129 | 9770880.0 |
| 2005-11-03 11:20:00 | AAPL | Stock | 2.2125 | 2.2139 | 2.2096 | 2.2096 | 6742092.0 |
| 2005-11-03 11:25:00 | AAPL | Stock | 2.2093 | 2.2107 | 2.2014 | 2.2086 | 14564676.0 |
| 2005-11-03 11:30:00 | AAPL | Stock | 2.2086 | 2.2089 | 2.2021 | 2.2071 | 9615928.0 |
| 2005-11-03 11:35:00 | AAPL | Stock | 2.2068 | 2.2111 | 2.2054 | 2.2082 | 6208468.0 |
| 2005-11-03 11:40:00 | AAPL | Stock | 2.2079 | 2.2089 | 2.2029 | 2.2064 | 8247372.0 |
| 2005-11-03 11:45:00 | AAPL | Stock | 2.2068 | 2.2096 | 2.2054 | 2.2089 | 4802308.0 |
| 2005-11-03 11:50:00 | AAPL | Stock | 2.2086 | 2.2093 | 2.2039 | 2.2039 | 6587364.0 |
| 2005-11-03 11:55:00 | AAPL | Stock | 2.2043 | 2.2089 | 2.2 | 2.2071 | 12778052.0 |
| 2005-11-03 12:00:00 | AAPL | Stock | 2.2071 | 2.2079 | 2.2042 | 2.2064 | 8280468.0 |
| 2005-11-03 12:05:00 | AAPL | Stock | 2.2061 | 2.2129 | 2.2061 | 2.2125 | 6903092.0 |
> showing 50 of 209,591 rows — these rows as CSV