PREVIEW / futures_daily / 2025-07-18
file: by_date/futures_daily/2025/2025-07-18.parquet size: 10 KB rows: 130
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 |
|---|---|---|---|---|---|---|---|
| 2025-07-18 | ES | Futures | 6342.5 | 6357.0 | 6323.25 | 6334.75 | 1050307.0 |
| 2025-07-18 | NQ | Futures | 23261.25 | 23320.75 | 23169.5 | 23224.25 | 450704.0 |
| 2025-07-18 | YM | Futures | 44735.0 | 44858.0 | 44423.0 | 44540.0 | 82856.0 |
| 2025-07-18 | CL | Futures | 66.31 | 67.54 | 65.93 | 66.05 | 296514.0 |
| 2025-07-18 | GC | Futures | 3347.5 | 3368.0 | 3337.2 | 3358.3 | 115413.0 |
| 2025-07-18 | ZN | Futures | 110.609375 | 110.90625 | 110.59375 | 110.78125 | 1110364.0 |
| 2025-07-18 | A6 | Futures | 0.6494 | 0.65475 | 0.6494 | 0.65125 | 59004.0 |
| 2025-07-18 | AD | Futures | 0.72925 | 0.73225 | 0.7292 | 0.7306 | 44188.0 |
| 2025-07-18 | ALI | Futures | 2491.5 | 2563.25 | 2489.0 | 2553.0 | 436.0 |
| 2025-07-18 | B | Futures | 69.55 | 70.77 | 69.14 | 69.28 | 411813.0 |
| 2025-07-18 | B6 | Futures | 1.3426 | 1.3482 | 1.3412 | 1.3424 | 60182.0 |
| 2025-07-18 | BFX | Futures | 4551.0 | 4551.0 | 4551.0 | 4551.0 | 0.0 |
| 2025-07-18 | BR | Futures | 0.17919 | 0.17949 | 0.17764 | 0.17764 | 232.0 |
| 2025-07-18 | BTC | Futures | 120600.0 | 121165.0 | 117035.0 | 117565.0 | 12472.0 |
| 2025-07-18 | BZ | Futures | 69.56 | 70.78 | 69.14 | 69.28 | 52366.0 |
| 2025-07-18 | C | Futures | 4825.0 | 5073.0 | 4780.0 | 5048.0 | 4629.0 |
| 2025-07-18 | CB | Futures | 264.0 | 264.025 | 260.025 | 261.525 | 58.0 |
| 2025-07-18 | CC | Futures | 6866.0 | 7227.0 | 6826.0 | 7194.0 | 11035.0 |
| 2025-07-18 | CNH | Futures | 7.154 | 7.1545 | 7.144 | 7.1495 | 652.0 |
| 2025-07-18 | CSC | Futures | 1.883 | 1.883 | 1.863 | 1.87 | 152.0 |
| 2025-07-18 | CT | Futures | 69.46 | 69.53 | 68.89 | 69.19 | 29.0 |
| 2025-07-18 | DC | Futures | 18.41 | 18.45 | 18.18 | 18.3 | 427.0 |
| 2025-07-18 | DX | Futures | 98.215 | 98.295 | 97.815 | 98.198 | 11997.0 |
| 2025-07-18 | E1 | Futures | 1.252 | 1.26125 | 1.25195 | 1.2563 | 14543.0 |
| 2025-07-18 | E6 | Futures | 1.1641 | 1.17165 | 1.1641 | 1.16665 | 124284.0 |
| 2025-07-18 | E7 | Futures | 1.1646 | 1.172 | 1.1644 | 1.1667 | 3225.0 |
| 2025-07-18 | EBM | Futures | 200.25 | 203.0 | 200.25 | 202.5 | 46892.0 |
| 2025-07-18 | ER | Futures | 98.085 | 98.11 | 98.075 | 98.085 | 144320.0 |
| 2025-07-18 | ESG | Futures | 549.08 | 549.08 | 546.12 | 546.92 | 255.0 |
| 2025-07-18 | EW | Futures | 3196.9 | 3209.9 | 3176.4 | 3189.3 | 7194.0 |
| 2025-07-18 | FBON | Futures | 123.22 | 123.22 | 123.02 | 123.07 | 28.0 |
| 2025-07-18 | FBTP | Futures | 120.4 | 120.46 | 120.17 | 120.22 | 181576.0 |
| 2025-07-18 | FBTS | Futures | 107.905 | 107.965 | 107.87 | 107.925 | 100519.0 |
| 2025-07-18 | FCE | Futures | 7876.5 | 7885.0 | 7802.5 | 7833.5 | 29710.0 |
| 2025-07-18 | FDAX | Futures | 24510.0 | 24588.0 | 24263.0 | 24383.0 | 24731.0 |
| 2025-07-18 | FDIV | Futures | 201.9 | 201.9 | 201.25 | 201.25 | 5.0 |
| 2025-07-18 | FDXM | Futures | 24500.0 | 24590.0 | 24263.0 | 24383.0 | 19369.0 |
| 2025-07-18 | FDXS | Futures | 24520.0 | 24589.0 | 24263.0 | 24383.0 | 17397.0 |
| 2025-07-18 | FESX | Futures | 5406.0 | 5420.0 | 5350.0 | 5373.0 | 437826.0 |
| 2025-07-18 | FEU3 | Futures | 98.08 | 98.09 | 98.075 | 98.09 | 4795.0 |
| 2025-07-18 | FGBL | Futures | 129.73 | 129.82 | 129.49 | 129.55 | 548854.0 |
| 2025-07-18 | FGBM | Futures | 117.56 | 117.66 | 117.45 | 117.53 | 461303.0 |
| 2025-07-18 | FGBS | Futures | 107.27 | 107.28 | 107.205 | 107.24 | 401785.0 |
| 2025-07-18 | FGBX | Futures | 116.62 | 116.9 | 115.68 | 115.76 | 62360.0 |
| 2025-07-18 | FMWO | Futures | 13106.0 | 13110.0 | 13044.0 | 13071.0 | 3634.0 |
| 2025-07-18 | FOAT | Futures | 122.8 | 122.91 | 122.62 | 122.66 | 164812.0 |
| 2025-07-18 | FSMX | Futures | 31185.0 | 31485.0 | 31075.0 | 31190.0 | 1366.0 |
| 2025-07-18 | FTDX | Futures | 3955.5 | 3955.5 | 3955.5 | 3955.5 | 0.0 |
| 2025-07-18 | FTI | Futures | 911.5 | 915.5 | 906.5 | 908.3 | 10386.0 |
| 2025-07-18 | FTUK | Futures | 8992.0 | 9014.5 | 8967.5 | 8990.0 | 59388.0 |
> showing 50 of 130 rows — these rows as CSV