PREVIEW / futures_daily / 2023-08-17
file: by_date/futures_daily/2023/2023-08-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 |
|---|---|---|---|---|---|---|---|
| 2023-08-17 | ES | Futures | 4787.18 | 4804.78 | 4740.89 | 4748.2 | 1630481.0 |
| 2023-08-17 | NQ | Futures | 16347.2 | 16432.55 | 16126.18 | 16169.67 | 681399.0 |
| 2023-08-17 | YM | Futures | 37034.0 | 37146.6 | 36664.1 | 36703.4 | 164743.0 |
| 2023-08-17 | CL | Futures | 68.97 | 70.46 | 68.7 | 69.84 | 239170.0 |
| 2023-08-17 | GC | Futures | 2069.8 | 2081.8 | 2061.0 | 2062.1 | 152329.0 |
| 2023-08-17 | ZN | Futures | 111.497856 | 111.593276 | 111.052565 | 111.227501 | 1741118.0 |
| 2023-08-17 | A6 | Futures | 0.65141 | 0.65399 | 0.64538 | 0.64852 | 96313.0 |
| 2023-08-17 | AD | Futures | 0.74693 | 0.74895 | 0.74582 | 0.74592 | 63078.0 |
| 2023-08-17 | ALI | Futures | 2342.17 | 2398.96 | 2335.0 | 2370.84 | 3363.0 |
| 2023-08-17 | B | Futures | 73.63 | 75.12 | 73.5 | 74.44 | 305577.0 |
| 2023-08-17 | B6 | Futures | 1.2755 | 1.2814 | 1.2727 | 1.2752 | 87072.0 |
| 2023-08-17 | BFX | Futures | 3985.9 | 3985.9 | 3963.2 | 3963.2 | 21.0 |
| 2023-08-17 | BR | Futures | 0.18625 | 0.18737 | 0.18583 | 0.18634 | 10685.0 |
| 2023-08-17 | BTC | Futures | 38354.8 | 38401.2 | 36407.6 | 36891.1 | 14274.0 |
| 2023-08-17 | BZ | Futures | 73.54 | 74.89 | 73.27 | 74.21 | 33977.0 |
| 2023-08-17 | C | Futures | 2260.0 | 2298.0 | 2257.0 | 2279.0 | 2229.0 |
| 2023-08-17 | CB | Futures | 263.833 | 265.738 | 261.952 | 264.786 | 48.0 |
| 2023-08-17 | CC | Futures | 2022.0 | 2049.0 | 2022.0 | 2035.0 | 25121.0 |
| 2023-08-17 | CNH | Futures | 7.0535 | 7.0645 | 7.0156 | 7.0267 | 1171.0 |
| 2023-08-17 | CSC | Futures | 2.031 | 2.04 | 2.011 | 2.023 | 232.0 |
| 2023-08-17 | CT | Futures | 106.07 | 106.07 | 105.14 | 105.14 | 5.0 |
| 2023-08-17 | DC | Futures | 18.62 | 18.78 | 18.46 | 18.57 | 613.0 |
| 2023-08-17 | DX | Futures | 101.406 | 101.534 | 100.994 | 101.509 | 16785.0 |
| 2023-08-17 | E1 | Futures | 1.20951 | 1.21476 | 1.20792 | 1.20925 | 10507.0 |
| 2023-08-17 | E6 | Futures | 1.11505 | 1.11899 | 1.11254 | 1.11265 | 156866.0 |
| 2023-08-17 | E7 | Futures | 1.1151 | 1.119 | 1.1126 | 1.1127 | 4581.0 |
| 2023-08-17 | EBM | Futures | 334.63 | 336.83 | 332.43 | 333.9 | 7415.0 |
| 2023-08-17 | ER | Futures | 97.817 | 97.817 | 97.802 | 97.817 | 70920.0 |
| 2023-08-17 | ESG | Futures | 414.96 | 416.48 | 411.37 | 412.05 | 1917.0 |
| 2023-08-17 | EW | Futures | 2761.3 | 2773.1 | 2724.2 | 2725.8 | 12223.0 |
| 2023-08-17 | FBON | Futures | 119.39 | 119.74 | 119.37 | 119.55 | 86.0 |
| 2023-08-17 | FBTP | Futures | 111.24 | 111.67 | 111.17 | 111.46 | 137311.0 |
| 2023-08-17 | FBTS | Futures | 105.775 | 105.886 | 105.775 | 105.876 | 115763.0 |
| 2023-08-17 | FCE | Futures | 7826.2 | 7878.7 | 7764.5 | 7802.4 | 63465.0 |
| 2023-08-17 | FDAX | Futures | 16682.6 | 16770.4 | 16562.9 | 16634.9 | 55400.0 |
| 2023-08-17 | FDIV | Futures | 183.26 | 183.26 | 183.26 | 183.26 | 0.0 |
| 2023-08-17 | FDXM | Futures | 16751.9 | 16838.0 | 16631.8 | 16703.0 | 40077.0 |
| 2023-08-17 | FDXS | Futures | 16640.4 | 16730.2 | 16524.2 | 16596.0 | 20596.0 |
| 2023-08-17 | FESX | Futures | 4326.6 | 4346.9 | 4277.0 | 4294.2 | 796222.0 |
| 2023-08-17 | FEU3 | Futures | 97.807 | 97.807 | 97.807 | 97.807 | 0.0 |
| 2023-08-17 | FGBL | Futures | 132.51 | 132.53 | 132.04 | 132.26 | 519682.0 |
| 2023-08-17 | FGBM | Futures | 117.76 | 117.82 | 117.61 | 117.7 | 483450.0 |
| 2023-08-17 | FGBS | Futures | 107.33 | 107.366 | 107.294 | 107.325 | 395600.0 |
| 2023-08-17 | FGBX | Futures | 132.54 | 132.64 | 131.29 | 131.8 | 53161.0 |
| 2023-08-17 | FMWO | Futures | 10162.0 | 10224.6 | 10094.9 | 10160.9 | 6234.0 |
| 2023-08-17 | FOAT | Futures | 123.72 | 123.75 | 123.26 | 123.49 | 160264.0 |
| 2023-08-17 | FSMX | Futures | 28849.5 | 28870.3 | 28667.5 | 28667.5 | 642.0 |
| 2023-08-17 | FTDX | Futures | 3261.2 | 3273.9 | 3250.7 | 3250.7 | 29.0 |
| 2023-08-17 | FTI | Futures | 782.44 | 785.16 | 768.47 | 771.06 | 13691.0 |
| 2023-08-17 | FTUK | Futures | 7456.8 | 7483.8 | 7405.5 | 7435.0 | 87849.0 |
> showing 50 of 130 rows — these rows as CSV