PREVIEW / futures_daily / 2023-06-29
file: by_date/futures_daily/2023/2023-06-29.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 |
|---|---|---|---|---|---|---|---|
| 2023-06-29 | ES | Futures | 4790.7 | 4806.14 | 4775.54 | 4803.7 | 1628750.0 |
| 2023-06-29 | NQ | Futures | 16588.74 | 16634.42 | 16443.76 | 16522.27 | 594134.0 |
| 2023-06-29 | YM | Futures | 36287.9 | 36546.2 | 36188.0 | 36509.0 | 158623.0 |
| 2023-06-29 | CL | Futures | 60.1 | 61.27 | 59.82 | 60.63 | 292865.0 |
| 2023-06-29 | GC | Futures | 2106.9 | 2112.1 | 2089.4 | 2108.4 | 205252.0 |
| 2023-06-29 | ZN | Futures | 115.266932 | 115.282836 | 114.026477 | 114.121897 | 1959722.0 |
| 2023-06-29 | A6 | Futures | 0.67015 | 0.67405 | 0.66954 | 0.67197 | 105234.0 |
| 2023-06-29 | AD | Futures | 0.7634 | 0.76421 | 0.76153 | 0.76381 | 63269.0 |
| 2023-06-29 | ALI | Futures | 2403.56 | 2403.56 | 2370.84 | 2387.76 | 784.0 |
| 2023-06-29 | B | Futures | 64.79 | 65.84 | 64.45 | 65.28 | 317853.0 |
| 2023-06-29 | B6 | Futures | 1.2661 | 1.2693 | 1.2616 | 1.2639 | 105574.0 |
| 2023-06-29 | BFX | Futures | 3872.5 | 3872.5 | 3872.5 | 3872.5 | 0.0 |
| 2023-06-29 | BR | Futures | 0.18937 | 0.18979 | 0.18928 | 0.18956 | 51.0 |
| 2023-06-29 | BTC | Futures | 40854.7 | 41927.7 | 40801.0 | 41632.6 | 8930.0 |
| 2023-06-29 | BZ | Futures | 64.56 | 65.71 | 64.36 | 65.16 | 26763.0 |
| 2023-06-29 | C | Futures | 2050.0 | 2053.0 | 2024.0 | 2028.0 | 1766.0 |
| 2023-06-29 | CB | Futures | 229.306 | 229.306 | 227.64 | 228.568 | 34.0 |
| 2023-06-29 | CC | Futures | 1931.0 | 1937.0 | 1888.0 | 1891.0 | 28260.0 |
| 2023-06-29 | CNH | Futures | 6.9207 | 6.9615 | 6.9207 | 6.9555 | 104.0 |
| 2023-06-29 | CSC | Futures | 1.846 | 1.851 | 1.821 | 1.822 | 98.0 |
| 2023-06-29 | CT | Futures | 97.34 | 99.83 | 96.33 | 98.72 | 16.0 |
| 2023-06-29 | DC | Futures | 16.87 | 16.92 | 16.57 | 16.61 | 294.0 |
| 2023-06-29 | DX | Futures | 100.68 | 101.156 | 100.513 | 101.056 | 13451.0 |
| 2023-06-29 | E1 | Futures | 1.19275 | 1.19593 | 1.18808 | 1.18867 | 17375.0 |
| 2023-06-29 | E6 | Futures | 1.12135 | 1.12411 | 1.11582 | 1.11654 | 206971.0 |
| 2023-06-29 | E7 | Futures | 1.121 | 1.1241 | 1.1158 | 1.1166 | 4924.0 |
| 2023-06-29 | EBM | Futures | 337.56 | 343.78 | 335.36 | 341.58 | 22039.0 |
| 2023-06-29 | ER | Futures | 97.807 | 97.812 | 97.777 | 97.792 | 223672.0 |
| 2023-06-29 | ESG | Futures | 416.02 | 416.38 | 414.45 | 415.99 | 466.0 |
| 2023-06-29 | EW | Futures | 2749.1 | 2778.8 | 2739.9 | 2777.4 | 8865.0 |
| 2023-06-29 | FBON | Futures | 123.44 | 123.44 | 122.15 | 122.46 | 230.0 |
| 2023-06-29 | FBTP | Futures | 114.85 | 115.18 | 113.84 | 114.18 | 153696.0 |
| 2023-06-29 | FBTS | Futures | 105.866 | 105.926 | 105.633 | 105.704 | 117932.0 |
| 2023-06-29 | FCE | Futures | 7944.6 | 8012.6 | 7939.1 | 7971.8 | 41718.0 |
| 2023-06-29 | FDAX | Futures | 17053.1 | 17063.6 | 16976.8 | 16999.1 | 47445.0 |
| 2023-06-29 | FDIV | Futures | 185.92 | 185.92 | 185.92 | 185.92 | 0.0 |
| 2023-06-29 | FDXM | Futures | 17119.7 | 17137.8 | 17047.4 | 17068.7 | 24882.0 |
| 2023-06-29 | FDXS | Futures | 17001.6 | 17023.7 | 16938.2 | 16959.3 | 20360.0 |
| 2023-06-29 | FESX | Futures | 4439.1 | 4455.3 | 4422.9 | 4437.0 | 527927.0 |
| 2023-06-29 | FEU3 | Futures | 97.787 | 97.787 | 97.787 | 97.787 | 0.0 |
| 2023-06-29 | FGBL | Futures | 136.47 | 136.47 | 135.0 | 135.32 | 807851.0 |
| 2023-06-29 | FGBM | Futures | 118.96 | 118.96 | 118.23 | 118.38 | 591377.0 |
| 2023-06-29 | FGBS | Futures | 107.463 | 107.468 | 107.238 | 107.305 | 429550.0 |
| 2023-06-29 | FGBX | Futures | 144.45 | 144.45 | 141.52 | 142.32 | 72355.0 |
| 2023-06-29 | FMWO | Futures | 10259.3 | 10287.3 | 10230.2 | 10273.9 | 2843.0 |
| 2023-06-29 | FOAT | Futures | 127.65 | 127.74 | 126.24 | 126.6 | 189116.0 |
| 2023-06-29 | FSMX | Futures | 28484.4 | 28513.5 | 28415.7 | 28471.9 | 55.0 |
| 2023-06-29 | FTDX | Futures | 3336.0 | 3336.0 | 3331.8 | 3331.8 | 2.0 |
| 2023-06-29 | FTI | Futures | 808.54 | 810.53 | 806.39 | 808.94 | 12986.0 |
| 2023-06-29 | FTUK | Futures | 7642.8 | 7649.9 | 7589.0 | 7603.2 | 71369.0 |
> showing 50 of 130 rows — these rows as CSV