PREVIEW / futures_daily / 2024-08-09
file: by_date/futures_daily/2024/2024-08-09.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-08-09 | ES | Futures | 5524.22 | 5562.43 | 5494.52 | 5546.94 | 1412017.0 |
| 2024-08-09 | NQ | Futures | 19224.84 | 19353.6 | 19051.5 | 19292.98 | 501761.0 |
| 2024-08-09 | YM | Futures | 40392.4 | 40555.5 | 40132.3 | 40423.0 | 114018.0 |
| 2024-08-09 | CL | Futures | 70.52 | 71.51 | 70.36 | 71.28 | 263007.0 |
| 2024-08-09 | GC | Futures | 2519.2 | 2528.6 | 2507.8 | 2525.4 | 152173.0 |
| 2024-08-09 | ZN | Futures | 113.292003 | 113.747496 | 113.26059 | 113.54331 | 1433071.0 |
| 2024-08-09 | A6 | Futures | 0.66083 | 0.66213 | 0.65823 | 0.65903 | 72628.0 |
| 2024-08-09 | AD | Futures | 0.73253 | 0.73338 | 0.73052 | 0.73258 | 61211.0 |
| 2024-08-09 | ALI | Futures | 2292.64 | 2330.81 | 2291.35 | 2304.76 | 3295.0 |
| 2024-08-09 | B | Futures | 76.96 | 77.74 | 76.71 | 77.58 | 230450.0 |
| 2024-08-09 | B6 | Futures | 1.2745 | 1.2775 | 1.2728 | 1.2759 | 65791.0 |
| 2024-08-09 | BFX | Futures | 4038.1 | 4038.1 | 4038.1 | 4038.1 | 0.0 |
| 2024-08-09 | BR | Futures | 0.17195 | 0.17528 | 0.17195 | 0.17475 | 14463.0 |
| 2024-08-09 | BTC | Futures | 67985.3 | 70620.9 | 67076.9 | 68400.3 | 8408.0 |
| 2024-08-09 | BZ | Futures | 75.38 | 76.15 | 75.15 | 76.0 | 32227.0 |
| 2024-08-09 | C | Futures | 6386.0 | 6734.0 | 6335.0 | 6617.0 | 2439.0 |
| 2024-08-09 | CB | Futures | 305.612 | 306.996 | 305.612 | 306.631 | 7.0 |
| 2024-08-09 | CC | Futures | 5641.0 | 6162.0 | 5611.0 | 6052.0 | 17922.0 |
| 2024-08-09 | CNH | Futures | 7.0673 | 7.0728 | 7.051 | 7.0634 | 1114.0 |
| 2024-08-09 | CSC | Futures | 1.949 | 1.973 | 1.933 | 1.966 | 151.0 |
| 2024-08-09 | CT | Futures | 74.38 | 75.71 | 74.38 | 75.36 | 33.0 |
| 2024-08-09 | DC | Futures | 19.03 | 19.25 | 18.83 | 19.12 | 484.0 |
| 2024-08-09 | DX | Futures | 102.557 | 102.582 | 102.318 | 102.43 | 8903.0 |
| 2024-08-09 | E1 | Futures | 1.18045 | 1.18518 | 1.17978 | 1.18315 | 24249.0 |
| 2024-08-09 | E6 | Futures | 1.10194 | 1.10325 | 1.10098 | 1.10214 | 143918.0 |
| 2024-08-09 | E7 | Futures | 1.1016 | 1.1028 | 1.1006 | 1.1018 | 2150.0 |
| 2024-08-09 | EBM | Futures | 254.66 | 257.0 | 253.2 | 253.49 | 13723.0 |
| 2024-08-09 | ER | Futures | 97.649 | 97.654 | 97.634 | 97.639 | 76585.0 |
| 2024-08-09 | ESG | Futures | 475.03 | 477.07 | 472.42 | 476.05 | 1218.0 |
| 2024-08-09 | EW | Futures | 2997.2 | 3020.8 | 2976.3 | 2997.4 | 7774.0 |
| 2024-08-09 | FBON | Futures | 124.74 | 125.04 | 124.74 | 124.96 | 5.0 |
| 2024-08-09 | FBTP | Futures | 118.43 | 118.78 | 118.35 | 118.69 | 164334.0 |
| 2024-08-09 | FBTS | Futures | 106.979 | 106.999 | 106.928 | 106.989 | 89585.0 |
| 2024-08-09 | FCE | Futures | 7444.7 | 7502.1 | 7410.9 | 7449.3 | 34535.0 |
| 2024-08-09 | FDAX | Futures | 18179.2 | 18269.3 | 18089.2 | 18180.3 | 33397.0 |
| 2024-08-09 | FDIV | Futures | 175.73 | 175.93 | 175.73 | 175.93 | 1.0 |
| 2024-08-09 | FDXM | Futures | 18090.6 | 18184.2 | 18006.1 | 18095.7 | 21630.0 |
| 2024-08-09 | FDXS | Futures | 18052.4 | 18135.7 | 17958.0 | 18048.4 | 19784.0 |
| 2024-08-09 | FESX | Futures | 4724.9 | 4763.2 | 4703.7 | 4730.0 | 572364.0 |
| 2024-08-09 | FEU3 | Futures | 97.654 | 97.654 | 97.639 | 97.649 | 450.0 |
| 2024-08-09 | FGBL | Futures | 135.67 | 136.1 | 135.57 | 135.98 | 513278.0 |
| 2024-08-09 | FGBM | Futures | 118.74 | 118.87 | 118.64 | 118.81 | 364971.0 |
| 2024-08-09 | FGBS | Futures | 107.124 | 107.139 | 107.054 | 107.104 | 338971.0 |
| 2024-08-09 | FGBX | Futures | 136.11 | 137.55 | 136.02 | 137.29 | 59290.0 |
| 2024-08-09 | FMWO | Futures | 11423.5 | 11469.6 | 11351.2 | 11406.7 | 7093.0 |
| 2024-08-09 | FOAT | Futures | 125.6 | 126.12 | 125.58 | 126.0 | 108081.0 |
| 2024-08-09 | FSMX | Futures | 24502.6 | 24755.7 | 24468.3 | 24527.8 | 98.0 |
| 2024-08-09 | FTDX | Futures | 3353.0 | 3353.0 | 3345.9 | 3345.9 | 2.0 |
| 2024-08-09 | FTI | Futures | 900.61 | 902.49 | 891.36 | 896.93 | 9714.0 |
| 2024-08-09 | FTUK | Futures | 8195.6 | 8234.7 | 8166.0 | 8201.1 | 59272.0 |
> showing 50 of 130 rows — these rows as CSV