PREVIEW / futures_1hour / 2025-04-20
file: by_date/futures_1hour/2025/2025-04-20.parquet size: 18 KB rows: 382
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-04-20 18:00:00 | ES | Futures | 5369.14 | 5392.51 | 5364.31 | 5371.93 | 13619.0 |
| 2025-04-20 19:00:00 | ES | Futures | 5372.18 | 5379.55 | 5368.88 | 5378.54 | 4785.0 |
| 2025-04-20 20:00:00 | ES | Futures | 5378.28 | 5388.95 | 5370.91 | 5371.42 | 10222.0 |
| 2025-04-20 21:00:00 | ES | Futures | 5371.42 | 5373.46 | 5358.21 | 5365.58 | 13016.0 |
| 2025-04-20 22:00:00 | ES | Futures | 5365.83 | 5370.66 | 5344.24 | 5351.86 | 10882.0 |
| 2025-04-20 23:00:00 | ES | Futures | 5351.86 | 5357.96 | 5349.83 | 5353.13 | 4956.0 |
| 2025-04-20 18:00:00 | NQ | Futures | 18646.95 | 18725.64 | 18570.55 | 18630.4 | 5491.0 |
| 2025-04-20 19:00:00 | NQ | Futures | 18626.83 | 18668.6 | 18619.19 | 18655.61 | 2738.0 |
| 2025-04-20 20:00:00 | NQ | Futures | 18654.08 | 18720.29 | 18638.8 | 18642.62 | 6530.0 |
| 2025-04-20 21:00:00 | NQ | Futures | 18643.64 | 18656.12 | 18596.78 | 18626.32 | 7538.0 |
| 2025-04-20 22:00:00 | NQ | Futures | 18626.58 | 18646.44 | 18527.52 | 18556.29 | 7630.0 |
| 2025-04-20 23:00:00 | NQ | Futures | 18557.82 | 18574.37 | 18548.14 | 18559.86 | 3326.0 |
| 2025-04-20 18:00:00 | YM | Futures | 40355.7 | 40394.8 | 40192.1 | 40267.2 | 744.0 |
| 2025-04-20 19:00:00 | YM | Futures | 40259.0 | 40317.6 | 40246.6 | 40311.5 | 340.0 |
| 2025-04-20 20:00:00 | YM | Futures | 40305.3 | 40361.9 | 40251.8 | 40251.8 | 1376.0 |
| 2025-04-20 21:00:00 | YM | Futures | 40253.8 | 40257.9 | 40162.2 | 40208.5 | 1776.0 |
| 2025-04-20 22:00:00 | YM | Futures | 40211.6 | 40237.4 | 40079.9 | 40122.1 | 1485.0 |
| 2025-04-20 23:00:00 | YM | Futures | 40123.1 | 40170.5 | 40091.2 | 40136.5 | 792.0 |
| 2025-04-20 18:00:00 | CL | Futures | 59.44 | 59.56 | 58.89 | 58.99 | 3406.0 |
| 2025-04-20 19:00:00 | CL | Futures | 58.97 | 59.05 | 58.83 | 58.97 | 2018.0 |
| 2025-04-20 20:00:00 | CL | Futures | 58.97 | 59.23 | 58.9 | 58.93 | 2227.0 |
| 2025-04-20 21:00:00 | CL | Futures | 58.95 | 58.97 | 58.55 | 58.76 | 5805.0 |
| 2025-04-20 22:00:00 | CL | Futures | 58.75 | 58.8 | 58.65 | 58.74 | 1288.0 |
| 2025-04-20 23:00:00 | CL | Futures | 58.76 | 58.88 | 58.65 | 58.87 | 1403.0 |
| 2025-04-20 18:00:00 | GC | Futures | 3457.6 | 3479.4 | 3454.5 | 3471.3 | 7967.0 |
| 2025-04-20 19:00:00 | GC | Futures | 3471.4 | 3478.0 | 3468.7 | 3472.9 | 5467.0 |
| 2025-04-20 20:00:00 | GC | Futures | 3473.1 | 3496.6 | 3472.3 | 3494.3 | 12414.0 |
| 2025-04-20 21:00:00 | GC | Futures | 3494.0 | 3503.7 | 3492.6 | 3502.3 | 12553.0 |
| 2025-04-20 22:00:00 | GC | Futures | 3502.5 | 3509.9 | 3498.8 | 3508.9 | 8720.0 |
| 2025-04-20 23:00:00 | GC | Futures | 3509.0 | 3509.5 | 3502.0 | 3506.3 | 6326.0 |
| 2025-04-20 18:00:00 | ZN | Futures | 111.156117 | 111.203005 | 111.062341 | 111.109229 | 11635.0 |
| 2025-04-20 19:00:00 | ZN | Futures | 111.124858 | 111.171747 | 111.109229 | 111.171747 | 5494.0 |
| 2025-04-20 20:00:00 | ZN | Futures | 111.171747 | 111.187376 | 111.046712 | 111.07797 | 14128.0 |
| 2025-04-20 21:00:00 | ZN | Futures | 111.07797 | 111.187376 | 111.07797 | 111.140488 | 10544.0 |
| 2025-04-20 22:00:00 | ZN | Futures | 111.156117 | 111.203005 | 111.140488 | 111.156117 | 7809.0 |
| 2025-04-20 23:00:00 | ZN | Futures | 111.156117 | 111.156117 | 111.0936 | 111.109229 | 6055.0 |
> showing 36 of 382 rows — these rows as CSV