PREVIEW / stock_5min / 2024-03-13
file: by_date/stock_5min/2024/2024-03-13.parquet size: 6.8 MB rows: 407,401 symbols: 1,095
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 |
|---|---|---|---|---|---|---|---|
| 2024-03-13 04:00:00 | AAPL | Stock | 173.31 | 173.31 | 173.2 | 173.2 | 565.0 |
| 2024-03-13 04:10:00 | AAPL | Stock | 173.07 | 173.07 | 173.07 | 173.07 | 463.0 |
| 2024-03-13 04:15:00 | AAPL | Stock | 173.03 | 173.11 | 172.96 | 173.1 | 1620.0 |
| 2024-03-13 04:20:00 | AAPL | Stock | 173.09 | 173.09 | 173.02 | 173.02 | 356.0 |
| 2024-03-13 04:25:00 | AAPL | Stock | 172.94 | 172.94 | 172.94 | 172.94 | 100.0 |
| 2024-03-13 04:30:00 | AAPL | Stock | 172.91 | 172.94 | 172.85 | 172.94 | 600.0 |
| 2024-03-13 04:35:00 | AAPL | Stock | 172.98 | 172.98 | 172.98 | 172.98 | 754.0 |
| 2024-03-13 04:55:00 | AAPL | Stock | 173.08 | 173.08 | 173.08 | 173.08 | 250.0 |
| 2024-03-13 05:00:00 | AAPL | Stock | 173.0 | 173.0 | 173.0 | 173.0 | 200.0 |
| 2024-03-13 05:05:00 | AAPL | Stock | 172.94 | 172.99 | 172.85 | 172.85 | 3488.0 |
| 2024-03-13 05:10:00 | AAPL | Stock | 172.91 | 172.96 | 172.91 | 172.96 | 733.0 |
| 2024-03-13 05:25:00 | AAPL | Stock | 172.9 | 172.9 | 172.9 | 172.9 | 312.0 |
| 2024-03-13 05:30:00 | AAPL | Stock | 172.99 | 173.0 | 172.99 | 173.0 | 553.0 |
| 2024-03-13 05:35:00 | AAPL | Stock | 173.0 | 173.0 | 173.0 | 173.0 | 186.0 |
| 2024-03-13 05:45:00 | AAPL | Stock | 173.07 | 173.07 | 173.07 | 173.07 | 100.0 |
| 2024-03-13 05:50:00 | AAPL | Stock | 173.05 | 173.05 | 173.05 | 173.05 | 500.0 |
| 2024-03-13 06:00:00 | AAPL | Stock | 173.08 | 173.09 | 173.08 | 173.09 | 1145.0 |
| 2024-03-13 06:05:00 | AAPL | Stock | 173.1 | 173.12 | 173.07 | 173.12 | 508.0 |
| 2024-03-13 06:10:00 | AAPL | Stock | 173.1 | 173.18 | 173.1 | 173.16 | 874.0 |
| 2024-03-13 06:15:00 | AAPL | Stock | 173.08 | 173.08 | 173.08 | 173.08 | 356.0 |
| 2024-03-13 06:25:00 | AAPL | Stock | 173.18 | 173.18 | 173.18 | 173.18 | 233.0 |
| 2024-03-13 06:40:00 | AAPL | Stock | 173.14 | 173.14 | 173.14 | 173.14 | 292.0 |
| 2024-03-13 06:50:00 | AAPL | Stock | 173.19 | 173.2 | 173.18 | 173.2 | 719.0 |
| 2024-03-13 06:55:00 | AAPL | Stock | 173.23 | 173.23 | 173.23 | 173.23 | 200.0 |
| 2024-03-13 07:00:00 | AAPL | Stock | 173.22 | 173.23 | 173.01 | 173.04 | 5357.0 |
| 2024-03-13 07:05:00 | AAPL | Stock | 173.0 | 173.0 | 172.9 | 172.92 | 5327.0 |
| 2024-03-13 07:10:00 | AAPL | Stock | 173.0 | 173.0 | 172.87 | 172.87 | 1427.0 |
| 2024-03-13 07:15:00 | AAPL | Stock | 172.9 | 172.92 | 172.86 | 172.9 | 2548.0 |
| 2024-03-13 07:20:00 | AAPL | Stock | 172.93 | 172.93 | 172.87 | 172.9 | 2340.0 |
| 2024-03-13 07:25:00 | AAPL | Stock | 172.91 | 172.91 | 172.86 | 172.86 | 652.0 |
| 2024-03-13 07:30:00 | AAPL | Stock | 172.87 | 172.87 | 172.8 | 172.8 | 4927.0 |
| 2024-03-13 07:35:00 | AAPL | Stock | 172.82 | 172.84 | 172.82 | 172.84 | 790.0 |
| 2024-03-13 07:40:00 | AAPL | Stock | 172.84 | 172.84 | 172.8 | 172.8 | 1054.0 |
| 2024-03-13 07:45:00 | AAPL | Stock | 172.8 | 172.85 | 172.8 | 172.84 | 2246.0 |
| 2024-03-13 07:50:00 | AAPL | Stock | 172.8 | 172.8 | 172.74 | 172.8 | 1524.0 |
| 2024-03-13 07:55:00 | AAPL | Stock | 172.82 | 172.82 | 172.8 | 172.81 | 622.0 |
| 2024-03-13 08:00:00 | AAPL | Stock | 173.2297 | 173.34 | 172.56 | 172.59 | 27619.0 |
| 2024-03-13 08:05:00 | AAPL | Stock | 172.61 | 172.7668 | 172.5392 | 172.6001 | 2315.0 |
| 2024-03-13 08:10:00 | AAPL | Stock | 172.6 | 172.6398 | 172.57 | 172.6398 | 4250.0 |
| 2024-03-13 08:15:00 | AAPL | Stock | 172.67 | 172.67 | 172.4101 | 172.5 | 13760.0 |
| 2024-03-13 08:20:00 | AAPL | Stock | 172.6584 | 172.92 | 172.59 | 172.78 | 7482.0 |
| 2024-03-13 08:25:00 | AAPL | Stock | 172.82 | 172.84 | 172.67 | 172.67 | 3606.0 |
| 2024-03-13 08:30:00 | AAPL | Stock | 172.77 | 172.9 | 172.704 | 172.88 | 6854.0 |
| 2024-03-13 08:35:00 | AAPL | Stock | 172.7222 | 172.99 | 172.7222 | 172.85 | 7153.0 |
| 2024-03-13 08:40:00 | AAPL | Stock | 172.8994 | 172.97 | 172.85 | 172.96 | 4466.0 |
| 2024-03-13 08:45:00 | AAPL | Stock | 172.87 | 172.9 | 172.66 | 172.9 | 8728.0 |
| 2024-03-13 08:50:00 | AAPL | Stock | 172.88 | 173.2055 | 172.88 | 172.9986 | 11058.0 |
| 2024-03-13 08:55:00 | AAPL | Stock | 173.0974 | 173.15 | 173.06 | 173.06 | 8196.0 |
| 2024-03-13 09:00:00 | AAPL | Stock | 173.07 | 173.39 | 173.0235 | 173.39 | 6955.0 |
| 2024-03-13 09:05:00 | AAPL | Stock | 173.34 | 173.44 | 173.29 | 173.34 | 13216.0 |
> showing 50 of 407,401 rows — these rows as CSV