PREVIEW / stock_5min / 2008-06-19
file: by_date/stock_5min/2008/2008-06-19.parquet size: 4.4 MB rows: 312,751 symbols: 3,323
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 |
|---|---|---|---|---|---|---|---|
| 2008-06-19 05:35:00 | AAPL | Stock | 6.3857 | 6.3857 | 6.3857 | 6.3857 | 33600.0 |
| 2008-06-19 06:35:00 | AAPL | Stock | 6.3868 | 6.3868 | 6.3868 | 6.3868 | 14000.0 |
| 2008-06-19 06:40:00 | AAPL | Stock | 6.3871 | 6.3871 | 6.3871 | 6.3871 | 12264.0 |
| 2008-06-19 06:50:00 | AAPL | Stock | 6.3893 | 6.3893 | 6.3893 | 6.3893 | 16800.0 |
| 2008-06-19 06:55:00 | AAPL | Stock | 6.3893 | 6.3893 | 6.3893 | 6.3893 | 13160.0 |
| 2008-06-19 07:05:00 | AAPL | Stock | 6.3893 | 6.3893 | 6.3893 | 6.3893 | 5600.0 |
| 2008-06-19 07:10:00 | AAPL | Stock | 6.3893 | 6.3893 | 6.3893 | 6.3893 | 2800.0 |
| 2008-06-19 07:20:00 | AAPL | Stock | 6.3839 | 6.3839 | 6.3839 | 6.3839 | 14000.0 |
| 2008-06-19 07:35:00 | AAPL | Stock | 6.3889 | 6.4104 | 6.3889 | 6.4071 | 81200.0 |
| 2008-06-19 07:40:00 | AAPL | Stock | 6.4068 | 6.4068 | 6.405 | 6.405 | 72240.0 |
| 2008-06-19 07:45:00 | AAPL | Stock | 6.4018 | 6.4018 | 6.4018 | 6.4018 | 2800.0 |
| 2008-06-19 07:50:00 | AAPL | Stock | 6.4043 | 6.4054 | 6.4043 | 6.4054 | 5600.0 |
| 2008-06-19 07:55:00 | AAPL | Stock | 6.4054 | 6.4214 | 6.405 | 6.4107 | 94360.0 |
| 2008-06-19 08:00:00 | AAPL | Stock | 6.4107 | 6.4125 | 6.4 | 6.4036 | 263144.0 |
| 2008-06-19 08:05:00 | AAPL | Stock | 6.4039 | 6.4071 | 6.3946 | 6.3996 | 259308.0 |
| 2008-06-19 08:10:00 | AAPL | Stock | 6.3993 | 6.3993 | 6.3896 | 6.3921 | 211008.0 |
| 2008-06-19 08:15:00 | AAPL | Stock | 6.3911 | 6.3925 | 6.3782 | 6.3786 | 234864.0 |
| 2008-06-19 08:20:00 | AAPL | Stock | 6.3786 | 6.3914 | 6.3786 | 6.3861 | 154420.0 |
| 2008-06-19 08:25:00 | AAPL | Stock | 6.3936 | 6.3936 | 6.3861 | 6.3921 | 83020.0 |
| 2008-06-19 08:30:00 | AAPL | Stock | 6.3857 | 6.4068 | 6.3786 | 6.3929 | 441420.0 |
| 2008-06-19 08:35:00 | AAPL | Stock | 6.3911 | 6.3925 | 6.3882 | 6.3921 | 76916.0 |
| 2008-06-19 08:40:00 | AAPL | Stock | 6.3921 | 6.3979 | 6.3886 | 6.3957 | 89600.0 |
| 2008-06-19 08:45:00 | AAPL | Stock | 6.3925 | 6.3929 | 6.3893 | 6.3911 | 132440.0 |
| 2008-06-19 08:50:00 | AAPL | Stock | 6.3925 | 6.3925 | 6.3857 | 6.3861 | 173796.0 |
| 2008-06-19 08:55:00 | AAPL | Stock | 6.3864 | 6.3864 | 6.3679 | 6.3679 | 150080.0 |
| 2008-06-19 09:00:00 | AAPL | Stock | 6.3711 | 6.3743 | 6.3675 | 6.3714 | 120148.0 |
| 2008-06-19 09:05:00 | AAPL | Stock | 6.3714 | 6.3929 | 6.3704 | 6.3921 | 190512.0 |
| 2008-06-19 09:10:00 | AAPL | Stock | 6.3861 | 6.3871 | 6.3821 | 6.3871 | 78400.0 |
| 2008-06-19 09:15:00 | AAPL | Stock | 6.3857 | 6.3857 | 6.3825 | 6.3854 | 110096.0 |
| 2008-06-19 09:20:00 | AAPL | Stock | 6.3871 | 6.3889 | 6.3832 | 6.3871 | 27916.0 |
| 2008-06-19 09:25:00 | AAPL | Stock | 6.3871 | 6.3889 | 6.3761 | 6.3768 | 326144.0 |
| 2008-06-19 09:30:00 | AAPL | Stock | 6.3768 | 6.4107 | 6.3711 | 6.3986 | 14475188.0 |
| 2008-06-19 09:35:00 | AAPL | Stock | 6.3986 | 6.4279 | 6.3929 | 6.4239 | 15404704.0 |
| 2008-06-19 09:40:00 | AAPL | Stock | 6.4256 | 6.4275 | 6.395 | 6.395 | 10662932.0 |
| 2008-06-19 09:45:00 | AAPL | Stock | 6.3954 | 6.3964 | 6.3482 | 6.3629 | 21318836.0 |
| 2008-06-19 09:50:00 | AAPL | Stock | 6.3629 | 6.3896 | 6.3568 | 6.3889 | 16448460.0 |
| 2008-06-19 09:55:00 | AAPL | Stock | 6.3886 | 6.4104 | 6.3839 | 6.403 | 15276184.0 |
| 2008-06-19 10:00:00 | AAPL | Stock | 6.4032 | 6.4107 | 6.3457 | 6.3814 | 20094620.0 |
| 2008-06-19 10:05:00 | AAPL | Stock | 6.3804 | 6.3832 | 6.3482 | 6.3493 | 12633936.0 |
| 2008-06-19 10:10:00 | AAPL | Stock | 6.3486 | 6.3618 | 6.3143 | 6.3539 | 21916468.0 |
| 2008-06-19 10:15:00 | AAPL | Stock | 6.3536 | 6.365 | 6.3332 | 6.35 | 11272100.0 |
| 2008-06-19 10:20:00 | AAPL | Stock | 6.3486 | 6.3664 | 6.3429 | 6.3579 | 8464316.0 |
| 2008-06-19 10:25:00 | AAPL | Stock | 6.3582 | 6.3732 | 6.3518 | 6.3657 | 8865500.0 |
| 2008-06-19 10:30:00 | AAPL | Stock | 6.3664 | 6.3996 | 6.36 | 6.3929 | 14323484.0 |
| 2008-06-19 10:35:00 | AAPL | Stock | 6.3921 | 6.4025 | 6.3811 | 6.3911 | 8980692.0 |
| 2008-06-19 10:40:00 | AAPL | Stock | 6.39 | 6.3957 | 6.3804 | 6.3879 | 5518324.0 |
| 2008-06-19 10:45:00 | AAPL | Stock | 6.3882 | 6.4104 | 6.3868 | 6.3979 | 6289192.0 |
| 2008-06-19 10:50:00 | AAPL | Stock | 6.3982 | 6.4282 | 6.3904 | 6.4254 | 15356124.0 |
| 2008-06-19 10:55:00 | AAPL | Stock | 6.4254 | 6.4325 | 6.4186 | 6.4243 | 11780440.0 |
| 2008-06-19 11:00:00 | AAPL | Stock | 6.4243 | 6.4414 | 6.4204 | 6.4239 | 13228852.0 |
> showing 50 of 312,751 rows — these rows as CSV