PREVIEW / futures_daily / 2024-09-27
file: by_date/futures_daily/2024/2024-09-27.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 |
|---|---|---|---|---|---|---|---|
| 2024-09-27 | ES | Futures | 5938.0 | 5955.65 | 5915.24 | 5924.7 | 1280272.0 |
| 2024-09-27 | NQ | Futures | 20868.21 | 20920.27 | 20691.79 | 20741.54 | 435634.0 |
| 2024-09-27 | YM | Futures | 42985.1 | 43457.0 | 42935.6 | 43104.3 | 139040.0 |
| 2024-09-27 | CL | Futures | 64.16 | 65.3 | 63.79 | 64.85 | 341133.0 |
| 2024-09-27 | GC | Futures | 2751.8 | 2753.6 | 2721.4 | 2724.2 | 196732.0 |
| 2024-09-27 | ZN | Futures | 114.488184 | 114.926237 | 114.394316 | 114.879303 | 1961298.0 |
| 2024-09-27 | A6 | Futures | 0.68973 | 0.69393 | 0.68708 | 0.69153 | 121161.0 |
| 2024-09-27 | AD | Futures | 0.74558 | 0.74578 | 0.74228 | 0.74318 | 80717.0 |
| 2024-09-27 | ALI | Futures | 2645.6 | 2678.0 | 2624.51 | 2667.46 | 888.0 |
| 2024-09-27 | B | Futures | 70.09 | 71.36 | 69.82 | 70.91 | 444187.0 |
| 2024-09-27 | B6 | Futures | 1.3404 | 1.342 | 1.3352 | 1.3378 | 96973.0 |
| 2024-09-27 | BFX | Futures | 4342.3 | 4342.3 | 4342.3 | 4342.3 | 0.0 |
| 2024-09-27 | BR | Futures | 0.17844 | 0.17849 | 0.17796 | 0.17825 | 14.0 |
| 2024-09-27 | BTC | Futures | 71686.2 | 73369.3 | 71276.4 | 72281.9 | 10156.0 |
| 2024-09-27 | BZ | Futures | 68.75 | 69.84 | 68.35 | 69.4 | 51149.0 |
| 2024-09-27 | C | Futures | 5248.0 | 5473.0 | 5198.0 | 5429.0 | 4977.0 |
| 2024-09-27 | CB | Futures | 289.976 | 290.495 | 289.457 | 289.742 | 43.0 |
| 2024-09-27 | CC | Futures | 6615.0 | 6854.0 | 6580.0 | 6781.0 | 7951.0 |
| 2024-09-27 | CNH | Futures | 6.8984 | 6.9353 | 6.8984 | 6.9298 | 806.0 |
| 2024-09-27 | CSC | Futures | 2.224 | 2.227 | 2.18 | 2.191 | 96.0 |
| 2024-09-27 | CT | Futures | 80.1 | 81.07 | 78.58 | 79.72 | 23149.0 |
| 2024-09-27 | DC | Futures | 21.41 | 21.53 | 21.09 | 21.23 | 453.0 |
| 2024-09-27 | DX | Futures | 100.051 | 100.335 | 99.592 | 99.835 | 23868.0 |
| 2024-09-27 | E1 | Futures | 1.2032 | 1.21183 | 1.19861 | 1.21113 | 29305.0 |
| 2024-09-27 | E6 | Futures | 1.12578 | 1.12839 | 1.1205 | 1.12482 | 220872.0 |
| 2024-09-27 | E7 | Futures | 1.1253 | 1.128 | 1.1201 | 1.1244 | 6221.0 |
| 2024-09-27 | EBM | Futures | 241.79 | 242.89 | 238.51 | 241.52 | 32088.0 |
| 2024-09-27 | ER | Futures | 97.715 | 97.775 | 97.704 | 97.76 | 410425.0 |
| 2024-09-27 | ESG | Futures | 512.48 | 513.04 | 509.79 | 510.99 | 302.0 |
| 2024-09-27 | EW | Futures | 3174.1 | 3206.9 | 3165.4 | 3177.6 | 10194.0 |
| 2024-09-27 | FBON | Futures | 125.94 | 126.48 | 125.77 | 126.12 | 186.0 |
| 2024-09-27 | FBTP | Futures | 120.88 | 121.38 | 120.74 | 120.95 | 353578.0 |
| 2024-09-27 | FBTS | Futures | 107.66 | 107.81 | 107.64 | 107.71 | 183869.0 |
| 2024-09-27 | FCE | Futures | 7786.6 | 7837.2 | 7773.6 | 7824.2 | 41212.0 |
| 2024-09-27 | FDAX | Futures | 19632.4 | 19854.5 | 19585.9 | 19838.4 | 48208.0 |
| 2024-09-27 | FDIV | Futures | 198.01 | 199.57 | 198.01 | 199.57 | 21.0 |
| 2024-09-27 | FDXM | Futures | 19586.9 | 19809.5 | 19543.5 | 19795.4 | 28670.0 |
| 2024-09-27 | FDXS | Futures | 19514.8 | 19765.2 | 19498.8 | 19751.1 | 30751.0 |
| 2024-09-27 | FESX | Futures | 5074.1 | 5109.2 | 5060.1 | 5105.2 | 805911.0 |
| 2024-09-27 | FEU3 | Futures | 97.714 | 97.77 | 97.709 | 97.765 | 1470.0 |
| 2024-09-27 | FGBL | Futures | 136.29 | 136.95 | 136.06 | 136.57 | 1192268.0 |
| 2024-09-27 | FGBM | Futures | 119.14 | 119.5 | 119.02 | 119.33 | 845238.0 |
| 2024-09-27 | FGBS | Futures | 107.36 | 107.51 | 107.34 | 107.45 | 898028.0 |
| 2024-09-27 | FGBX | Futures | 136.05 | 137.61 | 135.55 | 136.23 | 114593.0 |
| 2024-09-27 | FMWO | Futures | 12325.1 | 12359.3 | 12277.4 | 12339.6 | 3205.0 |
| 2024-09-27 | FOAT | Futures | 125.95 | 126.54 | 125.68 | 126.18 | 200900.0 |
| 2024-09-27 | FSMX | Futures | 27110.0 | 27480.1 | 27107.0 | 27449.1 | 482.0 |
| 2024-09-27 | FTDX | Futures | 3482.6 | 3520.1 | 3482.6 | 3518.5 | 19.0 |
| 2024-09-27 | FTI | Futures | 921.61 | 928.31 | 920.95 | 927.02 | 8110.0 |
| 2024-09-27 | FTUK | Futures | 8355.9 | 8406.0 | 8339.4 | 8392.0 | 73938.0 |
> showing 50 of 130 rows — these rows as CSV