PREVIEW / stock_5min / 2001-07-31
file: by_date/stock_5min/2001/2001-07-31.parquet size: 1.6 MB rows: 112,539 symbols: 1,329
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-07-31 08:05:00 | AAPL | Stock | 0.3386 | 0.3386 | 0.3386 | 0.3386 | 56000.0 |
| 2001-07-31 08:10:00 | AAPL | Stock | 0.338 | 0.338 | 0.338 | 0.338 | 134400.0 |
| 2001-07-31 08:30:00 | AAPL | Stock | 0.3384 | 0.3384 | 0.3384 | 0.3384 | 16800.0 |
| 2001-07-31 08:35:00 | AAPL | Stock | 0.3384 | 0.3384 | 0.3384 | 0.3384 | 56000.0 |
| 2001-07-31 09:00:00 | AAPL | Stock | 0.3384 | 0.3384 | 0.3384 | 0.3384 | 61600.0 |
| 2001-07-31 09:25:00 | AAPL | Stock | 0.342 | 0.3489 | 0.342 | 0.3441 | 576800.0 |
| 2001-07-31 09:30:00 | AAPL | Stock | 0.3441 | 0.3446 | 0.3395 | 0.3396 | 6664000.0 |
| 2001-07-31 09:35:00 | AAPL | Stock | 0.3396 | 0.3405 | 0.3355 | 0.3364 | 5566400.0 |
| 2001-07-31 09:40:00 | AAPL | Stock | 0.3361 | 0.3364 | 0.3323 | 0.3325 | 3572800.0 |
| 2001-07-31 09:45:00 | AAPL | Stock | 0.3325 | 0.3348 | 0.3305 | 0.3348 | 8696800.0 |
| 2001-07-31 09:50:00 | AAPL | Stock | 0.3348 | 0.3364 | 0.3339 | 0.3364 | 3007200.0 |
| 2001-07-31 09:55:00 | AAPL | Stock | 0.3364 | 0.3364 | 0.3346 | 0.3361 | 5152000.0 |
| 2001-07-31 10:00:00 | AAPL | Stock | 0.3359 | 0.3364 | 0.3321 | 0.3332 | 4614400.0 |
| 2001-07-31 10:05:00 | AAPL | Stock | 0.3334 | 0.3339 | 0.3323 | 0.3334 | 3287200.0 |
| 2001-07-31 10:10:00 | AAPL | Stock | 0.3334 | 0.3354 | 0.3334 | 0.3348 | 5056800.0 |
| 2001-07-31 10:15:00 | AAPL | Stock | 0.3348 | 0.3398 | 0.3348 | 0.3393 | 5426400.0 |
| 2001-07-31 10:20:00 | AAPL | Stock | 0.3391 | 0.3402 | 0.337 | 0.337 | 3270400.0 |
| 2001-07-31 10:25:00 | AAPL | Stock | 0.337 | 0.3382 | 0.3364 | 0.3371 | 4160800.0 |
| 2001-07-31 10:30:00 | AAPL | Stock | 0.3368 | 0.3409 | 0.3368 | 0.3405 | 1702400.0 |
| 2001-07-31 10:35:00 | AAPL | Stock | 0.3405 | 0.3418 | 0.3396 | 0.3404 | 3516800.0 |
| 2001-07-31 10:40:00 | AAPL | Stock | 0.3405 | 0.3405 | 0.3388 | 0.3402 | 1876000.0 |
| 2001-07-31 10:45:00 | AAPL | Stock | 0.3402 | 0.3414 | 0.3396 | 0.3407 | 4575200.0 |
| 2001-07-31 10:50:00 | AAPL | Stock | 0.3407 | 0.3441 | 0.3407 | 0.3438 | 6809600.0 |
| 2001-07-31 10:55:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3425 | 0.3438 | 2430400.0 |
| 2001-07-31 11:00:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3427 | 0.3436 | 2788800.0 |
| 2001-07-31 11:05:00 | AAPL | Stock | 0.343 | 0.3439 | 0.3427 | 0.3434 | 4720800.0 |
| 2001-07-31 11:10:00 | AAPL | Stock | 0.3429 | 0.3459 | 0.3427 | 0.345 | 5796000.0 |
| 2001-07-31 11:15:00 | AAPL | Stock | 0.3448 | 0.3455 | 0.3446 | 0.3452 | 2094400.0 |
| 2001-07-31 11:20:00 | AAPL | Stock | 0.345 | 0.3464 | 0.345 | 0.3464 | 3662400.0 |
| 2001-07-31 11:25:00 | AAPL | Stock | 0.3457 | 0.3468 | 0.3443 | 0.3443 | 5958400.0 |
| 2001-07-31 11:30:00 | AAPL | Stock | 0.3439 | 0.3445 | 0.3436 | 0.3445 | 1411200.0 |
| 2001-07-31 11:35:00 | AAPL | Stock | 0.3439 | 0.3443 | 0.3438 | 0.3441 | 476000.0 |
| 2001-07-31 11:40:00 | AAPL | Stock | 0.3439 | 0.3446 | 0.3439 | 0.3446 | 750400.0 |
| 2001-07-31 11:45:00 | AAPL | Stock | 0.3446 | 0.3446 | 0.3436 | 0.3436 | 672000.0 |
| 2001-07-31 11:50:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3429 | 0.3429 | 1562400.0 |
| 2001-07-31 11:55:00 | AAPL | Stock | 0.343 | 0.3432 | 0.3411 | 0.3411 | 2296000.0 |
| 2001-07-31 12:00:00 | AAPL | Stock | 0.3411 | 0.3427 | 0.3409 | 0.3423 | 1646400.0 |
| 2001-07-31 12:05:00 | AAPL | Stock | 0.3423 | 0.3434 | 0.342 | 0.3425 | 2010400.0 |
| 2001-07-31 12:10:00 | AAPL | Stock | 0.3421 | 0.3423 | 0.3393 | 0.3393 | 1747200.0 |
| 2001-07-31 12:15:00 | AAPL | Stock | 0.3393 | 0.342 | 0.3393 | 0.342 | 2738400.0 |
| 2001-07-31 12:20:00 | AAPL | Stock | 0.3418 | 0.3425 | 0.3414 | 0.3423 | 996800.0 |
| 2001-07-31 12:25:00 | AAPL | Stock | 0.3425 | 0.3425 | 0.3409 | 0.3409 | 425600.0 |
| 2001-07-31 12:30:00 | AAPL | Stock | 0.342 | 0.3423 | 0.3411 | 0.3414 | 280000.0 |
| 2001-07-31 12:35:00 | AAPL | Stock | 0.3413 | 0.3416 | 0.3393 | 0.3407 | 2514400.0 |
| 2001-07-31 12:40:00 | AAPL | Stock | 0.3407 | 0.3416 | 0.3398 | 0.3411 | 1635200.0 |
| 2001-07-31 12:45:00 | AAPL | Stock | 0.3413 | 0.3418 | 0.3413 | 0.3416 | 896000.0 |
| 2001-07-31 12:50:00 | AAPL | Stock | 0.3414 | 0.3418 | 0.3414 | 0.3416 | 4720800.0 |
| 2001-07-31 12:55:00 | AAPL | Stock | 0.3418 | 0.3425 | 0.3418 | 0.3418 | 980000.0 |
| 2001-07-31 13:00:00 | AAPL | Stock | 0.3416 | 0.342 | 0.3409 | 0.342 | 1842400.0 |
| 2001-07-31 13:05:00 | AAPL | Stock | 0.3425 | 0.3429 | 0.3423 | 0.3429 | 3914400.0 |
> showing 50 of 112,539 rows — these rows as CSV