PREVIEW / stock_5min / 2000-07-31
file: by_date/stock_5min/2000/2000-07-31.parquet size: 1.2 MB rows: 89,953 symbols: 1,200
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 |
|---|---|---|---|---|---|---|---|
| 2000-07-31 08:00:00 | AAPL | Stock | 0.8705 | 0.8705 | 0.8705 | 0.8705 | 5600.0 |
| 2000-07-31 09:05:00 | AAPL | Stock | 0.875 | 0.875 | 0.875 | 0.875 | 16800.0 |
| 2000-07-31 09:15:00 | AAPL | Stock | 0.8839 | 0.8839 | 0.8772 | 0.8772 | 56000.0 |
| 2000-07-31 09:20:00 | AAPL | Stock | 0.875 | 0.875 | 0.8705 | 0.8705 | 28000.0 |
| 2000-07-31 09:25:00 | AAPL | Stock | 0.8772 | 0.8795 | 0.875 | 0.8795 | 767200.0 |
| 2000-07-31 09:30:00 | AAPL | Stock | 0.8778 | 0.8795 | 0.875 | 0.8795 | 3802400.0 |
| 2000-07-31 09:35:00 | AAPL | Stock | 0.8795 | 0.8817 | 0.8705 | 0.875 | 4407200.0 |
| 2000-07-31 09:40:00 | AAPL | Stock | 0.8761 | 0.8917 | 0.8761 | 0.8884 | 5454400.0 |
| 2000-07-31 09:45:00 | AAPL | Stock | 0.8884 | 0.8906 | 0.8806 | 0.8884 | 2609600.0 |
| 2000-07-31 09:50:00 | AAPL | Stock | 0.8828 | 0.8895 | 0.8828 | 0.8873 | 2492000.0 |
| 2000-07-31 09:55:00 | AAPL | Stock | 0.8878 | 0.8906 | 0.8828 | 0.8884 | 2990400.0 |
| 2000-07-31 10:00:00 | AAPL | Stock | 0.8895 | 0.8973 | 0.8862 | 0.8968 | 5549600.0 |
| 2000-07-31 10:05:00 | AAPL | Stock | 0.8968 | 0.8996 | 0.8862 | 0.8862 | 3248000.0 |
| 2000-07-31 10:10:00 | AAPL | Stock | 0.8873 | 0.8873 | 0.8772 | 0.8828 | 3522400.0 |
| 2000-07-31 10:15:00 | AAPL | Stock | 0.8828 | 0.8828 | 0.8717 | 0.8795 | 2940000.0 |
| 2000-07-31 10:20:00 | AAPL | Stock | 0.8795 | 0.8873 | 0.8795 | 0.885 | 2217600.0 |
| 2000-07-31 10:25:00 | AAPL | Stock | 0.8839 | 0.885 | 0.8817 | 0.8817 | 1024800.0 |
| 2000-07-31 10:30:00 | AAPL | Stock | 0.8817 | 0.8929 | 0.8772 | 0.8895 | 3113600.0 |
| 2000-07-31 10:35:00 | AAPL | Stock | 0.8906 | 0.9018 | 0.8884 | 0.9018 | 2592800.0 |
| 2000-07-31 10:40:00 | AAPL | Stock | 0.9018 | 0.9063 | 0.8929 | 0.8929 | 3225600.0 |
| 2000-07-31 10:45:00 | AAPL | Stock | 0.8973 | 0.9063 | 0.894 | 0.904 | 1551200.0 |
| 2000-07-31 10:50:00 | AAPL | Stock | 0.9051 | 0.9107 | 0.904 | 0.9096 | 2161600.0 |
| 2000-07-31 10:55:00 | AAPL | Stock | 0.9085 | 0.9096 | 0.9074 | 0.9096 | 2962400.0 |
| 2000-07-31 11:00:00 | AAPL | Stock | 0.9085 | 0.9096 | 0.9085 | 0.9085 | 1198400.0 |
| 2000-07-31 11:05:00 | AAPL | Stock | 0.9085 | 0.9085 | 0.9063 | 0.9085 | 924000.0 |
| 2000-07-31 11:10:00 | AAPL | Stock | 0.9079 | 0.9096 | 0.9063 | 0.9096 | 2240000.0 |
| 2000-07-31 11:15:00 | AAPL | Stock | 0.9085 | 0.9163 | 0.9085 | 0.9085 | 3332000.0 |
| 2000-07-31 11:20:00 | AAPL | Stock | 0.9085 | 0.9129 | 0.904 | 0.904 | 1691200.0 |
| 2000-07-31 11:25:00 | AAPL | Stock | 0.9063 | 0.9063 | 0.8996 | 0.9051 | 896000.0 |
| 2000-07-31 11:30:00 | AAPL | Stock | 0.9063 | 0.9107 | 0.9051 | 0.9107 | 1321600.0 |
| 2000-07-31 11:35:00 | AAPL | Stock | 0.9085 | 0.9096 | 0.9018 | 0.9018 | 1080800.0 |
| 2000-07-31 11:40:00 | AAPL | Stock | 0.9018 | 0.9018 | 0.8906 | 0.8962 | 1472800.0 |
| 2000-07-31 11:45:00 | AAPL | Stock | 0.8962 | 0.8973 | 0.8929 | 0.8929 | 537600.0 |
| 2000-07-31 11:50:00 | AAPL | Stock | 0.8951 | 0.9029 | 0.8951 | 0.9007 | 1556800.0 |
| 2000-07-31 11:55:00 | AAPL | Stock | 0.9007 | 0.9018 | 0.8984 | 0.9018 | 515200.0 |
| 2000-07-31 12:00:00 | AAPL | Stock | 0.8996 | 0.9007 | 0.8962 | 0.8996 | 632800.0 |
| 2000-07-31 12:05:00 | AAPL | Stock | 0.8996 | 0.9018 | 0.8984 | 0.9018 | 201600.0 |
| 2000-07-31 12:10:00 | AAPL | Stock | 0.8996 | 0.8996 | 0.8962 | 0.8984 | 610400.0 |
| 2000-07-31 12:15:00 | AAPL | Stock | 0.9018 | 0.9018 | 0.8984 | 0.9018 | 1181600.0 |
| 2000-07-31 12:20:00 | AAPL | Stock | 0.9007 | 0.9074 | 0.9007 | 0.9063 | 543200.0 |
| 2000-07-31 12:25:00 | AAPL | Stock | 0.9029 | 0.9074 | 0.9029 | 0.9051 | 280000.0 |
| 2000-07-31 12:30:00 | AAPL | Stock | 0.9051 | 0.9085 | 0.9018 | 0.9085 | 929600.0 |
| 2000-07-31 12:35:00 | AAPL | Stock | 0.9085 | 0.9085 | 0.904 | 0.9051 | 448000.0 |
| 2000-07-31 12:40:00 | AAPL | Stock | 0.9051 | 0.9096 | 0.9046 | 0.9085 | 655200.0 |
| 2000-07-31 12:45:00 | AAPL | Stock | 0.9085 | 0.9096 | 0.9063 | 0.9096 | 4720800.0 |
| 2000-07-31 12:50:00 | AAPL | Stock | 0.9085 | 0.9096 | 0.9063 | 0.9096 | 1226400.0 |
| 2000-07-31 12:55:00 | AAPL | Stock | 0.9096 | 0.9096 | 0.9063 | 0.9063 | 722400.0 |
| 2000-07-31 13:00:00 | AAPL | Stock | 0.9063 | 0.9085 | 0.9051 | 0.9085 | 431200.0 |
| 2000-07-31 13:05:00 | AAPL | Stock | 0.9085 | 0.9152 | 0.9074 | 0.9141 | 2156000.0 |
| 2000-07-31 13:10:00 | AAPL | Stock | 0.9129 | 0.9152 | 0.9085 | 0.9096 | 778400.0 |
> showing 50 of 89,953 rows — these rows as CSV