PREVIEW / futures_daily / 2024-10-21
file: by_date/futures_daily/2024/2024-10-21.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-10-21 | ES | Futures | 6047.72 | 6051.81 | 6000.15 | 6032.12 | 1063780.0 |
| 2024-10-21 | NQ | Futures | 21023.35 | 21083.1 | 20866.93 | 21047.2 | 456078.0 |
| 2024-10-21 | YM | Futures | 43998.6 | 44036.0 | 43564.1 | 43630.8 | 112154.0 |
| 2024-10-21 | CL | Futures | 66.72 | 68.13 | 66.26 | 67.79 | 302745.0 |
| 2024-10-21 | GC | Futures | 2793.9 | 2813.4 | 2785.9 | 2796.5 | 210450.0 |
| 2024-10-21 | ZN | Futures | 112.313566 | 112.3605 | 111.578263 | 111.656487 | 2004525.0 |
| 2024-10-21 | A6 | Futures | 0.67079 | 0.67244 | 0.66539 | 0.66554 | 69955.0 |
| 2024-10-21 | AD | Futures | 0.72724 | 0.72749 | 0.72484 | 0.72529 | 54160.0 |
| 2024-10-21 | ALI | Futures | 2666.75 | 2699.24 | 2620.19 | 2628.64 | 2524.0 |
| 2024-10-21 | B | Futures | 72.46 | 73.91 | 72.16 | 73.63 | 279248.0 |
| 2024-10-21 | B6 | Futures | 1.3045 | 1.3052 | 1.2971 | 1.2973 | 59238.0 |
| 2024-10-21 | BFX | Futures | 4312.2 | 4312.2 | 4312.2 | 4312.2 | 0.0 |
| 2024-10-21 | BR | Futures | 0.17045 | 0.17054 | 0.17006 | 0.1702 | 63.0 |
| 2024-10-21 | BTC | Futures | 75729.8 | 76101.4 | 73063.2 | 74085.1 | 14146.0 |
| 2024-10-21 | BZ | Futures | 70.95 | 72.33 | 70.62 | 72.07 | 29891.0 |
| 2024-10-21 | C | Futures | 5498.0 | 5576.0 | 5393.0 | 5493.0 | 4107.0 |
| 2024-10-21 | CB | Futures | 285.333 | 288.16 | 285.307 | 287.693 | 17.0 |
| 2024-10-21 | CC | Futures | 6023.0 | 6256.0 | 5986.0 | 6055.0 | 6440.0 |
| 2024-10-21 | CNH | Futures | 7.0582 | 7.0816 | 7.0518 | 7.0816 | 971.0 |
| 2024-10-21 | CSC | Futures | 2.188 | 2.194 | 2.112 | 2.159 | 192.0 |
| 2024-10-21 | CT | Futures | 77.89 | 79.59 | 77.83 | 79.15 | 24054.0 |
| 2024-10-21 | DC | Futures | 21.3 | 21.39 | 20.68 | 21.04 | 576.0 |
| 2024-10-21 | DX | Futures | 103.038 | 103.561 | 102.963 | 103.55 | 16341.0 |
| 2024-10-21 | E1 | Futures | 1.17458 | 1.17645 | 1.17231 | 1.17251 | 14578.0 |
| 2024-10-21 | E6 | Futures | 1.09389 | 1.09434 | 1.08817 | 1.08827 | 145945.0 |
| 2024-10-21 | E7 | Futures | 1.0937 | 1.0938 | 1.0878 | 1.0879 | 2480.0 |
| 2024-10-21 | EBM | Futures | 248.62 | 249.17 | 244.25 | 245.07 | 29507.0 |
| 2024-10-21 | ER | Futures | 97.805 | 97.81 | 97.775 | 97.78 | 264987.0 |
| 2024-10-21 | ESG | Futures | 520.08 | 520.72 | 517.51 | 520.12 | 542.0 |
| 2024-10-21 | EW | Futures | 3252.3 | 3260.0 | 3206.6 | 3213.8 | 6550.0 |
| 2024-10-21 | FBON | Futures | 126.6 | 126.6 | 125.18 | 125.32 | 129.0 |
| 2024-10-21 | FBTP | Futures | 121.85 | 121.88 | 120.32 | 120.4 | 398450.0 |
| 2024-10-21 | FBTS | Futures | 107.66 | 107.66 | 107.36 | 107.38 | 184738.0 |
| 2024-10-21 | FCE | Futures | 7618.7 | 7637.2 | 7545.2 | 7552.2 | 32211.0 |
| 2024-10-21 | FDAX | Futures | 19975.7 | 19975.7 | 19759.6 | 19764.7 | 37237.0 |
| 2024-10-21 | FDIV | Futures | 194.53 | 194.53 | 194.53 | 194.53 | 0.0 |
| 2024-10-21 | FDXM | Futures | 19921.4 | 19929.4 | 19715.8 | 19721.9 | 23507.0 |
| 2024-10-21 | FDXS | Futures | 19871.7 | 19883.8 | 19672.7 | 19677.7 | 21147.0 |
| 2024-10-21 | FESX | Futures | 5015.0 | 5016.0 | 4961.9 | 4964.9 | 460930.0 |
| 2024-10-21 | FEU3 | Futures | 97.805 | 97.805 | 97.78 | 97.78 | 18383.0 |
| 2024-10-21 | FGBL | Futures | 135.8 | 135.93 | 134.79 | 134.89 | 1154407.0 |
| 2024-10-21 | FGBM | Futures | 118.88 | 118.94 | 118.36 | 118.39 | 752997.0 |
| 2024-10-21 | FGBS | Futures | 107.285 | 107.315 | 107.144 | 107.149 | 741739.0 |
| 2024-10-21 | FGBX | Futures | 134.87 | 135.25 | 132.38 | 132.78 | 118636.0 |
| 2024-10-21 | FMWO | Futures | 12397.6 | 12397.6 | 12290.9 | 12295.0 | 7804.0 |
| 2024-10-21 | FOAT | Futures | 126.26 | 126.33 | 125.08 | 125.21 | 231641.0 |
| 2024-10-21 | FSMX | Futures | 27488.1 | 27642.2 | 27307.0 | 27307.0 | 27.0 |
| 2024-10-21 | FTDX | Futures | 3455.2 | 3455.2 | 3455.2 | 3455.2 | 0.0 |
| 2024-10-21 | FTI | Futures | 910.76 | 914.14 | 905.21 | 905.74 | 6183.0 |
| 2024-10-21 | FTUK | Futures | 8426.1 | 8443.1 | 8364.5 | 8373.0 | 60649.0 |
> showing 50 of 130 rows — these rows as CSV