PREVIEW / stock_5min / 2006-03-07
file: by_date/stock_5min/2006/2006-03-07.parquet size: 3.0 MB rows: 219,675 symbols: 2,181
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 |
|---|---|---|---|---|---|---|---|
| 2006-03-07 05:30:00 | AAPL | Stock | 2.3232 | 2.3232 | 2.3232 | 2.3232 | 2800.0 |
| 2006-03-07 06:00:00 | AAPL | Stock | 2.325 | 2.3336 | 2.325 | 2.3336 | 5600.0 |
| 2006-03-07 06:05:00 | AAPL | Stock | 2.3336 | 2.3336 | 2.3336 | 2.3336 | 11200.0 |
| 2006-03-07 06:30:00 | AAPL | Stock | 2.3357 | 2.3357 | 2.3357 | 2.3357 | 27580.0 |
| 2006-03-07 07:35:00 | AAPL | Stock | 2.3343 | 2.3343 | 2.3343 | 2.3343 | 2800.0 |
| 2006-03-07 07:50:00 | AAPL | Stock | 2.3343 | 2.3343 | 2.3343 | 2.3343 | 11060.0 |
| 2006-03-07 08:00:00 | AAPL | Stock | 2.3343 | 2.3525 | 2.3343 | 2.3464 | 667492.0 |
| 2006-03-07 08:05:00 | AAPL | Stock | 2.3425 | 2.3482 | 2.3425 | 2.3461 | 145600.0 |
| 2006-03-07 08:10:00 | AAPL | Stock | 2.3454 | 2.3514 | 2.3446 | 2.35 | 515564.0 |
| 2006-03-07 08:15:00 | AAPL | Stock | 2.3489 | 2.3518 | 2.3429 | 2.3496 | 453880.0 |
| 2006-03-07 08:20:00 | AAPL | Stock | 2.3464 | 2.3518 | 2.3446 | 2.35 | 368200.0 |
| 2006-03-07 08:25:00 | AAPL | Stock | 2.3496 | 2.3518 | 2.3493 | 2.3507 | 305872.0 |
| 2006-03-07 08:30:00 | AAPL | Stock | 2.35 | 2.35 | 2.3429 | 2.3429 | 298340.0 |
| 2006-03-07 08:35:00 | AAPL | Stock | 2.3446 | 2.3464 | 2.3421 | 2.3429 | 218708.0 |
| 2006-03-07 08:40:00 | AAPL | Stock | 2.3429 | 2.3443 | 2.3411 | 2.3418 | 200900.0 |
| 2006-03-07 08:45:00 | AAPL | Stock | 2.3411 | 2.3439 | 2.3411 | 2.3429 | 225120.0 |
| 2006-03-07 08:50:00 | AAPL | Stock | 2.3425 | 2.3429 | 2.3411 | 2.3414 | 183316.0 |
| 2006-03-07 08:55:00 | AAPL | Stock | 2.3414 | 2.3429 | 2.34 | 2.3411 | 260904.0 |
| 2006-03-07 09:00:00 | AAPL | Stock | 2.3429 | 2.3429 | 2.3425 | 2.3425 | 159320.0 |
| 2006-03-07 09:05:00 | AAPL | Stock | 2.3429 | 2.3429 | 2.3411 | 2.3414 | 225484.0 |
| 2006-03-07 09:10:00 | AAPL | Stock | 2.3414 | 2.3425 | 2.3411 | 2.3418 | 219996.0 |
| 2006-03-07 09:15:00 | AAPL | Stock | 2.3411 | 2.3425 | 2.3407 | 2.3425 | 86296.0 |
| 2006-03-07 09:20:00 | AAPL | Stock | 2.3439 | 2.3482 | 2.3425 | 2.3464 | 340900.0 |
| 2006-03-07 09:25:00 | AAPL | Stock | 2.3461 | 2.3511 | 2.3446 | 2.3482 | 1755600.0 |
| 2006-03-07 09:30:00 | AAPL | Stock | 2.3486 | 2.3589 | 2.3396 | 2.3582 | 31063452.0 |
| 2006-03-07 09:35:00 | AAPL | Stock | 2.3579 | 2.3621 | 2.3489 | 2.3493 | 20815116.0 |
| 2006-03-07 09:40:00 | AAPL | Stock | 2.3489 | 2.3601 | 2.3418 | 2.3468 | 20034784.0 |
| 2006-03-07 09:45:00 | AAPL | Stock | 2.3471 | 2.3529 | 2.3429 | 2.3518 | 17108924.0 |
| 2006-03-07 09:50:00 | AAPL | Stock | 2.3514 | 2.3532 | 2.3396 | 2.3411 | 16890300.0 |
| 2006-03-07 09:55:00 | AAPL | Stock | 2.3411 | 2.3418 | 2.3304 | 2.3364 | 24837372.0 |
| 2006-03-07 10:00:00 | AAPL | Stock | 2.3368 | 2.3489 | 2.3364 | 2.3477 | 18732980.0 |
| 2006-03-07 10:05:00 | AAPL | Stock | 2.3479 | 2.3496 | 2.3429 | 2.3464 | 15185044.0 |
| 2006-03-07 10:10:00 | AAPL | Stock | 2.3464 | 2.3525 | 2.34 | 2.3496 | 13355720.0 |
| 2006-03-07 10:15:00 | AAPL | Stock | 2.3493 | 2.3632 | 2.3489 | 2.3596 | 24490816.0 |
| 2006-03-07 10:20:00 | AAPL | Stock | 2.3596 | 2.36 | 2.3532 | 2.3561 | 10954916.0 |
| 2006-03-07 10:25:00 | AAPL | Stock | 2.3557 | 2.3646 | 2.3514 | 2.3646 | 13183184.0 |
| 2006-03-07 10:30:00 | AAPL | Stock | 2.3643 | 2.3739 | 2.3611 | 2.3668 | 25215232.0 |
| 2006-03-07 10:35:00 | AAPL | Stock | 2.3661 | 2.3714 | 2.365 | 2.3696 | 15728328.0 |
| 2006-03-07 10:40:00 | AAPL | Stock | 2.3696 | 2.3704 | 2.3611 | 2.3629 | 10624040.0 |
| 2006-03-07 10:45:00 | AAPL | Stock | 2.3625 | 2.3668 | 2.36 | 2.3664 | 8494388.0 |
| 2006-03-07 10:50:00 | AAPL | Stock | 2.3664 | 2.3739 | 2.3661 | 2.3721 | 10522680.0 |
| 2006-03-07 10:55:00 | AAPL | Stock | 2.3718 | 2.3757 | 2.3625 | 2.3654 | 13960912.0 |
| 2006-03-07 11:00:00 | AAPL | Stock | 2.3654 | 2.3729 | 2.3636 | 2.3714 | 7656152.0 |
| 2006-03-07 11:05:00 | AAPL | Stock | 2.3714 | 2.3875 | 2.3711 | 2.3868 | 28248724.0 |
| 2006-03-07 11:10:00 | AAPL | Stock | 2.3868 | 2.3886 | 2.3811 | 2.3821 | 14875896.0 |
| 2006-03-07 11:15:00 | AAPL | Stock | 2.3825 | 2.3886 | 2.3804 | 2.3871 | 13408696.0 |
| 2006-03-07 11:20:00 | AAPL | Stock | 2.3875 | 2.3893 | 2.3818 | 2.3846 | 9903292.0 |
| 2006-03-07 11:25:00 | AAPL | Stock | 2.3846 | 2.3889 | 2.3829 | 2.3846 | 7506212.0 |
| 2006-03-07 11:30:00 | AAPL | Stock | 2.3846 | 2.3846 | 2.3746 | 2.3746 | 10181052.0 |
| 2006-03-07 11:35:00 | AAPL | Stock | 2.3746 | 2.3779 | 2.3721 | 2.3771 | 6291152.0 |
> showing 50 of 219,675 rows — these rows as CSV