PREVIEW / futures_1hour / 2025-07-23
file: by_date/futures_1hour/2025/2025-07-23.parquet size: 66 KB rows: 2,076
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-07-23 00:00:00 | ES | Futures | 6406.68 | 6410.46 | 6405.17 | 6409.96 | 3472.0 |
| 2025-07-23 01:00:00 | ES | Futures | 6409.96 | 6412.48 | 6409.2 | 6410.46 | 4541.0 |
| 2025-07-23 02:00:00 | ES | Futures | 6410.46 | 6413.23 | 6407.69 | 6412.73 | 5850.0 |
| 2025-07-23 03:00:00 | ES | Futures | 6412.73 | 6415.25 | 6408.2 | 6409.2 | 12340.0 |
| 2025-07-23 04:00:00 | ES | Futures | 6409.2 | 6419.53 | 6408.7 | 6419.03 | 13471.0 |
| 2025-07-23 05:00:00 | ES | Futures | 6419.03 | 6421.04 | 6415.75 | 6419.53 | 8969.0 |
| 2025-07-23 06:00:00 | ES | Futures | 6419.78 | 6422.05 | 6417.52 | 6418.02 | 8547.0 |
| 2025-07-23 07:00:00 | ES | Futures | 6417.77 | 6418.77 | 6410.71 | 6417.77 | 15489.0 |
| 2025-07-23 08:00:00 | ES | Futures | 6417.52 | 6420.29 | 6413.99 | 6417.26 | 15918.0 |
| 2025-07-23 09:00:00 | ES | Futures | 6417.26 | 6424.57 | 6401.65 | 6403.91 | 140943.0 |
| 2025-07-23 10:00:00 | ES | Futures | 6403.91 | 6412.23 | 6401.14 | 6411.22 | 123464.0 |
| 2025-07-23 11:00:00 | ES | Futures | 6410.97 | 6432.88 | 6407.19 | 6425.58 | 168983.0 |
| 2025-07-23 12:00:00 | ES | Futures | 6425.32 | 6431.12 | 6417.77 | 6423.31 | 125020.0 |
| 2025-07-23 13:00:00 | ES | Futures | 6423.31 | 6433.64 | 6419.53 | 6429.86 | 106918.0 |
| 2025-07-23 14:00:00 | ES | Futures | 6430.11 | 6441.69 | 6430.11 | 6437.41 | 97798.0 |
| 2025-07-23 15:00:00 | ES | Futures | 6437.67 | 6447.24 | 6434.39 | 6446.98 | 185529.0 |
| 2025-07-23 16:00:00 | ES | Futures | 6447.24 | 6455.3 | 6440.18 | 6453.78 | 68421.0 |
| 2025-07-23 18:00:00 | ES | Futures | 6452.02 | 6452.78 | 6448.5 | 6449.25 | 6219.0 |
| 2025-07-23 19:00:00 | ES | Futures | 6449.25 | 6453.03 | 6448.5 | 6452.02 | 2713.0 |
| 2025-07-23 20:00:00 | ES | Futures | 6451.77 | 6452.53 | 6448.5 | 6450.01 | 4252.0 |
| 2025-07-23 21:00:00 | ES | Futures | 6450.01 | 6454.79 | 6449.5 | 6453.03 | 4485.0 |
| 2025-07-23 22:00:00 | ES | Futures | 6453.03 | 6454.79 | 6452.27 | 6453.03 | 2915.0 |
| 2025-07-23 23:00:00 | ES | Futures | 6453.03 | 6453.03 | 6447.74 | 6448.5 | 3429.0 |
| 2025-07-23 00:00:00 | NQ | Futures | 23440.65 | 23454.01 | 23434.34 | 23450.99 | 1746.0 |
| 2025-07-23 01:00:00 | NQ | Futures | 23450.99 | 23462.08 | 23447.2 | 23453.0 | 2329.0 |
| 2025-07-23 02:00:00 | NQ | Futures | 23453.51 | 23473.93 | 23445.44 | 23470.66 | 3551.0 |
| 2025-07-23 03:00:00 | NQ | Futures | 23470.15 | 23479.99 | 23446.95 | 23463.34 | 6601.0 |
| 2025-07-23 04:00:00 | NQ | Futures | 23462.08 | 23484.53 | 23459.56 | 23482.0 | 5779.0 |
| 2025-07-23 05:00:00 | NQ | Futures | 23482.0 | 23486.54 | 23461.33 | 23473.93 | 3143.0 |
| 2025-07-23 06:00:00 | NQ | Futures | 23475.45 | 23484.27 | 23462.59 | 23463.85 | 3698.0 |
| 2025-07-23 07:00:00 | NQ | Futures | 23463.59 | 23466.62 | 23435.1 | 23460.06 | 7615.0 |
| 2025-07-23 08:00:00 | NQ | Futures | 23459.06 | 23471.41 | 23432.58 | 23439.13 | 9195.0 |
| 2025-07-23 09:00:00 | NQ | Futures | 23438.88 | 23477.46 | 23362.22 | 23367.77 | 73831.0 |
| 2025-07-23 10:00:00 | NQ | Futures | 23367.26 | 23405.59 | 23348.35 | 23401.56 | 65686.0 |
| 2025-07-23 11:00:00 | NQ | Futures | 23401.56 | 23496.38 | 23380.88 | 23460.32 | 63808.0 |
| 2025-07-23 12:00:00 | NQ | Futures | 23459.56 | 23465.36 | 23394.75 | 23430.81 | 54894.0 |
| 2025-07-23 13:00:00 | NQ | Futures | 23430.56 | 23472.42 | 23415.93 | 23465.86 | 42645.0 |
| 2025-07-23 14:00:00 | NQ | Futures | 23466.37 | 23526.89 | 23465.86 | 23504.45 | 47297.0 |
| 2025-07-23 15:00:00 | NQ | Futures | 23505.2 | 23527.9 | 23471.66 | 23527.65 | 50995.0 |
| 2025-07-23 16:00:00 | NQ | Futures | 23527.65 | 23621.96 | 23506.21 | 23615.15 | 31812.0 |
| 2025-07-23 18:00:00 | NQ | Futures | 23606.08 | 23608.09 | 23586.66 | 23591.2 | 3776.0 |
| 2025-07-23 19:00:00 | NQ | Futures | 23592.46 | 23608.85 | 23589.43 | 23604.81 | 2769.0 |
| 2025-07-23 20:00:00 | NQ | Futures | 23604.06 | 23610.87 | 23585.65 | 23598.26 | 3282.0 |
| 2025-07-23 21:00:00 | NQ | Futures | 23597.75 | 23626.75 | 23593.47 | 23611.88 | 3755.0 |
| 2025-07-23 22:00:00 | NQ | Futures | 23612.13 | 23618.94 | 23604.56 | 23608.6 | 1992.0 |
| 2025-07-23 23:00:00 | NQ | Futures | 23608.34 | 23609.61 | 23577.58 | 23582.62 | 2783.0 |
| 2025-07-23 00:00:00 | YM | Futures | 45788.9 | 45816.5 | 45773.6 | 45814.4 | 293.0 |
| 2025-07-23 01:00:00 | YM | Futures | 45815.5 | 45831.8 | 45806.3 | 45815.5 | 510.0 |
| 2025-07-23 02:00:00 | YM | Futures | 45816.5 | 45821.6 | 45776.6 | 45809.3 | 1057.0 |
| 2025-07-23 03:00:00 | YM | Futures | 45809.3 | 45839.0 | 45773.6 | 45795.0 | 2242.0 |
> showing 50 of 2,076 rows — these rows as CSV