PREVIEW / stock_5min / 2003-12-02
file: by_date/stock_5min/2003/2003-12-02.parquet size: 2.3 MB rows: 169,274 symbols: 1,684
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-12-02 08:00:00 | AAPL | Stock | 0.3885 | 0.3902 | 0.3885 | 0.3893 | 98560.0 |
| 2003-12-02 08:10:00 | AAPL | Stock | 0.3902 | 0.3907 | 0.3902 | 0.3902 | 36400.0 |
| 2003-12-02 08:25:00 | AAPL | Stock | 0.3902 | 0.3902 | 0.3902 | 0.3902 | 11200.0 |
| 2003-12-02 08:35:00 | AAPL | Stock | 0.3902 | 0.3902 | 0.3902 | 0.3902 | 11200.0 |
| 2003-12-02 08:45:00 | AAPL | Stock | 0.3877 | 0.3877 | 0.3877 | 0.3877 | 5600.0 |
| 2003-12-02 08:50:00 | AAPL | Stock | 0.3875 | 0.3875 | 0.3875 | 0.3875 | 56000.0 |
| 2003-12-02 08:55:00 | AAPL | Stock | 0.3879 | 0.3879 | 0.3879 | 0.3879 | 1338400.0 |
| 2003-12-02 09:05:00 | AAPL | Stock | 0.3857 | 0.3857 | 0.3857 | 0.3857 | 11200.0 |
| 2003-12-02 09:10:00 | AAPL | Stock | 0.3857 | 0.3893 | 0.3857 | 0.3875 | 168000.0 |
| 2003-12-02 09:20:00 | AAPL | Stock | 0.3868 | 0.3868 | 0.3868 | 0.3868 | 5600.0 |
| 2003-12-02 09:25:00 | AAPL | Stock | 0.3891 | 0.3891 | 0.3868 | 0.3877 | 128800.0 |
| 2003-12-02 09:30:00 | AAPL | Stock | 0.3875 | 0.3879 | 0.3823 | 0.3868 | 10080952.0 |
| 2003-12-02 09:35:00 | AAPL | Stock | 0.3879 | 0.39 | 0.3864 | 0.3893 | 5312944.0 |
| 2003-12-02 09:40:00 | AAPL | Stock | 0.3893 | 0.3893 | 0.3866 | 0.3871 | 4357416.0 |
| 2003-12-02 09:45:00 | AAPL | Stock | 0.3873 | 0.3884 | 0.387 | 0.3875 | 2391984.0 |
| 2003-12-02 09:50:00 | AAPL | Stock | 0.3875 | 0.3875 | 0.3861 | 0.3864 | 2242128.0 |
| 2003-12-02 09:55:00 | AAPL | Stock | 0.3863 | 0.3863 | 0.3845 | 0.3845 | 3988376.0 |
| 2003-12-02 10:00:00 | AAPL | Stock | 0.3845 | 0.3848 | 0.3839 | 0.3845 | 3568096.0 |
| 2003-12-02 10:05:00 | AAPL | Stock | 0.3848 | 0.3852 | 0.3846 | 0.385 | 2684304.0 |
| 2003-12-02 10:10:00 | AAPL | Stock | 0.385 | 0.3855 | 0.3848 | 0.3855 | 738248.0 |
| 2003-12-02 10:15:00 | AAPL | Stock | 0.3855 | 0.3875 | 0.385 | 0.3871 | 2817136.0 |
| 2003-12-02 10:20:00 | AAPL | Stock | 0.3871 | 0.3875 | 0.3859 | 0.3859 | 1365392.0 |
| 2003-12-02 10:25:00 | AAPL | Stock | 0.3859 | 0.3866 | 0.3855 | 0.3857 | 2225216.0 |
| 2003-12-02 10:30:00 | AAPL | Stock | 0.3855 | 0.3857 | 0.3848 | 0.3852 | 2951592.0 |
| 2003-12-02 10:35:00 | AAPL | Stock | 0.3852 | 0.3868 | 0.3848 | 0.3866 | 2768864.0 |
| 2003-12-02 10:40:00 | AAPL | Stock | 0.3861 | 0.3877 | 0.3861 | 0.3875 | 3648456.0 |
| 2003-12-02 10:45:00 | AAPL | Stock | 0.3873 | 0.3877 | 0.387 | 0.3871 | 1450568.0 |
| 2003-12-02 10:50:00 | AAPL | Stock | 0.3871 | 0.3873 | 0.3864 | 0.3869 | 933800.0 |
| 2003-12-02 10:55:00 | AAPL | Stock | 0.3866 | 0.3866 | 0.3863 | 0.3866 | 1207584.0 |
| 2003-12-02 11:00:00 | AAPL | Stock | 0.3864 | 0.3873 | 0.3864 | 0.3873 | 1339296.0 |
| 2003-12-02 11:05:00 | AAPL | Stock | 0.3875 | 0.3877 | 0.3871 | 0.3875 | 725760.0 |
| 2003-12-02 11:10:00 | AAPL | Stock | 0.3873 | 0.3877 | 0.387 | 0.3871 | 995064.0 |
| 2003-12-02 11:15:00 | AAPL | Stock | 0.3873 | 0.3893 | 0.3871 | 0.3893 | 2990904.0 |
| 2003-12-02 11:20:00 | AAPL | Stock | 0.3893 | 0.3902 | 0.3889 | 0.3893 | 3001096.0 |
| 2003-12-02 11:25:00 | AAPL | Stock | 0.3896 | 0.3898 | 0.3891 | 0.3895 | 1909600.0 |
| 2003-12-02 11:30:00 | AAPL | Stock | 0.3896 | 0.3896 | 0.3893 | 0.3893 | 1112552.0 |
| 2003-12-02 11:35:00 | AAPL | Stock | 0.3893 | 0.3895 | 0.3891 | 0.3893 | 1243368.0 |
| 2003-12-02 11:40:00 | AAPL | Stock | 0.3895 | 0.3902 | 0.3891 | 0.39 | 938112.0 |
| 2003-12-02 11:45:00 | AAPL | Stock | 0.3902 | 0.3911 | 0.39 | 0.3909 | 1814792.0 |
| 2003-12-02 11:50:00 | AAPL | Stock | 0.3909 | 0.3909 | 0.3902 | 0.3909 | 2296504.0 |
| 2003-12-02 11:55:00 | AAPL | Stock | 0.3907 | 0.3909 | 0.3907 | 0.3909 | 2937256.0 |
| 2003-12-02 12:00:00 | AAPL | Stock | 0.3907 | 0.3909 | 0.3905 | 0.3907 | 759808.0 |
| 2003-12-02 12:05:00 | AAPL | Stock | 0.3909 | 0.3909 | 0.3902 | 0.3905 | 514584.0 |
| 2003-12-02 12:10:00 | AAPL | Stock | 0.3905 | 0.3905 | 0.39 | 0.3902 | 649264.0 |
| 2003-12-02 12:15:00 | AAPL | Stock | 0.3904 | 0.3909 | 0.3902 | 0.3909 | 3346336.0 |
| 2003-12-02 12:20:00 | AAPL | Stock | 0.3907 | 0.3909 | 0.3907 | 0.3907 | 2823520.0 |
| 2003-12-02 12:25:00 | AAPL | Stock | 0.3907 | 0.3909 | 0.3907 | 0.3907 | 4306960.0 |
| 2003-12-02 12:30:00 | AAPL | Stock | 0.3907 | 0.3909 | 0.3905 | 0.3907 | 3797080.0 |
| 2003-12-02 12:35:00 | AAPL | Stock | 0.3907 | 0.3909 | 0.3893 | 0.3893 | 4115216.0 |
| 2003-12-02 12:40:00 | AAPL | Stock | 0.3893 | 0.3893 | 0.3875 | 0.3877 | 1896664.0 |
> showing 50 of 169,274 rows — these rows as CSV