PREVIEW / futures_1hour / 2025-06-30
file: by_date/futures_1hour/2025/2025-06-30.parquet size: 66 KB rows: 2,064
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-06-30 00:00:00 | ES | Futures | 6294.6 | 6296.87 | 6294.1 | 6294.35 | 3993.0 |
| 2025-06-30 01:00:00 | ES | Futures | 6294.35 | 6298.63 | 6293.34 | 6297.62 | 4610.0 |
| 2025-06-30 02:00:00 | ES | Futures | 6297.87 | 6301.9 | 6295.86 | 6297.62 | 9966.0 |
| 2025-06-30 03:00:00 | ES | Futures | 6297.62 | 6297.62 | 6290.57 | 6293.34 | 12854.0 |
| 2025-06-30 04:00:00 | ES | Futures | 6293.34 | 6297.87 | 6291.33 | 6293.59 | 10561.0 |
| 2025-06-30 05:00:00 | ES | Futures | 6293.59 | 6300.39 | 6292.08 | 6293.84 | 9054.0 |
| 2025-06-30 06:00:00 | ES | Futures | 6293.84 | 6298.88 | 6293.34 | 6297.12 | 8120.0 |
| 2025-06-30 07:00:00 | ES | Futures | 6297.12 | 6300.39 | 6295.61 | 6296.87 | 13802.0 |
| 2025-06-30 08:00:00 | ES | Futures | 6297.12 | 6297.62 | 6288.81 | 6292.08 | 19938.0 |
| 2025-06-30 09:00:00 | ES | Futures | 6292.08 | 6297.37 | 6281.5 | 6285.28 | 127212.0 |
| 2025-06-30 10:00:00 | ES | Futures | 6285.28 | 6289.56 | 6277.98 | 6281.5 | 138713.0 |
| 2025-06-30 11:00:00 | ES | Futures | 6281.5 | 6290.82 | 6278.48 | 6286.04 | 108269.0 |
| 2025-06-30 12:00:00 | ES | Futures | 6286.04 | 6292.59 | 6282.26 | 6287.8 | 77418.0 |
| 2025-06-30 13:00:00 | ES | Futures | 6287.55 | 6289.56 | 6270.92 | 6279.24 | 102857.0 |
| 2025-06-30 14:00:00 | ES | Futures | 6279.24 | 6290.32 | 6273.69 | 6290.32 | 117512.0 |
| 2025-06-30 15:00:00 | ES | Futures | 6290.32 | 6312.48 | 6289.81 | 6298.38 | 359121.0 |
| 2025-06-30 16:00:00 | ES | Futures | 6298.38 | 6301.4 | 6290.82 | 6292.08 | 78631.0 |
| 2025-06-30 18:00:00 | ES | Futures | 6292.59 | 6296.87 | 6290.07 | 6291.07 | 6452.0 |
| 2025-06-30 19:00:00 | ES | Futures | 6290.82 | 6297.87 | 6289.06 | 6296.87 | 4540.0 |
| 2025-06-30 20:00:00 | ES | Futures | 6297.12 | 6303.42 | 6297.12 | 6302.41 | 8706.0 |
| 2025-06-30 21:00:00 | ES | Futures | 6302.41 | 6304.68 | 6299.39 | 6304.17 | 4799.0 |
| 2025-06-30 22:00:00 | ES | Futures | 6304.17 | 6304.17 | 6295.1 | 6295.61 | 5306.0 |
| 2025-06-30 23:00:00 | ES | Futures | 6295.36 | 6297.37 | 6293.59 | 6294.1 | 4031.0 |
| 2025-06-30 00:00:00 | NQ | Futures | 23072.22 | 23084.57 | 23070.2 | 23073.48 | 2325.0 |
| 2025-06-30 01:00:00 | NQ | Futures | 23073.22 | 23083.06 | 23061.12 | 23075.24 | 2661.0 |
| 2025-06-30 02:00:00 | NQ | Futures | 23075.75 | 23100.96 | 23073.48 | 23081.04 | 5099.0 |
| 2025-06-30 03:00:00 | NQ | Futures | 23081.8 | 23082.05 | 23048.26 | 23067.68 | 6192.0 |
| 2025-06-30 04:00:00 | NQ | Futures | 23068.69 | 23093.15 | 23056.08 | 23072.97 | 5078.0 |
| 2025-06-30 05:00:00 | NQ | Futures | 23073.48 | 23114.58 | 23066.67 | 23080.79 | 5488.0 |
| 2025-06-30 06:00:00 | NQ | Futures | 23080.54 | 23108.28 | 23078.52 | 23089.87 | 3972.0 |
| 2025-06-30 07:00:00 | NQ | Futures | 23089.87 | 23105.25 | 23080.29 | 23093.9 | 5900.0 |
| 2025-06-30 08:00:00 | NQ | Futures | 23093.15 | 23096.68 | 23052.8 | 23066.92 | 8651.0 |
| 2025-06-30 09:00:00 | NQ | Futures | 23067.17 | 23088.86 | 22992.78 | 23025.31 | 55777.0 |
| 2025-06-30 10:00:00 | NQ | Futures | 23025.56 | 23052.8 | 23006.15 | 23020.01 | 52886.0 |
| 2025-06-30 11:00:00 | NQ | Futures | 23020.52 | 23057.59 | 23000.09 | 23042.21 | 39261.0 |
| 2025-06-30 12:00:00 | NQ | Futures | 23042.21 | 23066.67 | 23030.86 | 23041.2 | 30310.0 |
| 2025-06-30 13:00:00 | NQ | Futures | 23041.2 | 23048.51 | 22984.71 | 23019.76 | 33407.0 |
| 2025-06-30 14:00:00 | NQ | Futures | 23019.76 | 23052.29 | 22979.41 | 23048.51 | 40439.0 |
| 2025-06-30 15:00:00 | NQ | Futures | 23048.26 | 23134.5 | 23047.25 | 23084.82 | 79086.0 |
| 2025-06-30 16:00:00 | NQ | Futures | 23085.33 | 23097.18 | 23051.54 | 23065.91 | 16966.0 |
| 2025-06-30 18:00:00 | NQ | Futures | 23066.67 | 23086.09 | 23051.54 | 23056.58 | 3274.0 |
| 2025-06-30 19:00:00 | NQ | Futures | 23056.58 | 23086.59 | 23045.23 | 23080.03 | 2955.0 |
| 2025-06-30 20:00:00 | NQ | Futures | 23081.29 | 23105.25 | 23081.29 | 23099.7 | 4084.0 |
| 2025-06-30 21:00:00 | NQ | Futures | 23100.71 | 23114.33 | 23084.32 | 23110.8 | 4132.0 |
| 2025-06-30 22:00:00 | NQ | Futures | 23109.79 | 23113.32 | 23075.24 | 23078.02 | 3008.0 |
| 2025-06-30 23:00:00 | NQ | Futures | 23078.02 | 23084.32 | 23066.92 | 23071.96 | 2299.0 |
| 2025-06-30 00:00:00 | YM | Futures | 45328.2 | 45343.5 | 45322.0 | 45325.1 | 257.0 |
| 2025-06-30 01:00:00 | YM | Futures | 45324.1 | 45370.1 | 45319.0 | 45363.9 | 555.0 |
| 2025-06-30 02:00:00 | YM | Futures | 45362.9 | 45393.5 | 45345.5 | 45369.0 | 1023.0 |
| 2025-06-30 03:00:00 | YM | Futures | 45370.1 | 45370.1 | 45313.9 | 45323.1 | 1275.0 |
> showing 50 of 2,064 rows — these rows as CSV