PREVIEW / stock_5min / 2009-02-20
file: by_date/stock_5min/2009/2009-02-20.parquet size: 4.6 MB rows: 314,380 symbols: 3,366
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-02-20 07:05:00 | AAPL | Stock | 3.1921 | 3.1929 | 3.1921 | 3.1929 | 14000.0 |
| 2009-02-20 07:10:00 | AAPL | Stock | 3.1929 | 3.1929 | 3.1929 | 3.1929 | 2800.0 |
| 2009-02-20 07:35:00 | AAPL | Stock | 3.1786 | 3.1786 | 3.1786 | 3.1786 | 31640.0 |
| 2009-02-20 07:40:00 | AAPL | Stock | 3.1786 | 3.1786 | 3.1786 | 3.1786 | 8400.0 |
| 2009-02-20 07:45:00 | AAPL | Stock | 3.1696 | 3.1696 | 3.1643 | 3.1643 | 5600.0 |
| 2009-02-20 07:50:00 | AAPL | Stock | 3.1643 | 3.1718 | 3.1643 | 3.1718 | 19880.0 |
| 2009-02-20 08:00:00 | AAPL | Stock | 3.1904 | 3.1964 | 3.175 | 3.1839 | 295260.0 |
| 2009-02-20 08:05:00 | AAPL | Stock | 3.1839 | 3.1893 | 3.1839 | 3.1893 | 44240.0 |
| 2009-02-20 08:10:00 | AAPL | Stock | 3.1893 | 3.1957 | 3.1857 | 3.1857 | 159320.0 |
| 2009-02-20 08:15:00 | AAPL | Stock | 3.1857 | 3.1857 | 3.1804 | 3.1857 | 128940.0 |
| 2009-02-20 08:20:00 | AAPL | Stock | 3.1875 | 3.1879 | 3.1821 | 3.1821 | 39200.0 |
| 2009-02-20 08:25:00 | AAPL | Stock | 3.1811 | 3.1879 | 3.1811 | 3.1879 | 75488.0 |
| 2009-02-20 08:30:00 | AAPL | Stock | 3.1821 | 3.1857 | 3.1821 | 3.1857 | 75600.0 |
| 2009-02-20 08:35:00 | AAPL | Stock | 3.1907 | 3.1907 | 3.1821 | 3.1857 | 84000.0 |
| 2009-02-20 08:40:00 | AAPL | Stock | 3.19 | 3.1964 | 3.1821 | 3.1964 | 244300.0 |
| 2009-02-20 08:45:00 | AAPL | Stock | 3.1964 | 3.1989 | 3.1921 | 3.1964 | 223916.0 |
| 2009-02-20 08:50:00 | AAPL | Stock | 3.1964 | 3.1964 | 3.1957 | 3.1957 | 110040.0 |
| 2009-02-20 08:55:00 | AAPL | Stock | 3.1961 | 3.2011 | 3.1961 | 3.2004 | 156520.0 |
| 2009-02-20 09:00:00 | AAPL | Stock | 3.1982 | 3.1982 | 3.1836 | 3.1836 | 289828.0 |
| 2009-02-20 09:05:00 | AAPL | Stock | 3.1825 | 3.185 | 3.1786 | 3.1786 | 278740.0 |
| 2009-02-20 09:10:00 | AAPL | Stock | 3.1821 | 3.1821 | 3.1704 | 3.1718 | 326872.0 |
| 2009-02-20 09:15:00 | AAPL | Stock | 3.1714 | 3.175 | 3.1696 | 3.175 | 257376.0 |
| 2009-02-20 09:20:00 | AAPL | Stock | 3.1754 | 3.1918 | 3.1754 | 3.1893 | 332192.0 |
| 2009-02-20 09:25:00 | AAPL | Stock | 3.1893 | 3.2139 | 3.185 | 3.1943 | 2402736.0 |
| 2009-02-20 09:30:00 | AAPL | Stock | 3.1911 | 3.2204 | 3.1786 | 3.2196 | 40613692.0 |
| 2009-02-20 09:35:00 | AAPL | Stock | 3.2196 | 3.2343 | 3.2118 | 3.2171 | 15927632.0 |
| 2009-02-20 09:40:00 | AAPL | Stock | 3.2179 | 3.22 | 3.2007 | 3.215 | 10907624.0 |
| 2009-02-20 09:45:00 | AAPL | Stock | 3.2143 | 3.2318 | 3.2143 | 3.2196 | 13142612.0 |
| 2009-02-20 09:50:00 | AAPL | Stock | 3.22 | 3.2404 | 3.2143 | 3.2275 | 14273168.0 |
| 2009-02-20 09:55:00 | AAPL | Stock | 3.2275 | 3.2368 | 3.2207 | 3.2257 | 12171572.0 |
| 2009-02-20 10:00:00 | AAPL | Stock | 3.2261 | 3.2314 | 3.21 | 3.2179 | 10418828.0 |
| 2009-02-20 10:05:00 | AAPL | Stock | 3.2175 | 3.24 | 3.2164 | 3.2292 | 15109948.0 |
| 2009-02-20 10:10:00 | AAPL | Stock | 3.2293 | 3.2393 | 3.2268 | 3.2316 | 8357608.0 |
| 2009-02-20 10:15:00 | AAPL | Stock | 3.2318 | 3.2325 | 3.2146 | 3.2146 | 9230984.0 |
| 2009-02-20 10:20:00 | AAPL | Stock | 3.2146 | 3.2161 | 3.2018 | 3.2018 | 11587156.0 |
| 2009-02-20 10:25:00 | AAPL | Stock | 3.2018 | 3.2196 | 3.1989 | 3.2162 | 10448480.0 |
| 2009-02-20 10:30:00 | AAPL | Stock | 3.2161 | 3.2171 | 3.2107 | 3.2136 | 6580812.0 |
| 2009-02-20 10:35:00 | AAPL | Stock | 3.2136 | 3.2264 | 3.2104 | 3.2211 | 8592052.0 |
| 2009-02-20 10:40:00 | AAPL | Stock | 3.2204 | 3.2236 | 3.2114 | 3.2196 | 7533260.0 |
| 2009-02-20 10:45:00 | AAPL | Stock | 3.2196 | 3.2243 | 3.2139 | 3.2168 | 4943512.0 |
| 2009-02-20 10:50:00 | AAPL | Stock | 3.217 | 3.2171 | 3.2025 | 3.2079 | 6935768.0 |
| 2009-02-20 10:55:00 | AAPL | Stock | 3.2079 | 3.2096 | 3.1964 | 3.205 | 6951476.0 |
| 2009-02-20 11:00:00 | AAPL | Stock | 3.2046 | 3.2121 | 3.2039 | 3.2079 | 4236708.0 |
| 2009-02-20 11:05:00 | AAPL | Stock | 3.2075 | 3.2121 | 3.1993 | 3.2018 | 5999924.0 |
| 2009-02-20 11:10:00 | AAPL | Stock | 3.2018 | 3.2057 | 3.1982 | 3.1982 | 7484736.0 |
| 2009-02-20 11:15:00 | AAPL | Stock | 3.1982 | 3.2061 | 3.1975 | 3.2061 | 8591912.0 |
| 2009-02-20 11:20:00 | AAPL | Stock | 3.2061 | 3.2093 | 3.2036 | 3.205 | 5329072.0 |
| 2009-02-20 11:25:00 | AAPL | Stock | 3.2054 | 3.2143 | 3.2046 | 3.2121 | 5684224.0 |
| 2009-02-20 11:30:00 | AAPL | Stock | 3.2118 | 3.2139 | 3.2057 | 3.2111 | 5591544.0 |
| 2009-02-20 11:35:00 | AAPL | Stock | 3.211 | 3.22 | 3.2104 | 3.2189 | 9657256.0 |
> showing 50 of 314,380 rows — these rows as CSV