PREVIEW / stock_5min / 2006-04-04
file: by_date/stock_5min/2006/2006-04-04.parquet size: 3.1 MB rows: 225,728 symbols: 2,229
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 |
|---|---|---|---|---|---|---|---|
| 2006-04-04 07:15:00 | AAPL | Stock | 2.2539 | 2.2539 | 2.2539 | 2.2539 | 2800.0 |
| 2006-04-04 07:25:00 | AAPL | Stock | 2.2321 | 2.2321 | 2.2321 | 2.2321 | 14000.0 |
| 2006-04-04 07:35:00 | AAPL | Stock | 2.2321 | 2.2321 | 2.2321 | 2.2321 | 28000.0 |
| 2006-04-04 07:40:00 | AAPL | Stock | 2.2321 | 2.2321 | 2.2321 | 2.2321 | 5600.0 |
| 2006-04-04 08:00:00 | AAPL | Stock | 2.2304 | 2.2318 | 2.2236 | 2.2286 | 291480.0 |
| 2006-04-04 08:05:00 | AAPL | Stock | 2.2304 | 2.2304 | 2.2304 | 2.2304 | 51800.0 |
| 2006-04-04 08:10:00 | AAPL | Stock | 2.2286 | 2.2304 | 2.2275 | 2.2286 | 175420.0 |
| 2006-04-04 08:15:00 | AAPL | Stock | 2.2286 | 2.2304 | 2.2279 | 2.2279 | 269360.0 |
| 2006-04-04 08:20:00 | AAPL | Stock | 2.2286 | 2.2286 | 2.2279 | 2.2279 | 290500.0 |
| 2006-04-04 08:25:00 | AAPL | Stock | 2.2279 | 2.2279 | 2.2275 | 2.2275 | 70000.0 |
| 2006-04-04 08:30:00 | AAPL | Stock | 2.2275 | 2.2304 | 2.2271 | 2.2304 | 96320.0 |
| 2006-04-04 08:35:00 | AAPL | Stock | 2.2304 | 2.2318 | 2.2286 | 2.2286 | 148400.0 |
| 2006-04-04 08:40:00 | AAPL | Stock | 2.2304 | 2.2304 | 2.2286 | 2.2286 | 95200.0 |
| 2006-04-04 08:45:00 | AAPL | Stock | 2.2304 | 2.2311 | 2.2304 | 2.2307 | 61600.0 |
| 2006-04-04 08:50:00 | AAPL | Stock | 2.2307 | 2.2307 | 2.2282 | 2.2293 | 227360.0 |
| 2006-04-04 08:55:00 | AAPL | Stock | 2.2304 | 2.2375 | 2.2282 | 2.2282 | 205800.0 |
| 2006-04-04 09:00:00 | AAPL | Stock | 2.2282 | 2.2286 | 2.2214 | 2.2239 | 645316.0 |
| 2006-04-04 09:05:00 | AAPL | Stock | 2.2239 | 2.2239 | 2.2111 | 2.2182 | 1750028.0 |
| 2006-04-04 09:10:00 | AAPL | Stock | 2.2182 | 2.2214 | 2.2171 | 2.2214 | 593740.0 |
| 2006-04-04 09:15:00 | AAPL | Stock | 2.2214 | 2.2214 | 2.2193 | 2.2214 | 258552.0 |
| 2006-04-04 09:20:00 | AAPL | Stock | 2.2193 | 2.2379 | 2.2168 | 2.2186 | 315812.0 |
| 2006-04-04 09:25:00 | AAPL | Stock | 2.2221 | 2.2221 | 2.2161 | 2.2175 | 619444.0 |
| 2006-04-04 09:30:00 | AAPL | Stock | 2.2179 | 2.2189 | 2.2007 | 2.2114 | 35262696.0 |
| 2006-04-04 09:35:00 | AAPL | Stock | 2.2114 | 2.2128 | 2.205 | 2.2093 | 20677524.0 |
| 2006-04-04 09:40:00 | AAPL | Stock | 2.2089 | 2.2089 | 2.1986 | 2.2007 | 26456192.0 |
| 2006-04-04 09:45:00 | AAPL | Stock | 2.2011 | 2.205 | 2.1932 | 2.2018 | 35090076.0 |
| 2006-04-04 09:50:00 | AAPL | Stock | 2.2018 | 2.2129 | 2.2011 | 2.2107 | 31304588.0 |
| 2006-04-04 09:55:00 | AAPL | Stock | 2.2114 | 2.2179 | 2.2057 | 2.2061 | 27539456.0 |
| 2006-04-04 10:00:00 | AAPL | Stock | 2.2061 | 2.2114 | 2.205 | 2.2096 | 14617904.0 |
| 2006-04-04 10:05:00 | AAPL | Stock | 2.2096 | 2.2129 | 2.2036 | 2.2046 | 11825016.0 |
| 2006-04-04 10:10:00 | AAPL | Stock | 2.2046 | 2.2064 | 2.1996 | 2.2036 | 14146300.0 |
| 2006-04-04 10:15:00 | AAPL | Stock | 2.2039 | 2.2168 | 2.2025 | 2.2164 | 13641404.0 |
| 2006-04-04 10:20:00 | AAPL | Stock | 2.2164 | 2.2221 | 2.2118 | 2.2164 | 24167780.0 |
| 2006-04-04 10:25:00 | AAPL | Stock | 2.2164 | 2.2214 | 2.2129 | 2.2132 | 11309620.0 |
| 2006-04-04 10:30:00 | AAPL | Stock | 2.2136 | 2.2143 | 2.2075 | 2.2096 | 11496772.0 |
| 2006-04-04 10:35:00 | AAPL | Stock | 2.21 | 2.21 | 2.2025 | 2.2029 | 12258764.0 |
| 2006-04-04 10:40:00 | AAPL | Stock | 2.2025 | 2.2054 | 2.1961 | 2.1979 | 20058668.0 |
| 2006-04-04 10:45:00 | AAPL | Stock | 2.1979 | 2.2021 | 2.1961 | 2.2014 | 17138352.0 |
| 2006-04-04 10:50:00 | AAPL | Stock | 2.2018 | 2.2018 | 2.1961 | 2.1964 | 11214168.0 |
| 2006-04-04 10:55:00 | AAPL | Stock | 2.1968 | 2.1975 | 2.1861 | 2.1882 | 27144152.0 |
| 2006-04-04 11:00:00 | AAPL | Stock | 2.1882 | 2.1929 | 2.1807 | 2.1818 | 22275932.0 |
| 2006-04-04 11:05:00 | AAPL | Stock | 2.1818 | 2.1886 | 2.1807 | 2.1861 | 17656296.0 |
| 2006-04-04 11:10:00 | AAPL | Stock | 2.1864 | 2.1889 | 2.1825 | 2.1875 | 13333460.0 |
| 2006-04-04 11:15:00 | AAPL | Stock | 2.1875 | 2.1946 | 2.1871 | 2.1921 | 9524816.0 |
| 2006-04-04 11:20:00 | AAPL | Stock | 2.1921 | 2.1921 | 2.185 | 2.1857 | 7244552.0 |
| 2006-04-04 11:25:00 | AAPL | Stock | 2.1857 | 2.1954 | 2.1857 | 2.1911 | 10559108.0 |
| 2006-04-04 11:30:00 | AAPL | Stock | 2.1907 | 2.195 | 2.1904 | 2.1939 | 7228788.0 |
| 2006-04-04 11:35:00 | AAPL | Stock | 2.1936 | 2.2011 | 2.1936 | 2.1997 | 11545240.0 |
| 2006-04-04 11:40:00 | AAPL | Stock | 2.1993 | 2.2039 | 2.1964 | 2.2032 | 10474716.0 |
| 2006-04-04 11:45:00 | AAPL | Stock | 2.2032 | 2.2071 | 2.2018 | 2.2032 | 13633816.0 |
> showing 50 of 225,728 rows — these rows as CSV