PREVIEW / futures_30min / 2025-04-20
file: by_date/futures_30min/2025/2025-04-20.parquet size: 28 KB rows: 735
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 | 5373.71 | 10275.0 |
| 2025-04-20 18:30:00 | ES | Futures | 5373.71 | 5375.49 | 5365.58 | 5371.93 | 3344.0 |
| 2025-04-20 19:00:00 | ES | Futures | 5372.18 | 5379.55 | 5368.88 | 5371.17 | 2970.0 |
| 2025-04-20 19:30:00 | ES | Futures | 5371.17 | 5379.3 | 5370.15 | 5378.54 | 1815.0 |
| 2025-04-20 20:00:00 | ES | Futures | 5378.28 | 5388.95 | 5376.25 | 5387.43 | 5063.0 |
| 2025-04-20 20:30:00 | ES | Futures | 5387.68 | 5388.95 | 5370.91 | 5371.42 | 5159.0 |
| 2025-04-20 21:00:00 | ES | Futures | 5371.42 | 5372.69 | 5358.21 | 5364.31 | 6678.0 |
| 2025-04-20 21:30:00 | ES | Futures | 5364.31 | 5373.46 | 5362.53 | 5365.58 | 6338.0 |
| 2025-04-20 22:00:00 | ES | Futures | 5365.83 | 5370.66 | 5361.52 | 5363.29 | 3747.0 |
| 2025-04-20 22:30:00 | ES | Futures | 5363.04 | 5365.83 | 5344.24 | 5351.86 | 7135.0 |
| 2025-04-20 23:00:00 | ES | Futures | 5351.86 | 5357.45 | 5349.83 | 5357.2 | 3377.0 |
| 2025-04-20 23:30:00 | ES | Futures | 5357.2 | 5357.96 | 5350.85 | 5353.13 | 1579.0 |
| 2025-04-20 18:00:00 | NQ | Futures | 18646.95 | 18725.64 | 18570.55 | 18623.01 | 4161.0 |
| 2025-04-20 18:30:00 | NQ | Futures | 18622.25 | 18638.55 | 18602.13 | 18630.4 | 1330.0 |
| 2025-04-20 19:00:00 | NQ | Futures | 18626.83 | 18668.6 | 18620.72 | 18629.89 | 1622.0 |
| 2025-04-20 19:30:00 | NQ | Futures | 18627.09 | 18659.68 | 18619.19 | 18655.61 | 1116.0 |
| 2025-04-20 20:00:00 | NQ | Futures | 18654.08 | 18707.3 | 18648.73 | 18703.48 | 3005.0 |
| 2025-04-20 20:30:00 | NQ | Futures | 18703.99 | 18720.29 | 18638.8 | 18642.62 | 3525.0 |
| 2025-04-20 21:00:00 | NQ | Futures | 18643.64 | 18650.01 | 18596.78 | 18624.03 | 3634.0 |
| 2025-04-20 21:30:00 | NQ | Futures | 18624.29 | 18656.12 | 18603.15 | 18626.32 | 3904.0 |
| 2025-04-20 22:00:00 | NQ | Futures | 18626.58 | 18646.44 | 18612.57 | 18620.98 | 2345.0 |
| 2025-04-20 22:30:00 | NQ | Futures | 18620.47 | 18631.16 | 18527.52 | 18556.29 | 5285.0 |
| 2025-04-20 23:00:00 | NQ | Futures | 18557.82 | 18574.37 | 18549.93 | 18570.81 | 2009.0 |
| 2025-04-20 23:30:00 | NQ | Futures | 18571.57 | 18573.1 | 18548.14 | 18559.86 | 1317.0 |
| 2025-04-20 18:00:00 | YM | Futures | 40355.7 | 40394.8 | 40192.1 | 40315.6 | 571.0 |
| 2025-04-20 18:30:00 | YM | Futures | 40304.2 | 40318.7 | 40227.1 | 40267.2 | 173.0 |
| 2025-04-20 19:00:00 | YM | Futures | 40259.0 | 40308.4 | 40246.6 | 40262.1 | 203.0 |
| 2025-04-20 19:30:00 | YM | Futures | 40266.2 | 40317.6 | 40254.8 | 40311.5 | 137.0 |
| 2025-04-20 20:00:00 | YM | Futures | 40305.3 | 40361.9 | 40297.0 | 40341.3 | 592.0 |
| 2025-04-20 20:30:00 | YM | Futures | 40340.3 | 40345.4 | 40251.8 | 40251.8 | 784.0 |
| 2025-04-20 21:00:00 | YM | Futures | 40253.8 | 40257.9 | 40162.2 | 40199.3 | 926.0 |
| 2025-04-20 21:30:00 | YM | Futures | 40198.2 | 40252.8 | 40194.1 | 40208.5 | 850.0 |
| 2025-04-20 22:00:00 | YM | Futures | 40211.6 | 40237.4 | 40174.6 | 40181.8 | 550.0 |
| 2025-04-20 22:30:00 | YM | Futures | 40182.8 | 40197.2 | 40079.9 | 40122.1 | 935.0 |
| 2025-04-20 23:00:00 | YM | Futures | 40123.1 | 40164.3 | 40091.2 | 40164.3 | 492.0 |
| 2025-04-20 23:30:00 | YM | Futures | 40161.2 | 40170.5 | 40121.1 | 40136.5 | 300.0 |
| 2025-04-20 18:00:00 | CL | Futures | 59.44 | 59.56 | 59.01 | 59.12 | 2248.0 |
| 2025-04-20 18:30:00 | CL | Futures | 59.11 | 59.11 | 58.89 | 58.99 | 1158.0 |
| 2025-04-20 19:00:00 | CL | Futures | 58.97 | 59.05 | 58.92 | 58.93 | 793.0 |
| 2025-04-20 19:30:00 | CL | Futures | 58.94 | 58.97 | 58.83 | 58.97 | 1225.0 |
| 2025-04-20 20:00:00 | CL | Futures | 58.97 | 59.23 | 58.94 | 59.16 | 1116.0 |
| 2025-04-20 20:30:00 | CL | Futures | 59.15 | 59.15 | 58.9 | 58.93 | 1111.0 |
| 2025-04-20 21:00:00 | CL | Futures | 58.95 | 58.97 | 58.55 | 58.72 | 4463.0 |
| 2025-04-20 21:30:00 | CL | Futures | 58.71 | 58.85 | 58.62 | 58.76 | 1342.0 |
| 2025-04-20 22:00:00 | CL | Futures | 58.75 | 58.8 | 58.67 | 58.69 | 525.0 |
| 2025-04-20 22:30:00 | CL | Futures | 58.7 | 58.78 | 58.65 | 58.74 | 763.0 |
| 2025-04-20 23:00:00 | CL | Futures | 58.76 | 58.83 | 58.65 | 58.83 | 708.0 |
| 2025-04-20 23:30:00 | CL | Futures | 58.82 | 58.88 | 58.8 | 58.87 | 695.0 |
| 2025-04-20 18:00:00 | GC | Futures | 3457.6 | 3479.4 | 3454.5 | 3468.7 | 5793.0 |
| 2025-04-20 18:30:00 | GC | Futures | 3468.6 | 3473.7 | 3465.6 | 3471.3 | 2174.0 |
> showing 50 of 735 rows — these rows as CSV