PREVIEW / stock_5min / 2003-11-11
file: by_date/stock_5min/2003/2003-11-11.parquet size: 2.2 MB rows: 158,905 symbols: 1,660
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-11-11 08:00:00 | AAPL | Stock | 0.3929 | 0.3929 | 0.3929 | 0.3929 | 16800.0 |
| 2003-11-11 09:05:00 | AAPL | Stock | 0.3909 | 0.3909 | 0.3909 | 0.3909 | 89600.0 |
| 2003-11-11 09:20:00 | AAPL | Stock | 0.392 | 0.392 | 0.3909 | 0.392 | 280000.0 |
| 2003-11-11 09:25:00 | AAPL | Stock | 0.392 | 0.392 | 0.3902 | 0.3902 | 173600.0 |
| 2003-11-11 09:30:00 | AAPL | Stock | 0.3911 | 0.3911 | 0.3884 | 0.3904 | 6565160.0 |
| 2003-11-11 09:35:00 | AAPL | Stock | 0.3905 | 0.3927 | 0.3904 | 0.3916 | 2498216.0 |
| 2003-11-11 09:40:00 | AAPL | Stock | 0.3914 | 0.3929 | 0.3913 | 0.3929 | 11841200.0 |
| 2003-11-11 09:45:00 | AAPL | Stock | 0.3929 | 0.3929 | 0.3923 | 0.3929 | 5667088.0 |
| 2003-11-11 09:50:00 | AAPL | Stock | 0.3929 | 0.3932 | 0.3923 | 0.3929 | 3025008.0 |
| 2003-11-11 09:55:00 | AAPL | Stock | 0.3929 | 0.3929 | 0.3911 | 0.3916 | 3707312.0 |
| 2003-11-11 10:00:00 | AAPL | Stock | 0.3914 | 0.3916 | 0.3893 | 0.3893 | 6172208.0 |
| 2003-11-11 10:05:00 | AAPL | Stock | 0.3896 | 0.39 | 0.3886 | 0.3891 | 4953648.0 |
| 2003-11-11 10:10:00 | AAPL | Stock | 0.3893 | 0.3893 | 0.3871 | 0.3877 | 4478096.0 |
| 2003-11-11 10:15:00 | AAPL | Stock | 0.3875 | 0.3879 | 0.3866 | 0.3866 | 4749864.0 |
| 2003-11-11 10:20:00 | AAPL | Stock | 0.3866 | 0.3873 | 0.3861 | 0.3866 | 5471648.0 |
| 2003-11-11 10:25:00 | AAPL | Stock | 0.387 | 0.387 | 0.3861 | 0.3864 | 2390024.0 |
| 2003-11-11 10:30:00 | AAPL | Stock | 0.3866 | 0.3875 | 0.3866 | 0.3875 | 6032152.0 |
| 2003-11-11 10:35:00 | AAPL | Stock | 0.3877 | 0.3879 | 0.3875 | 0.3877 | 747824.0 |
| 2003-11-11 10:40:00 | AAPL | Stock | 0.3877 | 0.3877 | 0.3866 | 0.3866 | 2003400.0 |
| 2003-11-11 10:45:00 | AAPL | Stock | 0.3866 | 0.3866 | 0.3861 | 0.3861 | 1860096.0 |
| 2003-11-11 10:50:00 | AAPL | Stock | 0.3861 | 0.3877 | 0.3861 | 0.3863 | 1934688.0 |
| 2003-11-11 10:55:00 | AAPL | Stock | 0.3866 | 0.3866 | 0.3857 | 0.3859 | 3163832.0 |
| 2003-11-11 11:00:00 | AAPL | Stock | 0.3859 | 0.3879 | 0.3857 | 0.3879 | 1502648.0 |
| 2003-11-11 11:05:00 | AAPL | Stock | 0.3879 | 0.3891 | 0.3879 | 0.3886 | 1885520.0 |
| 2003-11-11 11:10:00 | AAPL | Stock | 0.3888 | 0.3911 | 0.3886 | 0.3911 | 1842064.0 |
| 2003-11-11 11:15:00 | AAPL | Stock | 0.3888 | 0.3888 | 0.3879 | 0.3879 | 1719816.0 |
| 2003-11-11 11:20:00 | AAPL | Stock | 0.388 | 0.3888 | 0.3879 | 0.3886 | 520800.0 |
| 2003-11-11 11:25:00 | AAPL | Stock | 0.388 | 0.388 | 0.3875 | 0.3877 | 400120.0 |
| 2003-11-11 11:30:00 | AAPL | Stock | 0.3879 | 0.3879 | 0.3873 | 0.3877 | 747992.0 |
| 2003-11-11 11:35:00 | AAPL | Stock | 0.3877 | 0.3889 | 0.3877 | 0.3879 | 693560.0 |
| 2003-11-11 11:40:00 | AAPL | Stock | 0.388 | 0.3884 | 0.3877 | 0.3879 | 210560.0 |
| 2003-11-11 11:45:00 | AAPL | Stock | 0.3879 | 0.3884 | 0.3866 | 0.3866 | 1405992.0 |
| 2003-11-11 11:50:00 | AAPL | Stock | 0.3866 | 0.3871 | 0.3866 | 0.387 | 889056.0 |
| 2003-11-11 11:55:00 | AAPL | Stock | 0.3871 | 0.3873 | 0.3868 | 0.3871 | 519344.0 |
| 2003-11-11 12:00:00 | AAPL | Stock | 0.387 | 0.3871 | 0.3866 | 0.3871 | 397600.0 |
| 2003-11-11 12:05:00 | AAPL | Stock | 0.3871 | 0.3873 | 0.3866 | 0.387 | 1033200.0 |
| 2003-11-11 12:10:00 | AAPL | Stock | 0.387 | 0.3871 | 0.3861 | 0.3871 | 761040.0 |
| 2003-11-11 12:15:00 | AAPL | Stock | 0.3871 | 0.3871 | 0.3868 | 0.3871 | 974400.0 |
| 2003-11-11 12:20:00 | AAPL | Stock | 0.387 | 0.3871 | 0.3868 | 0.3868 | 828800.0 |
| 2003-11-11 12:25:00 | AAPL | Stock | 0.3868 | 0.3873 | 0.3868 | 0.387 | 1420440.0 |
| 2003-11-11 12:30:00 | AAPL | Stock | 0.387 | 0.3875 | 0.3866 | 0.3875 | 2635416.0 |
| 2003-11-11 12:35:00 | AAPL | Stock | 0.3875 | 0.3888 | 0.387 | 0.3882 | 4320792.0 |
| 2003-11-11 12:40:00 | AAPL | Stock | 0.3882 | 0.3886 | 0.3877 | 0.3886 | 4760000.0 |
| 2003-11-11 12:45:00 | AAPL | Stock | 0.3888 | 0.3899 | 0.3884 | 0.3886 | 1220464.0 |
| 2003-11-11 12:50:00 | AAPL | Stock | 0.3884 | 0.3893 | 0.388 | 0.388 | 2269680.0 |
| 2003-11-11 12:55:00 | AAPL | Stock | 0.3884 | 0.3891 | 0.3882 | 0.3889 | 224000.0 |
| 2003-11-11 13:00:00 | AAPL | Stock | 0.3888 | 0.3891 | 0.3888 | 0.3889 | 397880.0 |
| 2003-11-11 13:05:00 | AAPL | Stock | 0.3889 | 0.3891 | 0.3888 | 0.3889 | 449120.0 |
| 2003-11-11 13:10:00 | AAPL | Stock | 0.3889 | 0.3891 | 0.3889 | 0.3891 | 576800.0 |
| 2003-11-11 13:15:00 | AAPL | Stock | 0.3893 | 0.3893 | 0.3889 | 0.3893 | 1136968.0 |
> showing 50 of 158,905 rows — these rows as CSV