PREVIEW / futures_daily / 2024-07-17
file: by_date/futures_daily/2024/2024-07-17.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-17 | ES | Futures | 5903.03 | 5905.87 | 5817.04 | 5824.53 | 2059862.0 |
| 2024-07-17 | NQ | Futures | 21339.8 | 21346.79 | 20691.81 | 20724.71 | 854323.0 |
| 2024-07-17 | YM | Futures | 42062.7 | 42366.6 | 41906.7 | 42316.6 | 174716.0 |
| 2024-07-17 | CL | Futures | 74.04 | 75.72 | 73.68 | 75.54 | 419583.0 |
| 2024-07-17 | GC | Futures | 2585.7 | 2601.6 | 2567.2 | 2571.8 | 259540.0 |
| 2024-07-17 | ZN | Futures | 111.988352 | 112.051179 | 111.689926 | 112.019765 | 1811339.0 |
| 2024-07-17 | A6 | Futures | 0.67535 | 0.6775 | 0.6741 | 0.6746 | 96046.0 |
| 2024-07-17 | AD | Futures | 0.7361 | 0.737 | 0.73459 | 0.73524 | 67519.0 |
| 2024-07-17 | ALI | Futures | 2448.92 | 2461.04 | 2431.64 | 2437.57 | 4974.0 |
| 2024-07-17 | B | Futures | 80.54 | 82.02 | 80.32 | 81.91 | 325399.0 |
| 2024-07-17 | B6 | Futures | 1.2975 | 1.3046 | 1.2969 | 1.3008 | 116103.0 |
| 2024-07-17 | BFX | Futures | 4005.3 | 4005.3 | 4005.3 | 4005.3 | 0.0 |
| 2024-07-17 | BR | Futures | 0.17629 | 0.17629 | 0.17499 | 0.17499 | 62.0 |
| 2024-07-17 | BTC | Futures | 73859.4 | 75557.6 | 72959.0 | 73773.9 | 8505.0 |
| 2024-07-17 | BZ | Futures | 79.09 | 80.37 | 78.71 | 80.26 | 44273.0 |
| 2024-07-17 | C | Futures | 6447.0 | 6585.0 | 6218.0 | 6248.0 | 5216.0 |
| 2024-07-17 | CB | Futures | 303.961 | 306.85 | 303.961 | 306.85 | 17.0 |
| 2024-07-17 | CC | Futures | 5578.0 | 5582.0 | 5324.0 | 5438.0 | 10306.0 |
| 2024-07-17 | CNH | Futures | 7.1666 | 7.173 | 7.1394 | 7.1522 | 1550.0 |
| 2024-07-17 | CSC | Futures | 1.946 | 1.961 | 1.946 | 1.957 | 156.0 |
| 2024-07-17 | CT | Futures | 79.76 | 80.92 | 79.76 | 79.89 | 28.0 |
| 2024-07-17 | DC | Futures | 18.77 | 18.94 | 18.73 | 18.85 | 389.0 |
| 2024-07-17 | DX | Futures | 103.368 | 103.453 | 102.811 | 102.913 | 22158.0 |
| 2024-07-17 | E1 | Futures | 1.14795 | 1.16242 | 1.14714 | 1.16124 | 48668.0 |
| 2024-07-17 | E6 | Futures | 1.10128 | 1.10627 | 1.10088 | 1.10516 | 230558.0 |
| 2024-07-17 | E7 | Futures | 1.101 | 1.106 | 1.1005 | 1.1048 | 3486.0 |
| 2024-07-17 | EBM | Futures | 250.28 | 253.49 | 249.41 | 251.16 | 29679.0 |
| 2024-07-17 | ER | Futures | 97.568 | 97.568 | 97.553 | 97.553 | 85628.0 |
| 2024-07-17 | ESG | Futures | 506.91 | 506.91 | 503.63 | 504.25 | 348.0 |
| 2024-07-17 | EW | Futures | 3196.9 | 3202.0 | 3149.9 | 3150.9 | 12378.0 |
| 2024-07-17 | FBON | Futures | 123.79 | 124.15 | 123.67 | 123.8 | 950.0 |
| 2024-07-17 | FBTP | Futures | 118.15 | 118.34 | 117.77 | 117.92 | 273129.0 |
| 2024-07-17 | FBTS | Futures | 106.606 | 106.616 | 106.444 | 106.475 | 134855.0 |
| 2024-07-17 | FCE | Futures | 7781.1 | 7816.4 | 7731.9 | 7781.1 | 55223.0 |
| 2024-07-17 | FDAX | Futures | 19137.6 | 19142.7 | 18900.3 | 19002.6 | 40244.0 |
| 2024-07-17 | FDIV | Futures | 187.21 | 188.5 | 187.21 | 188.25 | 11.0 |
| 2024-07-17 | FDXM | Futures | 19056.6 | 19056.6 | 18813.3 | 18914.1 | 26735.0 |
| 2024-07-17 | FDXS | Futures | 19008.9 | 19008.9 | 18763.1 | 18864.7 | 30703.0 |
| 2024-07-17 | FESX | Futures | 5038.5 | 5038.5 | 4947.7 | 4967.9 | 778224.0 |
| 2024-07-17 | FEU3 | Futures | 97.573 | 97.573 | 97.558 | 97.563 | 813.0 |
| 2024-07-17 | FGBL | Futures | 133.87 | 134.04 | 133.62 | 133.87 | 738455.0 |
| 2024-07-17 | FGBM | Futures | 117.56 | 117.61 | 117.37 | 117.48 | 559578.0 |
| 2024-07-17 | FGBS | Futures | 106.57 | 106.59 | 106.495 | 106.535 | 424850.0 |
| 2024-07-17 | FGBX | Futures | 132.99 | 133.61 | 132.77 | 133.25 | 92936.0 |
| 2024-07-17 | FMWO | Futures | 12096.1 | 12100.3 | 12005.0 | 12038.5 | 8211.0 |
| 2024-07-17 | FOAT | Futures | 124.82 | 124.88 | 124.58 | 124.77 | 187339.0 |
| 2024-07-17 | FSMX | Futures | 26016.1 | 26018.1 | 25804.4 | 25965.7 | 114.0 |
| 2024-07-17 | FTDX | Futures | 3455.0 | 3455.0 | 3437.2 | 3447.4 | 13.0 |
| 2024-07-17 | FTI | Futures | 946.41 | 947.12 | 926.49 | 930.14 | 15215.0 |
| 2024-07-17 | FTUK | Futures | 8232.2 | 8246.7 | 8166.5 | 8228.6 | 83204.0 |
> showing 50 of 130 rows — these rows as CSV