PREVIEW / futures_daily / 2024-07-22
file: by_date/futures_daily/2024/2024-07-22.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-22 | ES | Futures | 5747.58 | 5800.78 | 5736.22 | 5795.35 | 1671918.0 |
| 2024-07-22 | NQ | Futures | 20467.18 | 20773.68 | 20435.83 | 20728.34 | 657854.0 |
| 2024-07-22 | YM | Futures | 41404.0 | 41551.8 | 41287.7 | 41496.7 | 139016.0 |
| 2024-07-22 | CL | Futures | 73.23 | 73.4 | 71.93 | 72.72 | 345235.0 |
| 2024-07-22 | GC | Futures | 2513.1 | 2524.3 | 2493.7 | 2503.7 | 197562.0 |
| 2024-07-22 | ZN | Futures | 111.517153 | 111.611393 | 111.1559 | 111.29726 | 1409017.0 |
| 2024-07-22 | A6 | Futures | 0.67044 | 0.67215 | 0.66504 | 0.66599 | 104033.0 |
| 2024-07-22 | AD | Futures | 0.73328 | 0.73439 | 0.73062 | 0.73183 | 84156.0 |
| 2024-07-22 | ALI | Futures | 2388.83 | 2403.79 | 2332.35 | 2335.45 | 2073.0 |
| 2024-07-22 | B | Futures | 79.71 | 80.12 | 78.56 | 79.33 | 341722.0 |
| 2024-07-22 | B6 | Futures | 1.2914 | 1.2943 | 1.2907 | 1.2927 | 79688.0 |
| 2024-07-22 | BFX | Futures | 4018.8 | 4018.8 | 4018.8 | 4018.8 | 0.0 |
| 2024-07-22 | BR | Futures | 0.17253 | 0.17345 | 0.17128 | 0.17243 | 5667.0 |
| 2024-07-22 | BTC | Futures | 78247.3 | 78247.3 | 75984.9 | 77888.3 | 13300.0 |
| 2024-07-22 | BZ | Futures | 78.14 | 78.5 | 76.97 | 77.73 | 36408.0 |
| 2024-07-22 | C | Futures | 6283.0 | 6782.0 | 6230.0 | 6764.0 | 3957.0 |
| 2024-07-22 | CB | Futures | 301.047 | 302.99 | 301.047 | 302.019 | 30.0 |
| 2024-07-22 | CC | Futures | 5412.0 | 5920.0 | 5408.0 | 5883.0 | 11876.0 |
| 2024-07-22 | CNH | Futures | 7.1705 | 7.1804 | 7.1488 | 7.1784 | 931.0 |
| 2024-07-22 | CSC | Futures | 1.963 | 1.983 | 1.963 | 1.98 | 159.0 |
| 2024-07-22 | CT | Futures | 78.78 | 79.61 | 78.46 | 78.78 | 28.0 |
| 2024-07-22 | DC | Futures | 19.0 | 19.32 | 18.97 | 19.25 | 371.0 |
| 2024-07-22 | DX | Futures | 103.492 | 103.612 | 103.358 | 103.504 | 7412.0 |
| 2024-07-22 | E1 | Futures | 1.15391 | 1.15595 | 1.15192 | 1.15279 | 21957.0 |
| 2024-07-22 | E6 | Futures | 1.09957 | 1.10148 | 1.09841 | 1.10007 | 164641.0 |
| 2024-07-22 | E7 | Futures | 1.0992 | 1.101 | 1.0981 | 1.0997 | 2909.0 |
| 2024-07-22 | EBM | Futures | 262.55 | 265.76 | 261.38 | 263.72 | 38247.0 |
| 2024-07-22 | ER | Futures | 97.548 | 97.548 | 97.528 | 97.533 | 80422.0 |
| 2024-07-22 | ESG | Futures | 497.6 | 501.51 | 497.46 | 501.31 | 647.0 |
| 2024-07-22 | EW | Futures | 3094.2 | 3131.3 | 3076.7 | 3129.3 | 8162.0 |
| 2024-07-22 | FBON | Futures | 123.39 | 123.52 | 123.19 | 123.31 | 165.0 |
| 2024-07-22 | FBTP | Futures | 117.54 | 117.86 | 117.38 | 117.65 | 170993.0 |
| 2024-07-22 | FBTS | Futures | 106.424 | 106.475 | 106.384 | 106.414 | 93379.0 |
| 2024-07-22 | FCE | Futures | 7759.6 | 7863.0 | 7750.4 | 7828.2 | 41332.0 |
| 2024-07-22 | FDAX | Futures | 18756.1 | 19026.1 | 18708.0 | 18963.7 | 40499.0 |
| 2024-07-22 | FDIV | Futures | 188.85 | 189.75 | 188.85 | 189.5 | 5.0 |
| 2024-07-22 | FDXM | Futures | 18679.0 | 18936.5 | 18623.0 | 18875.4 | 24185.0 |
| 2024-07-22 | FDXS | Futures | 18596.6 | 18885.0 | 18573.3 | 18826.1 | 24250.0 |
| 2024-07-22 | FESX | Futures | 4911.4 | 4992.1 | 4899.3 | 4968.9 | 729270.0 |
| 2024-07-22 | FEU3 | Futures | 97.548 | 97.548 | 97.538 | 97.538 | 628.0 |
| 2024-07-22 | FGBL | Futures | 133.49 | 133.67 | 132.99 | 133.3 | 583367.0 |
| 2024-07-22 | FGBM | Futures | 117.37 | 117.45 | 117.09 | 117.21 | 448821.0 |
| 2024-07-22 | FGBS | Futures | 106.515 | 106.54 | 106.409 | 106.434 | 397935.0 |
| 2024-07-22 | FGBX | Futures | 131.86 | 132.24 | 130.79 | 131.68 | 71180.0 |
| 2024-07-22 | FMWO | Futures | 11854.1 | 11957.8 | 11825.8 | 11889.7 | 6593.0 |
| 2024-07-22 | FOAT | Futures | 124.37 | 124.48 | 124.05 | 124.27 | 148040.0 |
| 2024-07-22 | FSMX | Futures | 25764.0 | 25940.5 | 25764.0 | 25834.6 | 138.0 |
| 2024-07-22 | FTDX | Futures | 3388.2 | 3418.3 | 3388.2 | 3414.2 | 29.0 |
| 2024-07-22 | FTI | Futures | 921.96 | 934.92 | 921.4 | 929.86 | 10485.0 |
| 2024-07-22 | FTUK | Futures | 8217.1 | 8273.8 | 8193.6 | 8238.7 | 66719.0 |
> showing 50 of 130 rows — these rows as CSV