PREVIEW / futures_30min / 2025-08-27
file: by_date/futures_30min/2025/2025-08-27.parquet size: 105 KB rows: 3,891
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 |
|---|---|---|---|---|---|---|---|
| 2025-08-27 00:00:00 | ES | Futures | 6536.15 | 6536.4 | 6534.64 | 6535.9 | 874.0 |
| 2025-08-27 00:30:00 | ES | Futures | 6536.15 | 6537.16 | 6535.64 | 6535.9 | 921.0 |
| 2025-08-27 01:00:00 | ES | Futures | 6535.9 | 6536.15 | 6532.12 | 6532.87 | 1674.0 |
| 2025-08-27 01:30:00 | ES | Futures | 6532.87 | 6533.63 | 6531.61 | 6532.62 | 1385.0 |
| 2025-08-27 02:00:00 | ES | Futures | 6532.62 | 6535.9 | 6531.87 | 6535.14 | 2508.0 |
| 2025-08-27 02:30:00 | ES | Futures | 6534.89 | 6536.15 | 6532.37 | 6532.87 | 2856.0 |
| 2025-08-27 03:00:00 | ES | Futures | 6533.13 | 6536.4 | 6527.08 | 6528.34 | 6588.0 |
| 2025-08-27 03:30:00 | ES | Futures | 6528.09 | 6531.61 | 6527.08 | 6531.11 | 4885.0 |
| 2025-08-27 04:00:00 | ES | Futures | 6531.36 | 6533.13 | 6527.84 | 6528.84 | 4542.0 |
| 2025-08-27 04:30:00 | ES | Futures | 6529.1 | 6531.11 | 6526.58 | 6530.86 | 3658.0 |
| 2025-08-27 05:00:00 | ES | Futures | 6530.86 | 6534.38 | 6530.1 | 6533.63 | 3125.0 |
| 2025-08-27 05:30:00 | ES | Futures | 6533.88 | 6535.14 | 6533.13 | 6533.38 | 2356.0 |
| 2025-08-27 06:00:00 | ES | Futures | 6533.63 | 6534.89 | 6532.62 | 6534.64 | 2152.0 |
| 2025-08-27 06:30:00 | ES | Futures | 6534.89 | 6535.14 | 6533.13 | 6533.63 | 2044.0 |
| 2025-08-27 07:00:00 | ES | Futures | 6533.38 | 6535.39 | 6532.12 | 6534.38 | 2915.0 |
| 2025-08-27 07:30:00 | ES | Futures | 6534.38 | 6536.4 | 6534.13 | 6534.64 | 3162.0 |
| 2025-08-27 08:00:00 | ES | Futures | 6534.64 | 6537.16 | 6532.62 | 6533.13 | 5096.0 |
| 2025-08-27 08:30:00 | ES | Futures | 6533.13 | 6533.88 | 6526.32 | 6529.35 | 15293.0 |
| 2025-08-27 09:00:00 | ES | Futures | 6529.1 | 6529.85 | 6520.78 | 6522.29 | 20873.0 |
| 2025-08-27 09:30:00 | ES | Futures | 6522.55 | 6532.37 | 6521.29 | 6530.61 | 106138.0 |
| 2025-08-27 10:00:00 | ES | Futures | 6530.61 | 6540.68 | 6529.6 | 6538.41 | 75352.0 |
| 2025-08-27 10:30:00 | ES | Futures | 6538.16 | 6541.44 | 6534.64 | 6539.17 | 53934.0 |
| 2025-08-27 11:00:00 | ES | Futures | 6539.17 | 6542.7 | 6538.67 | 6540.18 | 39170.0 |
| 2025-08-27 11:30:00 | ES | Futures | 6540.43 | 6544.21 | 6536.15 | 6542.95 | 43547.0 |
| 2025-08-27 12:00:00 | ES | Futures | 6542.95 | 6543.45 | 6531.87 | 6536.9 | 49046.0 |
| 2025-08-27 12:30:00 | ES | Futures | 6536.65 | 6542.44 | 6530.61 | 6540.18 | 48819.0 |
| 2025-08-27 13:00:00 | ES | Futures | 6540.18 | 6542.7 | 6537.41 | 6541.44 | 27816.0 |
| 2025-08-27 13:30:00 | ES | Futures | 6541.69 | 6545.47 | 6541.44 | 6544.96 | 21577.0 |
| 2025-08-27 14:00:00 | ES | Futures | 6544.96 | 6551.01 | 6542.95 | 6550.0 | 42218.0 |
| 2025-08-27 14:30:00 | ES | Futures | 6549.75 | 6550.5 | 6547.23 | 6547.48 | 24972.0 |
| 2025-08-27 15:00:00 | ES | Futures | 6547.73 | 6547.99 | 6535.14 | 6543.96 | 68472.0 |
| 2025-08-27 15:30:00 | ES | Futures | 6543.96 | 6551.26 | 6542.95 | 6543.2 | 112831.0 |
| 2025-08-27 16:00:00 | ES | Futures | 6542.95 | 6554.28 | 6507.69 | 6536.15 | 74790.0 |
| 2025-08-27 16:30:00 | ES | Futures | 6535.9 | 6536.9 | 6522.8 | 6533.88 | 19804.0 |
| 2025-08-27 18:00:00 | ES | Futures | 6533.63 | 6534.89 | 6522.8 | 6524.56 | 4851.0 |
| 2025-08-27 18:30:00 | ES | Futures | 6524.81 | 6529.6 | 6524.56 | 6526.58 | 2607.0 |
| 2025-08-27 19:00:00 | ES | Futures | 6526.32 | 6528.09 | 6524.06 | 6525.57 | 1808.0 |
| 2025-08-27 19:30:00 | ES | Futures | 6525.57 | 6526.32 | 6523.05 | 6524.56 | 2344.0 |
| 2025-08-27 20:00:00 | ES | Futures | 6524.31 | 6526.07 | 6519.52 | 6520.53 | 4421.0 |
| 2025-08-27 20:30:00 | ES | Futures | 6520.53 | 6528.59 | 6519.78 | 6527.58 | 4139.0 |
| 2025-08-27 21:00:00 | ES | Futures | 6527.58 | 6530.61 | 6527.08 | 6529.1 | 2747.0 |
| 2025-08-27 21:30:00 | ES | Futures | 6529.1 | 6536.15 | 6529.1 | 6535.14 | 3574.0 |
| 2025-08-27 22:00:00 | ES | Futures | 6535.14 | 6538.41 | 6534.38 | 6537.41 | 3027.0 |
| 2025-08-27 22:30:00 | ES | Futures | 6537.41 | 6537.66 | 6535.14 | 6536.4 | 1525.0 |
| 2025-08-27 23:00:00 | ES | Futures | 6536.4 | 6542.44 | 6535.9 | 6541.19 | 3129.0 |
| 2025-08-27 23:30:00 | ES | Futures | 6541.19 | 6541.94 | 6539.17 | 6541.19 | 1508.0 |
| 2025-08-27 00:00:00 | NQ | Futures | 23818.91 | 23821.69 | 23810.59 | 23820.43 | 738.0 |
| 2025-08-27 00:30:00 | NQ | Futures | 23820.68 | 23827.23 | 23819.92 | 23822.44 | 673.0 |
| 2025-08-27 01:00:00 | NQ | Futures | 23822.44 | 23822.95 | 23801.01 | 23805.04 | 1372.0 |
| 2025-08-27 01:30:00 | NQ | Futures | 23805.04 | 23810.59 | 23796.97 | 23806.56 | 900.0 |
> showing 50 of 3,891 rows — these rows as CSV