PREVIEW / futures_30min / 2025-07-20
file: by_date/futures_30min/2025/2025-07-20.parquet size: 28 KB rows: 781
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-20 18:00:00 | ES | Futures | 6383.26 | 6385.28 | 6377.22 | 6384.77 | 5389.0 |
| 2025-07-20 18:30:00 | ES | Futures | 6384.77 | 6386.79 | 6383.51 | 6385.53 | 1804.0 |
| 2025-07-20 19:00:00 | ES | Futures | 6385.78 | 6387.54 | 6384.27 | 6384.77 | 1541.0 |
| 2025-07-20 19:30:00 | ES | Futures | 6385.02 | 6390.56 | 6384.52 | 6390.31 | 2085.0 |
| 2025-07-20 20:00:00 | ES | Futures | 6390.31 | 6391.32 | 6389.31 | 6390.31 | 1904.0 |
| 2025-07-20 20:30:00 | ES | Futures | 6390.31 | 6390.56 | 6389.05 | 6389.56 | 1116.0 |
| 2025-07-20 21:00:00 | ES | Futures | 6389.56 | 6392.58 | 6389.05 | 6391.07 | 2177.0 |
| 2025-07-20 21:30:00 | ES | Futures | 6390.82 | 6391.07 | 6388.8 | 6389.56 | 1814.0 |
| 2025-07-20 22:00:00 | ES | Futures | 6389.56 | 6390.56 | 6388.55 | 6390.31 | 1114.0 |
| 2025-07-20 22:30:00 | ES | Futures | 6390.31 | 6390.82 | 6387.54 | 6388.3 | 1103.0 |
| 2025-07-20 23:00:00 | ES | Futures | 6388.3 | 6389.31 | 6387.54 | 6388.05 | 877.0 |
| 2025-07-20 23:30:00 | ES | Futures | 6388.05 | 6388.05 | 6386.28 | 6387.29 | 1131.0 |
| 2025-07-20 18:00:00 | NQ | Futures | 23434.85 | 23438.38 | 23405.85 | 23436.11 | 3011.0 |
| 2025-07-20 18:30:00 | NQ | Futures | 23436.11 | 23447.96 | 23433.33 | 23446.45 | 1587.0 |
| 2025-07-20 19:00:00 | NQ | Futures | 23447.71 | 23455.53 | 23439.39 | 23441.15 | 1757.0 |
| 2025-07-20 19:30:00 | NQ | Futures | 23442.92 | 23465.36 | 23439.89 | 23462.84 | 1730.0 |
| 2025-07-20 20:00:00 | NQ | Futures | 23463.09 | 23465.61 | 23457.29 | 23460.32 | 1491.0 |
| 2025-07-20 20:30:00 | NQ | Futures | 23460.06 | 23461.58 | 23453.0 | 23454.52 | 976.0 |
| 2025-07-20 21:00:00 | NQ | Futures | 23455.02 | 23479.99 | 23453.51 | 23470.15 | 2405.0 |
| 2025-07-20 21:30:00 | NQ | Futures | 23470.4 | 23473.43 | 23465.11 | 23466.62 | 1049.0 |
| 2025-07-20 22:00:00 | NQ | Futures | 23466.62 | 23472.67 | 23463.85 | 23471.92 | 873.0 |
| 2025-07-20 22:30:00 | NQ | Futures | 23471.66 | 23473.18 | 23457.79 | 23460.06 | 1176.0 |
| 2025-07-20 23:00:00 | NQ | Futures | 23459.81 | 23464.35 | 23454.01 | 23457.54 | 895.0 |
| 2025-07-20 23:30:00 | NQ | Futures | 23457.29 | 23457.29 | 23444.93 | 23448.97 | 1002.0 |
| 2025-07-20 18:00:00 | YM | Futures | 45497.7 | 45515.1 | 45450.8 | 45515.1 | 251.0 |
| 2025-07-20 18:30:00 | YM | Futures | 45514.1 | 45523.3 | 45505.9 | 45512.1 | 166.0 |
| 2025-07-20 19:00:00 | YM | Futures | 45514.1 | 45529.4 | 45509.0 | 45517.2 | 288.0 |
| 2025-07-20 19:30:00 | YM | Futures | 45519.2 | 45566.2 | 45516.1 | 45564.2 | 364.0 |
| 2025-07-20 20:00:00 | YM | Futures | 45565.2 | 45570.3 | 45556.0 | 45566.2 | 215.0 |
| 2025-07-20 20:30:00 | YM | Futures | 45565.2 | 45574.4 | 45557.0 | 45567.2 | 271.0 |
| 2025-07-20 21:00:00 | YM | Futures | 45568.2 | 45573.3 | 45555.0 | 45564.2 | 261.0 |
| 2025-07-20 21:30:00 | YM | Futures | 45561.1 | 45561.1 | 45540.7 | 45544.7 | 371.0 |
| 2025-07-20 22:00:00 | YM | Futures | 45545.8 | 45553.9 | 45537.6 | 45546.8 | 137.0 |
| 2025-07-20 22:30:00 | YM | Futures | 45546.8 | 45548.8 | 45527.4 | 45533.5 | 143.0 |
| 2025-07-20 23:00:00 | YM | Futures | 45533.5 | 45547.8 | 45533.5 | 45533.5 | 186.0 |
| 2025-07-20 23:30:00 | YM | Futures | 45532.5 | 45534.5 | 45523.3 | 45530.4 | 111.0 |
| 2025-07-20 18:00:00 | CL | Futures | 63.33 | 63.56 | 63.27 | 63.54 | 1401.0 |
| 2025-07-20 18:30:00 | CL | Futures | 63.53 | 63.57 | 63.46 | 63.54 | 313.0 |
| 2025-07-20 19:00:00 | CL | Futures | 63.53 | 63.55 | 63.45 | 63.49 | 443.0 |
| 2025-07-20 19:30:00 | CL | Futures | 63.47 | 63.49 | 63.42 | 63.44 | 223.0 |
| 2025-07-20 20:00:00 | CL | Futures | 63.44 | 63.44 | 63.33 | 63.39 | 626.0 |
| 2025-07-20 20:30:00 | CL | Futures | 63.4 | 63.51 | 63.37 | 63.45 | 441.0 |
| 2025-07-20 21:00:00 | CL | Futures | 63.45 | 63.58 | 63.39 | 63.49 | 826.0 |
| 2025-07-20 21:30:00 | CL | Futures | 63.49 | 63.56 | 63.43 | 63.44 | 1260.0 |
| 2025-07-20 22:00:00 | CL | Futures | 63.45 | 63.47 | 63.36 | 63.41 | 516.0 |
| 2025-07-20 22:30:00 | CL | Futures | 63.42 | 63.45 | 63.35 | 63.4 | 635.0 |
| 2025-07-20 23:00:00 | CL | Futures | 63.4 | 63.5 | 63.39 | 63.48 | 721.0 |
| 2025-07-20 23:30:00 | CL | Futures | 63.48 | 63.49 | 63.42 | 63.48 | 186.0 |
| 2025-07-20 18:00:00 | GC | Futures | 3466.6 | 3467.9 | 3461.9 | 3465.0 | 2009.0 |
| 2025-07-20 18:30:00 | GC | Futures | 3464.9 | 3465.6 | 3463.8 | 3465.3 | 699.0 |
> showing 50 of 781 rows — these rows as CSV