PREVIEW / futures_1hour / 2025-08-25
file: by_date/futures_1hour/2025/2025-08-25.parquet size: 62 KB rows: 1,971
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-25 00:00:00 | ES | Futures | 6526.07 | 6528.59 | 6525.32 | 6527.84 | 2975.0 |
| 2025-08-25 01:00:00 | ES | Futures | 6527.84 | 6530.61 | 6526.83 | 6530.35 | 3890.0 |
| 2025-08-25 02:00:00 | ES | Futures | 6530.35 | 6531.11 | 6521.79 | 6522.55 | 8208.0 |
| 2025-08-25 03:00:00 | ES | Futures | 6522.8 | 6524.56 | 6520.28 | 6522.55 | 10644.0 |
| 2025-08-25 04:00:00 | ES | Futures | 6522.55 | 6524.31 | 6519.27 | 6519.52 | 7847.0 |
| 2025-08-25 05:00:00 | ES | Futures | 6519.78 | 6520.03 | 6515.49 | 6518.52 | 7693.0 |
| 2025-08-25 06:00:00 | ES | Futures | 6518.52 | 6518.52 | 6510.96 | 6512.22 | 8401.0 |
| 2025-08-25 07:00:00 | ES | Futures | 6512.22 | 6518.01 | 6511.21 | 6516.75 | 7481.0 |
| 2025-08-25 08:00:00 | ES | Futures | 6516.5 | 6516.5 | 6509.2 | 6512.72 | 16750.0 |
| 2025-08-25 09:00:00 | ES | Futures | 6512.98 | 6522.04 | 6512.22 | 6521.79 | 129401.0 |
| 2025-08-25 10:00:00 | ES | Futures | 6521.54 | 6525.32 | 6515.24 | 6522.55 | 138486.0 |
| 2025-08-25 11:00:00 | ES | Futures | 6522.29 | 6528.84 | 6520.28 | 6527.84 | 93315.0 |
| 2025-08-25 12:00:00 | ES | Futures | 6527.84 | 6531.36 | 6526.07 | 6528.34 | 56131.0 |
| 2025-08-25 13:00:00 | ES | Futures | 6528.09 | 6528.59 | 6518.26 | 6523.3 | 78828.0 |
| 2025-08-25 14:00:00 | ES | Futures | 6523.05 | 6523.81 | 6517.01 | 6517.26 | 66001.0 |
| 2025-08-25 15:00:00 | ES | Futures | 6517.51 | 6519.52 | 6501.64 | 6503.15 | 177265.0 |
| 2025-08-25 16:00:00 | ES | Futures | 6503.15 | 6509.7 | 6501.39 | 6507.94 | 49680.0 |
| 2025-08-25 18:00:00 | ES | Futures | 6508.69 | 6512.22 | 6506.93 | 6510.46 | 4172.0 |
| 2025-08-25 19:00:00 | ES | Futures | 6510.46 | 6511.46 | 6506.17 | 6508.44 | 3766.0 |
| 2025-08-25 20:00:00 | ES | Futures | 6508.19 | 6511.72 | 6478.97 | 6489.55 | 39835.0 |
| 2025-08-25 21:00:00 | ES | Futures | 6489.8 | 6498.11 | 6486.02 | 6490.05 | 11329.0 |
| 2025-08-25 22:00:00 | ES | Futures | 6490.31 | 6501.39 | 6490.05 | 6494.59 | 6412.0 |
| 2025-08-25 23:00:00 | ES | Futures | 6494.84 | 6496.6 | 6492.83 | 6495.09 | 3387.0 |
| 2025-08-25 00:00:00 | NQ | Futures | 23752.59 | 23764.69 | 23748.56 | 23759.9 | 1933.0 |
| 2025-08-25 01:00:00 | NQ | Futures | 23759.9 | 23773.27 | 23755.62 | 23770.75 | 2388.0 |
| 2025-08-25 02:00:00 | NQ | Futures | 23770.75 | 23773.77 | 23723.59 | 23727.12 | 3754.0 |
| 2025-08-25 03:00:00 | NQ | Futures | 23727.12 | 23741.49 | 23712.49 | 23731.16 | 4906.0 |
| 2025-08-25 04:00:00 | NQ | Futures | 23731.16 | 23742.76 | 23711.74 | 23714.26 | 5072.0 |
| 2025-08-25 05:00:00 | NQ | Futures | 23714.01 | 23718.55 | 23690.3 | 23708.71 | 5679.0 |
| 2025-08-25 06:00:00 | NQ | Futures | 23708.71 | 23709.22 | 23666.35 | 23684.75 | 7921.0 |
| 2025-08-25 07:00:00 | NQ | Futures | 23685.26 | 23705.69 | 23674.42 | 23702.15 | 4697.0 |
| 2025-08-25 08:00:00 | NQ | Futures | 23702.15 | 23702.66 | 23667.1 | 23683.75 | 10089.0 |
| 2025-08-25 09:00:00 | NQ | Futures | 23683.75 | 23724.35 | 23647.43 | 23724.09 | 66041.0 |
| 2025-08-25 10:00:00 | NQ | Futures | 23723.84 | 23779.57 | 23709.72 | 23776.29 | 67761.0 |
| 2025-08-25 11:00:00 | NQ | Futures | 23776.04 | 23821.94 | 23769.49 | 23806.81 | 44494.0 |
| 2025-08-25 12:00:00 | NQ | Futures | 23806.3 | 23819.42 | 23794.2 | 23801.76 | 24945.0 |
| 2025-08-25 13:00:00 | NQ | Futures | 23801.76 | 23803.53 | 23762.43 | 23783.36 | 28632.0 |
| 2025-08-25 14:00:00 | NQ | Futures | 23783.86 | 23789.16 | 23754.36 | 23757.63 | 26996.0 |
| 2025-08-25 15:00:00 | NQ | Futures | 23757.38 | 23778.82 | 23693.58 | 23700.14 | 49821.0 |
| 2025-08-25 16:00:00 | NQ | Futures | 23699.89 | 23723.34 | 23690.3 | 23706.95 | 14418.0 |
| 2025-08-25 18:00:00 | NQ | Futures | 23710.48 | 23725.1 | 23703.67 | 23716.53 | 2535.0 |
| 2025-08-25 19:00:00 | NQ | Futures | 23717.03 | 23721.07 | 23692.82 | 23701.15 | 3172.0 |
| 2025-08-25 20:00:00 | NQ | Futures | 23700.64 | 23714.51 | 23575.06 | 23620.95 | 21612.0 |
| 2025-08-25 21:00:00 | NQ | Futures | 23621.46 | 23660.55 | 23613.89 | 23629.28 | 7836.0 |
| 2025-08-25 22:00:00 | NQ | Futures | 23629.28 | 23679.96 | 23627.01 | 23652.98 | 4867.0 |
| 2025-08-25 23:00:00 | NQ | Futures | 23653.48 | 23661.81 | 23644.41 | 23655.25 | 2298.0 |
| 2025-08-25 00:00:00 | YM | Futures | 46648.0 | 46666.4 | 46638.8 | 46662.3 | 395.0 |
| 2025-08-25 01:00:00 | YM | Futures | 46661.3 | 46693.0 | 46653.1 | 46693.0 | 679.0 |
| 2025-08-25 02:00:00 | YM | Futures | 46694.0 | 46698.1 | 46635.8 | 46654.2 | 1184.0 |
| 2025-08-25 03:00:00 | YM | Futures | 46655.2 | 46659.3 | 46625.6 | 46638.8 | 957.0 |
> showing 50 of 1,971 rows — these rows as CSV