PREVIEW / futures_1hour / 2025-08-07
file: by_date/futures_1hour/2025/2025-08-07.parquet size: 66 KB rows: 2,096
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-07 00:00:00 | ES | Futures | 6435.65 | 6437.16 | 6428.6 | 6430.61 | 3180.0 |
| 2025-08-07 01:00:00 | ES | Futures | 6430.61 | 6433.38 | 6428.09 | 6433.13 | 3431.0 |
| 2025-08-07 02:00:00 | ES | Futures | 6432.88 | 6437.67 | 6430.61 | 6431.87 | 5799.0 |
| 2025-08-07 03:00:00 | ES | Futures | 6431.87 | 6443.46 | 6431.37 | 6442.2 | 10694.0 |
| 2025-08-07 04:00:00 | ES | Futures | 6442.2 | 6457.81 | 6441.95 | 6453.78 | 18123.0 |
| 2025-08-07 05:00:00 | ES | Futures | 6454.04 | 6468.65 | 6450.26 | 6466.38 | 15023.0 |
| 2025-08-07 06:00:00 | ES | Futures | 6466.63 | 6474.94 | 6459.33 | 6460.84 | 20276.0 |
| 2025-08-07 07:00:00 | ES | Futures | 6461.09 | 6465.12 | 6454.04 | 6454.54 | 17042.0 |
| 2025-08-07 08:00:00 | ES | Futures | 6454.54 | 6461.59 | 6453.28 | 6455.8 | 22150.0 |
| 2025-08-07 09:00:00 | ES | Futures | 6456.05 | 6462.6 | 6445.22 | 6457.31 | 156517.0 |
| 2025-08-07 10:00:00 | ES | Futures | 6457.31 | 6460.84 | 6415.25 | 6419.03 | 270046.0 |
| 2025-08-07 11:00:00 | ES | Futures | 6418.77 | 6423.31 | 6404.67 | 6409.96 | 166652.0 |
| 2025-08-07 12:00:00 | ES | Futures | 6409.71 | 6417.26 | 6391.57 | 6403.41 | 149722.0 |
| 2025-08-07 13:00:00 | ES | Futures | 6403.41 | 6410.21 | 6387.79 | 6398.62 | 127654.0 |
| 2025-08-07 14:00:00 | ES | Futures | 6398.62 | 6401.65 | 6382.0 | 6396.36 | 118566.0 |
| 2025-08-07 15:00:00 | ES | Futures | 6396.36 | 6416.26 | 6391.07 | 6415.25 | 186230.0 |
| 2025-08-07 16:00:00 | ES | Futures | 6415.25 | 6423.31 | 6413.99 | 6421.55 | 63594.0 |
| 2025-08-07 18:00:00 | ES | Futures | 6420.29 | 6430.61 | 6419.28 | 6427.34 | 7175.0 |
| 2025-08-07 19:00:00 | ES | Futures | 6427.59 | 6428.85 | 6423.56 | 6424.82 | 3381.0 |
| 2025-08-07 20:00:00 | ES | Futures | 6424.57 | 6435.4 | 6421.55 | 6432.38 | 8215.0 |
| 2025-08-07 21:00:00 | ES | Futures | 6432.38 | 6434.14 | 6428.85 | 6431.12 | 4466.0 |
| 2025-08-07 22:00:00 | ES | Futures | 6431.12 | 6435.4 | 6431.12 | 6434.64 | 3181.0 |
| 2025-08-07 23:00:00 | ES | Futures | 6434.39 | 6434.89 | 6429.1 | 6429.61 | 3609.0 |
| 2025-08-07 00:00:00 | NQ | Futures | 23694.34 | 23703.92 | 23661.55 | 23669.12 | 2981.0 |
| 2025-08-07 01:00:00 | NQ | Futures | 23668.62 | 23688.03 | 23658.78 | 23687.53 | 3157.0 |
| 2025-08-07 02:00:00 | NQ | Futures | 23686.77 | 23701.65 | 23671.64 | 23676.43 | 4075.0 |
| 2025-08-07 03:00:00 | NQ | Futures | 23676.43 | 23718.29 | 23675.17 | 23713.75 | 6049.0 |
| 2025-08-07 04:00:00 | NQ | Futures | 23713.5 | 23780.08 | 23712.24 | 23760.91 | 10884.0 |
| 2025-08-07 05:00:00 | NQ | Futures | 23761.16 | 23814.12 | 23742.76 | 23806.81 | 8560.0 |
| 2025-08-07 06:00:00 | NQ | Futures | 23807.56 | 23832.03 | 23802.02 | 23822.95 | 10998.0 |
| 2025-08-07 07:00:00 | NQ | Futures | 23823.45 | 23844.89 | 23785.37 | 23787.39 | 10791.0 |
| 2025-08-07 08:00:00 | NQ | Futures | 23786.63 | 23819.67 | 23781.09 | 23802.52 | 11464.0 |
| 2025-08-07 09:00:00 | NQ | Futures | 23803.28 | 23864.81 | 23775.29 | 23860.52 | 74526.0 |
| 2025-08-07 10:00:00 | NQ | Futures | 23860.02 | 23877.17 | 23720.82 | 23743.26 | 92607.0 |
| 2025-08-07 11:00:00 | NQ | Futures | 23743.26 | 23763.69 | 23681.48 | 23702.15 | 57569.0 |
| 2025-08-07 12:00:00 | NQ | Futures | 23702.15 | 23718.55 | 23593.72 | 23665.84 | 57661.0 |
| 2025-08-07 13:00:00 | NQ | Futures | 23664.58 | 23692.57 | 23584.64 | 23623.22 | 50245.0 |
| 2025-08-07 14:00:00 | NQ | Futures | 23622.72 | 23634.57 | 23532.19 | 23609.86 | 49110.0 |
| 2025-08-07 15:00:00 | NQ | Futures | 23610.36 | 23708.46 | 23583.38 | 23705.69 | 53535.0 |
| 2025-08-07 16:00:00 | NQ | Futures | 23706.19 | 23738.97 | 23703.92 | 23726.62 | 19528.0 |
| 2025-08-07 18:00:00 | NQ | Futures | 23723.09 | 23773.27 | 23720.82 | 23759.4 | 6409.0 |
| 2025-08-07 19:00:00 | NQ | Futures | 23759.65 | 23762.68 | 23742.0 | 23744.27 | 2679.0 |
| 2025-08-07 20:00:00 | NQ | Futures | 23745.53 | 23788.4 | 23733.42 | 23777.3 | 5270.0 |
| 2025-08-07 21:00:00 | NQ | Futures | 23777.3 | 23783.86 | 23759.65 | 23767.72 | 2564.0 |
| 2025-08-07 22:00:00 | NQ | Futures | 23768.73 | 23785.12 | 23767.72 | 23781.09 | 1717.0 |
| 2025-08-07 23:00:00 | NQ | Futures | 23779.32 | 23783.1 | 23756.37 | 23758.89 | 2441.0 |
| 2025-08-07 00:00:00 | YM | Futures | 45309.8 | 45322.0 | 45265.9 | 45280.2 | 398.0 |
| 2025-08-07 01:00:00 | YM | Futures | 45277.1 | 45279.1 | 45256.7 | 45273.0 | 557.0 |
| 2025-08-07 02:00:00 | YM | Futures | 45274.0 | 45322.0 | 45264.8 | 45268.9 | 1475.0 |
| 2025-08-07 03:00:00 | YM | Futures | 45272.0 | 45352.7 | 45268.9 | 45349.6 | 1340.0 |
> showing 50 of 2,096 rows — these rows as CSV