PREVIEW / stock_5min / 2005-06-06
file: by_date/stock_5min/2005/2005-06-06.parquet size: 2.6 MB rows: 193,849 symbols: 1,981
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 |
|---|---|---|---|---|---|---|---|
| 2005-06-06 07:00:00 | AAPL | Stock | 1.3689 | 1.3821 | 1.3689 | 1.3821 | 33600.0 |
| 2005-06-06 07:05:00 | AAPL | Stock | 1.3925 | 1.3929 | 1.3857 | 1.3929 | 106400.0 |
| 2005-06-06 07:10:00 | AAPL | Stock | 1.4 | 1.4 | 1.4 | 1.4 | 28000.0 |
| 2005-06-06 07:15:00 | AAPL | Stock | 1.3982 | 1.4 | 1.3982 | 1.4 | 36400.0 |
| 2005-06-06 07:20:00 | AAPL | Stock | 1.4 | 1.4 | 1.4 | 1.4 | 14000.0 |
| 2005-06-06 07:35:00 | AAPL | Stock | 1.3929 | 1.3929 | 1.3929 | 1.3929 | 30800.0 |
| 2005-06-06 07:40:00 | AAPL | Stock | 1.3946 | 1.3946 | 1.3929 | 1.3929 | 19600.0 |
| 2005-06-06 07:45:00 | AAPL | Stock | 1.3946 | 1.3946 | 1.3946 | 1.3946 | 53200.0 |
| 2005-06-06 07:50:00 | AAPL | Stock | 1.3946 | 1.3946 | 1.3946 | 1.3946 | 14000.0 |
| 2005-06-06 07:55:00 | AAPL | Stock | 1.3929 | 1.3929 | 1.3921 | 1.3921 | 73220.0 |
| 2005-06-06 08:00:00 | AAPL | Stock | 1.3921 | 1.3946 | 1.3814 | 1.3893 | 2040080.0 |
| 2005-06-06 08:05:00 | AAPL | Stock | 1.3921 | 1.3929 | 1.3839 | 1.3839 | 705880.0 |
| 2005-06-06 08:10:00 | AAPL | Stock | 1.3825 | 1.385 | 1.3821 | 1.3846 | 175728.0 |
| 2005-06-06 08:15:00 | AAPL | Stock | 1.3839 | 1.3868 | 1.3829 | 1.3832 | 445060.0 |
| 2005-06-06 08:20:00 | AAPL | Stock | 1.3832 | 1.3832 | 1.3807 | 1.3807 | 506800.0 |
| 2005-06-06 08:25:00 | AAPL | Stock | 1.3786 | 1.3811 | 1.3782 | 1.38 | 419160.0 |
| 2005-06-06 08:30:00 | AAPL | Stock | 1.3807 | 1.385 | 1.3807 | 1.3843 | 385392.0 |
| 2005-06-06 08:35:00 | AAPL | Stock | 1.3829 | 1.3839 | 1.3796 | 1.3814 | 347200.0 |
| 2005-06-06 08:40:00 | AAPL | Stock | 1.3814 | 1.3814 | 1.3804 | 1.3804 | 138320.0 |
| 2005-06-06 08:45:00 | AAPL | Stock | 1.3811 | 1.3821 | 1.3779 | 1.3821 | 405300.0 |
| 2005-06-06 08:50:00 | AAPL | Stock | 1.3804 | 1.3804 | 1.3786 | 1.3793 | 63000.0 |
| 2005-06-06 08:55:00 | AAPL | Stock | 1.3789 | 1.3789 | 1.3743 | 1.375 | 729120.0 |
| 2005-06-06 09:00:00 | AAPL | Stock | 1.375 | 1.3754 | 1.3657 | 1.3743 | 1084440.0 |
| 2005-06-06 09:05:00 | AAPL | Stock | 1.3743 | 1.3786 | 1.3732 | 1.3782 | 297052.0 |
| 2005-06-06 09:10:00 | AAPL | Stock | 1.3779 | 1.3779 | 1.3768 | 1.3779 | 120400.0 |
| 2005-06-06 09:15:00 | AAPL | Stock | 1.3775 | 1.3821 | 1.3775 | 1.3814 | 223160.0 |
| 2005-06-06 09:20:00 | AAPL | Stock | 1.3807 | 1.3814 | 1.3768 | 1.3768 | 314300.0 |
| 2005-06-06 09:25:00 | AAPL | Stock | 1.3764 | 1.3768 | 1.3686 | 1.3689 | 1231776.0 |
| 2005-06-06 09:30:00 | AAPL | Stock | 1.3689 | 1.3796 | 1.3679 | 1.3757 | 30402736.0 |
| 2005-06-06 09:35:00 | AAPL | Stock | 1.3754 | 1.3771 | 1.3661 | 1.3671 | 18920020.0 |
| 2005-06-06 09:40:00 | AAPL | Stock | 1.3671 | 1.3719 | 1.3586 | 1.3629 | 19890864.0 |
| 2005-06-06 09:45:00 | AAPL | Stock | 1.3629 | 1.3693 | 1.3582 | 1.3607 | 19556292.0 |
| 2005-06-06 09:50:00 | AAPL | Stock | 1.36 | 1.3789 | 1.36 | 1.37 | 17673824.0 |
| 2005-06-06 09:55:00 | AAPL | Stock | 1.3696 | 1.375 | 1.3671 | 1.3721 | 13490708.0 |
| 2005-06-06 10:00:00 | AAPL | Stock | 1.3725 | 1.3729 | 1.3686 | 1.3686 | 8241240.0 |
| 2005-06-06 10:05:00 | AAPL | Stock | 1.3689 | 1.3729 | 1.3686 | 1.3693 | 9151324.0 |
| 2005-06-06 10:10:00 | AAPL | Stock | 1.3693 | 1.3721 | 1.3693 | 1.3714 | 9415896.0 |
| 2005-06-06 10:15:00 | AAPL | Stock | 1.3714 | 1.3721 | 1.37 | 1.3714 | 7377888.0 |
| 2005-06-06 10:20:00 | AAPL | Stock | 1.3718 | 1.3718 | 1.3629 | 1.3636 | 11407928.0 |
| 2005-06-06 10:25:00 | AAPL | Stock | 1.3639 | 1.3668 | 1.3636 | 1.3646 | 10080532.0 |
| 2005-06-06 10:30:00 | AAPL | Stock | 1.3646 | 1.3664 | 1.3625 | 1.3625 | 5184844.0 |
| 2005-06-06 10:35:00 | AAPL | Stock | 1.3629 | 1.3636 | 1.36 | 1.36 | 9415196.0 |
| 2005-06-06 10:40:00 | AAPL | Stock | 1.36 | 1.3625 | 1.3586 | 1.3607 | 11051992.0 |
| 2005-06-06 10:45:00 | AAPL | Stock | 1.3604 | 1.3607 | 1.3529 | 1.3564 | 18353832.0 |
| 2005-06-06 10:50:00 | AAPL | Stock | 1.3564 | 1.36 | 1.3557 | 1.3564 | 9099804.0 |
| 2005-06-06 10:55:00 | AAPL | Stock | 1.3564 | 1.3564 | 1.3525 | 1.3532 | 12328008.0 |
| 2005-06-06 11:00:00 | AAPL | Stock | 1.3532 | 1.3557 | 1.3529 | 1.3546 | 8532804.0 |
| 2005-06-06 11:05:00 | AAPL | Stock | 1.3543 | 1.3546 | 1.35 | 1.35 | 8276632.0 |
| 2005-06-06 11:10:00 | AAPL | Stock | 1.35 | 1.355 | 1.3475 | 1.3482 | 10013948.0 |
| 2005-06-06 11:15:00 | AAPL | Stock | 1.3482 | 1.3529 | 1.345 | 1.3496 | 13941788.0 |
> showing 50 of 193,849 rows — these rows as CSV