PREVIEW / stock_5min / 2007-03-16
file: by_date/stock_5min/2007/2007-03-16.parquet size: 3.5 MB rows: 252,333 symbols: 2,534
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 |
|---|---|---|---|---|---|---|---|
| 2007-03-16 08:00:00 | AAPL | Stock | 3.2025 | 3.2029 | 3.1893 | 3.1893 | 44688.0 |
| 2007-03-16 08:05:00 | AAPL | Stock | 3.1929 | 3.1929 | 3.1929 | 3.1929 | 28000.0 |
| 2007-03-16 08:10:00 | AAPL | Stock | 3.1893 | 3.19 | 3.1893 | 3.19 | 54600.0 |
| 2007-03-16 08:15:00 | AAPL | Stock | 3.1886 | 3.1893 | 3.1875 | 3.1886 | 76580.0 |
| 2007-03-16 08:20:00 | AAPL | Stock | 3.1954 | 3.1964 | 3.195 | 3.1964 | 245616.0 |
| 2007-03-16 08:25:00 | AAPL | Stock | 3.1954 | 3.1964 | 3.1936 | 3.1964 | 238000.0 |
| 2007-03-16 08:30:00 | AAPL | Stock | 3.1971 | 3.2007 | 3.1918 | 3.1982 | 165760.0 |
| 2007-03-16 08:35:00 | AAPL | Stock | 3.1986 | 3.1986 | 3.1964 | 3.1964 | 69300.0 |
| 2007-03-16 08:40:00 | AAPL | Stock | 3.1982 | 3.1982 | 3.1964 | 3.1964 | 369152.0 |
| 2007-03-16 08:45:00 | AAPL | Stock | 3.1964 | 3.1964 | 3.1946 | 3.1964 | 88648.0 |
| 2007-03-16 08:50:00 | AAPL | Stock | 3.1964 | 3.2014 | 3.1964 | 3.1979 | 202888.0 |
| 2007-03-16 08:55:00 | AAPL | Stock | 3.1993 | 3.2014 | 3.1993 | 3.2014 | 20916.0 |
| 2007-03-16 09:00:00 | AAPL | Stock | 3.2 | 3.2 | 3.1993 | 3.2 | 16800.0 |
| 2007-03-16 09:05:00 | AAPL | Stock | 3.1993 | 3.2 | 3.1993 | 3.2 | 21840.0 |
| 2007-03-16 09:10:00 | AAPL | Stock | 3.1993 | 3.1993 | 3.1993 | 3.1993 | 16800.0 |
| 2007-03-16 09:15:00 | AAPL | Stock | 3.1993 | 3.1993 | 3.1993 | 3.1993 | 2800.0 |
| 2007-03-16 09:20:00 | AAPL | Stock | 3.2014 | 3.2018 | 3.2014 | 3.2018 | 64064.0 |
| 2007-03-16 09:25:00 | AAPL | Stock | 3.2032 | 3.2068 | 3.1954 | 3.1957 | 675080.0 |
| 2007-03-16 09:30:00 | AAPL | Stock | 3.1978 | 3.2082 | 3.195 | 3.1971 | 105314776.0 |
| 2007-03-16 09:35:00 | AAPL | Stock | 3.1971 | 3.2089 | 3.1957 | 3.2068 | 9956128.0 |
| 2007-03-16 09:40:00 | AAPL | Stock | 3.2071 | 3.2089 | 3.2021 | 3.2061 | 14445760.0 |
| 2007-03-16 09:45:00 | AAPL | Stock | 3.2057 | 3.2089 | 3.2043 | 3.2057 | 6658400.0 |
| 2007-03-16 09:50:00 | AAPL | Stock | 3.2064 | 3.2111 | 3.2025 | 3.2093 | 8418872.0 |
| 2007-03-16 09:55:00 | AAPL | Stock | 3.2089 | 3.2114 | 3.2057 | 3.2057 | 6339760.0 |
| 2007-03-16 10:00:00 | AAPL | Stock | 3.2061 | 3.2111 | 3.2054 | 3.2082 | 8212456.0 |
| 2007-03-16 10:05:00 | AAPL | Stock | 3.2086 | 3.2086 | 3.2057 | 3.2079 | 4619832.0 |
| 2007-03-16 10:10:00 | AAPL | Stock | 3.2071 | 3.2136 | 3.2068 | 3.2119 | 7772380.0 |
| 2007-03-16 10:15:00 | AAPL | Stock | 3.2118 | 3.2136 | 3.2107 | 3.2118 | 9040780.0 |
| 2007-03-16 10:20:00 | AAPL | Stock | 3.2118 | 3.2125 | 3.2086 | 3.2114 | 4295648.0 |
| 2007-03-16 10:25:00 | AAPL | Stock | 3.2117 | 3.2136 | 3.2107 | 3.2118 | 4866176.0 |
| 2007-03-16 10:30:00 | AAPL | Stock | 3.2114 | 3.2121 | 3.2096 | 3.2114 | 4323004.0 |
| 2007-03-16 10:35:00 | AAPL | Stock | 3.2118 | 3.2136 | 3.21 | 3.2136 | 6611668.0 |
| 2007-03-16 10:40:00 | AAPL | Stock | 3.2135 | 3.2139 | 3.2107 | 3.2125 | 6229216.0 |
| 2007-03-16 10:45:00 | AAPL | Stock | 3.2125 | 3.2129 | 3.2104 | 3.2114 | 4058712.0 |
| 2007-03-16 10:50:00 | AAPL | Stock | 3.2118 | 3.2121 | 3.2079 | 3.2082 | 5413016.0 |
| 2007-03-16 10:55:00 | AAPL | Stock | 3.2082 | 3.2129 | 3.2079 | 3.2125 | 8980664.0 |
| 2007-03-16 11:00:00 | AAPL | Stock | 3.2121 | 3.2121 | 3.2064 | 3.2104 | 6601448.0 |
| 2007-03-16 11:05:00 | AAPL | Stock | 3.2104 | 3.2114 | 3.2061 | 3.2086 | 3167640.0 |
| 2007-03-16 11:10:00 | AAPL | Stock | 3.2089 | 3.2089 | 3.2022 | 3.2061 | 7008120.0 |
| 2007-03-16 11:15:00 | AAPL | Stock | 3.2064 | 3.2079 | 3.2004 | 3.2007 | 7767480.0 |
| 2007-03-16 11:20:00 | AAPL | Stock | 3.2007 | 3.2036 | 3.2 | 3.2029 | 5637940.0 |
| 2007-03-16 11:25:00 | AAPL | Stock | 3.2029 | 3.2036 | 3.1993 | 3.2018 | 4325692.0 |
| 2007-03-16 11:30:00 | AAPL | Stock | 3.2018 | 3.2032 | 3.2 | 3.2004 | 5258400.0 |
| 2007-03-16 11:35:00 | AAPL | Stock | 3.2 | 3.2025 | 3.1982 | 3.2021 | 6775272.0 |
| 2007-03-16 11:40:00 | AAPL | Stock | 3.2025 | 3.2025 | 3.1996 | 3.2018 | 3183460.0 |
| 2007-03-16 11:45:00 | AAPL | Stock | 3.2018 | 3.2025 | 3.2007 | 3.2021 | 4453820.0 |
| 2007-03-16 11:50:00 | AAPL | Stock | 3.2021 | 3.2025 | 3.1982 | 3.1989 | 5178040.0 |
| 2007-03-16 11:55:00 | AAPL | Stock | 3.1993 | 3.2007 | 3.1968 | 3.2004 | 4894848.0 |
| 2007-03-16 12:00:00 | AAPL | Stock | 3.2004 | 3.2011 | 3.1986 | 3.1993 | 3474632.0 |
| 2007-03-16 12:05:00 | AAPL | Stock | 3.1996 | 3.2021 | 3.1982 | 3.2014 | 6784876.0 |
> showing 50 of 252,333 rows — these rows as CSV