PREVIEW / stock_5min / 2007-06-29
file: by_date/stock_5min/2007/2007-06-29.parquet size: 4.0 MB rows: 295,440 symbols: 3,066
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 |
|---|---|---|---|---|---|---|---|
| 2007-06-29 09:30:00 | AAPL | Stock | 4.3561 | 4.3661 | 4.3414 | 4.3529 | 32875052.0 |
| 2007-06-29 09:35:00 | AAPL | Stock | 4.3525 | 4.3643 | 4.3475 | 4.3496 | 20768328.0 |
| 2007-06-29 09:40:00 | AAPL | Stock | 4.3496 | 4.3507 | 4.335 | 4.345 | 21633528.0 |
| 2007-06-29 09:45:00 | AAPL | Stock | 4.3436 | 4.3729 | 4.3321 | 4.3654 | 28413224.0 |
| 2007-06-29 09:50:00 | AAPL | Stock | 4.3657 | 4.3907 | 4.3654 | 4.3804 | 28717052.0 |
| 2007-06-29 09:55:00 | AAPL | Stock | 4.3804 | 4.3825 | 4.3679 | 4.37 | 18826360.0 |
| 2007-06-29 10:00:00 | AAPL | Stock | 4.3696 | 4.3729 | 4.3596 | 4.3604 | 18308192.0 |
| 2007-06-29 10:05:00 | AAPL | Stock | 4.3604 | 4.3679 | 4.3539 | 4.3671 | 17286332.0 |
| 2007-06-29 10:10:00 | AAPL | Stock | 4.3671 | 4.3707 | 4.3479 | 4.3564 | 19178152.0 |
| 2007-06-29 10:15:00 | AAPL | Stock | 4.3564 | 4.3657 | 4.3504 | 4.3589 | 12285252.0 |
| 2007-06-29 10:20:00 | AAPL | Stock | 4.3589 | 4.3625 | 4.3557 | 4.3571 | 7830676.0 |
| 2007-06-29 10:25:00 | AAPL | Stock | 4.3582 | 4.37 | 4.3571 | 4.3696 | 12241852.0 |
| 2007-06-29 10:30:00 | AAPL | Stock | 4.3696 | 4.37 | 4.36 | 4.3632 | 9659664.0 |
| 2007-06-29 10:35:00 | AAPL | Stock | 4.3632 | 4.3664 | 4.3618 | 4.3653 | 5268788.0 |
| 2007-06-29 10:40:00 | AAPL | Stock | 4.365 | 4.3714 | 4.3625 | 4.3696 | 9072812.0 |
| 2007-06-29 10:45:00 | AAPL | Stock | 4.3695 | 4.3707 | 4.3657 | 4.3682 | 6423172.0 |
| 2007-06-29 10:50:00 | AAPL | Stock | 4.3682 | 4.37 | 4.3646 | 4.3693 | 6437172.0 |
| 2007-06-29 10:55:00 | AAPL | Stock | 4.3689 | 4.3771 | 4.3689 | 4.3736 | 12925920.0 |
| 2007-06-29 11:00:00 | AAPL | Stock | 4.3739 | 4.3786 | 4.3686 | 4.3686 | 10738056.0 |
| 2007-06-29 11:05:00 | AAPL | Stock | 4.3696 | 4.3736 | 4.3639 | 4.3664 | 13570676.0 |
| 2007-06-29 11:10:00 | AAPL | Stock | 4.3664 | 4.3714 | 4.365 | 4.37 | 6985244.0 |
| 2007-06-29 11:15:00 | AAPL | Stock | 4.3704 | 4.3782 | 4.3693 | 4.3757 | 11305840.0 |
| 2007-06-29 11:20:00 | AAPL | Stock | 4.3757 | 4.3861 | 4.375 | 4.3855 | 17625944.0 |
| 2007-06-29 11:25:00 | AAPL | Stock | 4.3857 | 4.3946 | 4.3832 | 4.3946 | 21990416.0 |
| 2007-06-29 11:30:00 | AAPL | Stock | 4.3943 | 4.4143 | 4.3925 | 4.4132 | 26897892.0 |
| 2007-06-29 11:35:00 | AAPL | Stock | 4.4132 | 4.425 | 4.405 | 4.4236 | 34920256.0 |
| 2007-06-29 11:40:00 | AAPL | Stock | 4.4236 | 4.4286 | 4.3629 | 4.4175 | 28722484.0 |
| 2007-06-29 11:45:00 | AAPL | Stock | 4.4175 | 4.4254 | 4.4139 | 4.4214 | 11997300.0 |
| 2007-06-29 11:50:00 | AAPL | Stock | 4.4214 | 4.4225 | 4.4118 | 4.4186 | 10634708.0 |
| 2007-06-29 11:55:00 | AAPL | Stock | 4.4186 | 4.4186 | 4.4057 | 4.4057 | 14047404.0 |
| 2007-06-29 12:00:00 | AAPL | Stock | 4.4061 | 4.4143 | 4.4046 | 4.4111 | 10403428.0 |
| 2007-06-29 12:05:00 | AAPL | Stock | 4.4114 | 4.4189 | 4.4104 | 4.4179 | 8416408.0 |
| 2007-06-29 12:10:00 | AAPL | Stock | 4.4182 | 4.4189 | 4.3982 | 4.3993 | 11726204.0 |
| 2007-06-29 12:15:00 | AAPL | Stock | 4.4 | 4.4007 | 4.385 | 4.3879 | 19536440.0 |
| 2007-06-29 12:20:00 | AAPL | Stock | 4.3879 | 4.3896 | 4.3793 | 4.3864 | 15780604.0 |
| 2007-06-29 12:25:00 | AAPL | Stock | 4.3864 | 4.3914 | 4.3804 | 4.3829 | 11103232.0 |
| 2007-06-29 12:30:00 | AAPL | Stock | 4.3829 | 4.3893 | 4.3739 | 4.3782 | 15791608.0 |
| 2007-06-29 12:35:00 | AAPL | Stock | 4.3789 | 4.3804 | 4.3671 | 4.3789 | 14594860.0 |
| 2007-06-29 12:40:00 | AAPL | Stock | 4.3793 | 4.3896 | 4.3768 | 4.3843 | 9510480.0 |
| 2007-06-29 12:45:00 | AAPL | Stock | 4.3839 | 4.3868 | 4.38 | 4.3825 | 5515244.0 |
| 2007-06-29 12:50:00 | AAPL | Stock | 4.3818 | 4.3979 | 4.3818 | 4.3939 | 7707028.0 |
| 2007-06-29 12:55:00 | AAPL | Stock | 4.3939 | 4.3979 | 4.3911 | 4.392 | 5537028.0 |
| 2007-06-29 13:00:00 | AAPL | Stock | 4.3921 | 4.4 | 4.3879 | 4.3971 | 8977024.0 |
| 2007-06-29 13:05:00 | AAPL | Stock | 4.3975 | 4.3979 | 4.3875 | 4.3882 | 4812612.0 |
| 2007-06-29 13:10:00 | AAPL | Stock | 4.3879 | 4.3964 | 4.3879 | 4.3954 | 6104308.0 |
| 2007-06-29 13:15:00 | AAPL | Stock | 4.3957 | 4.4054 | 4.395 | 4.4046 | 11900224.0 |
| 2007-06-29 13:20:00 | AAPL | Stock | 4.4039 | 4.4071 | 4.3696 | 4.4057 | 7429884.0 |
| 2007-06-29 13:25:00 | AAPL | Stock | 4.4061 | 4.4071 | 4.4018 | 4.4022 | 4749584.0 |
| 2007-06-29 13:30:00 | AAPL | Stock | 4.4021 | 4.4026 | 4.3971 | 4.3996 | 5874316.0 |
| 2007-06-29 13:35:00 | AAPL | Stock | 4.3993 | 4.4028 | 4.3964 | 4.3979 | 6616512.0 |
> showing 50 of 295,440 rows — these rows as CSV