PREVIEW / stock_5min / 2002-07-16
file: by_date/stock_5min/2002/2002-07-16.parquet size: 1.9 MB rows: 129,910 symbols: 1,451
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 |
|---|---|---|---|---|---|---|---|
| 2002-07-16 08:25:00 | AAPL | Stock | 0.3205 | 0.3205 | 0.3205 | 0.3205 | 11200.0 |
| 2002-07-16 08:35:00 | AAPL | Stock | 0.3205 | 0.3205 | 0.3205 | 0.3205 | 44800.0 |
| 2002-07-16 08:40:00 | AAPL | Stock | 0.3214 | 0.3214 | 0.3214 | 0.3214 | 16800.0 |
| 2002-07-16 09:05:00 | AAPL | Stock | 0.3232 | 0.3232 | 0.3232 | 0.3232 | 28000.0 |
| 2002-07-16 09:10:00 | AAPL | Stock | 0.3254 | 0.3255 | 0.3248 | 0.3255 | 39200.0 |
| 2002-07-16 09:20:00 | AAPL | Stock | 0.3241 | 0.3241 | 0.3241 | 0.3241 | 280000.0 |
| 2002-07-16 09:25:00 | AAPL | Stock | 0.3236 | 0.3241 | 0.3214 | 0.3241 | 1215200.0 |
| 2002-07-16 09:30:00 | AAPL | Stock | 0.3241 | 0.3271 | 0.3223 | 0.3271 | 11071200.0 |
| 2002-07-16 09:35:00 | AAPL | Stock | 0.3271 | 0.3284 | 0.3263 | 0.3275 | 10500000.0 |
| 2002-07-16 09:40:00 | AAPL | Stock | 0.3275 | 0.3288 | 0.3263 | 0.3266 | 3628800.0 |
| 2002-07-16 09:45:00 | AAPL | Stock | 0.3266 | 0.3268 | 0.3261 | 0.3268 | 6910400.0 |
| 2002-07-16 09:50:00 | AAPL | Stock | 0.3266 | 0.3296 | 0.3266 | 0.3282 | 5359200.0 |
| 2002-07-16 09:55:00 | AAPL | Stock | 0.3282 | 0.3293 | 0.3268 | 0.3268 | 4552800.0 |
| 2002-07-16 10:00:00 | AAPL | Stock | 0.3271 | 0.3291 | 0.3268 | 0.3275 | 6647200.0 |
| 2002-07-16 10:05:00 | AAPL | Stock | 0.3273 | 0.328 | 0.3259 | 0.3266 | 4653600.0 |
| 2002-07-16 10:10:00 | AAPL | Stock | 0.3264 | 0.33 | 0.3264 | 0.3298 | 6916000.0 |
| 2002-07-16 10:15:00 | AAPL | Stock | 0.3297 | 0.3316 | 0.3289 | 0.3289 | 6748000.0 |
| 2002-07-16 10:20:00 | AAPL | Stock | 0.3289 | 0.3307 | 0.3269 | 0.3295 | 3376800.0 |
| 2002-07-16 10:25:00 | AAPL | Stock | 0.3305 | 0.3305 | 0.3266 | 0.3266 | 5157600.0 |
| 2002-07-16 10:30:00 | AAPL | Stock | 0.3273 | 0.3295 | 0.327 | 0.3286 | 6484800.0 |
| 2002-07-16 10:35:00 | AAPL | Stock | 0.3288 | 0.3296 | 0.3277 | 0.328 | 11037600.0 |
| 2002-07-16 10:40:00 | AAPL | Stock | 0.3286 | 0.3295 | 0.3277 | 0.3286 | 8618400.0 |
| 2002-07-16 10:45:00 | AAPL | Stock | 0.3284 | 0.3293 | 0.3277 | 0.3282 | 5168800.0 |
| 2002-07-16 10:50:00 | AAPL | Stock | 0.3289 | 0.3293 | 0.328 | 0.3286 | 20216000.0 |
| 2002-07-16 10:55:00 | AAPL | Stock | 0.3286 | 0.3291 | 0.3284 | 0.3288 | 4877600.0 |
| 2002-07-16 11:00:00 | AAPL | Stock | 0.3288 | 0.3296 | 0.3286 | 0.3295 | 7588000.0 |
| 2002-07-16 11:05:00 | AAPL | Stock | 0.3295 | 0.33 | 0.3289 | 0.3293 | 10332000.0 |
| 2002-07-16 11:10:00 | AAPL | Stock | 0.3293 | 0.3293 | 0.3273 | 0.3273 | 4541600.0 |
| 2002-07-16 11:15:00 | AAPL | Stock | 0.3273 | 0.3284 | 0.3261 | 0.3275 | 3360000.0 |
| 2002-07-16 11:20:00 | AAPL | Stock | 0.3277 | 0.3288 | 0.3268 | 0.3282 | 3595200.0 |
| 2002-07-16 11:25:00 | AAPL | Stock | 0.3282 | 0.3282 | 0.325 | 0.325 | 6826400.0 |
| 2002-07-16 11:30:00 | AAPL | Stock | 0.3251 | 0.3272 | 0.3246 | 0.3259 | 5527200.0 |
| 2002-07-16 11:35:00 | AAPL | Stock | 0.3254 | 0.3268 | 0.3254 | 0.3261 | 1237600.0 |
| 2002-07-16 11:40:00 | AAPL | Stock | 0.3261 | 0.3268 | 0.3257 | 0.3259 | 4071200.0 |
| 2002-07-16 11:45:00 | AAPL | Stock | 0.3268 | 0.3298 | 0.3261 | 0.3295 | 4496800.0 |
| 2002-07-16 11:50:00 | AAPL | Stock | 0.3295 | 0.3304 | 0.3284 | 0.3284 | 8461600.0 |
| 2002-07-16 11:55:00 | AAPL | Stock | 0.3286 | 0.3295 | 0.328 | 0.3282 | 13636000.0 |
| 2002-07-16 12:00:00 | AAPL | Stock | 0.3282 | 0.3289 | 0.3277 | 0.328 | 2564800.0 |
| 2002-07-16 12:05:00 | AAPL | Stock | 0.328 | 0.328 | 0.3275 | 0.3279 | 1730400.0 |
| 2002-07-16 12:10:00 | AAPL | Stock | 0.3279 | 0.328 | 0.3271 | 0.3271 | 1215200.0 |
| 2002-07-16 12:15:00 | AAPL | Stock | 0.3271 | 0.3277 | 0.3264 | 0.327 | 2049600.0 |
| 2002-07-16 12:20:00 | AAPL | Stock | 0.3263 | 0.3286 | 0.3254 | 0.3273 | 3757600.0 |
| 2002-07-16 12:25:00 | AAPL | Stock | 0.328 | 0.3286 | 0.3271 | 0.3277 | 1988000.0 |
| 2002-07-16 12:30:00 | AAPL | Stock | 0.328 | 0.3286 | 0.327 | 0.3284 | 1943200.0 |
| 2002-07-16 12:35:00 | AAPL | Stock | 0.3284 | 0.33 | 0.3277 | 0.3288 | 3102400.0 |
| 2002-07-16 12:40:00 | AAPL | Stock | 0.3293 | 0.3295 | 0.3277 | 0.3293 | 4636800.0 |
| 2002-07-16 12:45:00 | AAPL | Stock | 0.3294 | 0.3302 | 0.3291 | 0.3302 | 5426400.0 |
| 2002-07-16 12:50:00 | AAPL | Stock | 0.3302 | 0.3304 | 0.3286 | 0.3291 | 2161600.0 |
| 2002-07-16 12:55:00 | AAPL | Stock | 0.3289 | 0.3296 | 0.3286 | 0.3286 | 1260000.0 |
| 2002-07-16 13:00:00 | AAPL | Stock | 0.3286 | 0.3288 | 0.3268 | 0.3268 | 5034400.0 |
> showing 50 of 129,910 rows — these rows as CSV