PREVIEW / futures_daily / 2024-07-12
file: by_date/futures_daily/2024/2024-07-12.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-12 | ES | Futures | 5824.02 | 5896.06 | 5806.2 | 5851.13 | 1684437.0 |
| 2024-07-12 | NQ | Futures | 21175.79 | 21495.25 | 21074.49 | 21270.36 | 724343.0 |
| 2024-07-12 | YM | Futures | 40913.5 | 41373.4 | 40811.5 | 41097.0 | 150766.0 |
| 2024-07-12 | CL | Futures | 75.69 | 76.5 | 75.0 | 75.1 | 370062.0 |
| 2024-07-12 | GC | Futures | 2531.2 | 2533.5 | 2505.1 | 2530.9 | 220933.0 |
| 2024-07-12 | ZN | Futures | 111.595686 | 111.846992 | 111.375793 | 111.768459 | 1993977.0 |
| 2024-07-12 | A6 | Futures | 0.678 | 0.68151 | 0.6775 | 0.68091 | 105052.0 |
| 2024-07-12 | AD | Futures | 0.73846 | 0.73951 | 0.73796 | 0.73851 | 68465.0 |
| 2024-07-12 | ALI | Futures | 2519.36 | 2530.55 | 2506.09 | 2521.7 | 3883.0 |
| 2024-07-12 | B | Futures | 82.5 | 83.13 | 81.78 | 81.86 | 363928.0 |
| 2024-07-12 | B6 | Futures | 1.2917 | 1.2993 | 1.2905 | 1.2992 | 118440.0 |
| 2024-07-12 | BFX | Futures | 4029.7 | 4029.7 | 4029.7 | 4029.7 | 0.0 |
| 2024-07-12 | BR | Futures | 0.17629 | 0.17745 | 0.17567 | 0.17673 | 273.0 |
| 2024-07-12 | BTC | Futures | 65607.8 | 67004.0 | 64604.9 | 65926.9 | 6811.0 |
| 2024-07-12 | BZ | Futures | 80.74 | 81.45 | 80.15 | 80.21 | 48430.0 |
| 2024-07-12 | C | Futures | 6955.0 | 7019.0 | 6708.0 | 6752.0 | 3329.0 |
| 2024-07-12 | CB | Futures | 306.874 | 306.874 | 306.146 | 306.146 | 1.0 |
| 2024-07-12 | CC | Futures | 5973.0 | 6076.0 | 5774.0 | 5829.0 | 8591.0 |
| 2024-07-12 | CNH | Futures | 7.1429 | 7.1557 | 7.1429 | 7.1498 | 724.0 |
| 2024-07-12 | CSC | Futures | 1.94 | 1.954 | 1.926 | 1.929 | 53.0 |
| 2024-07-12 | CT | Futures | 77.62 | 77.62 | 76.72 | 77.42 | 34.0 |
| 2024-07-12 | DC | Futures | 18.83 | 18.9 | 18.54 | 18.56 | 287.0 |
| 2024-07-12 | DX | Futures | 103.507 | 103.731 | 103.194 | 103.252 | 15936.0 |
| 2024-07-12 | E1 | Futures | 1.1452 | 1.14912 | 1.14423 | 1.14729 | 25868.0 |
| 2024-07-12 | E6 | Futures | 1.09836 | 1.10269 | 1.09771 | 1.10219 | 203608.0 |
| 2024-07-12 | E7 | Futures | 1.0979 | 1.1022 | 1.0973 | 1.1018 | 2425.0 |
| 2024-07-12 | EBM | Futures | 259.33 | 259.63 | 254.95 | 257.0 | 26478.0 |
| 2024-07-12 | ER | Futures | 97.558 | 97.573 | 97.553 | 97.573 | 132159.0 |
| 2024-07-12 | ESG | Futures | 503.75 | 509.55 | 503.55 | 506.15 | 837.0 |
| 2024-07-12 | EW | Futures | 3077.2 | 3117.1 | 3075.5 | 3099.1 | 12644.0 |
| 2024-07-12 | FBON | Futures | 123.1 | 123.36 | 123.03 | 123.19 | 129.0 |
| 2024-07-12 | FBTP | Futures | 117.11 | 117.53 | 117.0 | 117.33 | 198534.0 |
| 2024-07-12 | FBTS | Futures | 106.384 | 106.454 | 106.344 | 106.404 | 142673.0 |
| 2024-07-12 | FCE | Futures | 7859.4 | 7950.6 | 7859.4 | 7938.3 | 2045.0 |
| 2024-07-12 | FDAX | Futures | 19084.4 | 19358.5 | 19084.4 | 19347.2 | 39760.0 |
| 2024-07-12 | FDIV | Futures | 189.55 | 190.55 | 189.15 | 190.5 | 12.0 |
| 2024-07-12 | FDXM | Futures | 18993.5 | 19267.4 | 18989.5 | 19257.2 | 24622.0 |
| 2024-07-12 | FDXS | Futures | 18948.9 | 19218.0 | 18836.2 | 19206.8 | 20464.0 |
| 2024-07-12 | FESX | Futures | 5043.5 | 5129.2 | 5043.5 | 5127.2 | 684631.0 |
| 2024-07-12 | FEU3 | Futures | 97.568 | 97.578 | 97.563 | 97.578 | 6359.0 |
| 2024-07-12 | FGBL | Futures | 133.06 | 133.23 | 132.73 | 133.1 | 658977.0 |
| 2024-07-12 | FGBM | Futures | 117.15 | 117.21 | 116.98 | 117.16 | 593312.0 |
| 2024-07-12 | FGBS | Futures | 106.469 | 106.48 | 106.399 | 106.459 | 386648.0 |
| 2024-07-12 | FGBX | Futures | 130.93 | 131.4 | 130.29 | 131.1 | 80675.0 |
| 2024-07-12 | FMWO | Futures | 12002.9 | 12160.0 | 12002.9 | 12130.7 | 4910.0 |
| 2024-07-12 | FOAT | Futures | 124.05 | 124.19 | 123.77 | 124.07 | 143660.0 |
| 2024-07-12 | FSMX | Futures | 26212.8 | 26350.9 | 26104.9 | 26348.9 | 96.0 |
| 2024-07-12 | FTDX | Futures | 3488.7 | 3509.6 | 3476.4 | 3509.6 | 28.0 |
| 2024-07-12 | FTI | Futures | 950.04 | 961.4 | 950.04 | 959.3 | 676.0 |
| 2024-07-12 | FTUK | Futures | 8265.2 | 8321.4 | 8265.2 | 8298.3 | 67703.0 |
> showing 50 of 130 rows — these rows as CSV