PREVIEW / stock_5min / 2004-11-30
file: by_date/stock_5min/2004/2004-11-30.parquet size: 2.6 MB rows: 193,716 symbols: 1,894
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-30 08:00:00 | AAPL | Stock | 1.233 | 1.2375 | 1.2286 | 1.2295 | 756112.0 |
| 2004-11-30 08:05:00 | AAPL | Stock | 1.2286 | 1.2287 | 1.2259 | 1.2268 | 627312.0 |
| 2004-11-30 08:10:00 | AAPL | Stock | 1.2268 | 1.2277 | 1.2264 | 1.2277 | 184800.0 |
| 2004-11-30 08:15:00 | AAPL | Stock | 1.2277 | 1.2277 | 1.2268 | 1.2268 | 129640.0 |
| 2004-11-30 08:20:00 | AAPL | Stock | 1.2273 | 1.2288 | 1.2273 | 1.2273 | 219408.0 |
| 2004-11-30 08:25:00 | AAPL | Stock | 1.2277 | 1.2277 | 1.2261 | 1.2275 | 473480.0 |
| 2004-11-30 08:30:00 | AAPL | Stock | 1.2271 | 1.2286 | 1.2257 | 1.2277 | 824824.0 |
| 2004-11-30 08:35:00 | AAPL | Stock | 1.2277 | 1.2277 | 1.2259 | 1.2277 | 427616.0 |
| 2004-11-30 08:40:00 | AAPL | Stock | 1.2277 | 1.2277 | 1.2261 | 1.2268 | 77336.0 |
| 2004-11-30 08:45:00 | AAPL | Stock | 1.2273 | 1.2277 | 1.2257 | 1.2257 | 436744.0 |
| 2004-11-30 08:50:00 | AAPL | Stock | 1.2257 | 1.2268 | 1.2257 | 1.2268 | 44800.0 |
| 2004-11-30 08:55:00 | AAPL | Stock | 1.2264 | 1.2264 | 1.2264 | 1.2264 | 8400.0 |
| 2004-11-30 09:00:00 | AAPL | Stock | 1.2257 | 1.2264 | 1.2257 | 1.2259 | 72800.0 |
| 2004-11-30 09:05:00 | AAPL | Stock | 1.2259 | 1.2264 | 1.2257 | 1.2264 | 57456.0 |
| 2004-11-30 09:10:00 | AAPL | Stock | 1.2259 | 1.2286 | 1.2259 | 1.2268 | 731416.0 |
| 2004-11-30 09:15:00 | AAPL | Stock | 1.2266 | 1.2268 | 1.2263 | 1.2263 | 184800.0 |
| 2004-11-30 09:20:00 | AAPL | Stock | 1.2264 | 1.2268 | 1.2264 | 1.2268 | 181496.0 |
| 2004-11-30 09:25:00 | AAPL | Stock | 1.2239 | 1.2288 | 1.2239 | 1.2284 | 3536456.0 |
| 2004-11-30 09:30:00 | AAPL | Stock | 1.2284 | 1.2284 | 1.2166 | 1.217 | 47656056.0 |
| 2004-11-30 09:35:00 | AAPL | Stock | 1.217 | 1.2213 | 1.2064 | 1.2095 | 40758312.0 |
| 2004-11-30 09:40:00 | AAPL | Stock | 1.2093 | 1.217 | 1.2086 | 1.2143 | 25912936.0 |
| 2004-11-30 09:45:00 | AAPL | Stock | 1.2143 | 1.2188 | 1.2138 | 1.2148 | 19880560.0 |
| 2004-11-30 09:50:00 | AAPL | Stock | 1.2146 | 1.217 | 1.2116 | 1.2152 | 17914568.0 |
| 2004-11-30 09:55:00 | AAPL | Stock | 1.215 | 1.2221 | 1.2136 | 1.2204 | 18801384.0 |
| 2004-11-30 10:00:00 | AAPL | Stock | 1.2204 | 1.2223 | 1.2134 | 1.2139 | 29248352.0 |
| 2004-11-30 10:05:00 | AAPL | Stock | 1.2138 | 1.2152 | 1.2098 | 1.2098 | 21312144.0 |
| 2004-11-30 10:10:00 | AAPL | Stock | 1.2098 | 1.2125 | 1.2082 | 1.2118 | 18210864.0 |
| 2004-11-30 10:15:00 | AAPL | Stock | 1.212 | 1.2139 | 1.2089 | 1.2107 | 15257368.0 |
| 2004-11-30 10:20:00 | AAPL | Stock | 1.2107 | 1.2111 | 1.2089 | 1.2104 | 10411240.0 |
| 2004-11-30 10:25:00 | AAPL | Stock | 1.2104 | 1.2125 | 1.2071 | 1.2089 | 16230200.0 |
| 2004-11-30 10:30:00 | AAPL | Stock | 1.2089 | 1.2104 | 1.202 | 1.2045 | 30140656.0 |
| 2004-11-30 10:35:00 | AAPL | Stock | 1.2052 | 1.207 | 1.2034 | 1.205 | 12925080.0 |
| 2004-11-30 10:40:00 | AAPL | Stock | 1.205 | 1.208 | 1.2045 | 1.2071 | 9774968.0 |
| 2004-11-30 10:45:00 | AAPL | Stock | 1.2071 | 1.2093 | 1.2043 | 1.2046 | 14219632.0 |
| 2004-11-30 10:50:00 | AAPL | Stock | 1.2045 | 1.2068 | 1.2043 | 1.2057 | 7207424.0 |
| 2004-11-30 10:55:00 | AAPL | Stock | 1.2057 | 1.2061 | 1.2034 | 1.2055 | 10973648.0 |
| 2004-11-30 11:00:00 | AAPL | Stock | 1.205 | 1.2057 | 1.2007 | 1.2025 | 17170328.0 |
| 2004-11-30 11:05:00 | AAPL | Stock | 1.2025 | 1.2032 | 1.2002 | 1.2014 | 18077584.0 |
| 2004-11-30 11:10:00 | AAPL | Stock | 1.2018 | 1.2045 | 1.2013 | 1.2038 | 9674280.0 |
| 2004-11-30 11:15:00 | AAPL | Stock | 1.2038 | 1.2086 | 1.2027 | 1.208 | 10293584.0 |
| 2004-11-30 11:20:00 | AAPL | Stock | 1.2077 | 1.2089 | 1.2064 | 1.2073 | 8355816.0 |
| 2004-11-30 11:25:00 | AAPL | Stock | 1.2071 | 1.2116 | 1.2071 | 1.2098 | 12998048.0 |
| 2004-11-30 11:30:00 | AAPL | Stock | 1.2102 | 1.2111 | 1.2095 | 1.2111 | 11855984.0 |
| 2004-11-30 11:35:00 | AAPL | Stock | 1.2111 | 1.2155 | 1.2107 | 1.2155 | 16060016.0 |
| 2004-11-30 11:40:00 | AAPL | Stock | 1.2155 | 1.2182 | 1.2134 | 1.2148 | 16247000.0 |
| 2004-11-30 11:45:00 | AAPL | Stock | 1.2148 | 1.2154 | 1.2125 | 1.2145 | 15122632.0 |
| 2004-11-30 11:50:00 | AAPL | Stock | 1.2143 | 1.2146 | 1.2116 | 1.2129 | 12151720.0 |
| 2004-11-30 11:55:00 | AAPL | Stock | 1.2129 | 1.2145 | 1.2125 | 1.2143 | 8315272.0 |
| 2004-11-30 12:00:00 | AAPL | Stock | 1.2143 | 1.2146 | 1.2134 | 1.2136 | 4924192.0 |
| 2004-11-30 12:05:00 | AAPL | Stock | 1.2137 | 1.2143 | 1.2127 | 1.2141 | 5237512.0 |
> showing 50 of 193,716 rows — these rows as CSV