PREVIEW / stock_5min / 2003-08-22
file: by_date/stock_5min/2003/2003-08-22.parquet size: 2.1 MB rows: 153,495 symbols: 1,603
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 |
|---|---|---|---|---|---|---|---|
| 2003-08-22 08:30:00 | AAPL | Stock | 0.3845 | 0.3845 | 0.3845 | 0.3845 | 28000.0 |
| 2003-08-22 08:35:00 | AAPL | Stock | 0.3877 | 0.3877 | 0.3877 | 0.3877 | 28000.0 |
| 2003-08-22 08:40:00 | AAPL | Stock | 0.3893 | 0.3911 | 0.3893 | 0.3911 | 22400.0 |
| 2003-08-22 08:45:00 | AAPL | Stock | 0.392 | 0.3921 | 0.392 | 0.392 | 173600.0 |
| 2003-08-22 08:50:00 | AAPL | Stock | 0.3928 | 0.3929 | 0.392 | 0.3928 | 96320.0 |
| 2003-08-22 08:55:00 | AAPL | Stock | 0.3929 | 0.3948 | 0.3929 | 0.3948 | 13384.0 |
| 2003-08-22 09:00:00 | AAPL | Stock | 0.3929 | 0.3929 | 0.3929 | 0.3929 | 11200.0 |
| 2003-08-22 09:05:00 | AAPL | Stock | 0.3929 | 0.3929 | 0.3929 | 0.3929 | 95200.0 |
| 2003-08-22 09:10:00 | AAPL | Stock | 0.3929 | 0.3929 | 0.3929 | 0.3929 | 56000.0 |
| 2003-08-22 09:25:00 | AAPL | Stock | 0.392 | 0.3927 | 0.3911 | 0.3927 | 448000.0 |
| 2003-08-22 09:30:00 | AAPL | Stock | 0.3895 | 0.3929 | 0.3875 | 0.3907 | 8388800.0 |
| 2003-08-22 09:35:00 | AAPL | Stock | 0.3907 | 0.3913 | 0.3883 | 0.3886 | 3244528.0 |
| 2003-08-22 09:40:00 | AAPL | Stock | 0.3886 | 0.3886 | 0.3848 | 0.3848 | 2689456.0 |
| 2003-08-22 09:45:00 | AAPL | Stock | 0.3852 | 0.3861 | 0.3845 | 0.3859 | 3194408.0 |
| 2003-08-22 09:50:00 | AAPL | Stock | 0.3859 | 0.3871 | 0.3859 | 0.3868 | 2142000.0 |
| 2003-08-22 09:55:00 | AAPL | Stock | 0.3866 | 0.3893 | 0.3866 | 0.3875 | 4563440.0 |
| 2003-08-22 10:00:00 | AAPL | Stock | 0.3873 | 0.3873 | 0.3823 | 0.3825 | 9148944.0 |
| 2003-08-22 10:05:00 | AAPL | Stock | 0.3823 | 0.3839 | 0.3818 | 0.382 | 4348288.0 |
| 2003-08-22 10:10:00 | AAPL | Stock | 0.3818 | 0.3827 | 0.3813 | 0.3814 | 4294304.0 |
| 2003-08-22 10:15:00 | AAPL | Stock | 0.3814 | 0.3834 | 0.3814 | 0.3827 | 5164096.0 |
| 2003-08-22 10:20:00 | AAPL | Stock | 0.3827 | 0.3829 | 0.3814 | 0.3816 | 4440240.0 |
| 2003-08-22 10:25:00 | AAPL | Stock | 0.3814 | 0.3814 | 0.3795 | 0.3813 | 2235912.0 |
| 2003-08-22 10:30:00 | AAPL | Stock | 0.3814 | 0.3814 | 0.3796 | 0.3813 | 2710064.0 |
| 2003-08-22 10:35:00 | AAPL | Stock | 0.3813 | 0.3846 | 0.3813 | 0.3846 | 2386832.0 |
| 2003-08-22 10:40:00 | AAPL | Stock | 0.3846 | 0.3854 | 0.3829 | 0.3829 | 2538200.0 |
| 2003-08-22 10:45:00 | AAPL | Stock | 0.3827 | 0.3829 | 0.3811 | 0.3811 | 2556456.0 |
| 2003-08-22 10:50:00 | AAPL | Stock | 0.3813 | 0.3814 | 0.3804 | 0.3811 | 1793904.0 |
| 2003-08-22 10:55:00 | AAPL | Stock | 0.3811 | 0.3829 | 0.3811 | 0.3823 | 1309840.0 |
| 2003-08-22 11:00:00 | AAPL | Stock | 0.3823 | 0.3825 | 0.3805 | 0.3809 | 2520168.0 |
| 2003-08-22 11:05:00 | AAPL | Stock | 0.3813 | 0.3829 | 0.3811 | 0.382 | 1324624.0 |
| 2003-08-22 11:10:00 | AAPL | Stock | 0.382 | 0.3821 | 0.3804 | 0.3813 | 2829176.0 |
| 2003-08-22 11:15:00 | AAPL | Stock | 0.3814 | 0.3827 | 0.3814 | 0.3825 | 536648.0 |
| 2003-08-22 11:20:00 | AAPL | Stock | 0.3827 | 0.3827 | 0.3818 | 0.3821 | 561680.0 |
| 2003-08-22 11:25:00 | AAPL | Stock | 0.382 | 0.382 | 0.3804 | 0.3805 | 1069768.0 |
| 2003-08-22 11:30:00 | AAPL | Stock | 0.3805 | 0.3813 | 0.3804 | 0.3804 | 1148784.0 |
| 2003-08-22 11:35:00 | AAPL | Stock | 0.3804 | 0.3811 | 0.3804 | 0.3811 | 1691200.0 |
| 2003-08-22 11:40:00 | AAPL | Stock | 0.3813 | 0.3814 | 0.3809 | 0.3813 | 1766800.0 |
| 2003-08-22 11:45:00 | AAPL | Stock | 0.3809 | 0.3811 | 0.3802 | 0.3802 | 1529304.0 |
| 2003-08-22 11:50:00 | AAPL | Stock | 0.3802 | 0.3802 | 0.3782 | 0.3787 | 2334136.0 |
| 2003-08-22 11:55:00 | AAPL | Stock | 0.3786 | 0.3788 | 0.3773 | 0.3784 | 2808680.0 |
| 2003-08-22 12:00:00 | AAPL | Stock | 0.3782 | 0.3791 | 0.3782 | 0.3788 | 957600.0 |
| 2003-08-22 12:05:00 | AAPL | Stock | 0.3784 | 0.3784 | 0.3773 | 0.3775 | 757400.0 |
| 2003-08-22 12:10:00 | AAPL | Stock | 0.3775 | 0.3782 | 0.377 | 0.377 | 7845600.0 |
| 2003-08-22 12:15:00 | AAPL | Stock | 0.3771 | 0.3773 | 0.3761 | 0.3761 | 2627240.0 |
| 2003-08-22 12:20:00 | AAPL | Stock | 0.3764 | 0.3768 | 0.3759 | 0.3761 | 1794800.0 |
| 2003-08-22 12:25:00 | AAPL | Stock | 0.3761 | 0.3763 | 0.3748 | 0.3763 | 11473840.0 |
| 2003-08-22 12:30:00 | AAPL | Stock | 0.3763 | 0.3766 | 0.375 | 0.3752 | 3753288.0 |
| 2003-08-22 12:35:00 | AAPL | Stock | 0.3754 | 0.3755 | 0.3746 | 0.3755 | 2346400.0 |
| 2003-08-22 12:40:00 | AAPL | Stock | 0.3754 | 0.3764 | 0.375 | 0.3764 | 1058400.0 |
| 2003-08-22 12:45:00 | AAPL | Stock | 0.3766 | 0.3768 | 0.3763 | 0.3768 | 1713488.0 |
> showing 50 of 153,495 rows — these rows as CSV