PREVIEW / stock_5min / 2003-08-20
file: by_date/stock_5min/2003/2003-08-20.parquet size: 2.0 MB rows: 149,216 symbols: 1,611
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 |
|---|---|---|---|---|---|---|---|
| 2003-08-20 08:00:00 | AAPL | Stock | 0.3629 | 0.3629 | 0.3629 | 0.3629 | 5600.0 |
| 2003-08-20 08:15:00 | AAPL | Stock | 0.3605 | 0.3605 | 0.3605 | 0.3605 | 5600.0 |
| 2003-08-20 09:00:00 | AAPL | Stock | 0.36 | 0.36 | 0.36 | 0.36 | 89600.0 |
| 2003-08-20 09:25:00 | AAPL | Stock | 0.3598 | 0.3604 | 0.3593 | 0.3593 | 56000.0 |
| 2003-08-20 09:30:00 | AAPL | Stock | 0.3604 | 0.363 | 0.3596 | 0.3618 | 4588360.0 |
| 2003-08-20 09:35:00 | AAPL | Stock | 0.3625 | 0.3652 | 0.3616 | 0.3648 | 3469648.0 |
| 2003-08-20 09:40:00 | AAPL | Stock | 0.3648 | 0.3652 | 0.3639 | 0.3639 | 3453520.0 |
| 2003-08-20 09:45:00 | AAPL | Stock | 0.3639 | 0.3643 | 0.3621 | 0.3623 | 4138400.0 |
| 2003-08-20 09:50:00 | AAPL | Stock | 0.3625 | 0.3661 | 0.3625 | 0.3661 | 6561520.0 |
| 2003-08-20 09:55:00 | AAPL | Stock | 0.3659 | 0.3675 | 0.3652 | 0.3661 | 4541600.0 |
| 2003-08-20 10:00:00 | AAPL | Stock | 0.3661 | 0.3663 | 0.3643 | 0.3661 | 4155312.0 |
| 2003-08-20 10:05:00 | AAPL | Stock | 0.3659 | 0.3661 | 0.3655 | 0.3661 | 1996288.0 |
| 2003-08-20 10:10:00 | AAPL | Stock | 0.3661 | 0.3675 | 0.366 | 0.3661 | 2083536.0 |
| 2003-08-20 10:15:00 | AAPL | Stock | 0.3661 | 0.3663 | 0.3654 | 0.3659 | 2995664.0 |
| 2003-08-20 10:20:00 | AAPL | Stock | 0.3659 | 0.3663 | 0.3659 | 0.3661 | 778400.0 |
| 2003-08-20 10:25:00 | AAPL | Stock | 0.3659 | 0.3679 | 0.3659 | 0.3677 | 5224800.0 |
| 2003-08-20 10:30:00 | AAPL | Stock | 0.3677 | 0.3677 | 0.3659 | 0.3663 | 2268784.0 |
| 2003-08-20 10:35:00 | AAPL | Stock | 0.3664 | 0.3664 | 0.3651 | 0.3659 | 4698400.0 |
| 2003-08-20 10:40:00 | AAPL | Stock | 0.3659 | 0.3673 | 0.3659 | 0.3666 | 3136000.0 |
| 2003-08-20 10:45:00 | AAPL | Stock | 0.3663 | 0.367 | 0.3654 | 0.3664 | 1752800.0 |
| 2003-08-20 10:50:00 | AAPL | Stock | 0.3664 | 0.3664 | 0.3657 | 0.3661 | 896168.0 |
| 2003-08-20 10:55:00 | AAPL | Stock | 0.3661 | 0.3677 | 0.3661 | 0.3673 | 1528800.0 |
| 2003-08-20 11:00:00 | AAPL | Stock | 0.3673 | 0.3684 | 0.367 | 0.3679 | 5530896.0 |
| 2003-08-20 11:05:00 | AAPL | Stock | 0.368 | 0.3689 | 0.3679 | 0.3686 | 2441600.0 |
| 2003-08-20 11:10:00 | AAPL | Stock | 0.3686 | 0.3688 | 0.368 | 0.368 | 2389688.0 |
| 2003-08-20 11:15:00 | AAPL | Stock | 0.368 | 0.3686 | 0.3679 | 0.3684 | 1069600.0 |
| 2003-08-20 11:20:00 | AAPL | Stock | 0.3686 | 0.3689 | 0.3684 | 0.3688 | 2057440.0 |
| 2003-08-20 11:25:00 | AAPL | Stock | 0.3688 | 0.3709 | 0.3688 | 0.3709 | 3698352.0 |
| 2003-08-20 11:30:00 | AAPL | Stock | 0.3711 | 0.3725 | 0.3709 | 0.3723 | 3528112.0 |
| 2003-08-20 11:35:00 | AAPL | Stock | 0.3721 | 0.3725 | 0.3718 | 0.3721 | 1620080.0 |
| 2003-08-20 11:40:00 | AAPL | Stock | 0.3723 | 0.3725 | 0.3711 | 0.3714 | 1945272.0 |
| 2003-08-20 11:45:00 | AAPL | Stock | 0.3714 | 0.3723 | 0.3714 | 0.3721 | 2116800.0 |
| 2003-08-20 11:50:00 | AAPL | Stock | 0.3721 | 0.3729 | 0.3721 | 0.3723 | 1136800.0 |
| 2003-08-20 11:55:00 | AAPL | Stock | 0.3725 | 0.3732 | 0.3723 | 0.3729 | 1395128.0 |
| 2003-08-20 12:00:00 | AAPL | Stock | 0.3729 | 0.3734 | 0.3725 | 0.3732 | 2632840.0 |
| 2003-08-20 12:05:00 | AAPL | Stock | 0.3732 | 0.3734 | 0.3721 | 0.3727 | 2911720.0 |
| 2003-08-20 12:10:00 | AAPL | Stock | 0.3727 | 0.373 | 0.3725 | 0.373 | 1447936.0 |
| 2003-08-20 12:15:00 | AAPL | Stock | 0.3729 | 0.3729 | 0.3718 | 0.3718 | 1416800.0 |
| 2003-08-20 12:20:00 | AAPL | Stock | 0.3718 | 0.3718 | 0.3709 | 0.3709 | 554344.0 |
| 2003-08-20 12:25:00 | AAPL | Stock | 0.3709 | 0.3716 | 0.3705 | 0.3714 | 1909712.0 |
| 2003-08-20 12:30:00 | AAPL | Stock | 0.3714 | 0.3723 | 0.3714 | 0.3721 | 1197000.0 |
| 2003-08-20 12:35:00 | AAPL | Stock | 0.3723 | 0.3723 | 0.3718 | 0.3718 | 518392.0 |
| 2003-08-20 12:40:00 | AAPL | Stock | 0.3715 | 0.3718 | 0.3709 | 0.3709 | 308000.0 |
| 2003-08-20 12:45:00 | AAPL | Stock | 0.3709 | 0.3716 | 0.3707 | 0.3714 | 879200.0 |
| 2003-08-20 12:50:00 | AAPL | Stock | 0.3716 | 0.3752 | 0.3715 | 0.3752 | 12591880.0 |
| 2003-08-20 12:55:00 | AAPL | Stock | 0.3752 | 0.3759 | 0.375 | 0.3757 | 2271920.0 |
| 2003-08-20 13:00:00 | AAPL | Stock | 0.3755 | 0.3757 | 0.3752 | 0.3752 | 2195088.0 |
| 2003-08-20 13:05:00 | AAPL | Stock | 0.3752 | 0.3755 | 0.375 | 0.375 | 856688.0 |
| 2003-08-20 13:10:00 | AAPL | Stock | 0.3752 | 0.3752 | 0.3745 | 0.3746 | 1335432.0 |
| 2003-08-20 13:15:00 | AAPL | Stock | 0.3745 | 0.3746 | 0.374 | 0.3741 | 1047200.0 |
> showing 50 of 149,216 rows — these rows as CSV