PREVIEW / futures_daily / 2023-11-02
file: by_date/futures_daily/2023/2023-11-02.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 |
|---|---|---|---|---|---|---|---|
| 2023-11-02 | ES | Futures | 4558.19 | 4645.16 | 4557.39 | 4640.88 | 1819596.0 |
| 2023-11-02 | NQ | Futures | 15930.64 | 16206.92 | 15929.29 | 16186.14 | 652481.0 |
| 2023-11-02 | YM | Futures | 35104.6 | 35710.8 | 35083.6 | 35689.7 | 187248.0 |
| 2023-11-02 | CL | Futures | 72.35 | 74.15 | 71.81 | 73.82 | 307122.0 |
| 2023-11-02 | GC | Futures | 2144.8 | 2152.5 | 2138.6 | 2146.4 | 158650.0 |
| 2023-11-02 | ZN | Futures | 108.694013 | 109.375232 | 108.567275 | 108.979175 | 2451045.0 |
| 2023-11-02 | A6 | Futures | 0.64594 | 0.65174 | 0.64584 | 0.64917 | 150693.0 |
| 2023-11-02 | AD | Futures | 0.72811 | 0.73431 | 0.72806 | 0.73346 | 90360.0 |
| 2023-11-02 | ALI | Futures | 2463.75 | 2464.02 | 2433.89 | 2436.63 | 7398.0 |
| 2023-11-02 | B | Futures | 77.28 | 79.14 | 76.95 | 78.96 | 301873.0 |
| 2023-11-02 | B6 | Futures | 1.2162 | 1.2236 | 1.216 | 1.2214 | 132467.0 |
| 2023-11-02 | BR | Futures | 0.18921 | 0.19195 | 0.18921 | 0.19147 | 5174.0 |
| 2023-11-02 | BTC | Futures | 46941.3 | 47944.1 | 45342.0 | 46272.7 | 10328.0 |
| 2023-11-02 | BZ | Futures | 76.87 | 78.77 | 76.58 | 78.6 | 31512.0 |
| 2023-11-02 | C | Futures | 2778.0 | 2814.0 | 2775.0 | 2811.0 | 5396.0 |
| 2023-11-02 | CB | Futures | 265.472 | 268.443 | 265.472 | 265.496 | 22.0 |
| 2023-11-02 | CC | Futures | 2223.0 | 2256.0 | 2222.0 | 2255.0 | 19046.0 |
| 2023-11-02 | CNH | Futures | 7.0871 | 7.089 | 7.076 | 7.0837 | 561.0 |
| 2023-11-02 | CSC | Futures | 1.945 | 1.956 | 1.939 | 1.95 | 29.0 |
| 2023-11-02 | CT | Futures | 96.99 | 98.54 | 96.91 | 97.3 | 24071.0 |
| 2023-11-02 | DC | Futures | 18.43 | 18.75 | 18.42 | 18.67 | 339.0 |
| 2023-11-02 | DX | Futures | 104.895 | 104.895 | 104.219 | 104.542 | 16204.0 |
| 2023-11-02 | E1 | Futures | 1.16149 | 1.16894 | 1.16123 | 1.1638 | 19780.0 |
| 2023-11-02 | E6 | Futures | 1.07739 | 1.08726 | 1.07729 | 1.08299 | 222819.0 |
| 2023-11-02 | E7 | Futures | 1.0776 | 1.0874 | 1.0776 | 1.0832 | 4806.0 |
| 2023-11-02 | EBM | Futures | 315.96 | 320.42 | 315.27 | 318.7 | 21495.0 |
| 2023-11-02 | ER | Futures | 97.812 | 97.822 | 97.802 | 97.807 | 140410.0 |
| 2023-11-02 | ESG | Futures | 395.96 | 402.49 | 395.96 | 402.43 | 530.0 |
| 2023-11-02 | EW | Futures | 2499.5 | 2555.1 | 2499.5 | 2553.6 | 15120.0 |
| 2023-11-02 | FBON | Futures | 119.6 | 120.28 | 119.21 | 119.65 | 250.0 |
| 2023-11-02 | FBTP | Futures | 109.78 | 111.02 | 109.59 | 110.33 | 292341.0 |
| 2023-11-02 | FBTS | Futures | 105.967 | 106.159 | 105.875 | 105.926 | 157937.0 |
| 2023-11-02 | FCE | Futures | 7444.0 | 7582.1 | 7443.4 | 7541.6 | 66780.0 |
| 2023-11-02 | FDAX | Futures | 15874.5 | 16113.7 | 15868.2 | 16029.4 | 73242.0 |
| 2023-11-02 | FDIV | Futures | 168.43 | 169.43 | 168.43 | 169.43 | 45.0 |
| 2023-11-02 | FDXM | Futures | 15875.7 | 16110.5 | 15862.0 | 16023.1 | 46654.0 |
| 2023-11-02 | FDXS | Futures | 15767.8 | 15999.0 | 15757.3 | 15918.4 | 29492.0 |
| 2023-11-02 | FESX | Futures | 4158.3 | 4232.8 | 4155.2 | 4211.6 | 1205927.0 |
| 2023-11-02 | FEU3 | Futures | 97.802 | 97.802 | 97.802 | 97.802 | 0.0 |
| 2023-11-02 | FGBL | Futures | 132.05 | 132.56 | 131.63 | 132.07 | 1405238.0 |
| 2023-11-02 | FGBM | Futures | 118.07 | 118.19 | 117.85 | 117.91 | 1003869.0 |
| 2023-11-02 | FGBS | Futures | 107.351 | 107.387 | 107.223 | 107.254 | 865769.0 |
| 2023-11-02 | FGBX | Futures | 124.97 | 126.73 | 124.21 | 125.95 | 161838.0 |
| 2023-11-02 | FMWO | Futures | 9721.3 | 9886.9 | 9718.0 | 9833.9 | 8642.0 |
| 2023-11-02 | FOAT | Futures | 122.88 | 123.53 | 122.51 | 123.08 | 348108.0 |
| 2023-11-02 | FSMX | Futures | 25110.4 | 25729.7 | 25101.1 | 25557.2 | 780.0 |
| 2023-11-02 | FTDX | Futures | 3038.9 | 3074.7 | 3038.9 | 3043.0 | 238.0 |
| 2023-11-02 | FTI | Futures | 746.29 | 760.3 | 745.21 | 756.91 | 18820.0 |
| 2023-11-02 | FTUK | Futures | 7450.6 | 7540.2 | 7440.0 | 7513.0 | 124204.0 |
| 2023-11-02 | FVSA | Futures | 24.84 | 25.05 | 23.88 | 24.36 | 29124.0 |
> showing 50 of 129 rows — these rows as CSV