PREVIEW / stock_5min / 2004-11-29
file: by_date/stock_5min/2004/2004-11-29.parquet size: 2.6 MB rows: 192,742 symbols: 1,883
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 |
|---|---|---|---|---|---|---|---|
| 2004-11-29 08:00:00 | AAPL | Stock | 1.2248 | 1.2293 | 1.2134 | 1.2161 | 4438224.0 |
| 2004-11-29 08:05:00 | AAPL | Stock | 1.2161 | 1.2188 | 1.2143 | 1.2161 | 4206048.0 |
| 2004-11-29 08:10:00 | AAPL | Stock | 1.2164 | 1.2179 | 1.2136 | 1.2143 | 2540216.0 |
| 2004-11-29 08:15:00 | AAPL | Stock | 1.2148 | 1.2179 | 1.2145 | 1.2154 | 1258096.0 |
| 2004-11-29 08:20:00 | AAPL | Stock | 1.2161 | 1.222 | 1.2152 | 1.2188 | 5209792.0 |
| 2004-11-29 08:25:00 | AAPL | Stock | 1.2188 | 1.2196 | 1.2161 | 1.2168 | 4470200.0 |
| 2004-11-29 08:30:00 | AAPL | Stock | 1.2166 | 1.2171 | 1.2152 | 1.2161 | 2500400.0 |
| 2004-11-29 08:35:00 | AAPL | Stock | 1.2161 | 1.2175 | 1.2154 | 1.2161 | 1324848.0 |
| 2004-11-29 08:40:00 | AAPL | Stock | 1.2164 | 1.2205 | 1.2161 | 1.2205 | 1855504.0 |
| 2004-11-29 08:45:00 | AAPL | Stock | 1.2205 | 1.2239 | 1.2182 | 1.2198 | 3450440.0 |
| 2004-11-29 08:50:00 | AAPL | Stock | 1.2198 | 1.2205 | 1.2161 | 1.2161 | 1359176.0 |
| 2004-11-29 08:55:00 | AAPL | Stock | 1.2161 | 1.2179 | 1.2161 | 1.2175 | 664048.0 |
| 2004-11-29 09:00:00 | AAPL | Stock | 1.218 | 1.2225 | 1.2175 | 1.2225 | 3019184.0 |
| 2004-11-29 09:05:00 | AAPL | Stock | 1.223 | 1.2243 | 1.222 | 1.2243 | 4751096.0 |
| 2004-11-29 09:10:00 | AAPL | Stock | 1.2243 | 1.2254 | 1.2214 | 1.2241 | 5011272.0 |
| 2004-11-29 09:15:00 | AAPL | Stock | 1.2241 | 1.2254 | 1.2232 | 1.2238 | 2521456.0 |
| 2004-11-29 09:20:00 | AAPL | Stock | 1.2232 | 1.2241 | 1.2173 | 1.2173 | 3721312.0 |
| 2004-11-29 09:25:00 | AAPL | Stock | 1.217 | 1.2321 | 1.1786 | 1.2314 | 13863752.0 |
| 2004-11-29 09:30:00 | AAPL | Stock | 1.2321 | 1.2355 | 1.2243 | 1.2252 | 125890520.0 |
| 2004-11-29 09:35:00 | AAPL | Stock | 1.2252 | 1.2304 | 1.2204 | 1.225 | 67258968.0 |
| 2004-11-29 09:40:00 | AAPL | Stock | 1.225 | 1.2293 | 1.2229 | 1.225 | 59175480.0 |
| 2004-11-29 09:45:00 | AAPL | Stock | 1.2252 | 1.2409 | 1.2227 | 1.2405 | 70483392.0 |
| 2004-11-29 09:50:00 | AAPL | Stock | 1.2407 | 1.2423 | 1.2305 | 1.2316 | 73296720.0 |
| 2004-11-29 09:55:00 | AAPL | Stock | 1.2318 | 1.2318 | 1.2232 | 1.2241 | 53279912.0 |
| 2004-11-29 10:00:00 | AAPL | Stock | 1.2239 | 1.225 | 1.2161 | 1.2209 | 53396448.0 |
| 2004-11-29 10:05:00 | AAPL | Stock | 1.2204 | 1.2288 | 1.2196 | 1.2223 | 35669984.0 |
| 2004-11-29 10:10:00 | AAPL | Stock | 1.2223 | 1.2275 | 1.2207 | 1.2223 | 26546520.0 |
| 2004-11-29 10:15:00 | AAPL | Stock | 1.2223 | 1.2252 | 1.2198 | 1.2239 | 28707504.0 |
| 2004-11-29 10:20:00 | AAPL | Stock | 1.2241 | 1.2298 | 1.2239 | 1.2255 | 23551584.0 |
| 2004-11-29 10:25:00 | AAPL | Stock | 1.2254 | 1.2286 | 1.2246 | 1.2264 | 20479760.0 |
| 2004-11-29 10:30:00 | AAPL | Stock | 1.2264 | 1.2273 | 1.2241 | 1.2268 | 14794360.0 |
| 2004-11-29 10:35:00 | AAPL | Stock | 1.2268 | 1.2277 | 1.2257 | 1.2264 | 12166448.0 |
| 2004-11-29 10:40:00 | AAPL | Stock | 1.2264 | 1.2266 | 1.2209 | 1.2214 | 18528552.0 |
| 2004-11-29 10:45:00 | AAPL | Stock | 1.222 | 1.2232 | 1.2178 | 1.2204 | 25144672.0 |
| 2004-11-29 10:50:00 | AAPL | Stock | 1.2204 | 1.2232 | 1.2204 | 1.2225 | 15710968.0 |
| 2004-11-29 10:55:00 | AAPL | Stock | 1.2225 | 1.2227 | 1.2202 | 1.2209 | 9204384.0 |
| 2004-11-29 11:00:00 | AAPL | Stock | 1.2207 | 1.2216 | 1.2189 | 1.22 | 15034376.0 |
| 2004-11-29 11:05:00 | AAPL | Stock | 1.2202 | 1.2207 | 1.2125 | 1.215 | 30829008.0 |
| 2004-11-29 11:10:00 | AAPL | Stock | 1.215 | 1.2159 | 1.2107 | 1.2114 | 25302816.0 |
| 2004-11-29 11:15:00 | AAPL | Stock | 1.2116 | 1.2138 | 1.2082 | 1.2118 | 28986384.0 |
| 2004-11-29 11:20:00 | AAPL | Stock | 1.2118 | 1.215 | 1.2104 | 1.2143 | 18959192.0 |
| 2004-11-29 11:25:00 | AAPL | Stock | 1.2141 | 1.2148 | 1.2071 | 1.2077 | 21005656.0 |
| 2004-11-29 11:30:00 | AAPL | Stock | 1.2073 | 1.2093 | 1.2055 | 1.2057 | 22678320.0 |
| 2004-11-29 11:35:00 | AAPL | Stock | 1.2057 | 1.2104 | 1.2057 | 1.2095 | 18359208.0 |
| 2004-11-29 11:40:00 | AAPL | Stock | 1.2096 | 1.2114 | 1.2075 | 1.2077 | 16528008.0 |
| 2004-11-29 11:45:00 | AAPL | Stock | 1.2077 | 1.2091 | 1.2038 | 1.2059 | 22750952.0 |
| 2004-11-29 11:50:00 | AAPL | Stock | 1.2063 | 1.21 | 1.2061 | 1.2098 | 10020528.0 |
| 2004-11-29 11:55:00 | AAPL | Stock | 1.2096 | 1.21 | 1.2063 | 1.2071 | 11961600.0 |
| 2004-11-29 12:00:00 | AAPL | Stock | 1.2071 | 1.21 | 1.207 | 1.2088 | 9343712.0 |
| 2004-11-29 12:05:00 | AAPL | Stock | 1.2086 | 1.2089 | 1.205 | 1.2075 | 8160880.0 |
> showing 50 of 192,742 rows — these rows as CSV