PREVIEW / futures_1hour / 2025-09-02
file: by_date/futures_1hour/2025/2025-09-02.parquet size: 66 KB rows: 2,079
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-09-02 00:00:00 | ES | Futures | 6517.26 | 6519.78 | 6515.75 | 6518.01 | 2326.0 |
| 2025-09-02 01:00:00 | ES | Futures | 6518.01 | 6518.26 | 6511.46 | 6512.47 | 3734.0 |
| 2025-09-02 02:00:00 | ES | Futures | 6512.72 | 6520.28 | 6511.72 | 6520.03 | 4814.0 |
| 2025-09-02 03:00:00 | ES | Futures | 6520.03 | 6521.04 | 6475.95 | 6478.47 | 31913.0 |
| 2025-09-02 04:00:00 | ES | Futures | 6478.47 | 6494.34 | 6476.45 | 6490.05 | 20189.0 |
| 2025-09-02 05:00:00 | ES | Futures | 6490.05 | 6492.83 | 6485.77 | 6486.28 | 9235.0 |
| 2025-09-02 06:00:00 | ES | Futures | 6486.28 | 6489.3 | 6469.15 | 6474.69 | 17649.0 |
| 2025-09-02 07:00:00 | ES | Futures | 6474.94 | 6476.2 | 6468.9 | 6470.41 | 19555.0 |
| 2025-09-02 08:00:00 | ES | Futures | 6470.41 | 6470.41 | 6435.15 | 6443.96 | 78217.0 |
| 2025-09-02 09:00:00 | ES | Futures | 6443.96 | 6464.62 | 6431.12 | 6462.1 | 234874.0 |
| 2025-09-02 10:00:00 | ES | Futures | 6462.1 | 6473.18 | 6442.95 | 6447.24 | 239541.0 |
| 2025-09-02 11:00:00 | ES | Futures | 6447.49 | 6450.51 | 6419.53 | 6422.3 | 187546.0 |
| 2025-09-02 12:00:00 | ES | Futures | 6422.55 | 6440.44 | 6420.29 | 6440.18 | 131865.0 |
| 2025-09-02 13:00:00 | ES | Futures | 6440.18 | 6461.84 | 6435.9 | 6454.79 | 149981.0 |
| 2025-09-02 14:00:00 | ES | Futures | 6454.79 | 6460.59 | 6443.96 | 6451.77 | 114120.0 |
| 2025-09-02 15:00:00 | ES | Futures | 6451.77 | 6475.95 | 6451.52 | 6474.19 | 243590.0 |
| 2025-09-02 16:00:00 | ES | Futures | 6474.19 | 6495.85 | 6472.42 | 6495.6 | 96415.0 |
| 2025-09-02 18:00:00 | ES | Futures | 6496.35 | 6496.35 | 6484.01 | 6485.27 | 10240.0 |
| 2025-09-02 19:00:00 | ES | Futures | 6485.27 | 6486.28 | 6481.74 | 6483.25 | 5935.0 |
| 2025-09-02 20:00:00 | ES | Futures | 6483.0 | 6483.76 | 6480.23 | 6483.0 | 6948.0 |
| 2025-09-02 21:00:00 | ES | Futures | 6482.5 | 6483.0 | 6477.71 | 6481.74 | 5332.0 |
| 2025-09-02 22:00:00 | ES | Futures | 6481.49 | 6482.5 | 6476.96 | 6478.72 | 3984.0 |
| 2025-09-02 23:00:00 | ES | Futures | 6478.72 | 6481.24 | 6474.44 | 6478.22 | 5322.0 |
| 2025-09-02 00:00:00 | NQ | Futures | 23641.88 | 23655.25 | 23631.8 | 23641.63 | 1995.0 |
| 2025-09-02 01:00:00 | NQ | Futures | 23642.39 | 23643.15 | 23608.6 | 23616.92 | 4091.0 |
| 2025-09-02 02:00:00 | NQ | Futures | 23616.67 | 23652.22 | 23611.12 | 23651.97 | 3596.0 |
| 2025-09-02 03:00:00 | NQ | Futures | 23652.22 | 23656.26 | 23472.67 | 23481.0 | 16758.0 |
| 2025-09-02 04:00:00 | NQ | Futures | 23481.25 | 23536.73 | 23470.4 | 23513.78 | 11419.0 |
| 2025-09-02 05:00:00 | NQ | Futures | 23513.78 | 23534.71 | 23494.11 | 23494.86 | 4908.0 |
| 2025-09-02 06:00:00 | NQ | Futures | 23494.86 | 23514.03 | 23434.09 | 23455.27 | 10236.0 |
| 2025-09-02 07:00:00 | NQ | Futures | 23457.04 | 23462.84 | 23420.98 | 23427.03 | 10586.0 |
| 2025-09-02 08:00:00 | NQ | Futures | 23426.52 | 23426.52 | 23261.1 | 23296.65 | 36091.0 |
| 2025-09-02 09:00:00 | NQ | Futures | 23297.41 | 23463.34 | 23225.79 | 23436.11 | 106158.0 |
| 2025-09-02 10:00:00 | NQ | Futures | 23432.32 | 23482.76 | 23337.0 | 23363.23 | 97158.0 |
| 2025-09-02 11:00:00 | NQ | Futures | 23363.98 | 23381.39 | 23227.56 | 23248.74 | 70466.0 |
| 2025-09-02 12:00:00 | NQ | Futures | 23248.24 | 23332.46 | 23238.4 | 23327.67 | 48905.0 |
| 2025-09-02 13:00:00 | NQ | Futures | 23327.92 | 23427.79 | 23305.73 | 23391.22 | 54460.0 |
| 2025-09-02 14:00:00 | NQ | Futures | 23390.97 | 23435.1 | 23359.19 | 23390.97 | 43910.0 |
| 2025-09-02 15:00:00 | NQ | Futures | 23390.97 | 23493.1 | 23390.46 | 23479.48 | 63614.0 |
| 2025-09-02 16:00:00 | NQ | Futures | 23479.73 | 23589.68 | 23472.42 | 23583.13 | 39281.0 |
| 2025-09-02 18:00:00 | NQ | Futures | 23585.65 | 23591.45 | 23538.49 | 23544.8 | 6576.0 |
| 2025-09-02 19:00:00 | NQ | Futures | 23544.8 | 23548.83 | 23529.92 | 23537.23 | 3477.0 |
| 2025-09-02 20:00:00 | NQ | Futures | 23536.98 | 23544.04 | 23519.83 | 23534.71 | 6576.0 |
| 2025-09-02 21:00:00 | NQ | Futures | 23534.2 | 23543.54 | 23514.28 | 23540.26 | 3851.0 |
| 2025-09-02 22:00:00 | NQ | Futures | 23539.25 | 23542.27 | 23515.54 | 23524.87 | 2522.0 |
| 2025-09-02 23:00:00 | NQ | Futures | 23524.87 | 23536.22 | 23501.17 | 23527.14 | 5420.0 |
| 2025-09-02 00:00:00 | YM | Futures | 46575.5 | 46589.8 | 46563.2 | 46584.7 | 283.0 |
| 2025-09-02 01:00:00 | YM | Futures | 46583.7 | 46584.7 | 46532.6 | 46534.6 | 498.0 |
| 2025-09-02 02:00:00 | YM | Futures | 46531.6 | 46575.5 | 46527.5 | 46562.2 | 569.0 |
| 2025-09-02 03:00:00 | YM | Futures | 46565.3 | 46565.3 | 46272.1 | 46290.5 | 3733.0 |
> showing 50 of 2,079 rows — these rows as CSV