PREVIEW / stock_5min / 2001-04-18
file: by_date/stock_5min/2001/2001-04-18.parquet size: 1.7 MB rows: 115,064 symbols: 1,292
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-04-18 08:00:00 | AAPL | Stock | 0.3691 | 0.3691 | 0.3686 | 0.3686 | 28000.0 |
| 2001-04-18 08:05:00 | AAPL | Stock | 0.3732 | 0.375 | 0.3705 | 0.375 | 890400.0 |
| 2001-04-18 08:10:00 | AAPL | Stock | 0.375 | 0.3773 | 0.375 | 0.3773 | 44800.0 |
| 2001-04-18 08:15:00 | AAPL | Stock | 0.3773 | 0.3773 | 0.3773 | 0.3773 | 5600.0 |
| 2001-04-18 08:25:00 | AAPL | Stock | 0.3763 | 0.3818 | 0.3759 | 0.3759 | 28000.0 |
| 2001-04-18 08:30:00 | AAPL | Stock | 0.3759 | 0.3779 | 0.3759 | 0.3779 | 67200.0 |
| 2001-04-18 08:35:00 | AAPL | Stock | 0.3759 | 0.3761 | 0.3759 | 0.3761 | 106400.0 |
| 2001-04-18 08:40:00 | AAPL | Stock | 0.3768 | 0.3818 | 0.3768 | 0.38 | 106400.0 |
| 2001-04-18 08:45:00 | AAPL | Stock | 0.3768 | 0.3786 | 0.3768 | 0.3768 | 123200.0 |
| 2001-04-18 08:50:00 | AAPL | Stock | 0.3768 | 0.3779 | 0.3768 | 0.3779 | 78400.0 |
| 2001-04-18 08:55:00 | AAPL | Stock | 0.3821 | 0.3839 | 0.3795 | 0.3795 | 162400.0 |
| 2001-04-18 09:00:00 | AAPL | Stock | 0.3811 | 0.3811 | 0.3786 | 0.3795 | 39200.0 |
| 2001-04-18 09:05:00 | AAPL | Stock | 0.3795 | 0.3813 | 0.3795 | 0.3802 | 61600.0 |
| 2001-04-18 09:10:00 | AAPL | Stock | 0.3821 | 0.3839 | 0.3763 | 0.3839 | 347200.0 |
| 2001-04-18 09:15:00 | AAPL | Stock | 0.3839 | 0.3875 | 0.3821 | 0.3821 | 772800.0 |
| 2001-04-18 09:20:00 | AAPL | Stock | 0.3838 | 0.3839 | 0.375 | 0.3836 | 1601600.0 |
| 2001-04-18 09:25:00 | AAPL | Stock | 0.3836 | 0.385 | 0.383 | 0.3843 | 2934400.0 |
| 2001-04-18 09:30:00 | AAPL | Stock | 0.3852 | 0.3852 | 0.3764 | 0.377 | 17701600.0 |
| 2001-04-18 09:35:00 | AAPL | Stock | 0.377 | 0.3795 | 0.3768 | 0.3773 | 25720800.0 |
| 2001-04-18 09:40:00 | AAPL | Stock | 0.3773 | 0.3788 | 0.3766 | 0.377 | 9721600.0 |
| 2001-04-18 09:45:00 | AAPL | Stock | 0.377 | 0.3782 | 0.3768 | 0.3777 | 29943200.0 |
| 2001-04-18 09:50:00 | AAPL | Stock | 0.3773 | 0.3839 | 0.3764 | 0.3839 | 22758400.0 |
| 2001-04-18 09:55:00 | AAPL | Stock | 0.3839 | 0.3884 | 0.3838 | 0.388 | 13927200.0 |
| 2001-04-18 10:00:00 | AAPL | Stock | 0.388 | 0.3886 | 0.3852 | 0.3877 | 19213600.0 |
| 2001-04-18 10:05:00 | AAPL | Stock | 0.3873 | 0.3875 | 0.3845 | 0.3859 | 16150400.0 |
| 2001-04-18 10:10:00 | AAPL | Stock | 0.3857 | 0.3879 | 0.3846 | 0.3873 | 11614400.0 |
| 2001-04-18 10:15:00 | AAPL | Stock | 0.3873 | 0.3939 | 0.3873 | 0.3927 | 20647200.0 |
| 2001-04-18 10:20:00 | AAPL | Stock | 0.3932 | 0.3936 | 0.3911 | 0.3929 | 21593600.0 |
| 2001-04-18 10:25:00 | AAPL | Stock | 0.3929 | 0.3929 | 0.3882 | 0.3882 | 12107200.0 |
| 2001-04-18 10:30:00 | AAPL | Stock | 0.3882 | 0.3882 | 0.3854 | 0.3854 | 8478400.0 |
| 2001-04-18 10:35:00 | AAPL | Stock | 0.3854 | 0.3855 | 0.3845 | 0.3854 | 4155200.0 |
| 2001-04-18 10:40:00 | AAPL | Stock | 0.3845 | 0.3857 | 0.3836 | 0.3846 | 7128800.0 |
| 2001-04-18 10:45:00 | AAPL | Stock | 0.3845 | 0.3889 | 0.3845 | 0.3888 | 3796800.0 |
| 2001-04-18 10:50:00 | AAPL | Stock | 0.3888 | 0.3902 | 0.388 | 0.3884 | 11810400.0 |
| 2001-04-18 10:55:00 | AAPL | Stock | 0.3886 | 0.4018 | 0.3879 | 0.3991 | 13025600.0 |
| 2001-04-18 11:00:00 | AAPL | Stock | 0.3975 | 0.4063 | 0.3946 | 0.4063 | 13764800.0 |
| 2001-04-18 11:05:00 | AAPL | Stock | 0.4061 | 0.4079 | 0.4018 | 0.4068 | 21733600.0 |
| 2001-04-18 11:10:00 | AAPL | Stock | 0.4068 | 0.4075 | 0.405 | 0.4064 | 21173600.0 |
| 2001-04-18 11:15:00 | AAPL | Stock | 0.4064 | 0.4079 | 0.4046 | 0.4055 | 44004800.0 |
| 2001-04-18 11:20:00 | AAPL | Stock | 0.4052 | 0.4075 | 0.4048 | 0.4066 | 24819200.0 |
| 2001-04-18 11:25:00 | AAPL | Stock | 0.4073 | 0.4111 | 0.4064 | 0.4107 | 13619200.0 |
| 2001-04-18 11:30:00 | AAPL | Stock | 0.4104 | 0.4107 | 0.408 | 0.4098 | 12902400.0 |
| 2001-04-18 11:35:00 | AAPL | Stock | 0.4093 | 0.4105 | 0.4084 | 0.4105 | 9777600.0 |
| 2001-04-18 11:40:00 | AAPL | Stock | 0.4107 | 0.4121 | 0.41 | 0.4114 | 22803200.0 |
| 2001-04-18 11:45:00 | AAPL | Stock | 0.4116 | 0.4148 | 0.4114 | 0.4132 | 13232800.0 |
| 2001-04-18 11:50:00 | AAPL | Stock | 0.4132 | 0.4168 | 0.413 | 0.4166 | 10494400.0 |
| 2001-04-18 11:55:00 | AAPL | Stock | 0.4166 | 0.4179 | 0.4155 | 0.4155 | 12521600.0 |
| 2001-04-18 12:00:00 | AAPL | Stock | 0.4155 | 0.4164 | 0.4116 | 0.412 | 9027200.0 |
| 2001-04-18 12:05:00 | AAPL | Stock | 0.412 | 0.415 | 0.4116 | 0.415 | 9413600.0 |
| 2001-04-18 12:10:00 | AAPL | Stock | 0.4148 | 0.4155 | 0.4129 | 0.4139 | 5488000.0 |
> showing 50 of 115,064 rows — these rows as CSV