PREVIEW / futures_daily / 2024-09-17
file: by_date/futures_daily/2024/2024-09-17.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-17 | ES | Futures | 5825.46 | 5869.2 | 5808.58 | 5831.6 | 1773538.0 |
| 2024-09-17 | NQ | Futures | 20160.47 | 20360.74 | 20077.9 | 20181.75 | 509253.0 |
| 2024-09-17 | YM | Futures | 42482.8 | 42714.3 | 42333.3 | 42478.8 | 135724.0 |
| 2024-09-17 | CL | Futures | 65.96 | 67.2 | 65.17 | 66.54 | 289926.0 |
| 2024-09-17 | GC | Futures | 2664.7 | 2668.7 | 2641.7 | 2646.9 | 159525.0 |
| 2024-09-17 | ZN | Futures | 115.708474 | 115.817987 | 115.395579 | 115.520737 | 1801966.0 |
| 2024-09-17 | A6 | Futures | 0.67569 | 0.67738 | 0.67469 | 0.67648 | 74220.0 |
| 2024-09-17 | AD | Futures | 0.73962 | 0.73977 | 0.73777 | 0.73907 | 78551.0 |
| 2024-09-17 | ALI | Futures | 2513.94 | 2529.88 | 2496.96 | 2517.54 | 10965.0 |
| 2024-09-17 | B | Futures | 71.56 | 72.91 | 70.84 | 72.34 | 274588.0 |
| 2024-09-17 | B6 | Futures | 1.3215 | 1.3227 | 1.3144 | 1.3164 | 86480.0 |
| 2024-09-17 | BFX | Futures | 4267.5 | 4267.5 | 4267.5 | 4267.5 | 0.0 |
| 2024-09-17 | BR | Futures | 0.17649 | 0.17649 | 0.17649 | 0.17649 | 0.0 |
| 2024-09-17 | BTC | Futures | 63883.2 | 67780.9 | 63492.3 | 66178.9 | 14607.0 |
| 2024-09-17 | BZ | Futures | 70.14 | 71.35 | 69.33 | 70.8 | 38565.0 |
| 2024-09-17 | C | Futures | 5305.0 | 5333.0 | 5099.0 | 5177.0 | 4245.0 |
| 2024-09-17 | CB | Futures | 308.651 | 309.636 | 308.651 | 309.636 | 1.0 |
| 2024-09-17 | CC | Futures | 6308.0 | 6369.0 | 6120.0 | 6240.0 | 6229.0 |
| 2024-09-17 | CNH | Futures | 7.0174 | 7.0254 | 7.0075 | 7.0114 | 629.0 |
| 2024-09-17 | CSC | Futures | 2.257 | 2.274 | 2.227 | 2.274 | 47.0 |
| 2024-09-17 | CT | Futures | 79.94 | 79.94 | 79.1 | 79.54 | 33.0 |
| 2024-09-17 | DC | Futures | 21.64 | 22.04 | 21.53 | 22.0 | 215.0 |
| 2024-09-17 | DX | Futures | 100.106 | 100.415 | 99.966 | 100.292 | 17177.0 |
| 2024-09-17 | E1 | Futures | 1.20734 | 1.20971 | 1.20295 | 1.20552 | 21930.0 |
| 2024-09-17 | E6 | Futures | 1.12211 | 1.12331 | 1.11965 | 1.12101 | 134664.0 |
| 2024-09-17 | E7 | Futures | 1.1215 | 1.1229 | 1.1193 | 1.1206 | 3559.0 |
| 2024-09-17 | EBM | Futures | 242.61 | 243.43 | 238.51 | 239.61 | 37256.0 |
| 2024-09-17 | ER | Futures | 97.609 | 97.624 | 97.599 | 97.604 | 210945.0 |
| 2024-09-17 | ESG | Futures | 498.51 | 505.27 | 498.51 | 502.17 | 6920.0 |
| 2024-09-17 | EW | Futures | 3114.5 | 3154.7 | 3109.8 | 3134.6 | 14685.0 |
| 2024-09-17 | FBON | Futures | 126.12 | 126.49 | 126.03 | 126.08 | 106.0 |
| 2024-09-17 | FBTP | Futures | 120.58 | 121.07 | 120.42 | 120.5 | 355242.0 |
| 2024-09-17 | FBTS | Futures | 107.52 | 107.59 | 107.4 | 107.42 | 153763.0 |
| 2024-09-17 | FCE | Futures | 7522.5 | 7556.6 | 7483.9 | 7519.0 | 35021.0 |
| 2024-09-17 | FDAX | Futures | 19061.9 | 19175.0 | 18986.1 | 19098.2 | 33309.0 |
| 2024-09-17 | FDIV | Futures | 191.45 | 191.45 | 191.45 | 191.45 | 0.0 |
| 2024-09-17 | FDXM | Futures | 19044.8 | 19133.5 | 18944.0 | 19056.9 | 3278.0 |
| 2024-09-17 | FDXS | Futures | 19005.2 | 19089.6 | 18900.6 | 19014.2 | 914.0 |
| 2024-09-17 | FESX | Futures | 4883.8 | 4918.9 | 4872.8 | 4900.8 | 1091731.0 |
| 2024-09-17 | FEU3 | Futures | 97.609 | 97.614 | 97.599 | 97.604 | 2298.0 |
| 2024-09-17 | FGBL | Futures | 136.75 | 137.15 | 136.44 | 136.57 | 941938.0 |
| 2024-09-17 | FGBM | Futures | 119.24 | 119.45 | 119.01 | 119.07 | 736175.0 |
| 2024-09-17 | FGBS | Futures | 107.325 | 107.385 | 107.225 | 107.245 | 454210.0 |
| 2024-09-17 | FGBX | Futures | 138.43 | 139.34 | 138.03 | 138.43 | 86479.0 |
| 2024-09-17 | FMWO | Futures | 12028.0 | 12111.9 | 11999.7 | 12085.7 | 48348.0 |
| 2024-09-17 | FOAT | Futures | 127.23 | 127.53 | 126.86 | 126.96 | 182699.0 |
| 2024-09-17 | FSMX | Futures | 25995.6 | 26167.6 | 25995.6 | 26069.6 | 2749.0 |
| 2024-09-17 | FTDX | Futures | 3400.0 | 3400.0 | 3393.9 | 3393.9 | 425.0 |
| 2024-09-17 | FTI | Futures | 909.69 | 913.24 | 906.78 | 910.81 | 6240.0 |
| 2024-09-17 | FTUK | Futures | 8392.5 | 8431.1 | 8350.9 | 8394.5 | 252558.0 |
> showing 50 of 130 rows — these rows as CSV