PREVIEW / stock_5min / 2003-10-06
file: by_date/stock_5min/2003/2003-10-06.parquet size: 2.1 MB rows: 152,642 symbols: 1,623
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-10-06 09:05:00 | AAPL | Stock | 0.3873 | 0.3873 | 0.3873 | 0.3873 | 89600.0 |
| 2003-10-06 09:25:00 | AAPL | Stock | 0.3886 | 0.3886 | 0.3871 | 0.3871 | 72800.0 |
| 2003-10-06 09:30:00 | AAPL | Stock | 0.387 | 0.3884 | 0.3863 | 0.3868 | 2572416.0 |
| 2003-10-06 09:35:00 | AAPL | Stock | 0.3864 | 0.3888 | 0.3863 | 0.3879 | 1324960.0 |
| 2003-10-06 09:40:00 | AAPL | Stock | 0.3879 | 0.3879 | 0.3861 | 0.3861 | 1496488.0 |
| 2003-10-06 09:45:00 | AAPL | Stock | 0.3861 | 0.3868 | 0.3859 | 0.3864 | 1355200.0 |
| 2003-10-06 09:50:00 | AAPL | Stock | 0.3863 | 0.3884 | 0.3854 | 0.3884 | 1798776.0 |
| 2003-10-06 09:55:00 | AAPL | Stock | 0.3882 | 0.3898 | 0.3873 | 0.3891 | 2005136.0 |
| 2003-10-06 10:00:00 | AAPL | Stock | 0.3889 | 0.3904 | 0.3888 | 0.3893 | 2634184.0 |
| 2003-10-06 10:05:00 | AAPL | Stock | 0.3895 | 0.3902 | 0.3893 | 0.3899 | 3600296.0 |
| 2003-10-06 10:10:00 | AAPL | Stock | 0.3902 | 0.3909 | 0.39 | 0.3909 | 4621344.0 |
| 2003-10-06 10:15:00 | AAPL | Stock | 0.3907 | 0.3913 | 0.3907 | 0.3907 | 1892800.0 |
| 2003-10-06 10:20:00 | AAPL | Stock | 0.3907 | 0.3909 | 0.3904 | 0.3904 | 2440816.0 |
| 2003-10-06 10:25:00 | AAPL | Stock | 0.3905 | 0.3914 | 0.3904 | 0.3905 | 1090376.0 |
| 2003-10-06 10:30:00 | AAPL | Stock | 0.3905 | 0.3907 | 0.3902 | 0.3902 | 1237600.0 |
| 2003-10-06 10:35:00 | AAPL | Stock | 0.3905 | 0.3911 | 0.3898 | 0.39 | 5863200.0 |
| 2003-10-06 10:40:00 | AAPL | Stock | 0.3898 | 0.3898 | 0.3889 | 0.3893 | 2519104.0 |
| 2003-10-06 10:45:00 | AAPL | Stock | 0.3893 | 0.3895 | 0.3889 | 0.3893 | 1826048.0 |
| 2003-10-06 10:50:00 | AAPL | Stock | 0.3891 | 0.3893 | 0.3886 | 0.3893 | 2066400.0 |
| 2003-10-06 10:55:00 | AAPL | Stock | 0.3893 | 0.3898 | 0.3893 | 0.3895 | 655200.0 |
| 2003-10-06 11:00:00 | AAPL | Stock | 0.3891 | 0.3902 | 0.3891 | 0.3895 | 871584.0 |
| 2003-10-06 11:05:00 | AAPL | Stock | 0.3893 | 0.3905 | 0.3893 | 0.3904 | 767200.0 |
| 2003-10-06 11:10:00 | AAPL | Stock | 0.3905 | 0.3907 | 0.39 | 0.3902 | 2290400.0 |
| 2003-10-06 11:15:00 | AAPL | Stock | 0.3904 | 0.3914 | 0.3902 | 0.3913 | 1629656.0 |
| 2003-10-06 11:20:00 | AAPL | Stock | 0.3913 | 0.3918 | 0.3911 | 0.3914 | 1092000.0 |
| 2003-10-06 11:25:00 | AAPL | Stock | 0.3914 | 0.3916 | 0.3907 | 0.3911 | 268800.0 |
| 2003-10-06 11:30:00 | AAPL | Stock | 0.3911 | 0.3911 | 0.3904 | 0.3904 | 4485600.0 |
| 2003-10-06 11:35:00 | AAPL | Stock | 0.3904 | 0.3909 | 0.3904 | 0.3909 | 893200.0 |
| 2003-10-06 11:40:00 | AAPL | Stock | 0.3907 | 0.3908 | 0.3904 | 0.3904 | 621600.0 |
| 2003-10-06 11:45:00 | AAPL | Stock | 0.3904 | 0.3913 | 0.39 | 0.3904 | 2986368.0 |
| 2003-10-06 11:50:00 | AAPL | Stock | 0.3904 | 0.3913 | 0.3902 | 0.3913 | 1153600.0 |
| 2003-10-06 11:55:00 | AAPL | Stock | 0.3909 | 0.3918 | 0.3905 | 0.3918 | 1273832.0 |
| 2003-10-06 12:00:00 | AAPL | Stock | 0.3916 | 0.3921 | 0.3916 | 0.392 | 2962400.0 |
| 2003-10-06 12:05:00 | AAPL | Stock | 0.3921 | 0.3921 | 0.392 | 0.392 | 840000.0 |
| 2003-10-06 12:10:00 | AAPL | Stock | 0.392 | 0.392 | 0.3918 | 0.392 | 1069544.0 |
| 2003-10-06 12:15:00 | AAPL | Stock | 0.392 | 0.3927 | 0.3918 | 0.3926 | 3241672.0 |
| 2003-10-06 12:20:00 | AAPL | Stock | 0.3927 | 0.3946 | 0.3925 | 0.3946 | 3917256.0 |
| 2003-10-06 12:25:00 | AAPL | Stock | 0.3946 | 0.3948 | 0.3938 | 0.3941 | 2080232.0 |
| 2003-10-06 12:30:00 | AAPL | Stock | 0.3943 | 0.3952 | 0.3938 | 0.3939 | 4782008.0 |
| 2003-10-06 12:35:00 | AAPL | Stock | 0.3938 | 0.3946 | 0.3938 | 0.3945 | 3857112.0 |
| 2003-10-06 12:40:00 | AAPL | Stock | 0.3945 | 0.3952 | 0.3944 | 0.3946 | 2720536.0 |
| 2003-10-06 12:45:00 | AAPL | Stock | 0.3946 | 0.3948 | 0.3936 | 0.3945 | 2508800.0 |
| 2003-10-06 12:50:00 | AAPL | Stock | 0.3941 | 0.3945 | 0.3939 | 0.3939 | 537600.0 |
| 2003-10-06 12:55:00 | AAPL | Stock | 0.3939 | 0.3941 | 0.3938 | 0.3941 | 1873592.0 |
| 2003-10-06 13:00:00 | AAPL | Stock | 0.3939 | 0.3946 | 0.3938 | 0.3941 | 5112800.0 |
| 2003-10-06 13:05:00 | AAPL | Stock | 0.3939 | 0.3945 | 0.3936 | 0.3943 | 1766632.0 |
| 2003-10-06 13:10:00 | AAPL | Stock | 0.3943 | 0.3943 | 0.3938 | 0.3941 | 1119832.0 |
| 2003-10-06 13:15:00 | AAPL | Stock | 0.3943 | 0.3943 | 0.3939 | 0.3941 | 873600.0 |
| 2003-10-06 13:20:00 | AAPL | Stock | 0.3943 | 0.3943 | 0.3938 | 0.3939 | 1660064.0 |
| 2003-10-06 13:25:00 | AAPL | Stock | 0.3941 | 0.3944 | 0.3938 | 0.3943 | 627200.0 |
> showing 50 of 152,642 rows — these rows as CSV