PREVIEW / stock_5min / 2009-12-01
file: by_date/stock_5min/2009/2009-12-01.parquet size: 4.8 MB rows: 324,573 symbols: 3,441
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-01 04:15:00 | AAPL | Stock | 7.1664 | 7.175 | 7.1664 | 7.175 | 8400.0 |
| 2009-12-01 04:55:00 | AAPL | Stock | 7.1964 | 7.1964 | 7.1964 | 7.1964 | 2800.0 |
| 2009-12-01 05:50:00 | AAPL | Stock | 7.2036 | 7.2036 | 7.2036 | 7.2036 | 14000.0 |
| 2009-12-01 06:00:00 | AAPL | Stock | 7.2036 | 7.2036 | 7.2036 | 7.2036 | 5600.0 |
| 2009-12-01 06:15:00 | AAPL | Stock | 7.2036 | 7.2036 | 7.2036 | 7.2036 | 7000.0 |
| 2009-12-01 07:00:00 | AAPL | Stock | 7.2029 | 7.2029 | 7.1971 | 7.1971 | 20328.0 |
| 2009-12-01 07:05:00 | AAPL | Stock | 7.1975 | 7.2043 | 7.1971 | 7.2032 | 67928.0 |
| 2009-12-01 07:25:00 | AAPL | Stock | 7.1979 | 7.1979 | 7.1979 | 7.1979 | 8400.0 |
| 2009-12-01 07:30:00 | AAPL | Stock | 7.1979 | 7.1979 | 7.1979 | 7.1979 | 2800.0 |
| 2009-12-01 07:35:00 | AAPL | Stock | 7.1975 | 7.1975 | 7.1964 | 7.1975 | 39900.0 |
| 2009-12-01 07:40:00 | AAPL | Stock | 7.1975 | 7.1975 | 7.1975 | 7.1975 | 5600.0 |
| 2009-12-01 07:45:00 | AAPL | Stock | 7.1975 | 7.1975 | 7.1975 | 7.1975 | 16800.0 |
| 2009-12-01 07:50:00 | AAPL | Stock | 7.1968 | 7.1968 | 7.1968 | 7.1968 | 2800.0 |
| 2009-12-01 07:55:00 | AAPL | Stock | 7.1968 | 7.2007 | 7.1968 | 7.2 | 28000.0 |
| 2009-12-01 08:00:00 | AAPL | Stock | 7.1975 | 7.2121 | 7.1914 | 7.1929 | 505540.0 |
| 2009-12-01 08:05:00 | AAPL | Stock | 7.1929 | 7.1929 | 7.1839 | 7.1911 | 179536.0 |
| 2009-12-01 08:10:00 | AAPL | Stock | 7.1911 | 7.1954 | 7.1911 | 7.1929 | 112000.0 |
| 2009-12-01 08:15:00 | AAPL | Stock | 7.1929 | 7.1939 | 7.1911 | 7.1936 | 56000.0 |
| 2009-12-01 08:20:00 | AAPL | Stock | 7.1932 | 7.2 | 7.1932 | 7.2 | 423556.0 |
| 2009-12-01 08:25:00 | AAPL | Stock | 7.2036 | 7.2182 | 7.1996 | 7.2096 | 952280.0 |
| 2009-12-01 08:30:00 | AAPL | Stock | 7.2086 | 7.2121 | 7.2054 | 7.2054 | 119280.0 |
| 2009-12-01 08:35:00 | AAPL | Stock | 7.2086 | 7.2096 | 7.2061 | 7.2093 | 142800.0 |
| 2009-12-01 08:40:00 | AAPL | Stock | 7.2071 | 7.2089 | 7.2046 | 7.2071 | 107240.0 |
| 2009-12-01 08:45:00 | AAPL | Stock | 7.2079 | 7.2104 | 7.1971 | 7.1971 | 380156.0 |
| 2009-12-01 08:50:00 | AAPL | Stock | 7.2011 | 7.2011 | 7.1971 | 7.2004 | 45556.0 |
| 2009-12-01 08:55:00 | AAPL | Stock | 7.2004 | 7.2061 | 7.2004 | 7.2061 | 70560.0 |
| 2009-12-01 09:00:00 | AAPL | Stock | 7.2057 | 7.2057 | 7.2046 | 7.2054 | 17416.0 |
| 2009-12-01 09:05:00 | AAPL | Stock | 7.2057 | 7.2057 | 7.1396 | 7.205 | 165816.0 |
| 2009-12-01 09:10:00 | AAPL | Stock | 7.2054 | 7.2114 | 7.2054 | 7.2104 | 147616.0 |
| 2009-12-01 09:15:00 | AAPL | Stock | 7.2096 | 7.2143 | 7.1396 | 7.2107 | 194544.0 |
| 2009-12-01 09:20:00 | AAPL | Stock | 7.2104 | 7.2114 | 7.2082 | 7.2089 | 36400.0 |
| 2009-12-01 09:25:00 | AAPL | Stock | 7.2089 | 7.2232 | 7.2079 | 7.2229 | 356664.0 |
| 2009-12-01 09:30:00 | AAPL | Stock | 7.2225 | 7.2418 | 7.2075 | 7.2186 | 22138760.0 |
| 2009-12-01 09:35:00 | AAPL | Stock | 7.2179 | 7.2268 | 7.2146 | 7.2243 | 11483864.0 |
| 2009-12-01 09:40:00 | AAPL | Stock | 7.225 | 7.2261 | 7.2154 | 7.2186 | 7547792.0 |
| 2009-12-01 09:45:00 | AAPL | Stock | 7.2186 | 7.2254 | 7.2179 | 7.2196 | 6188196.0 |
| 2009-12-01 09:50:00 | AAPL | Stock | 7.2196 | 7.2304 | 7.2196 | 7.2239 | 7569436.0 |
| 2009-12-01 09:55:00 | AAPL | Stock | 7.2239 | 7.2271 | 7.2168 | 7.2221 | 5522972.0 |
| 2009-12-01 10:00:00 | AAPL | Stock | 7.22 | 7.2221 | 7.2082 | 7.2164 | 12536552.0 |
| 2009-12-01 10:05:00 | AAPL | Stock | 7.2161 | 7.2168 | 7.175 | 7.1782 | 14800828.0 |
| 2009-12-01 10:10:00 | AAPL | Stock | 7.1782 | 7.1879 | 7.1639 | 7.1836 | 10364508.0 |
| 2009-12-01 10:15:00 | AAPL | Stock | 7.1839 | 7.1857 | 7.18 | 7.1811 | 5264140.0 |
| 2009-12-01 10:20:00 | AAPL | Stock | 7.1811 | 7.1839 | 7.165 | 7.1686 | 8835232.0 |
| 2009-12-01 10:25:00 | AAPL | Stock | 7.1693 | 7.1711 | 7.1614 | 7.17 | 6945064.0 |
| 2009-12-01 10:30:00 | AAPL | Stock | 7.17 | 7.1904 | 7.1689 | 7.1869 | 7705432.0 |
| 2009-12-01 10:35:00 | AAPL | Stock | 7.1871 | 7.1882 | 7.1728 | 7.1764 | 4119584.0 |
| 2009-12-01 10:40:00 | AAPL | Stock | 7.1761 | 7.1857 | 7.1754 | 7.1807 | 2317868.0 |
| 2009-12-01 10:45:00 | AAPL | Stock | 7.1807 | 7.1843 | 7.1789 | 7.1818 | 3148880.0 |
| 2009-12-01 10:50:00 | AAPL | Stock | 7.1821 | 7.1836 | 7.1736 | 7.1771 | 3862768.0 |
| 2009-12-01 10:55:00 | AAPL | Stock | 7.1775 | 7.1889 | 7.175 | 7.1875 | 3522036.0 |
> showing 50 of 324,573 rows — these rows as CSV