PREVIEW / futures_daily / 2024-07-09
file: by_date/futures_daily/2024/2024-07-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-07-09 | ES | Futures | 5812.91 | 5831.5 | 5811.36 | 5816.53 | 1063568.0 |
| 2024-07-09 | NQ | Futures | 21433.07 | 21527.12 | 21365.45 | 21430.48 | 569689.0 |
| 2024-07-09 | YM | Futures | 40453.5 | 40604.5 | 40229.2 | 40378.1 | 128209.0 |
| 2024-07-09 | CL | Futures | 75.11 | 75.34 | 74.22 | 74.37 | 297325.0 |
| 2024-07-09 | GC | Futures | 2474.2 | 2486.5 | 2463.2 | 2475.7 | 252489.0 |
| 2024-07-09 | ZN | Futures | 111.077367 | 111.140193 | 110.794647 | 110.983127 | 1622679.0 |
| 2024-07-09 | A6 | Futures | 0.676 | 0.677 | 0.67455 | 0.6762 | 74753.0 |
| 2024-07-09 | AD | Futures | 0.73831 | 0.73866 | 0.73755 | 0.73856 | 58291.0 |
| 2024-07-09 | ALI | Futures | 2572.18 | 2590.39 | 2544.08 | 2550.06 | 2152.0 |
| 2024-07-09 | B | Futures | 82.48 | 82.65 | 81.38 | 81.5 | 354292.0 |
| 2024-07-09 | B6 | Futures | 1.281 | 1.2828 | 1.2781 | 1.279 | 85074.0 |
| 2024-07-09 | BFX | Futures | 3984.5 | 3984.5 | 3984.5 | 3984.5 | 0.0 |
| 2024-07-09 | BR | Futures | 0.17586 | 0.17716 | 0.17586 | 0.17711 | 25.0 |
| 2024-07-09 | BTC | Futures | 64764.4 | 66753.2 | 64439.6 | 66286.0 | 7065.0 |
| 2024-07-09 | BZ | Futures | 80.83 | 80.99 | 79.75 | 79.86 | 44667.0 |
| 2024-07-09 | C | Futures | 6465.0 | 6703.0 | 6193.0 | 6678.0 | 1001.0 |
| 2024-07-09 | CB | Futures | 305.903 | 306.85 | 305.417 | 306.364 | 51.0 |
| 2024-07-09 | CC | Futures | 5515.0 | 5845.0 | 5269.0 | 5709.0 | 8413.0 |
| 2024-07-09 | CNH | Futures | 7.1606 | 7.17 | 7.1606 | 7.1646 | 493.0 |
| 2024-07-09 | CSC | Futures | 1.989 | 2.002 | 1.958 | 1.966 | 80.0 |
| 2024-07-09 | CT | Futures | 78.17 | 78.17 | 77.26 | 77.66 | 32.0 |
| 2024-07-09 | DC | Futures | 19.15 | 19.3 | 18.82 | 19.01 | 301.0 |
| 2024-07-09 | DX | Futures | 104.129 | 104.353 | 104.089 | 104.27 | 9864.0 |
| 2024-07-09 | E1 | Futures | 1.14418 | 1.1451 | 1.1424 | 1.14388 | 17811.0 |
| 2024-07-09 | E6 | Futures | 1.09413 | 1.09504 | 1.09227 | 1.09302 | 121229.0 |
| 2024-07-09 | E7 | Futures | 1.0939 | 1.0946 | 1.092 | 1.0927 | 1830.0 |
| 2024-07-09 | EBM | Futures | 260.21 | 264.59 | 257.29 | 264.01 | 38064.0 |
| 2024-07-09 | ER | Futures | 97.528 | 97.538 | 97.523 | 97.533 | 165853.0 |
| 2024-07-09 | ESG | Futures | 502.03 | 503.13 | 501.85 | 502.21 | 415.0 |
| 2024-07-09 | EW | Futures | 2987.8 | 2991.0 | 2962.3 | 2964.3 | 10169.0 |
| 2024-07-09 | FBON | Futures | 122.79 | 122.87 | 122.17 | 122.2 | 156.0 |
| 2024-07-09 | FBTP | Futures | 116.41 | 116.45 | 115.87 | 115.94 | 212046.0 |
| 2024-07-09 | FBTS | Futures | 106.112 | 106.142 | 106.031 | 106.041 | 148447.0 |
| 2024-07-09 | FCE | Futures | 7857.4 | 7874.9 | 7714.8 | 7740.5 | 71441.0 |
| 2024-07-09 | FDAX | Futures | 19072.1 | 19080.3 | 18779.6 | 18786.8 | 44372.0 |
| 2024-07-09 | FDIV | Futures | 185.56 | 185.56 | 185.11 | 185.51 | 2.0 |
| 2024-07-09 | FDXM | Futures | 18972.1 | 18991.5 | 18691.2 | 18699.3 | 29257.0 |
| 2024-07-09 | FDXS | Futures | 18918.5 | 18956.1 | 18643.3 | 18650.4 | 26069.0 |
| 2024-07-09 | FESX | Futures | 5048.6 | 5051.6 | 4968.9 | 4971.9 | 775195.0 |
| 2024-07-09 | FEU3 | Futures | 97.533 | 97.543 | 97.528 | 97.538 | 1506.0 |
| 2024-07-09 | FGBL | Futures | 132.62 | 132.67 | 132.14 | 132.22 | 851750.0 |
| 2024-07-09 | FGBM | Futures | 116.9 | 116.92 | 116.67 | 116.71 | 580514.0 |
| 2024-07-09 | FGBS | Futures | 106.313 | 106.313 | 106.248 | 106.258 | 405186.0 |
| 2024-07-09 | FGBX | Futures | 130.59 | 130.73 | 129.37 | 129.55 | 110639.0 |
| 2024-07-09 | FMWO | Futures | 11952.6 | 11985.1 | 11931.6 | 11936.9 | 2934.0 |
| 2024-07-09 | FOAT | Futures | 123.83 | 123.87 | 122.99 | 123.05 | 284614.0 |
| 2024-07-09 | FSMX | Futures | 25894.1 | 25904.2 | 25579.5 | 25588.6 | 151.0 |
| 2024-07-09 | FTDX | Futures | 3465.7 | 3476.4 | 3413.7 | 3417.3 | 29.0 |
| 2024-07-09 | FTI | Futures | 947.99 | 951.84 | 944.19 | 945.09 | 10706.0 |
| 2024-07-09 | FTUK | Futures | 8266.8 | 8266.8 | 8176.5 | 8182.5 | 87743.0 |
> showing 50 of 130 rows — these rows as CSV