PREVIEW / futures_30min / 2025-10-19
file: by_date/futures_30min/2025/2025-10-19.parquet size: 25 KB rows: 692
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-10-19 18:00:00 | ES | Futures | 6771.4 | 6776.44 | 6763.59 | 6765.61 | 8316.0 |
| 2025-10-19 18:30:00 | ES | Futures | 6765.61 | 6767.62 | 6763.09 | 6766.11 | 2924.0 |
| 2025-10-19 19:00:00 | ES | Futures | 6766.61 | 6766.87 | 6752.26 | 6753.01 | 5383.0 |
| 2025-10-19 19:30:00 | ES | Futures | 6753.26 | 6757.04 | 6751.75 | 6756.03 | 3869.0 |
| 2025-10-19 20:00:00 | ES | Futures | 6755.78 | 6756.03 | 6744.2 | 6748.73 | 8724.0 |
| 2025-10-19 20:30:00 | ES | Futures | 6748.98 | 6766.87 | 6746.97 | 6764.85 | 8841.0 |
| 2025-10-19 21:00:00 | ES | Futures | 6764.85 | 6771.15 | 6764.09 | 6768.63 | 4660.0 |
| 2025-10-19 21:30:00 | ES | Futures | 6768.38 | 6768.63 | 6760.32 | 6763.59 | 5851.0 |
| 2025-10-19 22:00:00 | ES | Futures | 6763.34 | 6764.6 | 6759.56 | 6762.08 | 2908.0 |
| 2025-10-19 22:30:00 | ES | Futures | 6762.33 | 6767.37 | 6761.07 | 6765.35 | 2716.0 |
| 2025-10-19 23:00:00 | ES | Futures | 6765.35 | 6768.12 | 6765.35 | 6767.62 | 1589.0 |
| 2025-10-19 23:30:00 | ES | Futures | 6767.62 | 6775.18 | 6766.61 | 6773.67 | 3292.0 |
| 2025-10-19 18:00:00 | NQ | Futures | 25284.85 | 25318.64 | 25264.42 | 25267.95 | 4127.0 |
| 2025-10-19 18:30:00 | NQ | Futures | 25267.45 | 25284.85 | 25258.62 | 25279.3 | 1696.0 |
| 2025-10-19 19:00:00 | NQ | Futures | 25280.56 | 25283.08 | 25205.66 | 25213.23 | 3377.0 |
| 2025-10-19 19:30:00 | NQ | Futures | 25212.72 | 25234.66 | 25208.44 | 25230.63 | 2226.0 |
| 2025-10-19 20:00:00 | NQ | Futures | 25230.38 | 25235.17 | 25173.89 | 25195.07 | 5693.0 |
| 2025-10-19 20:30:00 | NQ | Futures | 25195.83 | 25275.01 | 25183.22 | 25265.93 | 4916.0 |
| 2025-10-19 21:00:00 | NQ | Futures | 25266.69 | 25295.69 | 25261.39 | 25281.06 | 3502.0 |
| 2025-10-19 21:30:00 | NQ | Futures | 25281.57 | 25287.12 | 25249.54 | 25265.68 | 3099.0 |
| 2025-10-19 22:00:00 | NQ | Futures | 25265.18 | 25267.7 | 25245.51 | 25256.6 | 1998.0 |
| 2025-10-19 22:30:00 | NQ | Futures | 25256.85 | 25278.04 | 25253.32 | 25270.73 | 1593.0 |
| 2025-10-19 23:00:00 | NQ | Futures | 25272.49 | 25285.35 | 25270.47 | 25284.09 | 907.0 |
| 2025-10-19 23:30:00 | NQ | Futures | 25283.59 | 25318.39 | 25279.05 | 25314.61 | 2390.0 |
| 2025-10-19 18:00:00 | YM | Futures | 47145.1 | 47167.4 | 47098.4 | 47114.6 | 307.0 |
| 2025-10-19 18:30:00 | YM | Futures | 47119.7 | 47120.7 | 47099.4 | 47113.6 | 79.0 |
| 2025-10-19 19:00:00 | YM | Futures | 47116.7 | 47116.7 | 47032.5 | 47034.5 | 318.0 |
| 2025-10-19 19:30:00 | YM | Futures | 47032.5 | 47061.9 | 47024.4 | 47042.6 | 289.0 |
| 2025-10-19 20:00:00 | YM | Futures | 47041.6 | 47042.6 | 46969.6 | 46996.0 | 1654.0 |
| 2025-10-19 20:30:00 | YM | Futures | 47000.0 | 47102.5 | 46988.9 | 47093.3 | 865.0 |
| 2025-10-19 21:00:00 | YM | Futures | 47091.3 | 47132.9 | 47082.2 | 47114.6 | 445.0 |
| 2025-10-19 21:30:00 | YM | Futures | 47112.6 | 47114.6 | 47068.0 | 47086.2 | 511.0 |
| 2025-10-19 22:00:00 | YM | Futures | 47086.2 | 47097.4 | 47066.0 | 47083.2 | 301.0 |
| 2025-10-19 22:30:00 | YM | Futures | 47078.1 | 47107.5 | 47077.1 | 47102.5 | 182.0 |
| 2025-10-19 23:00:00 | YM | Futures | 47102.5 | 47113.6 | 47097.4 | 47106.5 | 96.0 |
| 2025-10-19 23:30:00 | YM | Futures | 47107.5 | 47151.1 | 47101.5 | 47140.0 | 286.0 |
| 2025-10-19 18:00:00 | CL | Futures | 56.25 | 56.36 | 56.05 | 56.29 | 1790.0 |
| 2025-10-19 18:30:00 | CL | Futures | 56.3 | 56.3 | 56.02 | 56.08 | 951.0 |
| 2025-10-19 19:00:00 | CL | Futures | 56.08 | 56.15 | 55.99 | 56.02 | 462.0 |
| 2025-10-19 19:30:00 | CL | Futures | 56.01 | 56.01 | 55.88 | 55.89 | 455.0 |
| 2025-10-19 20:00:00 | CL | Futures | 55.89 | 55.94 | 55.83 | 55.85 | 941.0 |
| 2025-10-19 20:30:00 | CL | Futures | 55.85 | 55.96 | 55.84 | 55.93 | 454.0 |
| 2025-10-19 21:00:00 | CL | Futures | 55.92 | 56.0 | 55.81 | 55.88 | 842.0 |
| 2025-10-19 21:30:00 | CL | Futures | 55.87 | 55.87 | 55.7 | 55.83 | 1252.0 |
| 2025-10-19 22:00:00 | CL | Futures | 55.83 | 55.94 | 55.82 | 55.93 | 486.0 |
| 2025-10-19 22:30:00 | CL | Futures | 55.93 | 55.97 | 55.87 | 55.88 | 433.0 |
| 2025-10-19 23:00:00 | CL | Futures | 55.89 | 55.93 | 55.85 | 55.88 | 447.0 |
| 2025-10-19 23:30:00 | CL | Futures | 55.88 | 55.95 | 55.85 | 55.91 | 473.0 |
| 2025-10-19 18:00:00 | GC | Futures | 4336.1 | 4357.3 | 4320.0 | 4342.1 | 7301.0 |
| 2025-10-19 18:30:00 | GC | Futures | 4341.1 | 4343.2 | 4325.9 | 4336.8 | 3143.0 |
> showing 50 of 692 rows — these rows as CSV