PREVIEW / futures_daily / 2024-09-20
file: by_date/futures_daily/2024/2024-09-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-09-20 | ES | Futures | 5909.1 | 5909.87 | 5865.62 | 5894.78 | 1623655.0 |
| 2024-09-20 | NQ | Futures | 20582.04 | 20600.5 | 20370.74 | 20543.32 | 479646.0 |
| 2024-09-20 | YM | Futures | 42913.3 | 42984.1 | 42693.0 | 42889.1 | 114933.0 |
| 2024-09-20 | CL | Futures | 67.7 | 67.96 | 66.93 | 67.53 | 306997.0 |
| 2024-09-20 | GC | Futures | 2666.1 | 2706.8 | 2663.6 | 2701.9 | 207209.0 |
| 2024-09-20 | ZN | Futures | 115.051395 | 115.145263 | 114.675921 | 114.988816 | 1884141.0 |
| 2024-09-20 | A6 | Futures | 0.68178 | 0.68313 | 0.67858 | 0.68148 | 99126.0 |
| 2024-09-20 | AD | Futures | 0.74077 | 0.74162 | 0.73897 | 0.74067 | 84556.0 |
| 2024-09-20 | ALI | Futures | 2553.02 | 2562.8 | 2489.76 | 2494.65 | 1880.0 |
| 2024-09-20 | B | Futures | 73.39 | 73.62 | 72.63 | 73.12 | 221094.0 |
| 2024-09-20 | B6 | Futures | 1.3279 | 1.3333 | 1.3261 | 1.3311 | 125825.0 |
| 2024-09-20 | BFX | Futures | 4241.9 | 4241.9 | 4241.9 | 4241.9 | 0.0 |
| 2024-09-20 | BR | Futures | 0.17474 | 0.17552 | 0.17474 | 0.17552 | 11.0 |
| 2024-09-20 | BTC | Futures | 69366.4 | 70687.7 | 68738.8 | 69294.9 | 10825.0 |
| 2024-09-20 | BZ | Futures | 71.94 | 72.06 | 71.09 | 71.56 | 27358.0 |
| 2024-09-20 | C | Futures | 5198.0 | 5238.0 | 5138.0 | 5165.0 | 4304.0 |
| 2024-09-20 | CB | Futures | 301.933 | 302.037 | 301.933 | 302.037 | 6.0 |
| 2024-09-20 | CC | Futures | 6334.0 | 6393.0 | 6224.0 | 6271.0 | 7013.0 |
| 2024-09-20 | CNH | Futures | 6.9865 | 6.9925 | 6.9592 | 6.9606 | 1404.0 |
| 2024-09-20 | CSC | Futures | 2.274 | 2.308 | 2.234 | 2.243 | 127.0 |
| 2024-09-20 | CT | Futures | 80.79 | 83.78 | 80.72 | 81.12 | 42.0 |
| 2024-09-20 | DC | Futures | 21.92 | 22.21 | 21.56 | 21.69 | 290.0 |
| 2024-09-20 | DX | Futures | 100.116 | 100.46 | 99.851 | 100.149 | 24452.0 |
| 2024-09-20 | E1 | Futures | 1.20199 | 1.20568 | 1.19644 | 1.19841 | 24813.0 |
| 2024-09-20 | E6 | Futures | 1.12442 | 1.12643 | 1.12181 | 1.12472 | 173647.0 |
| 2024-09-20 | E7 | Futures | 1.1239 | 1.126 | 1.1215 | 1.1243 | 3313.0 |
| 2024-09-20 | EBM | Futures | 236.33 | 237.97 | 234.96 | 236.06 | 33615.0 |
| 2024-09-20 | ER | Futures | 97.604 | 97.614 | 97.584 | 97.584 | 175192.0 |
| 2024-09-20 | ESG | Futures | 507.78 | 508.4 | 506.32 | 507.0 | 387.0 |
| 2024-09-20 | EW | Futures | 3187.5 | 3188.5 | 3151.9 | 3164.1 | 14972.0 |
| 2024-09-20 | FBON | Futures | 125.7 | 125.76 | 125.25 | 125.25 | 130.0 |
| 2024-09-20 | FBTP | Futures | 120.16 | 120.28 | 119.81 | 119.88 | 250886.0 |
| 2024-09-20 | FBTS | Futures | 107.45 | 107.46 | 107.32 | 107.34 | 140789.0 |
| 2024-09-20 | FCE | Futures | 7628.2 | 7647.8 | 7516.0 | 7527.0 | 52672.0 |
| 2024-09-20 | FDAX | Futures | 19313.3 | 19320.4 | 19060.9 | 19088.1 | 50889.0 |
| 2024-09-20 | FDIV | Futures | 190.69 | 190.69 | 189.99 | 190.14 | 25.0 |
| 2024-09-20 | FDXM | Futures | 19276.5 | 19278.5 | 19019.6 | 19046.8 | 25722.0 |
| 2024-09-20 | FDXS | Futures | 19231.4 | 19234.4 | 18978.0 | 19004.2 | 34078.0 |
| 2024-09-20 | FESX | Futures | 4968.9 | 4972.0 | 4901.8 | 4908.8 | 812862.0 |
| 2024-09-20 | FEU3 | Futures | 97.604 | 97.609 | 97.584 | 97.589 | 1108.0 |
| 2024-09-20 | FGBL | Futures | 136.04 | 136.28 | 135.66 | 135.68 | 933186.0 |
| 2024-09-20 | FGBM | Futures | 118.91 | 119.04 | 118.7 | 118.7 | 643541.0 |
| 2024-09-20 | FGBS | Futures | 107.235 | 107.27 | 107.149 | 107.149 | 431264.0 |
| 2024-09-20 | FGBX | Futures | 135.83 | 136.57 | 134.97 | 135.01 | 93379.0 |
| 2024-09-20 | FMWO | Futures | 12232.8 | 12232.8 | 12130.2 | 12140.6 | 6633.0 |
| 2024-09-20 | FOAT | Futures | 126.4 | 126.5 | 125.73 | 125.74 | 231632.0 |
| 2024-09-20 | FSMX | Futures | 26516.8 | 26516.8 | 26119.6 | 26186.6 | 930.0 |
| 2024-09-20 | FTDX | Futures | 3403.0 | 3403.0 | 3337.1 | 3340.7 | 88.0 |
| 2024-09-20 | FTI | Futures | 914.6 | 916.61 | 905.47 | 907.56 | 12013.0 |
| 2024-09-20 | FTUK | Futures | 8396.0 | 8396.0 | 8267.8 | 8298.3 | 128361.0 |
> showing 50 of 130 rows — these rows as CSV