PREVIEW / futures_daily / 2023-09-18
file: by_date/futures_daily/2023/2023-09-18.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-09-18 | ES | Futures | 4816.16 | 4832.21 | 4802.78 | 4818.3 | 1155158.0 |
| 2023-09-18 | NQ | Futures | 16600.83 | 16685.82 | 16544.98 | 16635.64 | 509746.0 |
| 2023-09-18 | YM | Futures | 36758.9 | 36872.6 | 36672.6 | 36764.2 | 122942.0 |
| 2023-09-18 | CL | Futures | 79.71 | 80.55 | 79.27 | 79.86 | 414189.0 |
| 2023-09-18 | GC | Futures | 2094.9 | 2105.7 | 2092.9 | 2103.2 | 138031.0 |
| 2023-09-18 | ZN | Futures | 110.959462 | 111.133727 | 110.769355 | 111.038674 | 972461.0 |
| 2023-09-18 | A6 | Futures | 0.65048 | 0.65219 | 0.64891 | 0.65063 | 64552.0 |
| 2023-09-18 | AD | Futures | 0.74616 | 0.74923 | 0.74616 | 0.74802 | 71251.0 |
| 2023-09-18 | ALI | Futures | 2421.88 | 2451.06 | 2411.7 | 2448.58 | 3169.0 |
| 2023-09-18 | B | Futures | 84.03 | 84.63 | 83.59 | 84.16 | 337777.0 |
| 2023-09-18 | B6 | Futures | 1.2388 | 1.2415 | 1.2375 | 1.2379 | 62256.0 |
| 2023-09-18 | BFX | Futures | 3990.9 | 3990.9 | 3990.9 | 3990.9 | 0.0 |
| 2023-09-18 | BR | Futures | 0.19251 | 0.19251 | 0.19195 | 0.19228 | 9.0 |
| 2023-09-18 | BTC | Futures | 35408.3 | 36728.1 | 35228.3 | 35841.5 | 10480.0 |
| 2023-09-18 | BZ | Futures | 83.76 | 84.43 | 83.39 | 83.97 | 33918.0 |
| 2023-09-18 | C | Futures | 2598.0 | 2600.0 | 2514.0 | 2517.0 | 10318.0 |
| 2023-09-18 | CB | Futures | 263.49 | 263.49 | 261.41 | 261.757 | 24.0 |
| 2023-09-18 | CC | Futures | 2186.0 | 2190.0 | 2108.0 | 2113.0 | 29765.0 |
| 2023-09-18 | CNH | Futures | 7.0328 | 7.0515 | 7.0328 | 7.0447 | 953.0 |
| 2023-09-18 | CSC | Futures | 2.077 | 2.077 | 2.069 | 2.076 | 31.0 |
| 2023-09-18 | CT | Futures | 106.91 | 107.15 | 106.61 | 106.61 | 7.0 |
| 2023-09-18 | DC | Futures | 19.55 | 19.62 | 19.24 | 19.51 | 233.0 |
| 2023-09-18 | DX | Futures | 103.558 | 103.598 | 103.262 | 103.435 | 8977.0 |
| 2023-09-18 | E1 | Futures | 1.18048 | 1.18284 | 1.17906 | 1.17943 | 15403.0 |
| 2023-09-18 | E6 | Futures | 1.08935 | 1.09281 | 1.08828 | 1.09067 | 114813.0 |
| 2023-09-18 | E7 | Futures | 1.0895 | 1.0929 | 1.0885 | 1.0909 | 3049.0 |
| 2023-09-18 | EBM | Futures | 332.08 | 332.77 | 325.91 | 327.28 | 39565.0 |
| 2023-09-18 | ER | Futures | 97.756 | 97.756 | 97.736 | 97.741 | 191931.0 |
| 2023-09-18 | ESG | Futures | 417.18 | 418.0 | 415.78 | 417.01 | 195.0 |
| 2023-09-18 | EW | Futures | 2715.8 | 2723.4 | 2704.2 | 2710.4 | 9676.0 |
| 2023-09-18 | FBON | Futures | 119.53 | 119.6 | 119.22 | 119.23 | 81.0 |
| 2023-09-18 | FBTP | Futures | 111.02 | 111.14 | 110.59 | 110.65 | 135252.0 |
| 2023-09-18 | FBTS | Futures | 105.572 | 105.643 | 105.531 | 105.552 | 91699.0 |
| 2023-09-18 | FCE | Futures | 7943.5 | 7947.8 | 7831.0 | 7854.6 | 63289.0 |
| 2023-09-18 | FDAX | Futures | 16910.1 | 16922.8 | 16695.2 | 16722.6 | 60428.0 |
| 2023-09-18 | FDIV | Futures | 182.47 | 182.47 | 180.98 | 181.28 | 28.0 |
| 2023-09-18 | FDXM | Futures | 16891.9 | 16916.1 | 16688.7 | 16716.0 | 41125.0 |
| 2023-09-18 | FDXS | Futures | 16797.3 | 16804.6 | 16578.6 | 16606.9 | 21749.0 |
| 2023-09-18 | FESX | Futures | 4353.6 | 4358.7 | 4293.2 | 4301.3 | 653748.0 |
| 2023-09-18 | FEU3 | Futures | 97.741 | 97.741 | 97.741 | 97.741 | 0.0 |
| 2023-09-18 | FGBL | Futures | 132.36 | 132.41 | 131.89 | 131.92 | 567031.0 |
| 2023-09-18 | FGBM | Futures | 117.54 | 117.54 | 117.24 | 117.25 | 480105.0 |
| 2023-09-18 | FGBS | Futures | 107.03 | 107.035 | 106.928 | 106.933 | 348960.0 |
| 2023-09-18 | FGBX | Futures | 130.51 | 130.88 | 129.65 | 129.71 | 72614.0 |
| 2023-09-18 | FMWO | Futures | 10307.4 | 10307.4 | 10250.0 | 10276.5 | 4700.0 |
| 2023-09-18 | FOAT | Futures | 123.57 | 123.58 | 123.11 | 123.13 | 166142.0 |
| 2023-09-18 | FSMX | Futures | 28333.5 | 28333.5 | 27874.4 | 27885.7 | 277.0 |
| 2023-09-18 | FTDX | Futures | 3258.6 | 3258.6 | 3206.7 | 3206.7 | 51.0 |
| 2023-09-18 | FTI | Futures | 770.93 | 771.97 | 764.96 | 766.33 | 14148.0 |
| 2023-09-18 | FTUK | Futures | 7838.5 | 7840.5 | 7757.9 | 7766.9 | 92415.0 |
> showing 50 of 130 rows — these rows as CSV