PREVIEW / futures_1hour / 2025-08-27
file: by_date/futures_1hour/2025/2025-08-27.parquet size: 65 KB rows: 2,054
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 | 6537.16 | 6534.64 | 6535.9 | 1795.0 |
| 2025-08-27 01:00:00 | ES | Futures | 6535.9 | 6536.15 | 6531.61 | 6532.62 | 3059.0 |
| 2025-08-27 02:00:00 | ES | Futures | 6532.62 | 6536.15 | 6531.87 | 6532.87 | 5364.0 |
| 2025-08-27 03:00:00 | ES | Futures | 6533.13 | 6536.4 | 6527.08 | 6531.11 | 11473.0 |
| 2025-08-27 04:00:00 | ES | Futures | 6531.36 | 6533.13 | 6526.58 | 6530.86 | 8200.0 |
| 2025-08-27 05:00:00 | ES | Futures | 6530.86 | 6535.14 | 6530.1 | 6533.38 | 5481.0 |
| 2025-08-27 06:00:00 | ES | Futures | 6533.63 | 6535.14 | 6532.62 | 6533.63 | 4196.0 |
| 2025-08-27 07:00:00 | ES | Futures | 6533.38 | 6536.4 | 6532.12 | 6534.64 | 6077.0 |
| 2025-08-27 08:00:00 | ES | Futures | 6534.64 | 6537.16 | 6526.32 | 6529.35 | 20389.0 |
| 2025-08-27 09:00:00 | ES | Futures | 6529.1 | 6532.37 | 6520.78 | 6530.61 | 127011.0 |
| 2025-08-27 10:00:00 | ES | Futures | 6530.61 | 6541.44 | 6529.6 | 6539.17 | 129286.0 |
| 2025-08-27 11:00:00 | ES | Futures | 6539.17 | 6544.21 | 6536.15 | 6542.95 | 82717.0 |
| 2025-08-27 12:00:00 | ES | Futures | 6542.95 | 6543.45 | 6530.61 | 6540.18 | 97865.0 |
| 2025-08-27 13:00:00 | ES | Futures | 6540.18 | 6545.47 | 6537.41 | 6544.96 | 49393.0 |
| 2025-08-27 14:00:00 | ES | Futures | 6544.96 | 6551.01 | 6542.95 | 6547.48 | 67190.0 |
| 2025-08-27 15:00:00 | ES | Futures | 6547.73 | 6551.26 | 6535.14 | 6543.2 | 181303.0 |
| 2025-08-27 16:00:00 | ES | Futures | 6542.95 | 6554.28 | 6507.69 | 6533.88 | 94594.0 |
| 2025-08-27 18:00:00 | ES | Futures | 6533.63 | 6534.89 | 6522.8 | 6526.58 | 7458.0 |
| 2025-08-27 19:00:00 | ES | Futures | 6526.32 | 6528.09 | 6523.05 | 6524.56 | 4152.0 |
| 2025-08-27 20:00:00 | ES | Futures | 6524.31 | 6528.59 | 6519.52 | 6527.58 | 8560.0 |
| 2025-08-27 21:00:00 | ES | Futures | 6527.58 | 6536.15 | 6527.08 | 6535.14 | 6321.0 |
| 2025-08-27 22:00:00 | ES | Futures | 6535.14 | 6538.41 | 6534.38 | 6536.4 | 4552.0 |
| 2025-08-27 23:00:00 | ES | Futures | 6536.4 | 6542.44 | 6535.9 | 6541.19 | 4637.0 |
| 2025-08-27 00:00:00 | NQ | Futures | 23818.91 | 23827.23 | 23810.59 | 23822.44 | 1411.0 |
| 2025-08-27 01:00:00 | NQ | Futures | 23822.44 | 23822.95 | 23796.97 | 23806.56 | 2272.0 |
| 2025-08-27 02:00:00 | NQ | Futures | 23806.3 | 23824.97 | 23800.76 | 23807.82 | 2872.0 |
| 2025-08-27 03:00:00 | NQ | Futures | 23808.32 | 23820.68 | 23780.83 | 23800.25 | 5628.0 |
| 2025-08-27 04:00:00 | NQ | Futures | 23800.76 | 23804.54 | 23772.76 | 23792.18 | 4252.0 |
| 2025-08-27 05:00:00 | NQ | Futures | 23792.69 | 23807.82 | 23790.67 | 23802.02 | 2734.0 |
| 2025-08-27 06:00:00 | NQ | Futures | 23802.52 | 23812.36 | 23796.72 | 23806.05 | 2546.0 |
| 2025-08-27 07:00:00 | NQ | Futures | 23805.55 | 23820.43 | 23802.27 | 23813.37 | 3128.0 |
| 2025-08-27 08:00:00 | NQ | Futures | 23813.62 | 23826.73 | 23768.73 | 23787.64 | 12193.0 |
| 2025-08-27 09:00:00 | NQ | Futures | 23786.89 | 23791.43 | 23692.07 | 23740.49 | 73486.0 |
| 2025-08-27 10:00:00 | NQ | Futures | 23739.73 | 23821.94 | 23731.41 | 23805.55 | 59854.0 |
| 2025-08-27 11:00:00 | NQ | Futures | 23805.8 | 23836.57 | 23777.56 | 23829.0 | 40111.0 |
| 2025-08-27 12:00:00 | NQ | Futures | 23829.0 | 23830.01 | 23747.04 | 23805.55 | 49031.0 |
| 2025-08-27 13:00:00 | NQ | Futures | 23806.05 | 23830.26 | 23792.69 | 23826.98 | 23752.0 |
| 2025-08-27 14:00:00 | NQ | Futures | 23826.98 | 23863.55 | 23818.91 | 23832.53 | 30138.0 |
| 2025-08-27 15:00:00 | NQ | Futures | 23832.28 | 23852.7 | 23758.64 | 23825.97 | 58370.0 |
| 2025-08-27 16:00:00 | NQ | Futures | 23825.72 | 23895.32 | 23638.86 | 23747.04 | 42470.0 |
| 2025-08-27 18:00:00 | NQ | Futures | 23747.29 | 23755.36 | 23702.66 | 23723.34 | 6171.0 |
| 2025-08-27 19:00:00 | NQ | Futures | 23723.09 | 23730.4 | 23706.69 | 23713.25 | 2621.0 |
| 2025-08-27 20:00:00 | NQ | Futures | 23712.49 | 23728.63 | 23692.07 | 23725.36 | 5508.0 |
| 2025-08-27 21:00:00 | NQ | Futures | 23725.86 | 23757.89 | 23722.83 | 23752.59 | 3612.0 |
| 2025-08-27 22:00:00 | NQ | Futures | 23753.35 | 23769.74 | 23750.07 | 23760.66 | 3057.0 |
| 2025-08-27 23:00:00 | NQ | Futures | 23759.65 | 23789.66 | 23759.4 | 23780.33 | 3806.0 |
| 2025-08-27 00:00:00 | YM | Futures | 46514.2 | 46519.3 | 46505.0 | 46508.1 | 298.0 |
| 2025-08-27 01:00:00 | YM | Futures | 46505.0 | 46507.1 | 46472.3 | 46480.5 | 303.0 |
| 2025-08-27 02:00:00 | YM | Futures | 46479.5 | 46507.1 | 46469.3 | 46477.4 | 604.0 |
| 2025-08-27 03:00:00 | YM | Futures | 46476.4 | 46510.1 | 46440.7 | 46482.5 | 1376.0 |
> showing 50 of 2,054 rows — these rows as CSV