PREVIEW / stock_5min / 2001-09-04
file: by_date/stock_5min/2001/2001-09-04.parquet size: 1.6 MB rows: 111,975 symbols: 1,335
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-09-04 08:25:00 | AAPL | Stock | 0.3321 | 0.3321 | 0.3321 | 0.3321 | 11200.0 |
| 2001-09-04 08:50:00 | AAPL | Stock | 0.3321 | 0.3321 | 0.3321 | 0.3321 | 39200.0 |
| 2001-09-04 09:10:00 | AAPL | Stock | 0.3321 | 0.3322 | 0.3321 | 0.3321 | 61600.0 |
| 2001-09-04 09:20:00 | AAPL | Stock | 0.3325 | 0.3325 | 0.3323 | 0.3323 | 95200.0 |
| 2001-09-04 09:25:00 | AAPL | Stock | 0.3316 | 0.3318 | 0.3304 | 0.3304 | 285600.0 |
| 2001-09-04 09:30:00 | AAPL | Stock | 0.3304 | 0.3307 | 0.3271 | 0.3296 | 4351200.0 |
| 2001-09-04 09:35:00 | AAPL | Stock | 0.3295 | 0.3298 | 0.3259 | 0.327 | 3668000.0 |
| 2001-09-04 09:40:00 | AAPL | Stock | 0.3268 | 0.3277 | 0.3259 | 0.3277 | 2251200.0 |
| 2001-09-04 09:45:00 | AAPL | Stock | 0.3277 | 0.3279 | 0.3254 | 0.3271 | 5202400.0 |
| 2001-09-04 09:50:00 | AAPL | Stock | 0.327 | 0.327 | 0.3246 | 0.3255 | 4278400.0 |
| 2001-09-04 09:55:00 | AAPL | Stock | 0.3257 | 0.3284 | 0.3254 | 0.3282 | 4054400.0 |
| 2001-09-04 10:00:00 | AAPL | Stock | 0.3282 | 0.3375 | 0.3273 | 0.3359 | 6899200.0 |
| 2001-09-04 10:05:00 | AAPL | Stock | 0.335 | 0.3375 | 0.3343 | 0.3364 | 6059200.0 |
| 2001-09-04 10:10:00 | AAPL | Stock | 0.3366 | 0.3377 | 0.333 | 0.3359 | 3236800.0 |
| 2001-09-04 10:15:00 | AAPL | Stock | 0.3366 | 0.3375 | 0.3341 | 0.3343 | 2385600.0 |
| 2001-09-04 10:20:00 | AAPL | Stock | 0.3341 | 0.3348 | 0.3314 | 0.3314 | 4513600.0 |
| 2001-09-04 10:25:00 | AAPL | Stock | 0.3314 | 0.3331 | 0.3302 | 0.3307 | 5611200.0 |
| 2001-09-04 10:30:00 | AAPL | Stock | 0.3311 | 0.332 | 0.3304 | 0.3304 | 4821600.0 |
| 2001-09-04 10:35:00 | AAPL | Stock | 0.3304 | 0.3313 | 0.3275 | 0.3289 | 9368800.0 |
| 2001-09-04 10:40:00 | AAPL | Stock | 0.3289 | 0.3305 | 0.3286 | 0.3304 | 6916000.0 |
| 2001-09-04 10:45:00 | AAPL | Stock | 0.3296 | 0.3309 | 0.3289 | 0.3298 | 5628000.0 |
| 2001-09-04 10:50:00 | AAPL | Stock | 0.3298 | 0.3302 | 0.3295 | 0.3295 | 2760800.0 |
| 2001-09-04 10:55:00 | AAPL | Stock | 0.33 | 0.3325 | 0.33 | 0.332 | 2430400.0 |
| 2001-09-04 11:00:00 | AAPL | Stock | 0.3319 | 0.3327 | 0.3313 | 0.3313 | 1439200.0 |
| 2001-09-04 11:05:00 | AAPL | Stock | 0.3316 | 0.3321 | 0.3304 | 0.3313 | 2923200.0 |
| 2001-09-04 11:10:00 | AAPL | Stock | 0.3314 | 0.3316 | 0.3288 | 0.3305 | 5079200.0 |
| 2001-09-04 11:15:00 | AAPL | Stock | 0.3305 | 0.3321 | 0.3298 | 0.3305 | 2072000.0 |
| 2001-09-04 11:20:00 | AAPL | Stock | 0.3305 | 0.3329 | 0.33 | 0.3325 | 2290400.0 |
| 2001-09-04 11:25:00 | AAPL | Stock | 0.3325 | 0.3334 | 0.3305 | 0.333 | 4043200.0 |
| 2001-09-04 11:30:00 | AAPL | Stock | 0.3331 | 0.3341 | 0.3304 | 0.3321 | 10539200.0 |
| 2001-09-04 11:35:00 | AAPL | Stock | 0.3321 | 0.3348 | 0.3321 | 0.3348 | 3152800.0 |
| 2001-09-04 11:40:00 | AAPL | Stock | 0.3346 | 0.3355 | 0.3338 | 0.3348 | 1646400.0 |
| 2001-09-04 11:45:00 | AAPL | Stock | 0.3348 | 0.3348 | 0.3325 | 0.3334 | 481600.0 |
| 2001-09-04 11:50:00 | AAPL | Stock | 0.3339 | 0.3346 | 0.3329 | 0.3341 | 2111200.0 |
| 2001-09-04 11:55:00 | AAPL | Stock | 0.3339 | 0.3354 | 0.3336 | 0.3339 | 3130400.0 |
| 2001-09-04 12:00:00 | AAPL | Stock | 0.3338 | 0.3368 | 0.3338 | 0.3366 | 1915200.0 |
| 2001-09-04 12:05:00 | AAPL | Stock | 0.3366 | 0.3375 | 0.3352 | 0.3375 | 2548000.0 |
| 2001-09-04 12:10:00 | AAPL | Stock | 0.3375 | 0.3389 | 0.3363 | 0.3364 | 2531200.0 |
| 2001-09-04 12:15:00 | AAPL | Stock | 0.337 | 0.337 | 0.3354 | 0.3356 | 588000.0 |
| 2001-09-04 12:20:00 | AAPL | Stock | 0.3357 | 0.3361 | 0.3348 | 0.335 | 1299200.0 |
| 2001-09-04 12:25:00 | AAPL | Stock | 0.3353 | 0.337 | 0.3348 | 0.3368 | 5101600.0 |
| 2001-09-04 12:30:00 | AAPL | Stock | 0.337 | 0.3382 | 0.3368 | 0.3375 | 1400000.0 |
| 2001-09-04 12:35:00 | AAPL | Stock | 0.3375 | 0.3391 | 0.337 | 0.3388 | 2290400.0 |
| 2001-09-04 12:40:00 | AAPL | Stock | 0.3391 | 0.3398 | 0.3379 | 0.3398 | 3836000.0 |
| 2001-09-04 12:45:00 | AAPL | Stock | 0.3398 | 0.3407 | 0.3384 | 0.3389 | 2816800.0 |
| 2001-09-04 12:50:00 | AAPL | Stock | 0.3386 | 0.3386 | 0.3359 | 0.3359 | 4328800.0 |
| 2001-09-04 12:55:00 | AAPL | Stock | 0.3361 | 0.3371 | 0.3357 | 0.3363 | 1332800.0 |
| 2001-09-04 13:00:00 | AAPL | Stock | 0.3371 | 0.338 | 0.3363 | 0.3364 | 1635200.0 |
| 2001-09-04 13:05:00 | AAPL | Stock | 0.3365 | 0.337 | 0.3354 | 0.3354 | 1002400.0 |
| 2001-09-04 13:10:00 | AAPL | Stock | 0.3352 | 0.3354 | 0.3338 | 0.3348 | 2486400.0 |
> showing 50 of 111,975 rows — these rows as CSV