PREVIEW / futures_daily / 2023-11-17
file: by_date/futures_daily/2023/2023-11-17.parquet size: 10 KB rows: 129
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-11-17 | ES | Futures | 4846.39 | 4858.97 | 4830.34 | 4846.13 | 1331912.0 |
| 2023-11-17 | NQ | Futures | 17157.17 | 17202.77 | 17078.66 | 17155.01 | 562424.0 |
| 2023-11-17 | YM | Futures | 36886.3 | 37009.4 | 36773.7 | 36845.2 | 116814.0 |
| 2023-11-17 | CL | Futures | 65.44 | 68.19 | 65.26 | 68.06 | 368483.0 |
| 2023-11-17 | GC | Futures | 2136.4 | 2149.5 | 2133.0 | 2136.9 | 133120.0 |
| 2023-11-17 | ZN | Futures | 110.389139 | 110.785197 | 110.103978 | 110.262401 | 1685178.0 |
| 2023-11-17 | A6 | Futures | 0.6529 | 0.65753 | 0.65103 | 0.65683 | 83265.0 |
| 2023-11-17 | AD | Futures | 0.73316 | 0.73573 | 0.73235 | 0.73512 | 60244.0 |
| 2023-11-17 | ALI | Futures | 2408.69 | 2414.17 | 2397.19 | 2410.06 | 3069.0 |
| 2023-11-17 | B | Futures | 70.51 | 73.47 | 70.26 | 73.29 | 340026.0 |
| 2023-11-17 | B6 | Futures | 1.2421 | 1.2473 | 1.2381 | 1.2456 | 93934.0 |
| 2023-11-17 | BR | Futures | 0.1935 | 0.19406 | 0.19157 | 0.19195 | 10891.0 |
| 2023-11-17 | BTC | Futures | 47577.0 | 48560.2 | 47118.2 | 47930.9 | 10400.0 |
| 2023-11-17 | BZ | Futures | 70.17 | 73.13 | 69.94 | 72.95 | 35037.0 |
| 2023-11-17 | C | Futures | 2957.0 | 2973.0 | 2948.0 | 2972.0 | 2120.0 |
| 2023-11-17 | CB | Futures | 259.528 | 259.528 | 255.071 | 255.071 | 56.0 |
| 2023-11-17 | CC | Futures | 2340.0 | 2383.0 | 2338.0 | 2377.0 | 26652.0 |
| 2023-11-17 | CNH | Futures | 7.0076 | 7.0178 | 6.9732 | 6.9815 | 2471.0 |
| 2023-11-17 | CSC | Futures | 1.911 | 1.917 | 1.875 | 1.877 | 521.0 |
| 2023-11-17 | CT | Futures | 95.86 | 96.82 | 95.38 | 96.22 | 5649.0 |
| 2023-11-17 | DC | Futures | 18.36 | 18.39 | 17.89 | 17.9 | 1391.0 |
| 2023-11-17 | DX | Futures | 102.838 | 103.011 | 102.276 | 102.389 | 15849.0 |
| 2023-11-17 | E1 | Futures | 1.18441 | 1.18887 | 1.18336 | 1.18845 | 24455.0 |
| 2023-11-17 | E6 | Futures | 1.10553 | 1.11214 | 1.10263 | 1.11031 | 179310.0 |
| 2023-11-17 | E7 | Futures | 1.1055 | 1.1119 | 1.1028 | 1.1105 | 4577.0 |
| 2023-11-17 | EBM | Futures | 310.47 | 312.19 | 308.41 | 311.16 | 24321.0 |
| 2023-11-17 | ER | Futures | 97.792 | 97.792 | 97.782 | 97.787 | 114392.0 |
| 2023-11-17 | ESG | Futures | 420.81 | 420.92 | 418.66 | 419.94 | 749.0 |
| 2023-11-17 | EW | Futures | 2642.2 | 2667.4 | 2641.0 | 2661.8 | 11797.0 |
| 2023-11-17 | FBON | Futures | 121.48 | 122.03 | 121.31 | 121.35 | 158.0 |
| 2023-11-17 | FBTP | Futures | 112.9 | 113.62 | 112.56 | 112.69 | 227353.0 |
| 2023-11-17 | FBTS | Futures | 106.371 | 106.533 | 106.29 | 106.311 | 139838.0 |
| 2023-11-17 | FCE | Futures | 7651.3 | 7705.5 | 7634.9 | 7690.6 | 56511.0 |
| 2023-11-17 | FDAX | Futures | 16725.8 | 16854.3 | 16711.0 | 16824.8 | 56046.0 |
| 2023-11-17 | FDIV | Futures | 173.96 | 174.11 | 173.76 | 174.11 | 56.0 |
| 2023-11-17 | FDXM | Futures | 16717.1 | 16846.6 | 16704.5 | 16818.2 | 40235.0 |
| 2023-11-17 | FDXS | Futures | 16605.8 | 16737.6 | 16591.2 | 16708.4 | 17330.0 |
| 2023-11-17 | FESX | Futures | 4355.6 | 4387.9 | 4346.6 | 4378.8 | 848843.0 |
| 2023-11-17 | FEU3 | Futures | 97.782 | 97.782 | 97.782 | 97.782 | 0.0 |
| 2023-11-17 | FGBL | Futures | 133.27 | 133.93 | 133.08 | 133.22 | 904530.0 |
| 2023-11-17 | FGBM | Futures | 118.27 | 118.57 | 118.12 | 118.19 | 786642.0 |
| 2023-11-17 | FGBS | Futures | 107.249 | 107.315 | 107.183 | 107.198 | 648410.0 |
| 2023-11-17 | FGBX | Futures | 130.18 | 132.03 | 129.67 | 130.61 | 157646.0 |
| 2023-11-17 | FMWO | Futures | 10276.5 | 10321.7 | 10274.3 | 10286.4 | 2848.0 |
| 2023-11-17 | FOAT | Futures | 124.71 | 125.43 | 124.5 | 124.62 | 167231.0 |
| 2023-11-17 | FSMX | Futures | 27075.3 | 27301.3 | 27043.4 | 27074.3 | 314.0 |
| 2023-11-17 | FTDX | Futures | 3231.1 | 3255.5 | 3231.1 | 3241.5 | 14.0 |
| 2023-11-17 | FTI | Futures | 781.58 | 786.32 | 778.48 | 784.69 | 17530.0 |
| 2023-11-17 | FTUK | Futures | 7505.0 | 7592.6 | 7499.4 | 7578.5 | 102456.0 |
| 2023-11-17 | FVSA | Futures | 21.4 | 21.54 | 20.85 | 20.99 | 15686.0 |
> showing 50 of 129 rows — these rows as CSV