PREVIEW / stock_5min / 2001-06-20
file: by_date/stock_5min/2001/2001-06-20.parquet size: 1.6 MB rows: 113,227 symbols: 1,312
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-06-20 08:00:00 | AAPL | Stock | 0.3589 | 0.3605 | 0.3589 | 0.3605 | 1271200.0 |
| 2001-06-20 08:40:00 | AAPL | Stock | 0.3575 | 0.3575 | 0.3575 | 0.3575 | 5600.0 |
| 2001-06-20 08:50:00 | AAPL | Stock | 0.3575 | 0.3575 | 0.3575 | 0.3575 | 11200.0 |
| 2001-06-20 08:55:00 | AAPL | Stock | 0.3573 | 0.3573 | 0.3573 | 0.3573 | 123200.0 |
| 2001-06-20 09:05:00 | AAPL | Stock | 0.3575 | 0.3575 | 0.3575 | 0.3575 | 16800.0 |
| 2001-06-20 09:15:00 | AAPL | Stock | 0.3573 | 0.3573 | 0.3571 | 0.3573 | 218400.0 |
| 2001-06-20 09:20:00 | AAPL | Stock | 0.3573 | 0.3575 | 0.3573 | 0.3575 | 733600.0 |
| 2001-06-20 09:25:00 | AAPL | Stock | 0.3575 | 0.3577 | 0.3571 | 0.3571 | 1148000.0 |
| 2001-06-20 09:30:00 | AAPL | Stock | 0.3571 | 0.3614 | 0.3568 | 0.3596 | 6882400.0 |
| 2001-06-20 09:35:00 | AAPL | Stock | 0.3595 | 0.3625 | 0.3571 | 0.3625 | 4009600.0 |
| 2001-06-20 09:40:00 | AAPL | Stock | 0.3627 | 0.3679 | 0.3625 | 0.3679 | 7996800.0 |
| 2001-06-20 09:45:00 | AAPL | Stock | 0.3679 | 0.3695 | 0.367 | 0.3677 | 11188800.0 |
| 2001-06-20 09:50:00 | AAPL | Stock | 0.3677 | 0.368 | 0.367 | 0.3671 | 2335200.0 |
| 2001-06-20 09:55:00 | AAPL | Stock | 0.3682 | 0.3696 | 0.3668 | 0.3691 | 11732000.0 |
| 2001-06-20 10:00:00 | AAPL | Stock | 0.3689 | 0.3698 | 0.3679 | 0.3688 | 6798400.0 |
| 2001-06-20 10:05:00 | AAPL | Stock | 0.3682 | 0.373 | 0.3682 | 0.3727 | 8596000.0 |
| 2001-06-20 10:10:00 | AAPL | Stock | 0.3716 | 0.3732 | 0.3707 | 0.3721 | 4289600.0 |
| 2001-06-20 10:15:00 | AAPL | Stock | 0.3721 | 0.3729 | 0.3696 | 0.3696 | 3544800.0 |
| 2001-06-20 10:20:00 | AAPL | Stock | 0.3698 | 0.3723 | 0.3691 | 0.3723 | 3623200.0 |
| 2001-06-20 10:25:00 | AAPL | Stock | 0.3723 | 0.375 | 0.3718 | 0.3723 | 9900800.0 |
| 2001-06-20 10:30:00 | AAPL | Stock | 0.3723 | 0.3748 | 0.3714 | 0.3748 | 2749600.0 |
| 2001-06-20 10:35:00 | AAPL | Stock | 0.3746 | 0.375 | 0.3725 | 0.3739 | 3970400.0 |
| 2001-06-20 10:40:00 | AAPL | Stock | 0.3745 | 0.3745 | 0.3718 | 0.3725 | 3186400.0 |
| 2001-06-20 10:45:00 | AAPL | Stock | 0.3729 | 0.3748 | 0.3727 | 0.3748 | 2906400.0 |
| 2001-06-20 10:50:00 | AAPL | Stock | 0.3748 | 0.3777 | 0.3748 | 0.3768 | 7694400.0 |
| 2001-06-20 10:55:00 | AAPL | Stock | 0.3755 | 0.3784 | 0.3754 | 0.3779 | 6171200.0 |
| 2001-06-20 11:00:00 | AAPL | Stock | 0.3782 | 0.3782 | 0.3764 | 0.378 | 4754400.0 |
| 2001-06-20 11:05:00 | AAPL | Stock | 0.378 | 0.3807 | 0.3779 | 0.3793 | 10892000.0 |
| 2001-06-20 11:10:00 | AAPL | Stock | 0.3793 | 0.3798 | 0.3786 | 0.3788 | 3718400.0 |
| 2001-06-20 11:15:00 | AAPL | Stock | 0.3791 | 0.3802 | 0.3788 | 0.3788 | 6479200.0 |
| 2001-06-20 11:20:00 | AAPL | Stock | 0.3786 | 0.3793 | 0.3786 | 0.3791 | 3102400.0 |
| 2001-06-20 11:25:00 | AAPL | Stock | 0.3789 | 0.3804 | 0.3788 | 0.3796 | 9744000.0 |
| 2001-06-20 11:30:00 | AAPL | Stock | 0.3795 | 0.3804 | 0.3786 | 0.3791 | 4972800.0 |
| 2001-06-20 11:35:00 | AAPL | Stock | 0.3788 | 0.3802 | 0.3786 | 0.3786 | 3522400.0 |
| 2001-06-20 11:40:00 | AAPL | Stock | 0.3786 | 0.3796 | 0.3775 | 0.3789 | 5247200.0 |
| 2001-06-20 11:45:00 | AAPL | Stock | 0.3789 | 0.3796 | 0.3768 | 0.3777 | 2699200.0 |
| 2001-06-20 11:50:00 | AAPL | Stock | 0.3777 | 0.3786 | 0.3768 | 0.3784 | 4849600.0 |
| 2001-06-20 11:55:00 | AAPL | Stock | 0.378 | 0.3796 | 0.3768 | 0.3771 | 7996800.0 |
| 2001-06-20 12:00:00 | AAPL | Stock | 0.3764 | 0.3775 | 0.3755 | 0.3763 | 6126400.0 |
| 2001-06-20 12:05:00 | AAPL | Stock | 0.3763 | 0.3771 | 0.3755 | 0.3759 | 4687200.0 |
| 2001-06-20 12:10:00 | AAPL | Stock | 0.3759 | 0.3788 | 0.3757 | 0.3786 | 4709600.0 |
| 2001-06-20 12:15:00 | AAPL | Stock | 0.3782 | 0.3798 | 0.3775 | 0.3786 | 5560800.0 |
| 2001-06-20 12:20:00 | AAPL | Stock | 0.3786 | 0.3791 | 0.3777 | 0.3777 | 2195200.0 |
| 2001-06-20 12:25:00 | AAPL | Stock | 0.3775 | 0.3782 | 0.3757 | 0.377 | 3225600.0 |
| 2001-06-20 12:30:00 | AAPL | Stock | 0.377 | 0.3796 | 0.3768 | 0.3796 | 2660000.0 |
| 2001-06-20 12:35:00 | AAPL | Stock | 0.3795 | 0.38 | 0.3777 | 0.3786 | 2968000.0 |
| 2001-06-20 12:40:00 | AAPL | Stock | 0.3782 | 0.3788 | 0.3779 | 0.3788 | 711200.0 |
| 2001-06-20 12:45:00 | AAPL | Stock | 0.3786 | 0.3802 | 0.3779 | 0.378 | 1814400.0 |
| 2001-06-20 12:50:00 | AAPL | Stock | 0.378 | 0.3788 | 0.377 | 0.3771 | 1243200.0 |
| 2001-06-20 12:55:00 | AAPL | Stock | 0.3771 | 0.3771 | 0.3761 | 0.3761 | 1349600.0 |
> showing 50 of 113,227 rows — these rows as CSV