PREVIEW / stock_5min / 2006-03-16
file: by_date/stock_5min/2006/2006-03-16.parquet size: 3.0 MB rows: 219,946 symbols: 2,218
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-16 07:35:00 | AAPL | Stock | 2.3643 | 2.3643 | 2.3643 | 2.3643 | 17808.0 |
| 2006-03-16 07:40:00 | AAPL | Stock | 2.3686 | 2.3686 | 2.3686 | 2.3686 | 14000.0 |
| 2006-03-16 08:00:00 | AAPL | Stock | 2.3679 | 2.375 | 2.3643 | 2.375 | 219520.0 |
| 2006-03-16 08:05:00 | AAPL | Stock | 2.375 | 2.3775 | 2.3664 | 2.3682 | 120120.0 |
| 2006-03-16 08:10:00 | AAPL | Stock | 2.3696 | 2.3696 | 2.3661 | 2.3679 | 156240.0 |
| 2006-03-16 08:15:00 | AAPL | Stock | 2.3696 | 2.3696 | 2.3639 | 2.3639 | 35532.0 |
| 2006-03-16 08:20:00 | AAPL | Stock | 2.3614 | 2.3661 | 2.3611 | 2.3661 | 100800.0 |
| 2006-03-16 08:25:00 | AAPL | Stock | 2.3661 | 2.3661 | 2.3625 | 2.3643 | 75600.0 |
| 2006-03-16 08:30:00 | AAPL | Stock | 2.3643 | 2.3725 | 2.3643 | 2.3696 | 449120.0 |
| 2006-03-16 08:35:00 | AAPL | Stock | 2.3686 | 2.3707 | 2.3686 | 2.37 | 67480.0 |
| 2006-03-16 08:40:00 | AAPL | Stock | 2.37 | 2.3743 | 2.37 | 2.3743 | 318500.0 |
| 2006-03-16 08:45:00 | AAPL | Stock | 2.3736 | 2.3771 | 2.3732 | 2.3768 | 577500.0 |
| 2006-03-16 08:50:00 | AAPL | Stock | 2.3768 | 2.3786 | 2.375 | 2.3771 | 345800.0 |
| 2006-03-16 08:55:00 | AAPL | Stock | 2.3771 | 2.3786 | 2.3721 | 2.3786 | 387660.0 |
| 2006-03-16 09:00:00 | AAPL | Stock | 2.3768 | 2.3782 | 2.3768 | 2.3782 | 67200.0 |
| 2006-03-16 09:05:00 | AAPL | Stock | 2.3786 | 2.3814 | 2.3768 | 2.3811 | 179088.0 |
| 2006-03-16 09:10:00 | AAPL | Stock | 2.3818 | 2.3821 | 2.3804 | 2.3811 | 395248.0 |
| 2006-03-16 09:15:00 | AAPL | Stock | 2.3811 | 2.3811 | 2.3779 | 2.3786 | 211680.0 |
| 2006-03-16 09:20:00 | AAPL | Stock | 2.3786 | 2.3793 | 2.3768 | 2.3786 | 126000.0 |
| 2006-03-16 09:25:00 | AAPL | Stock | 2.375 | 2.3889 | 2.375 | 2.3889 | 1133468.0 |
| 2006-03-16 09:30:00 | AAPL | Stock | 2.3875 | 2.3893 | 2.3696 | 2.3714 | 24431400.0 |
| 2006-03-16 09:35:00 | AAPL | Stock | 2.3711 | 2.3764 | 2.3586 | 2.3593 | 16654092.0 |
| 2006-03-16 09:40:00 | AAPL | Stock | 2.3596 | 2.3632 | 2.3529 | 2.3561 | 18687592.0 |
| 2006-03-16 09:45:00 | AAPL | Stock | 2.3564 | 2.3636 | 2.3507 | 2.3561 | 25980556.0 |
| 2006-03-16 09:50:00 | AAPL | Stock | 2.3561 | 2.3593 | 2.3482 | 2.3532 | 17197068.0 |
| 2006-03-16 09:55:00 | AAPL | Stock | 2.3532 | 2.36 | 2.3529 | 2.3571 | 9862692.0 |
| 2006-03-16 10:00:00 | AAPL | Stock | 2.3579 | 2.3636 | 2.355 | 2.3596 | 14266588.0 |
| 2006-03-16 10:05:00 | AAPL | Stock | 2.3596 | 2.3625 | 2.3529 | 2.3586 | 13480572.0 |
| 2006-03-16 10:10:00 | AAPL | Stock | 2.3571 | 2.3586 | 2.3514 | 2.3518 | 8500548.0 |
| 2006-03-16 10:15:00 | AAPL | Stock | 2.3521 | 2.3586 | 2.3496 | 2.3543 | 9718968.0 |
| 2006-03-16 10:20:00 | AAPL | Stock | 2.3546 | 2.3546 | 2.3446 | 2.3511 | 17412192.0 |
| 2006-03-16 10:25:00 | AAPL | Stock | 2.3511 | 2.3607 | 2.3482 | 2.3489 | 8331316.0 |
| 2006-03-16 10:30:00 | AAPL | Stock | 2.3489 | 2.3557 | 2.3486 | 2.3529 | 10028340.0 |
| 2006-03-16 10:35:00 | AAPL | Stock | 2.3525 | 2.3525 | 2.3468 | 2.3493 | 7571116.0 |
| 2006-03-16 10:40:00 | AAPL | Stock | 2.3496 | 2.3518 | 2.3482 | 2.3493 | 6839476.0 |
| 2006-03-16 10:45:00 | AAPL | Stock | 2.3493 | 2.3493 | 2.3414 | 2.3439 | 13435296.0 |
| 2006-03-16 10:50:00 | AAPL | Stock | 2.3439 | 2.3454 | 2.3414 | 2.3443 | 7446796.0 |
| 2006-03-16 10:55:00 | AAPL | Stock | 2.3443 | 2.3443 | 2.3343 | 2.335 | 17338748.0 |
| 2006-03-16 11:00:00 | AAPL | Stock | 2.3346 | 2.3389 | 2.3325 | 2.3379 | 9270352.0 |
| 2006-03-16 11:05:00 | AAPL | Stock | 2.3382 | 2.345 | 2.3379 | 2.345 | 9565724.0 |
| 2006-03-16 11:10:00 | AAPL | Stock | 2.345 | 2.3511 | 2.3432 | 2.3504 | 8441664.0 |
| 2006-03-16 11:15:00 | AAPL | Stock | 2.3504 | 2.3504 | 2.3454 | 2.3493 | 5547556.0 |
| 2006-03-16 11:20:00 | AAPL | Stock | 2.3493 | 2.3879 | 2.3464 | 2.3489 | 4935392.0 |
| 2006-03-16 11:25:00 | AAPL | Stock | 2.3489 | 2.3493 | 2.3457 | 2.3493 | 5301464.0 |
| 2006-03-16 11:30:00 | AAPL | Stock | 2.3493 | 2.3511 | 2.3461 | 2.3479 | 7568540.0 |
| 2006-03-16 11:35:00 | AAPL | Stock | 2.3482 | 2.3514 | 2.3475 | 2.3486 | 5296508.0 |
| 2006-03-16 11:40:00 | AAPL | Stock | 2.3482 | 2.3532 | 2.3479 | 2.3497 | 7234080.0 |
| 2006-03-16 11:45:00 | AAPL | Stock | 2.3496 | 2.3511 | 2.3479 | 2.3482 | 4198012.0 |
| 2006-03-16 11:50:00 | AAPL | Stock | 2.3486 | 2.3486 | 2.3457 | 2.3468 | 3861144.0 |
| 2006-03-16 11:55:00 | AAPL | Stock | 2.3468 | 2.35 | 2.3468 | 2.3493 | 3856664.0 |
> showing 50 of 219,946 rows — these rows as CSV