PREVIEW / stock_5min / 2005-05-23
file: by_date/stock_5min/2005/2005-05-23.parquet size: 2.7 MB rows: 194,774 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-05-23 07:45:00 | AAPL | Stock | 1.3464 | 1.3479 | 1.3464 | 1.3479 | 50652.0 |
| 2005-05-23 07:50:00 | AAPL | Stock | 1.3486 | 1.3486 | 1.3486 | 1.3486 | 28000.0 |
| 2005-05-23 08:00:00 | AAPL | Stock | 1.3561 | 1.3611 | 1.3529 | 1.3611 | 522312.0 |
| 2005-05-23 08:05:00 | AAPL | Stock | 1.3636 | 1.375 | 1.3636 | 1.3714 | 892024.0 |
| 2005-05-23 08:10:00 | AAPL | Stock | 1.3714 | 1.375 | 1.3661 | 1.3696 | 626360.0 |
| 2005-05-23 08:15:00 | AAPL | Stock | 1.3696 | 1.3714 | 1.3607 | 1.3639 | 690816.0 |
| 2005-05-23 08:20:00 | AAPL | Stock | 1.3643 | 1.3643 | 1.3636 | 1.3643 | 75600.0 |
| 2005-05-23 08:25:00 | AAPL | Stock | 1.3657 | 1.3664 | 1.3657 | 1.3661 | 101248.0 |
| 2005-05-23 08:30:00 | AAPL | Stock | 1.3657 | 1.3657 | 1.3636 | 1.3636 | 139440.0 |
| 2005-05-23 08:35:00 | AAPL | Stock | 1.3643 | 1.3643 | 1.3629 | 1.3629 | 33600.0 |
| 2005-05-23 08:40:00 | AAPL | Stock | 1.3625 | 1.3625 | 1.3607 | 1.3607 | 213920.0 |
| 2005-05-23 08:45:00 | AAPL | Stock | 1.3596 | 1.3596 | 1.3582 | 1.3582 | 180880.0 |
| 2005-05-23 08:50:00 | AAPL | Stock | 1.3593 | 1.36 | 1.3575 | 1.36 | 221200.0 |
| 2005-05-23 08:55:00 | AAPL | Stock | 1.3625 | 1.3682 | 1.3607 | 1.3668 | 571704.0 |
| 2005-05-23 09:00:00 | AAPL | Stock | 1.3668 | 1.3693 | 1.3657 | 1.3661 | 599200.0 |
| 2005-05-23 09:05:00 | AAPL | Stock | 1.3661 | 1.3689 | 1.3657 | 1.3664 | 173096.0 |
| 2005-05-23 09:10:00 | AAPL | Stock | 1.3664 | 1.3679 | 1.3661 | 1.3661 | 182000.0 |
| 2005-05-23 09:15:00 | AAPL | Stock | 1.3654 | 1.3664 | 1.3643 | 1.3643 | 152040.0 |
| 2005-05-23 09:20:00 | AAPL | Stock | 1.3639 | 1.3657 | 1.3625 | 1.365 | 92400.0 |
| 2005-05-23 09:25:00 | AAPL | Stock | 1.3625 | 1.3657 | 1.3489 | 1.3518 | 2750412.0 |
| 2005-05-23 09:30:00 | AAPL | Stock | 1.3518 | 1.3732 | 1.3518 | 1.3689 | 40359676.0 |
| 2005-05-23 09:35:00 | AAPL | Stock | 1.3689 | 1.3718 | 1.3611 | 1.3614 | 25478824.0 |
| 2005-05-23 09:40:00 | AAPL | Stock | 1.3614 | 1.3664 | 1.3596 | 1.3661 | 22470896.0 |
| 2005-05-23 09:45:00 | AAPL | Stock | 1.3664 | 1.3743 | 1.3661 | 1.3739 | 17878952.0 |
| 2005-05-23 09:50:00 | AAPL | Stock | 1.3739 | 1.3775 | 1.3718 | 1.3739 | 30685760.0 |
| 2005-05-23 09:55:00 | AAPL | Stock | 1.3739 | 1.3811 | 1.3739 | 1.3803 | 18304776.0 |
| 2005-05-23 10:00:00 | AAPL | Stock | 1.3804 | 1.3879 | 1.38 | 1.3846 | 29425816.0 |
| 2005-05-23 10:05:00 | AAPL | Stock | 1.3846 | 1.3853 | 1.3789 | 1.3793 | 21566804.0 |
| 2005-05-23 10:10:00 | AAPL | Stock | 1.3789 | 1.3846 | 1.3768 | 1.3836 | 19694836.0 |
| 2005-05-23 10:15:00 | AAPL | Stock | 1.3832 | 1.3921 | 1.3832 | 1.3907 | 26199236.0 |
| 2005-05-23 10:20:00 | AAPL | Stock | 1.3911 | 1.3911 | 1.3846 | 1.385 | 23342172.0 |
| 2005-05-23 10:25:00 | AAPL | Stock | 1.3846 | 1.3904 | 1.3846 | 1.3879 | 17440752.0 |
| 2005-05-23 10:30:00 | AAPL | Stock | 1.3879 | 1.3904 | 1.3854 | 1.3861 | 15511076.0 |
| 2005-05-23 10:35:00 | AAPL | Stock | 1.3861 | 1.39 | 1.3861 | 1.3875 | 11272268.0 |
| 2005-05-23 10:40:00 | AAPL | Stock | 1.3875 | 1.3886 | 1.3854 | 1.3886 | 13393352.0 |
| 2005-05-23 10:45:00 | AAPL | Stock | 1.3886 | 1.3932 | 1.3868 | 1.3889 | 28682920.0 |
| 2005-05-23 10:50:00 | AAPL | Stock | 1.3886 | 1.3886 | 1.3846 | 1.3857 | 16683772.0 |
| 2005-05-23 10:55:00 | AAPL | Stock | 1.3857 | 1.3875 | 1.3843 | 1.3864 | 9033248.0 |
| 2005-05-23 11:00:00 | AAPL | Stock | 1.3861 | 1.3864 | 1.3814 | 1.3821 | 19792612.0 |
| 2005-05-23 11:05:00 | AAPL | Stock | 1.3821 | 1.3871 | 1.3814 | 1.3854 | 8808548.0 |
| 2005-05-23 11:10:00 | AAPL | Stock | 1.3857 | 1.39 | 1.3857 | 1.39 | 7582624.0 |
| 2005-05-23 11:15:00 | AAPL | Stock | 1.3896 | 1.3925 | 1.3893 | 1.3907 | 11291924.0 |
| 2005-05-23 11:20:00 | AAPL | Stock | 1.3907 | 1.3971 | 1.3861 | 1.3957 | 21702632.0 |
| 2005-05-23 11:25:00 | AAPL | Stock | 1.3954 | 1.3982 | 1.3921 | 1.3954 | 15421504.0 |
| 2005-05-23 11:30:00 | AAPL | Stock | 1.3954 | 1.3957 | 1.3925 | 1.3936 | 9809072.0 |
| 2005-05-23 11:35:00 | AAPL | Stock | 1.3936 | 1.3946 | 1.3882 | 1.3943 | 8820700.0 |
| 2005-05-23 11:40:00 | AAPL | Stock | 1.3939 | 1.3954 | 1.3932 | 1.3932 | 4128712.0 |
| 2005-05-23 11:45:00 | AAPL | Stock | 1.3936 | 1.3954 | 1.3929 | 1.3946 | 3473876.0 |
| 2005-05-23 11:50:00 | AAPL | Stock | 1.395 | 1.4011 | 1.3946 | 1.4011 | 12495504.0 |
| 2005-05-23 11:55:00 | AAPL | Stock | 1.4007 | 1.4057 | 1.4 | 1.4046 | 17678976.0 |
> showing 50 of 194,774 rows — these rows as CSV