PREVIEW / futures_daily / 2024-11-19
file: by_date/futures_daily/2024/2024-11-19.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-11-19 | ES | Futures | 6055.39 | 6084.55 | 5989.92 | 6075.6 | 1636346.0 |
| 2024-11-19 | NQ | Futures | 21163.87 | 21327.22 | 20906.68 | 21301.83 | 553617.0 |
| 2024-11-19 | YM | Futures | 43997.6 | 44080.5 | 43442.8 | 43856.1 | 124808.0 |
| 2024-11-19 | CL | Futures | 67.15 | 67.79 | 66.57 | 67.31 | 349702.0 |
| 2024-11-19 | GC | Futures | 2671.3 | 2699.0 | 2669.2 | 2686.3 | 202241.0 |
| 2024-11-19 | ZN | Futures | 109.747829 | 110.27975 | 109.732184 | 109.9825 | 2172126.0 |
| 2024-11-19 | A6 | Futures | 0.6505 | 0.65325 | 0.64815 | 0.65295 | 90720.0 |
| 2024-11-19 | AD | Futures | 0.71567 | 0.71872 | 0.71461 | 0.71827 | 93796.0 |
| 2024-11-19 | ALI | Futures | 2615.35 | 2660.54 | 2614.59 | 2653.18 | 2181.0 |
| 2024-11-19 | B | Futures | 72.58 | 73.3 | 72.05 | 72.74 | 354131.0 |
| 2024-11-19 | B6 | Futures | 1.2676 | 1.2684 | 1.2607 | 1.2671 | 100900.0 |
| 2024-11-19 | BFX | Futures | 4101.2 | 4101.2 | 4101.2 | 4101.2 | 0.0 |
| 2024-11-19 | BR | Futures | 0.16937 | 0.16947 | 0.16791 | 0.16869 | 14029.0 |
| 2024-11-19 | BTC | Futures | 99291.1 | 102399.3 | 98134.3 | 100610.1 | 14591.0 |
| 2024-11-19 | BZ | Futures | 71.16 | 71.84 | 70.61 | 71.29 | 32668.0 |
| 2024-11-19 | C | Futures | 6793.0 | 7143.0 | 6779.0 | 7094.0 | 5301.0 |
| 2024-11-19 | CB | Futures | 269.771 | 270.782 | 269.745 | 269.745 | 29.0 |
| 2024-11-19 | CC | Futures | 7177.0 | 7520.0 | 7105.0 | 7437.0 | 10162.0 |
| 2024-11-19 | CNH | Futures | 7.1991 | 7.2166 | 7.1967 | 7.2061 | 2044.0 |
| 2024-11-19 | CSC | Futures | 1.966 | 1.993 | 1.895 | 1.918 | 355.0 |
| 2024-11-19 | CT | Futures | 73.02 | 73.54 | 72.35 | 73.33 | 12141.0 |
| 2024-11-19 | DC | Futures | 19.36 | 19.63 | 18.69 | 18.93 | 1507.0 |
| 2024-11-19 | DX | Futures | 105.89 | 106.279 | 105.745 | 105.853 | 18174.0 |
| 2024-11-19 | E1 | Futures | 1.14576 | 1.15031 | 1.14465 | 1.14677 | 28374.0 |
| 2024-11-19 | E6 | Futures | 1.06562 | 1.06572 | 1.05789 | 1.06497 | 218122.0 |
| 2024-11-19 | E7 | Futures | 1.0652 | 1.0653 | 1.0576 | 1.0646 | 6394.0 |
| 2024-11-19 | EBM | Futures | 239.33 | 240.7 | 236.33 | 238.24 | 19910.0 |
| 2024-11-19 | ER | Futures | 97.795 | 97.805 | 97.775 | 97.785 | 215014.0 |
| 2024-11-19 | ESG | Futures | 522.93 | 524.63 | 516.87 | 524.01 | 344.0 |
| 2024-11-19 | EW | Futures | 3258.5 | 3266.4 | 3216.7 | 3261.6 | 8948.0 |
| 2024-11-19 | FBON | Futures | 124.8 | 125.32 | 124.78 | 124.88 | 68.0 |
| 2024-11-19 | FBTP | Futures | 119.96 | 120.37 | 119.57 | 119.93 | 265409.0 |
| 2024-11-19 | FBTS | Futures | 107.24 | 107.35 | 107.16 | 107.25 | 171477.0 |
| 2024-11-19 | FCE | Futures | 7346.8 | 7361.8 | 7191.3 | 7288.9 | 46943.0 |
| 2024-11-19 | FDAX | Futures | 19395.1 | 19500.1 | 19052.8 | 19305.2 | 63450.0 |
| 2024-11-19 | FDIV | Futures | 182.67 | 182.67 | 182.67 | 182.67 | 0.0 |
| 2024-11-19 | FDXM | Futures | 19363.2 | 19456.9 | 19009.5 | 19263.4 | 42686.0 |
| 2024-11-19 | FDXS | Futures | 19330.9 | 19413.3 | 18969.0 | 19220.3 | 44100.0 |
| 2024-11-19 | FESX | Futures | 4797.7 | 4828.7 | 4706.5 | 4770.6 | 888790.0 |
| 2024-11-19 | FEU3 | Futures | 97.795 | 97.8 | 97.785 | 97.785 | 26487.0 |
| 2024-11-19 | FGBL | Futures | 133.78 | 134.72 | 133.78 | 134.05 | 1268129.0 |
| 2024-11-19 | FGBM | Futures | 117.86 | 118.37 | 117.85 | 118.0 | 872764.0 |
| 2024-11-19 | FGBS | Futures | 107.024 | 107.189 | 107.024 | 107.084 | 990300.0 |
| 2024-11-19 | FGBX | Futures | 133.6 | 135.79 | 133.6 | 134.22 | 137262.0 |
| 2024-11-19 | FMWO | Futures | 12289.8 | 12307.5 | 12131.3 | 12275.3 | 8016.0 |
| 2024-11-19 | FOAT | Futures | 124.42 | 125.12 | 124.28 | 124.58 | 247124.0 |
| 2024-11-19 | FSMX | Futures | 26399.7 | 26399.7 | 25940.5 | 26211.6 | 520.0 |
| 2024-11-19 | FTDX | Futures | 3363.0 | 3370.1 | 3338.2 | 3370.1 | 21.0 |
| 2024-11-19 | FTI | Futures | 870.4 | 873.11 | 858.04 | 865.89 | 10922.0 |
| 2024-11-19 | FTUK | Futures | 8157.1 | 8188.1 | 8087.9 | 8137.5 | 68622.0 |
> showing 50 of 130 rows — these rows as CSV