PREVIEW / futures_daily / 2026-07-27
file: by_date/futures_daily/2026/2026-07-27.parquet size: 10 KB rows: 129
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2026-07-27 | ES | Futures | 7490.0 | 7524.75 | 7416.25 | 7448.25 | 1468720.0 |
| 2026-07-27 | NQ | Futures | 28500.0 | 28763.25 | 27939.0 | 28190.0 | 596053.0 |
| 2026-07-27 | YM | Futures | 52299.0 | 52790.0 | 52173.0 | 52382.0 | 91904.0 |
| 2026-07-27 | CL | Futures | 86.12 | 86.2 | 81.63 | 82.61 | 352813.0 |
| 2026-07-27 | GC | Futures | 4151.1 | 4178.5 | 4126.5 | 4136.4 | 61698.0 |
| 2026-07-27 | ZN | Futures | 108.5 | 108.6875 | 108.390625 | 108.578125 | 1690983.0 |
| 2026-07-27 | A6 | Futures | 0.699 | 0.70055 | 0.69795 | 0.69825 | 51863.0 |
| 2026-07-27 | AD | Futures | 0.71105 | 0.7123 | 0.70945 | 0.70955 | 46906.0 |
| 2026-07-27 | ALI | Futures | 3448.75 | 3486.0 | 3448.75 | 3462.75 | 67.0 |
| 2026-07-27 | B | Futures | 88.8 | 88.95 | 84.65 | 85.87 | 459497.0 |
| 2026-07-27 | B6 | Futures | 1.3328 | 1.3364 | 1.3285 | 1.3288 | 62121.0 |
| 2026-07-27 | BFX | Futures | 5716.0 | 5716.0 | 5716.0 | 5716.0 | 0.0 |
| 2026-07-27 | BR | Futures | 0.1951 | 0.196 | 0.19385 | 0.1941 | 29604.0 |
| 2026-07-27 | BTC | Futures | 64345.0 | 66175.0 | 64250.0 | 65190.0 | 5212.0 |
| 2026-07-27 | BZ | Futures | 89.06 | 89.06 | 84.66 | 85.87 | 52445.0 |
| 2026-07-27 | C | Futures | 3992.0 | 4150.0 | 3824.0 | 3832.0 | 6788.0 |
| 2026-07-27 | CB | Futures | 158.35 | 160.65 | 153.5 | 155.0 | 75.0 |
| 2026-07-27 | CC | Futures | 5332.0 | 5561.0 | 5080.0 | 5100.0 | 17744.0 |
| 2026-07-27 | CNH | Futures | 6.7455 | 6.7465 | 6.7405 | 6.7435 | 1077.0 |
| 2026-07-27 | CSC | Futures | 1.673 | 1.673 | 1.643 | 1.651 | 465.0 |
| 2026-07-27 | CT | Futures | 78.63 | 79.52 | 78.21 | 79.34 | 26.0 |
| 2026-07-27 | DC | Futures | 17.43 | 17.5 | 17.09 | 17.15 | 615.0 |
| 2026-07-27 | DX | Futures | 101.19 | 101.39 | 100.95 | 101.384 | 14081.0 |
| 2026-07-27 | E1 | Futures | 1.23105 | 1.2353 | 1.22685 | 1.22755 | 23660.0 |
| 2026-07-27 | E6 | Futures | 1.14095 | 1.1442 | 1.13905 | 1.13915 | 137453.0 |
| 2026-07-27 | E7 | Futures | 1.1411 | 1.1442 | 1.139 | 1.1392 | 2612.0 |
| 2026-07-27 | EBM | Futures | 229.0 | 235.0 | 228.0 | 229.25 | 37115.0 |
| 2026-07-27 | ER | Futures | 97.405 | 97.425 | 97.405 | 97.41 | 146538.0 |
| 2026-07-27 | ESG | Futures | 663.02 | 663.02 | 651.92 | 653.92 | 421.0 |
| 2026-07-27 | EW | Futures | 3832.0 | 3847.2 | 3786.6 | 3811.9 | 13216.0 |
| 2026-07-27 | FBON | Futures | 119.41 | 120.48 | 119.4 | 120.32 | 11.0 |
| 2026-07-27 | FBTP | Futures | 116.65 | 116.89 | 116.58 | 116.72 | 269874.0 |
| 2026-07-27 | FBTS | Futures | 106.37 | 106.43 | 106.345 | 106.39 | 141558.0 |
| 2026-07-27 | FCE | Futures | 8450.0 | 8483.0 | 8413.0 | 8422.0 | 38773.0 |
| 2026-07-27 | FDAX | Futures | 25370.0 | 25654.0 | 25270.0 | 25520.0 | 26788.0 |
| 2026-07-27 | FDIV | Futures | 219.1 | 219.1 | 219.1 | 219.1 | 0.0 |
| 2026-07-27 | FDXM | Futures | 25368.0 | 25655.0 | 25272.0 | 25520.0 | 27445.0 |
| 2026-07-27 | FDXS | Futures | 25349.0 | 25656.0 | 25268.0 | 25520.0 | 25979.0 |
| 2026-07-27 | FESX | Futures | 6348.0 | 6392.0 | 6304.0 | 6321.0 | 543883.0 |
| 2026-07-27 | FEU3 | Futures | 97.41 | 97.425 | 97.41 | 97.41 | 49817.0 |
| 2026-07-27 | FGBL | Futures | 124.8 | 125.04 | 124.77 | 124.97 | 1094490.0 |
| 2026-07-27 | FGBM | Futures | 113.96 | 114.11 | 113.95 | 114.08 | 838289.0 |
| 2026-07-27 | FGBS | Futures | 105.465 | 105.525 | 105.46 | 105.495 | 565651.0 |
| 2026-07-27 | FGBX | Futures | 107.0 | 107.38 | 106.84 | 107.22 | 155447.0 |
| 2026-07-27 | FMWO | Futures | 15708.0 | 15732.0 | 15520.0 | 15570.0 | 5375.0 |
| 2026-07-27 | FOAT | Futures | 117.55 | 117.76 | 117.47 | 117.64 | 214569.0 |
| 2026-07-27 | FSMX | Futures | 32980.0 | 32980.0 | 32250.0 | 32310.0 | 66.0 |
| 2026-07-27 | FTDX | Futures | 3870.0 | 3870.0 | 3836.0 | 3836.0 | 12.0 |
| 2026-07-27 | FTI | Futures | 1089.0 | 1095.5 | 1077.15 | 1077.41 | 9917.0 |
| 2026-07-27 | FTUK | Futures | 10756.0 | 10833.0 | 10717.5 | 10803.5 | 74746.0 |
> showing 50 of 129 rows — these rows as CSV