PREVIEW / futures_1hour / 2025-07-02
file: by_date/futures_1hour/2025/2025-07-02.parquet size: 66 KB rows: 2,058
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-02 00:00:00 | ES | Futures | 6306.19 | 6314.75 | 6305.68 | 6312.48 | 5096.0 |
| 2025-07-02 01:00:00 | ES | Futures | 6312.23 | 6312.23 | 6307.19 | 6311.48 | 3894.0 |
| 2025-07-02 02:00:00 | ES | Futures | 6311.48 | 6317.77 | 6310.47 | 6316.51 | 8135.0 |
| 2025-07-02 03:00:00 | ES | Futures | 6316.51 | 6317.27 | 6302.41 | 6304.17 | 10525.0 |
| 2025-07-02 04:00:00 | ES | Futures | 6304.42 | 6307.19 | 6299.13 | 6301.9 | 10437.0 |
| 2025-07-02 05:00:00 | ES | Futures | 6301.65 | 6304.17 | 6299.89 | 6303.92 | 6472.0 |
| 2025-07-02 06:00:00 | ES | Futures | 6303.92 | 6304.17 | 6298.88 | 6301.9 | 8712.0 |
| 2025-07-02 07:00:00 | ES | Futures | 6301.65 | 6305.43 | 6292.59 | 6296.36 | 15687.0 |
| 2025-07-02 08:00:00 | ES | Futures | 6296.62 | 6300.39 | 6282.26 | 6286.79 | 42451.0 |
| 2025-07-02 09:00:00 | ES | Futures | 6286.79 | 6295.36 | 6284.02 | 6291.83 | 123267.0 |
| 2025-07-02 10:00:00 | ES | Futures | 6292.08 | 6310.97 | 6291.58 | 6306.44 | 182169.0 |
| 2025-07-02 11:00:00 | ES | Futures | 6306.69 | 6313.74 | 6304.42 | 6311.73 | 106545.0 |
| 2025-07-02 12:00:00 | ES | Futures | 6311.73 | 6315.25 | 6307.45 | 6315.0 | 74860.0 |
| 2025-07-02 13:00:00 | ES | Futures | 6315.0 | 6316.26 | 6309.96 | 6312.99 | 68912.0 |
| 2025-07-02 14:00:00 | ES | Futures | 6313.24 | 6318.53 | 6310.97 | 6317.52 | 70197.0 |
| 2025-07-02 15:00:00 | ES | Futures | 6317.52 | 6323.57 | 6315.0 | 6322.31 | 168703.0 |
| 2025-07-02 16:00:00 | ES | Futures | 6322.31 | 6326.59 | 6318.02 | 6324.07 | 55812.0 |
| 2025-07-02 18:00:00 | ES | Futures | 6323.57 | 6325.83 | 6320.04 | 6323.82 | 3065.0 |
| 2025-07-02 19:00:00 | ES | Futures | 6323.82 | 6325.33 | 6323.06 | 6324.57 | 1464.0 |
| 2025-07-02 20:00:00 | ES | Futures | 6324.57 | 6326.84 | 6322.56 | 6324.57 | 3319.0 |
| 2025-07-02 21:00:00 | ES | Futures | 6324.32 | 6326.84 | 6321.8 | 6323.57 | 3504.0 |
| 2025-07-02 22:00:00 | ES | Futures | 6323.57 | 6323.57 | 6317.52 | 6322.05 | 4730.0 |
| 2025-07-02 23:00:00 | ES | Futures | 6322.05 | 6331.12 | 6321.8 | 6326.08 | 5198.0 |
| 2025-07-02 00:00:00 | NQ | Futures | 22937.55 | 22979.67 | 22934.78 | 22970.59 | 3668.0 |
| 2025-07-02 01:00:00 | NQ | Futures | 22970.34 | 22970.84 | 22944.36 | 22967.56 | 3228.0 |
| 2025-07-02 02:00:00 | NQ | Futures | 22967.06 | 22977.14 | 22953.94 | 22970.34 | 3452.0 |
| 2025-07-02 03:00:00 | NQ | Futures | 22970.84 | 22974.88 | 22915.36 | 22921.67 | 6155.0 |
| 2025-07-02 04:00:00 | NQ | Futures | 22922.17 | 22935.28 | 22899.98 | 22907.54 | 5586.0 |
| 2025-07-02 05:00:00 | NQ | Futures | 22907.54 | 22914.1 | 22891.15 | 22910.57 | 3776.0 |
| 2025-07-02 06:00:00 | NQ | Futures | 22911.58 | 22915.61 | 22869.46 | 22885.6 | 5955.0 |
| 2025-07-02 07:00:00 | NQ | Futures | 22884.6 | 22899.47 | 22835.42 | 22859.88 | 7595.0 |
| 2025-07-02 08:00:00 | NQ | Futures | 22859.63 | 22883.33 | 22778.68 | 22813.73 | 21651.0 |
| 2025-07-02 09:00:00 | NQ | Futures | 22813.23 | 22926.2 | 22796.08 | 22905.02 | 52970.0 |
| 2025-07-02 10:00:00 | NQ | Futures | 22904.27 | 23030.61 | 22900.48 | 23009.93 | 74115.0 |
| 2025-07-02 11:00:00 | NQ | Futures | 23010.43 | 23046.49 | 22996.81 | 23020.77 | 43614.0 |
| 2025-07-02 12:00:00 | NQ | Futures | 23020.77 | 23043.97 | 23008.16 | 23039.18 | 32932.0 |
| 2025-07-02 13:00:00 | NQ | Futures | 23039.68 | 23047.25 | 23007.15 | 23024.05 | 30514.0 |
| 2025-07-02 14:00:00 | NQ | Futures | 23024.3 | 23037.16 | 23011.69 | 23027.08 | 25841.0 |
| 2025-07-02 15:00:00 | NQ | Futures | 23027.83 | 23053.05 | 23011.95 | 23043.47 | 48008.0 |
| 2025-07-02 16:00:00 | NQ | Futures | 23043.47 | 23057.84 | 23026.57 | 23051.79 | 13947.0 |
| 2025-07-02 18:00:00 | NQ | Futures | 23043.97 | 23062.38 | 23030.1 | 23044.48 | 2411.0 |
| 2025-07-02 19:00:00 | NQ | Futures | 23045.48 | 23049.02 | 23039.94 | 23047.75 | 1222.0 |
| 2025-07-02 20:00:00 | NQ | Futures | 23047.0 | 23055.82 | 23038.17 | 23050.02 | 2178.0 |
| 2025-07-02 21:00:00 | NQ | Futures | 23049.77 | 23071.21 | 23041.7 | 23049.02 | 2907.0 |
| 2025-07-02 22:00:00 | NQ | Futures | 23049.02 | 23050.28 | 23025.81 | 23046.75 | 2960.0 |
| 2025-07-02 23:00:00 | NQ | Futures | 23045.99 | 23081.29 | 23044.48 | 23061.12 | 3191.0 |
| 2025-07-02 00:00:00 | YM | Futures | 45839.0 | 45893.1 | 45835.9 | 45870.6 | 856.0 |
| 2025-07-02 01:00:00 | YM | Futures | 45866.5 | 45867.6 | 45839.0 | 45858.4 | 347.0 |
| 2025-07-02 02:00:00 | YM | Futures | 45859.4 | 45928.9 | 45855.3 | 45927.8 | 1422.0 |
| 2025-07-02 03:00:00 | YM | Futures | 45927.8 | 45930.9 | 45827.7 | 45844.1 | 1786.0 |
> showing 50 of 2,058 rows — these rows as CSV