PREVIEW / stock_5min / 2008-04-01
file: by_date/stock_5min/2008/2008-04-01.parquet size: 4.5 MB rows: 321,415 symbols: 3,266
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 |
|---|---|---|---|---|---|---|---|
| 2008-04-01 05:35:00 | AAPL | Stock | 5.1575 | 5.1575 | 5.1575 | 5.1575 | 2800.0 |
| 2008-04-01 05:45:00 | AAPL | Stock | 5.1646 | 5.1646 | 5.1646 | 5.1646 | 4116.0 |
| 2008-04-01 06:20:00 | AAPL | Stock | 5.1464 | 5.1464 | 5.1464 | 5.1464 | 5600.0 |
| 2008-04-01 06:40:00 | AAPL | Stock | 5.1696 | 5.1696 | 5.1696 | 5.1696 | 3752.0 |
| 2008-04-01 07:00:00 | AAPL | Stock | 5.1911 | 5.1929 | 5.1786 | 5.1786 | 66640.0 |
| 2008-04-01 07:05:00 | AAPL | Stock | 5.1786 | 5.1786 | 5.1786 | 5.1786 | 53760.0 |
| 2008-04-01 07:10:00 | AAPL | Stock | 5.1839 | 5.1839 | 5.1839 | 5.1839 | 28000.0 |
| 2008-04-01 07:15:00 | AAPL | Stock | 5.1839 | 5.1839 | 5.1786 | 5.1786 | 41160.0 |
| 2008-04-01 07:20:00 | AAPL | Stock | 5.1786 | 5.1786 | 5.1786 | 5.1786 | 28000.0 |
| 2008-04-01 07:30:00 | AAPL | Stock | 5.175 | 5.1839 | 5.175 | 5.1839 | 45248.0 |
| 2008-04-01 07:35:00 | AAPL | Stock | 5.1832 | 5.1832 | 5.1786 | 5.1786 | 43120.0 |
| 2008-04-01 07:40:00 | AAPL | Stock | 5.1821 | 5.1821 | 5.1821 | 5.1821 | 5600.0 |
| 2008-04-01 07:45:00 | AAPL | Stock | 5.1839 | 5.1839 | 5.1796 | 5.1839 | 27300.0 |
| 2008-04-01 07:50:00 | AAPL | Stock | 5.1839 | 5.1839 | 5.1839 | 5.1839 | 75964.0 |
| 2008-04-01 07:55:00 | AAPL | Stock | 5.1839 | 5.1954 | 5.1839 | 5.1946 | 111384.0 |
| 2008-04-01 08:00:00 | AAPL | Stock | 5.1875 | 5.1979 | 5.125 | 5.1964 | 767396.0 |
| 2008-04-01 08:05:00 | AAPL | Stock | 5.1979 | 5.2064 | 5.1946 | 5.2014 | 738332.0 |
| 2008-04-01 08:10:00 | AAPL | Stock | 5.2018 | 5.2032 | 5.1964 | 5.1964 | 580300.0 |
| 2008-04-01 08:15:00 | AAPL | Stock | 5.1982 | 5.2014 | 5.125 | 5.1979 | 323148.0 |
| 2008-04-01 08:20:00 | AAPL | Stock | 5.1982 | 5.1989 | 5.125 | 5.1982 | 160664.0 |
| 2008-04-01 08:25:00 | AAPL | Stock | 5.1982 | 5.1982 | 5.1929 | 5.1982 | 792260.0 |
| 2008-04-01 08:30:00 | AAPL | Stock | 5.1993 | 5.2061 | 5.1961 | 5.2036 | 516852.0 |
| 2008-04-01 08:35:00 | AAPL | Stock | 5.2036 | 5.2054 | 5.2036 | 5.2054 | 96180.0 |
| 2008-04-01 08:40:00 | AAPL | Stock | 5.2054 | 5.2125 | 5.125 | 5.2104 | 788732.0 |
| 2008-04-01 08:45:00 | AAPL | Stock | 5.2089 | 5.2114 | 5.2086 | 5.2107 | 270144.0 |
| 2008-04-01 08:50:00 | AAPL | Stock | 5.2107 | 5.2121 | 5.2018 | 5.2114 | 357896.0 |
| 2008-04-01 08:55:00 | AAPL | Stock | 5.2107 | 5.2232 | 5.2107 | 5.2161 | 767032.0 |
| 2008-04-01 09:00:00 | AAPL | Stock | 5.2161 | 5.2186 | 5.2143 | 5.2143 | 346444.0 |
| 2008-04-01 09:05:00 | AAPL | Stock | 5.2179 | 5.2214 | 5.2146 | 5.2214 | 210980.0 |
| 2008-04-01 09:10:00 | AAPL | Stock | 5.2214 | 5.2225 | 5.2182 | 5.2214 | 314944.0 |
| 2008-04-01 09:15:00 | AAPL | Stock | 5.2232 | 5.2261 | 5.2214 | 5.2261 | 193872.0 |
| 2008-04-01 09:20:00 | AAPL | Stock | 5.2261 | 5.2268 | 5.2214 | 5.2214 | 337624.0 |
| 2008-04-01 09:25:00 | AAPL | Stock | 5.2182 | 5.225 | 5.2182 | 5.225 | 1532608.0 |
| 2008-04-01 09:30:00 | AAPL | Stock | 5.2246 | 5.2407 | 5.2018 | 5.2089 | 29195712.0 |
| 2008-04-01 09:35:00 | AAPL | Stock | 5.2089 | 5.2282 | 5.2081 | 5.2204 | 18205040.0 |
| 2008-04-01 09:40:00 | AAPL | Stock | 5.2207 | 5.2389 | 5.2093 | 5.2104 | 17516688.0 |
| 2008-04-01 09:45:00 | AAPL | Stock | 5.2111 | 5.2154 | 5.2 | 5.2154 | 13040188.0 |
| 2008-04-01 09:50:00 | AAPL | Stock | 5.2146 | 5.2154 | 5.1979 | 5.2021 | 12880448.0 |
| 2008-04-01 09:55:00 | AAPL | Stock | 5.2018 | 5.2221 | 5.2018 | 5.2104 | 15991864.0 |
| 2008-04-01 10:00:00 | AAPL | Stock | 5.2114 | 5.2289 | 5.2089 | 5.2221 | 19761980.0 |
| 2008-04-01 10:05:00 | AAPL | Stock | 5.2214 | 5.2243 | 5.21 | 5.2139 | 11091248.0 |
| 2008-04-01 10:10:00 | AAPL | Stock | 5.2154 | 5.2193 | 5.2018 | 5.2043 | 12304936.0 |
| 2008-04-01 10:15:00 | AAPL | Stock | 5.2043 | 5.2164 | 5.1968 | 5.2139 | 13414856.0 |
| 2008-04-01 10:20:00 | AAPL | Stock | 5.2136 | 5.2161 | 5.1993 | 5.2025 | 12404924.0 |
| 2008-04-01 10:25:00 | AAPL | Stock | 5.2029 | 5.2154 | 5.1971 | 5.2104 | 12576732.0 |
| 2008-04-01 10:30:00 | AAPL | Stock | 5.2114 | 5.2129 | 5.1993 | 5.2096 | 11203164.0 |
| 2008-04-01 10:35:00 | AAPL | Stock | 5.21 | 5.2125 | 5.1907 | 5.1918 | 16864120.0 |
| 2008-04-01 10:40:00 | AAPL | Stock | 5.1918 | 5.2011 | 5.18 | 5.1818 | 17066056.0 |
| 2008-04-01 10:45:00 | AAPL | Stock | 5.1814 | 5.2036 | 5.1782 | 5.1969 | 15823976.0 |
| 2008-04-01 10:50:00 | AAPL | Stock | 5.1964 | 5.1996 | 5.1911 | 5.1943 | 9105208.0 |
> showing 50 of 321,415 rows — these rows as CSV