PREVIEW / futures_daily / 2023-07-06
file: by_date/futures_daily/2023/2023-07-06.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-07-06 | ES | Futures | 4853.51 | 4855.41 | 4786.1 | 4815.88 | 1741520.0 |
| 2023-07-06 | NQ | Futures | 16799.64 | 16813.05 | 16534.58 | 16672.99 | 574681.0 |
| 2023-07-06 | YM | Futures | 36652.4 | 36659.9 | 36098.7 | 36273.0 | 159330.0 |
| 2023-07-06 | CL | Futures | 62.31 | 62.78 | 60.94 | 62.31 | 395381.0 |
| 2023-07-06 | GC | Futures | 2113.4 | 2126.1 | 2098.1 | 2105.7 | 231513.0 |
| 2023-07-06 | ZN | Futures | 113.406249 | 113.453959 | 112.118084 | 112.579279 | 2270324.0 |
| 2023-07-06 | A6 | Futures | 0.67557 | 0.67922 | 0.66995 | 0.67268 | 94071.0 |
| 2023-07-06 | AD | Futures | 0.76168 | 0.76204 | 0.75643 | 0.75734 | 81212.0 |
| 2023-07-06 | ALI | Futures | 2367.24 | 2377.22 | 2353.65 | 2355.59 | 3407.0 |
| 2023-07-06 | B | Futures | 67.2 | 67.54 | 65.73 | 67.04 | 333875.0 |
| 2023-07-06 | B6 | Futures | 1.2728 | 1.2806 | 1.2698 | 1.2765 | 133949.0 |
| 2023-07-06 | BFX | Futures | 3865.9 | 3865.9 | 3865.9 | 3865.9 | 0.0 |
| 2023-07-06 | BR | Futures | 0.19082 | 0.19082 | 0.18653 | 0.18732 | 182.0 |
| 2023-07-06 | BTC | Futures | 41183.3 | 42732.4 | 40318.2 | 40921.7 | 11172.0 |
| 2023-07-06 | BZ | Futures | 66.94 | 67.41 | 65.6 | 66.92 | 29695.0 |
| 2023-07-06 | C | Futures | 2169.0 | 2192.0 | 2154.0 | 2159.0 | 1895.0 |
| 2023-07-06 | CB | Futures | 231.449 | 231.449 | 230.259 | 230.259 | 28.0 |
| 2023-07-06 | CC | Futures | 1946.0 | 1958.0 | 1910.0 | 1921.0 | 19544.0 |
| 2023-07-06 | CNH | Futures | 6.9509 | 6.9622 | 6.9327 | 6.9471 | 445.0 |
| 2023-07-06 | CSC | Futures | 1.801 | 1.809 | 1.783 | 1.786 | 55.0 |
| 2023-07-06 | CT | Futures | 100.74 | 104.69 | 100.74 | 103.61 | 56.0 |
| 2023-07-06 | DC | Futures | 16.37 | 16.45 | 16.15 | 16.25 | 201.0 |
| 2023-07-06 | DX | Futures | 101.073 | 101.318 | 100.661 | 100.918 | 21210.0 |
| 2023-07-06 | E1 | Futures | 1.18936 | 1.19397 | 1.18766 | 1.1927 | 19204.0 |
| 2023-07-06 | E6 | Futures | 1.1149 | 1.11961 | 1.11254 | 1.11751 | 227043.0 |
| 2023-07-06 | E7 | Futures | 1.1147 | 1.1196 | 1.1126 | 1.1176 | 5645.0 |
| 2023-07-06 | EBM | Futures | 340.85 | 343.42 | 337.92 | 341.22 | 15514.0 |
| 2023-07-06 | ER | Futures | 97.802 | 97.807 | 97.777 | 97.787 | 159602.0 |
| 2023-07-06 | ESG | Futures | 419.15 | 419.15 | 414.85 | 417.77 | 461.0 |
| 2023-07-06 | EW | Futures | 2778.0 | 2778.8 | 2719.4 | 2746.4 | 11385.0 |
| 2023-07-06 | FBON | Futures | 121.02 | 121.43 | 119.84 | 120.06 | 131.0 |
| 2023-07-06 | FBTP | Futures | 112.91 | 113.27 | 111.38 | 111.66 | 214037.0 |
| 2023-07-06 | FBTS | Futures | 105.644 | 105.674 | 105.32 | 105.411 | 116446.0 |
| 2023-07-06 | FCE | Futures | 7921.2 | 7926.6 | 7699.6 | 7719.2 | 93286.0 |
| 2023-07-06 | FDAX | Futures | 16953.5 | 16968.4 | 16513.2 | 16531.2 | 87066.0 |
| 2023-07-06 | FDIV | Futures | 181.89 | 181.89 | 181.17 | 181.17 | 10.0 |
| 2023-07-06 | FDXM | Futures | 17024.0 | 17038.9 | 16581.9 | 16598.9 | 46671.0 |
| 2023-07-06 | FDXS | Futures | 16928.7 | 16929.7 | 16475.6 | 16492.5 | 28485.0 |
| 2023-07-06 | FESX | Futures | 4421.8 | 4427.9 | 4288.1 | 4294.2 | 1381980.0 |
| 2023-07-06 | FEU3 | Futures | 97.777 | 97.777 | 97.777 | 97.777 | 0.0 |
| 2023-07-06 | FGBL | Futures | 134.21 | 134.31 | 132.61 | 132.84 | 1105960.0 |
| 2023-07-06 | FGBM | Futures | 118.03 | 118.03 | 117.19 | 117.32 | 730828.0 |
| 2023-07-06 | FGBS | Futures | 107.202 | 107.202 | 106.982 | 107.054 | 585576.0 |
| 2023-07-06 | FGBX | Futures | 139.65 | 140.04 | 136.8 | 137.64 | 113734.0 |
| 2023-07-06 | FMWO | Futures | 10347.7 | 10347.7 | 10178.8 | 10186.6 | 5558.0 |
| 2023-07-06 | FOAT | Futures | 125.53 | 125.67 | 123.83 | 124.04 | 324783.0 |
| 2023-07-06 | FSMX | Futures | 28371.0 | 28445.9 | 27893.6 | 27917.5 | 275.0 |
| 2023-07-06 | FTDX | Futures | 3323.9 | 3323.9 | 3269.7 | 3273.9 | 42.0 |
| 2023-07-06 | FTI | Futures | 805.7 | 805.7 | 790.27 | 792.23 | 24481.0 |
| 2023-07-06 | FTUK | Futures | 7557.4 | 7559.0 | 7381.6 | 7390.8 | 130697.0 |
> showing 50 of 130 rows — these rows as CSV