PREVIEW / futures_daily / 2024-06-20
file: by_date/futures_daily/2024/2024-06-20.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-06-20 | ES | Futures | 5744.74 | 5771.85 | 5707.3 | 5726.92 | 1811776.0 |
| 2024-06-20 | NQ | Futures | 20939.24 | 21111.8 | 20684.04 | 20759.95 | 897181.0 |
| 2024-06-20 | YM | Futures | 40050.7 | 40470.9 | 39969.2 | 40356.7 | 169379.0 |
| 2024-06-20 | CL | Futures | 73.76 | 74.47 | 73.35 | 74.26 | 420499.0 |
| 2024-06-20 | GC | Futures | 2450.9 | 2487.8 | 2444.9 | 2476.8 | 252687.0 |
| 2024-06-20 | ZN | Futures | 111.29726 | 111.407206 | 110.841767 | 111.124487 | 1722710.0 |
| 2024-06-20 | A6 | Futures | 0.66824 | 0.67049 | 0.66729 | 0.66864 | 128901.0 |
| 2024-06-20 | AD | Futures | 0.73414 | 0.73605 | 0.73369 | 0.7357 | 126737.0 |
| 2024-06-20 | ALI | Futures | 2584.41 | 2602.1 | 2567.24 | 2594.55 | 5983.0 |
| 2024-06-20 | B | Futures | 81.22 | 81.96 | 80.99 | 81.72 | 256456.0 |
| 2024-06-20 | B6 | Futures | 1.2713 | 1.2742 | 1.2658 | 1.2674 | 143130.0 |
| 2024-06-20 | BFX | Futures | 3930.5 | 3930.5 | 3930.5 | 3930.5 | 0.0 |
| 2024-06-20 | BR | Futures | 0.1761 | 0.17871 | 0.17417 | 0.1761 | 27.0 |
| 2024-06-20 | BTC | Futures | 74575.7 | 76274.5 | 73895.0 | 74472.7 | 9083.0 |
| 2024-06-20 | BZ | Futures | 79.87 | 80.42 | 79.41 | 80.18 | 52543.0 |
| 2024-06-20 | C | Futures | 7639.0 | 7763.0 | 7304.0 | 7353.0 | 1022.0 |
| 2024-06-20 | CB | Futures | 300.101 | 300.562 | 300.101 | 300.562 | 12.0 |
| 2024-06-20 | CC | Futures | 6637.0 | 6685.0 | 6165.0 | 6343.0 | 11013.0 |
| 2024-06-20 | CNH | Futures | 7.1315 | 7.1542 | 7.1295 | 7.1532 | 972.0 |
| 2024-06-20 | CSC | Futures | 1.946 | 1.988 | 1.946 | 1.968 | 65.0 |
| 2024-06-20 | CT | Futures | 83.76 | 84.9 | 83.38 | 83.57 | 5208.0 |
| 2024-06-20 | DC | Futures | 18.69 | 19.09 | 18.69 | 18.91 | 103.0 |
| 2024-06-20 | DX | Futures | 104.328 | 104.776 | 104.328 | 104.688 | 12504.0 |
| 2024-06-20 | E1 | Futures | 1.16461 | 1.16537 | 1.15299 | 1.15529 | 59235.0 |
| 2024-06-20 | E6 | Futures | 1.08672 | 1.08813 | 1.08269 | 1.0836 | 233132.0 |
| 2024-06-20 | E7 | Futures | 1.0864 | 1.0876 | 1.0824 | 1.0833 | 5166.0 |
| 2024-06-20 | EBM | Futures | 266.93 | 267.22 | 262.26 | 264.88 | 34148.0 |
| 2024-06-20 | ER | Futures | 97.487 | 97.503 | 97.477 | 97.498 | 115879.0 |
| 2024-06-20 | ESG | Futures | 497.58 | 497.58 | 492.54 | 493.64 | 1604.0 |
| 2024-06-20 | EW | Futures | 3017.8 | 3026.1 | 2998.8 | 3006.9 | 10565.0 |
| 2024-06-20 | FBON | Futures | 122.3 | 122.61 | 122.18 | 122.45 | 324.0 |
| 2024-06-20 | FBTP | Futures | 115.83 | 116.14 | 115.54 | 115.95 | 243707.0 |
| 2024-06-20 | FBTS | Futures | 105.85 | 105.971 | 105.799 | 105.92 | 115482.0 |
| 2024-06-20 | FCE | Futures | 7833.2 | 7935.1 | 7820.3 | 7921.7 | 57800.0 |
| 2024-06-20 | FDAX | Futures | 18676.3 | 18867.6 | 18676.3 | 18845.1 | 38777.0 |
| 2024-06-20 | FDIV | Futures | 185.46 | 185.96 | 185.46 | 185.96 | 2.0 |
| 2024-06-20 | FDXM | Futures | 18583.3 | 18779.7 | 18583.3 | 18757.4 | 12591.0 |
| 2024-06-20 | FDXS | Futures | 18538.8 | 18732.7 | 18538.8 | 18708.3 | 4580.0 |
| 2024-06-20 | FESX | Futures | 4968.9 | 5036.5 | 4961.9 | 5029.4 | 743977.0 |
| 2024-06-20 | FEU3 | Futures | 97.482 | 97.503 | 97.482 | 97.503 | 522.0 |
| 2024-06-20 | FGBL | Futures | 133.84 | 133.97 | 133.39 | 133.61 | 894398.0 |
| 2024-06-20 | FGBM | Futures | 117.47 | 117.55 | 117.28 | 117.38 | 630372.0 |
| 2024-06-20 | FGBS | Futures | 106.515 | 106.56 | 106.459 | 106.51 | 430245.0 |
| 2024-06-20 | FGBX | Futures | 134.4 | 134.64 | 133.03 | 133.55 | 86501.0 |
| 2024-06-20 | FMWO | Futures | 11811.2 | 11840.5 | 11756.7 | 11804.9 | 9861.0 |
| 2024-06-20 | FOAT | Futures | 123.56 | 123.83 | 123.37 | 123.68 | 286033.0 |
| 2024-06-20 | FSMX | Futures | 26034.3 | 26251.1 | 26034.3 | 26186.5 | 1223.0 |
| 2024-06-20 | FTDX | Futures | 3407.1 | 3416.8 | 3391.3 | 3406.6 | 336.0 |
| 2024-06-20 | FTI | Futures | 941.6 | 950.47 | 941.3 | 949.96 | 8558.0 |
| 2024-06-20 | FTUK | Futures | 8269.3 | 8357.5 | 8268.3 | 8339.9 | 97870.0 |
> showing 50 of 130 rows — these rows as CSV