PREVIEW / futures_1hour / 2025-08-12
file: by_date/futures_1hour/2025/2025-08-12.parquet size: 66 KB rows: 2,071
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-12 00:00:00 | ES | Futures | 6452.78 | 6457.81 | 6451.52 | 6457.06 | 2482.0 |
| 2025-08-12 01:00:00 | ES | Futures | 6457.06 | 6457.31 | 6440.18 | 6448.75 | 12311.0 |
| 2025-08-12 02:00:00 | ES | Futures | 6449.0 | 6459.07 | 6447.99 | 6453.28 | 7115.0 |
| 2025-08-12 03:00:00 | ES | Futures | 6453.53 | 6458.57 | 6451.52 | 6456.56 | 8088.0 |
| 2025-08-12 04:00:00 | ES | Futures | 6456.3 | 6457.06 | 6449.25 | 6450.26 | 5817.0 |
| 2025-08-12 05:00:00 | ES | Futures | 6450.01 | 6453.03 | 6448.24 | 6448.5 | 6246.0 |
| 2025-08-12 06:00:00 | ES | Futures | 6448.24 | 6449.5 | 6445.98 | 6446.73 | 5862.0 |
| 2025-08-12 07:00:00 | ES | Futures | 6446.98 | 6446.98 | 6439.18 | 6445.98 | 11256.0 |
| 2025-08-12 08:00:00 | ES | Futures | 6446.23 | 6490.31 | 6445.47 | 6480.23 | 88364.0 |
| 2025-08-12 09:00:00 | ES | Futures | 6480.23 | 6488.04 | 6458.32 | 6462.1 | 233465.0 |
| 2025-08-12 10:00:00 | ES | Futures | 6462.35 | 6491.57 | 6456.56 | 6488.04 | 218201.0 |
| 2025-08-12 11:00:00 | ES | Futures | 6488.04 | 6502.14 | 6487.28 | 6501.64 | 152497.0 |
| 2025-08-12 12:00:00 | ES | Futures | 6501.89 | 6509.7 | 6497.86 | 6506.43 | 79155.0 |
| 2025-08-12 13:00:00 | ES | Futures | 6506.43 | 6510.96 | 6503.66 | 6510.2 | 66460.0 |
| 2025-08-12 14:00:00 | ES | Futures | 6509.95 | 6515.75 | 6509.2 | 6509.95 | 73300.0 |
| 2025-08-12 15:00:00 | ES | Futures | 6509.95 | 6518.52 | 6509.2 | 6516.25 | 175748.0 |
| 2025-08-12 16:00:00 | ES | Futures | 6516.25 | 6518.26 | 6513.98 | 6517.01 | 47304.0 |
| 2025-08-12 18:00:00 | ES | Futures | 6516.5 | 6517.01 | 6512.47 | 6513.48 | 5549.0 |
| 2025-08-12 19:00:00 | ES | Futures | 6513.23 | 6523.3 | 6512.98 | 6519.78 | 8355.0 |
| 2025-08-12 20:00:00 | ES | Futures | 6519.78 | 6520.53 | 6513.73 | 6514.49 | 8169.0 |
| 2025-08-12 21:00:00 | ES | Futures | 6514.49 | 6515.49 | 6509.7 | 6510.2 | 5555.0 |
| 2025-08-12 22:00:00 | ES | Futures | 6510.2 | 6515.75 | 6509.45 | 6514.23 | 4224.0 |
| 2025-08-12 23:00:00 | ES | Futures | 6514.23 | 6517.01 | 6513.73 | 6514.99 | 3183.0 |
| 2025-08-12 00:00:00 | NQ | Futures | 23862.04 | 23882.97 | 23855.98 | 23877.67 | 1569.0 |
| 2025-08-12 01:00:00 | NQ | Futures | 23878.17 | 23879.44 | 23801.51 | 23835.3 | 7322.0 |
| 2025-08-12 02:00:00 | NQ | Futures | 23835.81 | 23874.9 | 23833.29 | 23854.72 | 3413.0 |
| 2025-08-12 03:00:00 | NQ | Futures | 23854.72 | 23881.71 | 23844.38 | 23872.12 | 4039.0 |
| 2025-08-12 04:00:00 | NQ | Futures | 23871.87 | 23878.68 | 23840.6 | 23847.16 | 3212.0 |
| 2025-08-12 05:00:00 | NQ | Futures | 23847.16 | 23858.5 | 23839.84 | 23841.86 | 2583.0 |
| 2025-08-12 06:00:00 | NQ | Futures | 23841.86 | 23851.19 | 23831.77 | 23841.1 | 3282.0 |
| 2025-08-12 07:00:00 | NQ | Futures | 23841.36 | 23848.17 | 23814.12 | 23846.4 | 5295.0 |
| 2025-08-12 08:00:00 | NQ | Futures | 23846.9 | 24029.73 | 23844.64 | 23980.31 | 34561.0 |
| 2025-08-12 09:00:00 | NQ | Futures | 23979.55 | 24015.61 | 23855.23 | 23859.01 | 93958.0 |
| 2025-08-12 10:00:00 | NQ | Futures | 23859.77 | 23988.88 | 23827.74 | 23983.84 | 79246.0 |
| 2025-08-12 11:00:00 | NQ | Futures | 23983.84 | 24078.91 | 23980.05 | 24075.88 | 66436.0 |
| 2025-08-12 12:00:00 | NQ | Futures | 24075.38 | 24119.0 | 24053.94 | 24107.91 | 38383.0 |
| 2025-08-12 13:00:00 | NQ | Futures | 24108.41 | 24124.3 | 24093.53 | 24122.79 | 27215.0 |
| 2025-08-12 14:00:00 | NQ | Futures | 24122.53 | 24141.2 | 24113.71 | 24115.22 | 27199.0 |
| 2025-08-12 15:00:00 | NQ | Futures | 24115.22 | 24158.6 | 24110.43 | 24142.96 | 52719.0 |
| 2025-08-12 16:00:00 | NQ | Futures | 24142.46 | 24162.13 | 24132.62 | 24158.09 | 13473.0 |
| 2025-08-12 18:00:00 | NQ | Futures | 24153.55 | 24153.55 | 24133.88 | 24138.42 | 2636.0 |
| 2025-08-12 19:00:00 | NQ | Futures | 24138.42 | 24178.77 | 24135.9 | 24168.94 | 4688.0 |
| 2025-08-12 20:00:00 | NQ | Futures | 24168.18 | 24176.0 | 24145.23 | 24150.27 | 5502.0 |
| 2025-08-12 21:00:00 | NQ | Futures | 24149.77 | 24156.58 | 24133.63 | 24136.91 | 2418.0 |
| 2025-08-12 22:00:00 | NQ | Futures | 24136.91 | 24160.11 | 24130.1 | 24154.06 | 3400.0 |
| 2025-08-12 23:00:00 | NQ | Futures | 24154.06 | 24167.42 | 24149.27 | 24151.03 | 1837.0 |
| 2025-08-12 00:00:00 | YM | Futures | 45076.9 | 45122.8 | 45070.7 | 45119.8 | 1535.0 |
| 2025-08-12 01:00:00 | YM | Futures | 45118.7 | 45120.8 | 45008.4 | 45069.7 | 2682.0 |
| 2025-08-12 02:00:00 | YM | Futures | 45070.7 | 45136.1 | 45058.5 | 45090.1 | 959.0 |
| 2025-08-12 03:00:00 | YM | Futures | 45093.2 | 45131.0 | 45091.2 | 45118.7 | 730.0 |
> showing 50 of 2,071 rows — these rows as CSV