PREVIEW / stock_5min / 2001-10-29
file: by_date/stock_5min/2001/2001-10-29.parquet size: 1.6 MB rows: 109,541 symbols: 1,355
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 |
|---|---|---|---|---|---|---|---|
| 2001-10-29 08:25:00 | AAPL | Stock | 0.3332 | 0.3332 | 0.3332 | 0.3332 | 72800.0 |
| 2001-10-29 08:30:00 | AAPL | Stock | 0.3334 | 0.3334 | 0.3334 | 0.3334 | 56000.0 |
| 2001-10-29 09:15:00 | AAPL | Stock | 0.3329 | 0.3329 | 0.3329 | 0.3329 | 168000.0 |
| 2001-10-29 09:20:00 | AAPL | Stock | 0.3332 | 0.3332 | 0.3332 | 0.3332 | 5600.0 |
| 2001-10-29 09:30:00 | AAPL | Stock | 0.3316 | 0.3334 | 0.3304 | 0.3304 | 4754400.0 |
| 2001-10-29 09:35:00 | AAPL | Stock | 0.3304 | 0.3304 | 0.3241 | 0.3268 | 5868800.0 |
| 2001-10-29 09:40:00 | AAPL | Stock | 0.3268 | 0.3288 | 0.3259 | 0.327 | 4603200.0 |
| 2001-10-29 09:45:00 | AAPL | Stock | 0.327 | 0.3302 | 0.3268 | 0.33 | 5241600.0 |
| 2001-10-29 09:50:00 | AAPL | Stock | 0.3302 | 0.332 | 0.3289 | 0.3302 | 3018400.0 |
| 2001-10-29 09:55:00 | AAPL | Stock | 0.3291 | 0.33 | 0.3263 | 0.3282 | 3024000.0 |
| 2001-10-29 10:00:00 | AAPL | Stock | 0.3282 | 0.3282 | 0.3236 | 0.3273 | 5392800.0 |
| 2001-10-29 10:05:00 | AAPL | Stock | 0.3273 | 0.3273 | 0.3229 | 0.3254 | 5258400.0 |
| 2001-10-29 10:10:00 | AAPL | Stock | 0.3254 | 0.3261 | 0.3234 | 0.3261 | 2598400.0 |
| 2001-10-29 10:15:00 | AAPL | Stock | 0.3261 | 0.3261 | 0.3239 | 0.3255 | 3382400.0 |
| 2001-10-29 10:20:00 | AAPL | Stock | 0.3255 | 0.3277 | 0.3252 | 0.327 | 2363200.0 |
| 2001-10-29 10:25:00 | AAPL | Stock | 0.327 | 0.3279 | 0.3259 | 0.3268 | 1388800.0 |
| 2001-10-29 10:30:00 | AAPL | Stock | 0.3271 | 0.3293 | 0.3264 | 0.3291 | 1400000.0 |
| 2001-10-29 10:35:00 | AAPL | Stock | 0.3288 | 0.3295 | 0.3286 | 0.3295 | 957600.0 |
| 2001-10-29 10:40:00 | AAPL | Stock | 0.3295 | 0.3295 | 0.3261 | 0.3264 | 1652000.0 |
| 2001-10-29 10:45:00 | AAPL | Stock | 0.3261 | 0.3286 | 0.3255 | 0.3283 | 1584800.0 |
| 2001-10-29 10:50:00 | AAPL | Stock | 0.3287 | 0.3295 | 0.3282 | 0.3291 | 1870400.0 |
| 2001-10-29 10:55:00 | AAPL | Stock | 0.3289 | 0.33 | 0.3286 | 0.3298 | 1495200.0 |
| 2001-10-29 11:00:00 | AAPL | Stock | 0.33 | 0.33 | 0.3279 | 0.328 | 1528800.0 |
| 2001-10-29 11:05:00 | AAPL | Stock | 0.3279 | 0.3279 | 0.3255 | 0.3263 | 1366400.0 |
| 2001-10-29 11:10:00 | AAPL | Stock | 0.3259 | 0.3282 | 0.3255 | 0.3263 | 1288000.0 |
| 2001-10-29 11:15:00 | AAPL | Stock | 0.3263 | 0.3282 | 0.3263 | 0.3282 | 1041600.0 |
| 2001-10-29 11:20:00 | AAPL | Stock | 0.328 | 0.3282 | 0.3271 | 0.3282 | 565600.0 |
| 2001-10-29 11:25:00 | AAPL | Stock | 0.3282 | 0.3289 | 0.328 | 0.3282 | 728000.0 |
| 2001-10-29 11:30:00 | AAPL | Stock | 0.3286 | 0.3295 | 0.3284 | 0.3284 | 1444800.0 |
| 2001-10-29 11:35:00 | AAPL | Stock | 0.3289 | 0.3289 | 0.3271 | 0.3271 | 772800.0 |
| 2001-10-29 11:40:00 | AAPL | Stock | 0.3271 | 0.3282 | 0.3263 | 0.3273 | 1355200.0 |
| 2001-10-29 11:45:00 | AAPL | Stock | 0.3273 | 0.3286 | 0.3254 | 0.327 | 2716000.0 |
| 2001-10-29 11:50:00 | AAPL | Stock | 0.3279 | 0.3284 | 0.3263 | 0.3263 | 1596000.0 |
| 2001-10-29 11:55:00 | AAPL | Stock | 0.3263 | 0.3268 | 0.3259 | 0.3266 | 3432800.0 |
| 2001-10-29 12:00:00 | AAPL | Stock | 0.3263 | 0.3264 | 0.325 | 0.325 | 3707200.0 |
| 2001-10-29 12:05:00 | AAPL | Stock | 0.3255 | 0.3255 | 0.3239 | 0.3245 | 2749600.0 |
| 2001-10-29 12:10:00 | AAPL | Stock | 0.325 | 0.3271 | 0.325 | 0.327 | 772800.0 |
| 2001-10-29 12:15:00 | AAPL | Stock | 0.327 | 0.3275 | 0.3254 | 0.3259 | 1153600.0 |
| 2001-10-29 12:20:00 | AAPL | Stock | 0.3261 | 0.3263 | 0.3255 | 0.3261 | 420000.0 |
| 2001-10-29 12:25:00 | AAPL | Stock | 0.3261 | 0.3271 | 0.325 | 0.3254 | 4065600.0 |
| 2001-10-29 12:30:00 | AAPL | Stock | 0.3263 | 0.3268 | 0.3252 | 0.3252 | 1131200.0 |
| 2001-10-29 12:35:00 | AAPL | Stock | 0.3263 | 0.3263 | 0.3229 | 0.3232 | 1892800.0 |
| 2001-10-29 12:40:00 | AAPL | Stock | 0.3234 | 0.3246 | 0.3232 | 0.3246 | 1926400.0 |
| 2001-10-29 12:45:00 | AAPL | Stock | 0.3246 | 0.3254 | 0.3243 | 0.3246 | 571200.0 |
| 2001-10-29 12:50:00 | AAPL | Stock | 0.3248 | 0.3252 | 0.3241 | 0.3252 | 638400.0 |
| 2001-10-29 12:55:00 | AAPL | Stock | 0.3246 | 0.3255 | 0.3239 | 0.3243 | 1920800.0 |
| 2001-10-29 13:00:00 | AAPL | Stock | 0.3243 | 0.3252 | 0.3239 | 0.3252 | 632800.0 |
| 2001-10-29 13:05:00 | AAPL | Stock | 0.3254 | 0.3254 | 0.3241 | 0.3245 | 548800.0 |
| 2001-10-29 13:10:00 | AAPL | Stock | 0.3245 | 0.3245 | 0.3234 | 0.3243 | 1713600.0 |
| 2001-10-29 13:15:00 | AAPL | Stock | 0.3245 | 0.3245 | 0.3234 | 0.3243 | 890400.0 |
> showing 50 of 109,541 rows — these rows as CSV