PREVIEW / stock_5min / 2003-09-24
file: by_date/stock_5min/2003/2003-09-24.parquet size: 2.2 MB rows: 157,521 symbols: 1,615
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-09-24 08:25:00 | AAPL | Stock | 0.4 | 0.4 | 0.4 | 0.4 | 22400.0 |
| 2003-09-24 08:50:00 | AAPL | Stock | 0.4 | 0.4 | 0.4 | 0.4 | 33600.0 |
| 2003-09-24 09:00:00 | AAPL | Stock | 0.4 | 0.4 | 0.4 | 0.4 | 5600.0 |
| 2003-09-24 09:25:00 | AAPL | Stock | 0.4 | 0.4 | 0.3977 | 0.398 | 509600.0 |
| 2003-09-24 09:30:00 | AAPL | Stock | 0.3966 | 0.3984 | 0.3954 | 0.3973 | 4913608.0 |
| 2003-09-24 09:35:00 | AAPL | Stock | 0.3975 | 0.3979 | 0.3957 | 0.3957 | 4935448.0 |
| 2003-09-24 09:40:00 | AAPL | Stock | 0.3957 | 0.3971 | 0.3952 | 0.3966 | 1828568.0 |
| 2003-09-24 09:45:00 | AAPL | Stock | 0.397 | 0.397 | 0.3961 | 0.3964 | 2279200.0 |
| 2003-09-24 09:50:00 | AAPL | Stock | 0.3964 | 0.3964 | 0.395 | 0.395 | 1804824.0 |
| 2003-09-24 09:55:00 | AAPL | Stock | 0.3952 | 0.3952 | 0.3923 | 0.3936 | 8098552.0 |
| 2003-09-24 10:00:00 | AAPL | Stock | 0.3934 | 0.3945 | 0.3934 | 0.3938 | 2998240.0 |
| 2003-09-24 10:05:00 | AAPL | Stock | 0.3938 | 0.3941 | 0.3918 | 0.392 | 5832512.0 |
| 2003-09-24 10:10:00 | AAPL | Stock | 0.392 | 0.3925 | 0.3907 | 0.392 | 2755144.0 |
| 2003-09-24 10:15:00 | AAPL | Stock | 0.3914 | 0.3914 | 0.3893 | 0.3905 | 3720752.0 |
| 2003-09-24 10:20:00 | AAPL | Stock | 0.3904 | 0.3918 | 0.3904 | 0.3911 | 1515192.0 |
| 2003-09-24 10:25:00 | AAPL | Stock | 0.3913 | 0.3913 | 0.3904 | 0.3904 | 760928.0 |
| 2003-09-24 10:30:00 | AAPL | Stock | 0.3904 | 0.3904 | 0.3895 | 0.3896 | 2094176.0 |
| 2003-09-24 10:35:00 | AAPL | Stock | 0.3896 | 0.3896 | 0.3893 | 0.3895 | 1880984.0 |
| 2003-09-24 10:40:00 | AAPL | Stock | 0.3895 | 0.3918 | 0.3893 | 0.3916 | 3904656.0 |
| 2003-09-24 10:45:00 | AAPL | Stock | 0.3916 | 0.392 | 0.3904 | 0.3904 | 1503432.0 |
| 2003-09-24 10:50:00 | AAPL | Stock | 0.3904 | 0.3907 | 0.3898 | 0.3898 | 1276800.0 |
| 2003-09-24 10:55:00 | AAPL | Stock | 0.3898 | 0.39 | 0.3889 | 0.3891 | 1156400.0 |
| 2003-09-24 11:00:00 | AAPL | Stock | 0.3889 | 0.3889 | 0.3886 | 0.3886 | 2118984.0 |
| 2003-09-24 11:05:00 | AAPL | Stock | 0.3888 | 0.3889 | 0.3886 | 0.3888 | 1610056.0 |
| 2003-09-24 11:10:00 | AAPL | Stock | 0.3888 | 0.3896 | 0.3888 | 0.3893 | 1294720.0 |
| 2003-09-24 11:15:00 | AAPL | Stock | 0.3895 | 0.3896 | 0.3893 | 0.3895 | 3078880.0 |
| 2003-09-24 11:20:00 | AAPL | Stock | 0.3893 | 0.3896 | 0.3893 | 0.3893 | 1360800.0 |
| 2003-09-24 11:25:00 | AAPL | Stock | 0.3896 | 0.3896 | 0.3889 | 0.3889 | 1664320.0 |
| 2003-09-24 11:30:00 | AAPL | Stock | 0.3889 | 0.3891 | 0.3886 | 0.3888 | 509600.0 |
| 2003-09-24 11:35:00 | AAPL | Stock | 0.3888 | 0.3893 | 0.3888 | 0.3893 | 781144.0 |
| 2003-09-24 11:40:00 | AAPL | Stock | 0.3891 | 0.3891 | 0.3859 | 0.3859 | 9640792.0 |
| 2003-09-24 11:45:00 | AAPL | Stock | 0.3859 | 0.3868 | 0.3852 | 0.3852 | 10132472.0 |
| 2003-09-24 11:50:00 | AAPL | Stock | 0.3852 | 0.3852 | 0.3838 | 0.3839 | 5249664.0 |
| 2003-09-24 11:55:00 | AAPL | Stock | 0.3839 | 0.3843 | 0.383 | 0.383 | 3656800.0 |
| 2003-09-24 12:00:00 | AAPL | Stock | 0.3829 | 0.3829 | 0.3788 | 0.3796 | 6548584.0 |
| 2003-09-24 12:05:00 | AAPL | Stock | 0.3795 | 0.3802 | 0.3789 | 0.3795 | 7702912.0 |
| 2003-09-24 12:10:00 | AAPL | Stock | 0.3795 | 0.38 | 0.378 | 0.3784 | 7351232.0 |
| 2003-09-24 12:15:00 | AAPL | Stock | 0.3788 | 0.3802 | 0.3788 | 0.3802 | 1335544.0 |
| 2003-09-24 12:20:00 | AAPL | Stock | 0.3802 | 0.382 | 0.3802 | 0.3819 | 2279200.0 |
| 2003-09-24 12:25:00 | AAPL | Stock | 0.382 | 0.3825 | 0.3814 | 0.3815 | 1861048.0 |
| 2003-09-24 12:30:00 | AAPL | Stock | 0.3814 | 0.3814 | 0.3805 | 0.3807 | 2172016.0 |
| 2003-09-24 12:35:00 | AAPL | Stock | 0.3805 | 0.3829 | 0.3805 | 0.3821 | 1122688.0 |
| 2003-09-24 12:40:00 | AAPL | Stock | 0.3821 | 0.3823 | 0.3798 | 0.3802 | 3521336.0 |
| 2003-09-24 12:45:00 | AAPL | Stock | 0.3798 | 0.38 | 0.3773 | 0.3777 | 7031752.0 |
| 2003-09-24 12:50:00 | AAPL | Stock | 0.3777 | 0.3782 | 0.377 | 0.377 | 4629744.0 |
| 2003-09-24 12:55:00 | AAPL | Stock | 0.3771 | 0.3779 | 0.377 | 0.3777 | 5298552.0 |
| 2003-09-24 13:00:00 | AAPL | Stock | 0.3779 | 0.3786 | 0.3775 | 0.3779 | 2169496.0 |
| 2003-09-24 13:05:00 | AAPL | Stock | 0.3779 | 0.3791 | 0.3777 | 0.3791 | 2195312.0 |
| 2003-09-24 13:10:00 | AAPL | Stock | 0.3791 | 0.3802 | 0.3791 | 0.38 | 1674288.0 |
| 2003-09-24 13:15:00 | AAPL | Stock | 0.3802 | 0.3809 | 0.3798 | 0.3809 | 980000.0 |
> showing 50 of 157,521 rows — these rows as CSV