PREVIEW / futures_1hour / 2025-08-18
file: by_date/futures_1hour/2025/2025-08-18.parquet size: 65 KB rows: 2,067
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-08-18 00:00:00 | ES | Futures | 6528.84 | 6529.6 | 6526.58 | 6527.08 | 2450.0 |
| 2025-08-18 01:00:00 | ES | Futures | 6526.83 | 6528.59 | 6525.57 | 6527.08 | 2947.0 |
| 2025-08-18 02:00:00 | ES | Futures | 6526.83 | 6528.34 | 6509.7 | 6514.74 | 9662.0 |
| 2025-08-18 03:00:00 | ES | Futures | 6514.99 | 6517.26 | 6507.43 | 6513.73 | 10455.0 |
| 2025-08-18 04:00:00 | ES | Futures | 6513.98 | 6516.25 | 6505.17 | 6512.72 | 11802.0 |
| 2025-08-18 05:00:00 | ES | Futures | 6512.98 | 6513.23 | 6504.41 | 6507.94 | 8058.0 |
| 2025-08-18 06:00:00 | ES | Futures | 6508.19 | 6514.99 | 6507.69 | 6513.73 | 6660.0 |
| 2025-08-18 07:00:00 | ES | Futures | 6513.73 | 6514.74 | 6509.7 | 6512.98 | 7688.0 |
| 2025-08-18 08:00:00 | ES | Futures | 6512.98 | 6515.75 | 6509.45 | 6514.99 | 12068.0 |
| 2025-08-18 09:00:00 | ES | Futures | 6514.99 | 6522.55 | 6509.45 | 6511.21 | 109233.0 |
| 2025-08-18 10:00:00 | ES | Futures | 6511.21 | 6523.81 | 6506.93 | 6516.75 | 144232.0 |
| 2025-08-18 11:00:00 | ES | Futures | 6516.5 | 6519.02 | 6509.2 | 6511.72 | 78963.0 |
| 2025-08-18 12:00:00 | ES | Futures | 6511.46 | 6518.26 | 6505.67 | 6509.2 | 77633.0 |
| 2025-08-18 13:00:00 | ES | Futures | 6509.2 | 6522.8 | 6508.95 | 6511.97 | 82111.0 |
| 2025-08-18 14:00:00 | ES | Futures | 6512.22 | 6520.28 | 6508.44 | 6519.02 | 70232.0 |
| 2025-08-18 15:00:00 | ES | Futures | 6518.77 | 6523.3 | 6514.99 | 6517.26 | 137545.0 |
| 2025-08-18 16:00:00 | ES | Futures | 6517.51 | 6519.27 | 6514.49 | 6515.49 | 31977.0 |
| 2025-08-18 18:00:00 | ES | Futures | 6517.01 | 6526.07 | 6516.25 | 6523.05 | 5050.0 |
| 2025-08-18 19:00:00 | ES | Futures | 6522.8 | 6523.81 | 6518.77 | 6520.03 | 2302.0 |
| 2025-08-18 20:00:00 | ES | Futures | 6520.03 | 6520.28 | 6510.46 | 6514.23 | 6455.0 |
| 2025-08-18 21:00:00 | ES | Futures | 6514.49 | 6517.51 | 6512.22 | 6512.47 | 3966.0 |
| 2025-08-18 22:00:00 | ES | Futures | 6512.22 | 6514.74 | 6508.69 | 6509.2 | 3889.0 |
| 2025-08-18 23:00:00 | ES | Futures | 6509.2 | 6514.49 | 6507.69 | 6508.44 | 4071.0 |
| 2025-08-18 00:00:00 | NQ | Futures | 24065.04 | 24067.81 | 24052.93 | 24056.46 | 2302.0 |
| 2025-08-18 01:00:00 | NQ | Futures | 24056.97 | 24066.3 | 24049.4 | 24059.74 | 2106.0 |
| 2025-08-18 02:00:00 | NQ | Futures | 24059.74 | 24062.52 | 23978.29 | 24009.81 | 7141.0 |
| 2025-08-18 03:00:00 | NQ | Futures | 24010.32 | 24023.68 | 23987.62 | 24013.59 | 6542.0 |
| 2025-08-18 04:00:00 | NQ | Futures | 24012.84 | 24019.14 | 23950.3 | 23985.6 | 8115.0 |
| 2025-08-18 05:00:00 | NQ | Futures | 23986.11 | 23988.12 | 23946.26 | 23966.44 | 4157.0 |
| 2025-08-18 06:00:00 | NQ | Futures | 23965.68 | 23999.22 | 23963.66 | 23995.18 | 3558.0 |
| 2025-08-18 07:00:00 | NQ | Futures | 23995.44 | 23998.21 | 23953.58 | 23977.78 | 5784.0 |
| 2025-08-18 08:00:00 | NQ | Futures | 23977.28 | 23984.09 | 23953.07 | 23982.58 | 6910.0 |
| 2025-08-18 09:00:00 | NQ | Futures | 23982.07 | 24024.69 | 23941.72 | 23955.85 | 61967.0 |
| 2025-08-18 10:00:00 | NQ | Futures | 23955.85 | 24031.75 | 23925.58 | 23985.1 | 74385.0 |
| 2025-08-18 11:00:00 | NQ | Futures | 23984.59 | 23991.4 | 23935.42 | 23954.58 | 40471.0 |
| 2025-08-18 12:00:00 | NQ | Futures | 23954.08 | 23987.62 | 23929.11 | 23941.72 | 37594.0 |
| 2025-08-18 13:00:00 | NQ | Futures | 23941.98 | 24007.29 | 23939.71 | 23966.94 | 36485.0 |
| 2025-08-18 14:00:00 | NQ | Futures | 23968.2 | 24009.31 | 23955.09 | 24002.75 | 30008.0 |
| 2025-08-18 15:00:00 | NQ | Futures | 24002.75 | 24023.68 | 23991.65 | 24004.26 | 41491.0 |
| 2025-08-18 16:00:00 | NQ | Futures | 24004.26 | 24013.59 | 23990.9 | 23995.18 | 11038.0 |
| 2025-08-18 18:00:00 | NQ | Futures | 24008.05 | 24045.62 | 23999.47 | 24027.72 | 4014.0 |
| 2025-08-18 19:00:00 | NQ | Futures | 24027.72 | 24032.0 | 24009.31 | 24012.08 | 1908.0 |
| 2025-08-18 20:00:00 | NQ | Futures | 24012.84 | 24012.84 | 23967.95 | 23987.87 | 4565.0 |
| 2025-08-18 21:00:00 | NQ | Futures | 23989.89 | 23999.47 | 23977.53 | 23978.04 | 3274.0 |
| 2025-08-18 22:00:00 | NQ | Futures | 23977.78 | 23991.91 | 23969.21 | 23970.98 | 2678.0 |
| 2025-08-18 23:00:00 | NQ | Futures | 23971.23 | 23994.68 | 23957.36 | 23960.64 | 3368.0 |
| 2025-08-18 00:00:00 | YM | Futures | 46068.8 | 46073.9 | 46054.5 | 46055.5 | 148.0 |
| 2025-08-18 01:00:00 | YM | Futures | 46056.5 | 46064.7 | 46048.4 | 46051.4 | 216.0 |
| 2025-08-18 02:00:00 | YM | Futures | 46050.4 | 46060.6 | 45909.4 | 45924.8 | 2304.0 |
| 2025-08-18 03:00:00 | YM | Futures | 45923.7 | 45947.2 | 45865.5 | 45922.7 | 1687.0 |
> showing 50 of 2,067 rows — these rows as CSV