PREVIEW / futures_daily / 2023-05-18
file: by_date/futures_daily/2023/2023-05-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-05-18 | ES | Futures | 4564.27 | 4612.97 | 4553.33 | 4608.86 | 1760668.0 |
| 2023-05-18 | NQ | Futures | 15121.19 | 15423.28 | 15107.62 | 15402.21 | 749496.0 |
| 2023-05-18 | YM | Futures | 35868.5 | 36059.3 | 35662.8 | 36023.9 | 183601.0 |
| 2023-05-18 | CL | Futures | 63.51 | 63.64 | 62.37 | 62.74 | 239916.0 |
| 2023-05-18 | GC | Futures | 2203.2 | 2206.7 | 2168.5 | 2174.5 | 227733.0 |
| 2023-05-18 | ZN | Futures | 117.281989 | 117.409887 | 116.498617 | 116.562566 | 1742318.0 |
| 2023-05-18 | A6 | Futures | 0.67778 | 0.67839 | 0.67193 | 0.6729 | 74266.0 |
| 2023-05-18 | AD | Futures | 0.75338 | 0.75344 | 0.74943 | 0.75014 | 58157.0 |
| 2023-05-18 | ALI | Futures | 2503.86 | 2527.36 | 2482.26 | 2506.32 | 1363.0 |
| 2023-05-18 | B | Futures | 67.82 | 68.0 | 66.69 | 67.01 | 232004.0 |
| 2023-05-18 | B6 | Futures | 1.2553 | 1.2555 | 1.2453 | 1.2464 | 81878.0 |
| 2023-05-18 | BFX | Futures | 4117.4 | 4117.4 | 4117.4 | 4117.4 | 0.0 |
| 2023-05-18 | BR | Futures | 0.1825 | 0.18363 | 0.18083 | 0.18142 | 4492.0 |
| 2023-05-18 | BTC | Futures | 36874.4 | 37083.1 | 35508.0 | 36053.2 | 7836.0 |
| 2023-05-18 | BZ | Futures | 67.42 | 67.59 | 66.27 | 66.6 | 20152.0 |
| 2023-05-18 | C | Futures | 1768.0 | 1802.0 | 1768.0 | 1790.0 | 8219.0 |
| 2023-05-18 | CB | Futures | 238.877 | 238.877 | 237.849 | 238.633 | 60.0 |
| 2023-05-18 | CC | Futures | 1742.0 | 1759.0 | 1733.0 | 1736.0 | 21182.0 |
| 2023-05-18 | CNH | Futures | 6.6876 | 6.7325 | 6.6843 | 6.7262 | 4098.0 |
| 2023-05-18 | CSC | Futures | 2.023 | 2.037 | 1.991 | 1.991 | 272.0 |
| 2023-05-18 | CT | Futures | 109.59 | 110.43 | 108.48 | 109.8 | 32316.0 |
| 2023-05-18 | DC | Futures | 19.02 | 19.16 | 18.61 | 18.64 | 1166.0 |
| 2023-05-18 | DX | Futures | 100.42 | 101.153 | 100.332 | 101.119 | 13981.0 |
| 2023-05-18 | E1 | Futures | 1.19597 | 1.1965 | 1.18558 | 1.18708 | 18423.0 |
| 2023-05-18 | E6 | Futures | 1.11664 | 1.11736 | 1.10857 | 1.10898 | 166280.0 |
| 2023-05-18 | E7 | Futures | 1.116 | 1.1168 | 1.108 | 1.1085 | 4208.0 |
| 2023-05-18 | EBM | Futures | 328.4 | 331.7 | 324.01 | 325.48 | 18974.0 |
| 2023-05-18 | ER | Futures | 97.868 | 97.878 | 97.863 | 97.868 | 119601.0 |
| 2023-05-18 | ESG | Futures | 396.89 | 400.92 | 396.52 | 400.56 | 404.0 |
| 2023-05-18 | EW | Futures | 2629.3 | 2655.5 | 2616.4 | 2651.9 | 10762.0 |
| 2023-05-18 | FBON | Futures | 121.62 | 121.65 | 120.61 | 120.61 | 108.0 |
| 2023-05-18 | FBTP | Futures | 112.06 | 112.1 | 110.89 | 111.04 | 187741.0 |
| 2023-05-18 | FBTS | Futures | 106.431 | 106.431 | 106.229 | 106.239 | 124899.0 |
| 2023-05-18 | FCE | Futures | 8077.1 | 8130.7 | 8067.0 | 8090.7 | 59763.0 |
| 2023-05-18 | FDAX | Futures | 17137.7 | 17357.4 | 17114.2 | 17292.3 | 70572.0 |
| 2023-05-18 | FDIV | Futures | 187.83 | 189.19 | 187.83 | 189.19 | 40.0 |
| 2023-05-18 | FDXM | Futures | 17289.1 | 17504.2 | 17261.1 | 17439.7 | 46262.0 |
| 2023-05-18 | FDXS | Futures | 17178.4 | 17385.6 | 17146.3 | 17322.6 | 25081.0 |
| 2023-05-18 | FESX | Futures | 4439.5 | 4474.3 | 4431.4 | 4460.0 | 804351.0 |
| 2023-05-18 | FEU3 | Futures | 97.878 | 97.878 | 97.878 | 97.878 | 0.0 |
| 2023-05-18 | FGBL | Futures | 136.07 | 136.17 | 134.57 | 134.75 | 628902.0 |
| 2023-05-18 | FGBM | Futures | 119.73 | 119.79 | 119.14 | 119.23 | 475135.0 |
| 2023-05-18 | FGBS | Futures | 108.205 | 108.221 | 108.072 | 108.098 | 383408.0 |
| 2023-05-18 | FGBX | Futures | 139.72 | 140.02 | 135.92 | 136.19 | 85122.0 |
| 2023-05-18 | FMWO | Futures | 9927.8 | 9990.0 | 9900.7 | 9945.9 | 1662.0 |
| 2023-05-18 | FOAT | Futures | 126.94 | 127.0 | 125.39 | 125.6 | 161893.0 |
| 2023-05-18 | FSMX | Futures | 29255.7 | 29296.8 | 29145.9 | 29257.8 | 49.0 |
| 2023-05-18 | FTDX | Futures | 3496.2 | 3509.6 | 3488.7 | 3495.1 | 38.0 |
| 2023-05-18 | FTI | Futures | 804.43 | 811.46 | 803.16 | 809.5 | 11395.0 |
| 2023-05-18 | FTUK | Futures | 7910.2 | 7942.3 | 7887.3 | 7908.2 | 85369.0 |
> showing 50 of 130 rows — these rows as CSV