PREVIEW / futures_daily / 2024-08-22
file: by_date/futures_daily/2024/2024-08-22.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 |
|---|---|---|---|---|---|---|---|
| 2024-08-22 | ES | Futures | 5827.63 | 5851.65 | 5766.43 | 5778.05 | 1409474.0 |
| 2024-08-22 | NQ | Futures | 20645.69 | 20753.47 | 20252.65 | 20290.22 | 630179.0 |
| 2024-08-22 | YM | Futures | 41825.1 | 41972.0 | 41487.6 | 41634.4 | 127189.0 |
| 2024-08-22 | CL | Futures | 67.8 | 69.3 | 67.47 | 68.82 | 334117.0 |
| 2024-08-22 | GC | Futures | 2603.5 | 2605.1 | 2559.1 | 2569.6 | 177369.0 |
| 2024-08-22 | ZN | Futures | 114.328642 | 114.438588 | 113.763203 | 113.888856 | 3456441.0 |
| 2024-08-22 | A6 | Futures | 0.6759 | 0.6767 | 0.6711 | 0.67195 | 92233.0 |
| 2024-08-22 | AD | Futures | 0.73987 | 0.74112 | 0.73851 | 0.73931 | 98539.0 |
| 2024-08-22 | ALI | Futures | 2446.26 | 2530.02 | 2446.26 | 2481.31 | 4108.0 |
| 2024-08-22 | B | Futures | 73.97 | 75.67 | 73.79 | 75.2 | 277529.0 |
| 2024-08-22 | B6 | Futures | 1.309 | 1.313 | 1.3076 | 1.3092 | 113823.0 |
| 2024-08-22 | BFX | Futures | 4103.9 | 4103.9 | 4103.9 | 4103.9 | 0.0 |
| 2024-08-22 | BR | Futures | 0.176 | 0.176 | 0.17229 | 0.17234 | 23582.0 |
| 2024-08-22 | BTC | Futures | 68871.3 | 69196.6 | 67110.6 | 67682.5 | 9974.0 |
| 2024-08-22 | BZ | Futures | 72.66 | 74.13 | 72.29 | 73.67 | 33822.0 |
| 2024-08-22 | C | Futures | 6279.0 | 6306.0 | 6045.0 | 6270.0 | 1983.0 |
| 2024-08-22 | CB | Futures | 311.244 | 311.244 | 309.195 | 309.195 | 39.0 |
| 2024-08-22 | CC | Futures | 6293.0 | 6374.0 | 6092.0 | 6347.0 | 11138.0 |
| 2024-08-22 | CNH | Futures | 7.016 | 7.0397 | 7.016 | 7.0397 | 2102.0 |
| 2024-08-22 | CSC | Futures | 2.146 | 2.146 | 2.076 | 2.085 | 103.0 |
| 2024-08-22 | CT | Futures | 78.4 | 79.61 | 76.96 | 78.17 | 41.0 |
| 2024-08-22 | DC | Futures | 20.86 | 20.89 | 20.21 | 20.32 | 1061.0 |
| 2024-08-22 | DX | Futures | 100.498 | 100.985 | 100.418 | 100.88 | 15289.0 |
| 2024-08-22 | E1 | Futures | 1.19955 | 1.20321 | 1.197 | 1.19894 | 25023.0 |
| 2024-08-22 | E6 | Futures | 1.12466 | 1.12743 | 1.11942 | 1.12068 | 201295.0 |
| 2024-08-22 | E7 | Futures | 1.1241 | 1.1271 | 1.1192 | 1.1204 | 3290.0 |
| 2024-08-22 | EBM | Futures | 233.93 | 234.8 | 228.38 | 229.84 | 14723.0 |
| 2024-08-22 | ER | Futures | 97.644 | 97.654 | 97.629 | 97.634 | 103513.0 |
| 2024-08-22 | ESG | Futures | 502.67 | 504.63 | 495.7 | 496.46 | 573.0 |
| 2024-08-22 | EW | Futures | 3112.5 | 3127.2 | 3088.5 | 3094.6 | 6863.0 |
| 2024-08-22 | FBON | Futures | 125.66 | 125.78 | 125.05 | 125.17 | 168.0 |
| 2024-08-22 | FBTP | Futures | 119.43 | 119.66 | 118.82 | 118.92 | 233533.0 |
| 2024-08-22 | FBTS | Futures | 107.1 | 107.14 | 106.979 | 106.999 | 108803.0 |
| 2024-08-22 | FCE | Futures | 7675.4 | 7716.6 | 7641.9 | 7669.8 | 23886.0 |
| 2024-08-22 | FDAX | Futures | 18970.9 | 19033.2 | 18909.5 | 18970.9 | 29220.0 |
| 2024-08-22 | FDIV | Futures | 185.16 | 185.16 | 185.16 | 185.16 | 0.0 |
| 2024-08-22 | FDXM | Futures | 18882.6 | 18946.7 | 18822.5 | 18882.6 | 14350.0 |
| 2024-08-22 | FDXS | Futures | 18824.1 | 18896.1 | 18773.3 | 18833.2 | 11927.0 |
| 2024-08-22 | FESX | Futures | 4952.8 | 4968.9 | 4918.5 | 4941.7 | 444444.0 |
| 2024-08-22 | FEU3 | Futures | 97.644 | 97.654 | 97.639 | 97.639 | 1494.0 |
| 2024-08-22 | FGBL | Futures | 136.16 | 136.48 | 135.5 | 135.65 | 788638.0 |
| 2024-08-22 | FGBM | Futures | 118.8 | 118.96 | 118.49 | 118.55 | 479452.0 |
| 2024-08-22 | FGBS | Futures | 107.089 | 107.144 | 106.988 | 107.008 | 386702.0 |
| 2024-08-22 | FGBX | Futures | 137.86 | 138.28 | 136.29 | 136.69 | 95671.0 |
| 2024-08-22 | FMWO | Futures | 12052.1 | 12093.0 | 11934.8 | 12015.5 | 5479.0 |
| 2024-08-22 | FOAT | Futures | 126.52 | 126.87 | 125.9 | 126.05 | 159790.0 |
| 2024-08-22 | FSMX | Futures | 25227.6 | 25328.4 | 25227.6 | 25258.8 | 52.0 |
| 2024-08-22 | FTDX | Futures | 3416.2 | 3416.2 | 3416.2 | 3416.2 | 0.0 |
| 2024-08-22 | FTI | Futures | 917.05 | 923.56 | 914.38 | 918.43 | 5685.0 |
| 2024-08-22 | FTUK | Futures | 8333.9 | 8363.5 | 8309.9 | 8321.9 | 55047.0 |
> showing 50 of 129 rows — these rows as CSV