PREVIEW / futures_1hour / 2025-07-17
file: by_date/futures_1hour/2025/2025-07-17.parquet size: 65 KB rows: 2,029
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-17 00:00:00 | ES | Futures | 6339.94 | 6340.95 | 6337.92 | 6340.19 | 2036.0 |
| 2025-07-17 01:00:00 | ES | Futures | 6340.44 | 6351.27 | 6340.19 | 6348.25 | 7045.0 |
| 2025-07-17 02:00:00 | ES | Futures | 6348.25 | 6358.83 | 6348.25 | 6355.55 | 8620.0 |
| 2025-07-17 03:00:00 | ES | Futures | 6355.81 | 6356.81 | 6349.51 | 6351.52 | 9040.0 |
| 2025-07-17 04:00:00 | ES | Futures | 6351.27 | 6355.05 | 6349.01 | 6353.29 | 7826.0 |
| 2025-07-17 05:00:00 | ES | Futures | 6353.29 | 6358.32 | 6353.29 | 6354.29 | 5416.0 |
| 2025-07-17 06:00:00 | ES | Futures | 6354.29 | 6355.81 | 6349.51 | 6350.26 | 6299.0 |
| 2025-07-17 07:00:00 | ES | Futures | 6350.26 | 6351.02 | 6344.22 | 6346.23 | 11477.0 |
| 2025-07-17 08:00:00 | ES | Futures | 6346.23 | 6362.35 | 6344.72 | 6361.6 | 30410.0 |
| 2025-07-17 09:00:00 | ES | Futures | 6361.35 | 6370.16 | 6349.26 | 6366.13 | 133743.0 |
| 2025-07-17 10:00:00 | ES | Futures | 6365.88 | 6370.67 | 6356.06 | 6366.38 | 149414.0 |
| 2025-07-17 11:00:00 | ES | Futures | 6366.38 | 6381.25 | 6365.88 | 6380.74 | 104444.0 |
| 2025-07-17 12:00:00 | ES | Futures | 6380.74 | 6384.02 | 6373.44 | 6376.96 | 81371.0 |
| 2025-07-17 13:00:00 | ES | Futures | 6376.96 | 6383.26 | 6374.95 | 6383.01 | 63913.0 |
| 2025-07-17 14:00:00 | ES | Futures | 6383.01 | 6390.31 | 6379.73 | 6388.3 | 73348.0 |
| 2025-07-17 15:00:00 | ES | Futures | 6388.55 | 6393.08 | 6385.02 | 6389.81 | 218065.0 |
| 2025-07-17 16:00:00 | ES | Futures | 6389.81 | 6392.83 | 6386.03 | 6389.81 | 44392.0 |
| 2025-07-17 18:00:00 | ES | Futures | 6390.06 | 6391.32 | 6386.03 | 6389.81 | 3897.0 |
| 2025-07-17 19:00:00 | ES | Futures | 6390.06 | 6398.37 | 6389.56 | 6396.86 | 5459.0 |
| 2025-07-17 20:00:00 | ES | Futures | 6396.86 | 6398.12 | 6393.84 | 6394.59 | 4449.0 |
| 2025-07-17 21:00:00 | ES | Futures | 6394.59 | 6396.11 | 6393.08 | 6394.09 | 3333.0 |
| 2025-07-17 22:00:00 | ES | Futures | 6393.84 | 6399.38 | 6392.33 | 6397.87 | 3304.0 |
| 2025-07-17 23:00:00 | ES | Futures | 6397.87 | 6400.39 | 6396.61 | 6397.62 | 4041.0 |
| 2025-07-17 00:00:00 | NQ | Futures | 23239.66 | 23243.95 | 23227.56 | 23241.93 | 1786.0 |
| 2025-07-17 01:00:00 | NQ | Futures | 23241.68 | 23301.19 | 23239.91 | 23288.33 | 5924.0 |
| 2025-07-17 02:00:00 | NQ | Futures | 23288.84 | 23353.39 | 23287.83 | 23339.52 | 8712.0 |
| 2025-07-17 03:00:00 | NQ | Futures | 23339.52 | 23342.8 | 23301.44 | 23314.31 | 7622.0 |
| 2025-07-17 04:00:00 | NQ | Futures | 23314.31 | 23320.61 | 23289.59 | 23305.23 | 6364.0 |
| 2025-07-17 05:00:00 | NQ | Futures | 23305.73 | 23327.17 | 23304.47 | 23310.78 | 3417.0 |
| 2025-07-17 06:00:00 | NQ | Futures | 23310.27 | 23316.58 | 23288.58 | 23292.11 | 3584.0 |
| 2025-07-17 07:00:00 | NQ | Futures | 23291.36 | 23296.91 | 23272.95 | 23288.58 | 6101.0 |
| 2025-07-17 08:00:00 | NQ | Futures | 23287.83 | 23349.11 | 23274.21 | 23348.1 | 13421.0 |
| 2025-07-17 09:00:00 | NQ | Futures | 23347.34 | 23360.2 | 23266.64 | 23351.63 | 65899.0 |
| 2025-07-17 10:00:00 | NQ | Futures | 23352.13 | 23400.8 | 23316.32 | 23396.52 | 70081.0 |
| 2025-07-17 11:00:00 | NQ | Futures | 23396.52 | 23458.05 | 23395.76 | 23451.99 | 54547.0 |
| 2025-07-17 12:00:00 | NQ | Futures | 23451.49 | 23478.73 | 23447.2 | 23459.31 | 37866.0 |
| 2025-07-17 13:00:00 | NQ | Futures | 23459.81 | 23478.73 | 23442.92 | 23477.97 | 27020.0 |
| 2025-07-17 14:00:00 | NQ | Futures | 23478.47 | 23482.51 | 23438.88 | 23455.02 | 33179.0 |
| 2025-07-17 15:00:00 | NQ | Futures | 23455.53 | 23480.74 | 23447.71 | 23460.32 | 55231.0 |
| 2025-07-17 16:00:00 | NQ | Futures | 23460.82 | 23478.22 | 23436.61 | 23468.13 | 19047.0 |
| 2025-07-17 18:00:00 | NQ | Futures | 23463.85 | 23465.36 | 23447.71 | 23459.06 | 2565.0 |
| 2025-07-17 19:00:00 | NQ | Futures | 23460.32 | 23491.59 | 23458.8 | 23483.52 | 4429.0 |
| 2025-07-17 20:00:00 | NQ | Futures | 23483.26 | 23487.55 | 23466.87 | 23470.4 | 2895.0 |
| 2025-07-17 21:00:00 | NQ | Futures | 23469.65 | 23475.2 | 23461.33 | 23469.14 | 2267.0 |
| 2025-07-17 22:00:00 | NQ | Futures | 23469.4 | 23490.07 | 23462.33 | 23482.26 | 2243.0 |
| 2025-07-17 23:00:00 | NQ | Futures | 23482.26 | 23488.56 | 23476.46 | 23478.22 | 2045.0 |
| 2025-07-17 00:00:00 | YM | Futures | 45342.5 | 45353.7 | 45334.3 | 45349.6 | 201.0 |
| 2025-07-17 01:00:00 | YM | Futures | 45347.6 | 45398.7 | 45347.6 | 45382.3 | 803.0 |
| 2025-07-17 02:00:00 | YM | Futures | 45383.3 | 45433.4 | 45381.3 | 45381.3 | 1269.0 |
| 2025-07-17 03:00:00 | YM | Futures | 45384.4 | 45419.1 | 45367.0 | 45367.0 | 1138.0 |
> showing 50 of 2,029 rows — these rows as CSV