PREVIEW / futures_daily / 2022-11-01
file: by_date/futures_daily/2022/2022-11-01.parquet size: 10 KB rows: 126
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 |
|---|---|---|---|---|---|---|---|
| 2022-11-01 | ES | Futures | 4329.02 | 4378.06 | 4293.91 | 4308.96 | 1895614.0 |
| 2022-11-01 | NQ | Futures | 12981.38 | 13167.23 | 12792.97 | 12841.99 | 605362.0 |
| 2022-11-01 | YM | Futures | 35657.7 | 35937.4 | 35375.9 | 35566.3 | 224690.0 |
| 2022-11-01 | CL | Futures | 74.68 | 77.29 | 74.24 | 76.36 | 274321.0 |
| 2022-11-01 | GC | Futures | 1872.4 | 1900.1 | 1869.5 | 1887.9 | 197976.0 |
| 2022-11-01 | ZN | Futures | 113.92105 | 114.85338 | 113.663856 | 113.760304 | 1837010.0 |
| 2022-11-01 | A6 | Futures | 0.65515 | 0.6621 | 0.6532 | 0.6554 | 96459.0 |
| 2022-11-01 | AD | Futures | 0.74484 | 0.74986 | 0.74221 | 0.74495 | 90503.0 |
| 2022-11-01 | ALI | Futures | 2542.28 | 2579.87 | 2528.15 | 2548.5 | 3132.0 |
| 2022-11-01 | B | Futures | 81.09 | 83.61 | 80.79 | 82.82 | 247652.0 |
| 2022-11-01 | B6 | Futures | 1.1592 | 1.1691 | 1.1561 | 1.1608 | 109162.0 |
| 2022-11-01 | BR | Futures | 0.16965 | 0.17317 | 0.16789 | 0.17154 | 26439.0 |
| 2022-11-01 | BTC | Futures | 28014.5 | 28419.0 | 27863.7 | 28083.1 | 4663.0 |
| 2022-11-01 | BZ | Futures | 79.61 | 81.97 | 79.23 | 81.2 | 21355.0 |
| 2022-11-01 | C | Futures | 1376.0 | 1387.0 | 1369.0 | 1384.0 | 5686.0 |
| 2022-11-01 | CB | Futures | 225.641 | 226.28 | 221.946 | 221.946 | 176.0 |
| 2022-11-01 | CC | Futures | 1370.0 | 1378.0 | 1357.0 | 1375.0 | 24453.0 |
| 2022-11-01 | CNH | Futures | 6.902 | 6.9264 | 6.8383 | 6.8787 | 768.0 |
| 2022-11-01 | CSC | Futures | 2.363 | 2.419 | 2.363 | 2.394 | 110.0 |
| 2022-11-01 | CT | Futures | 93.44 | 97.13 | 93.24 | 97.13 | 13666.0 |
| 2022-11-01 | DC | Futures | 22.97 | 23.34 | 22.73 | 23.09 | 360.0 |
| 2022-11-01 | DX | Futures | 108.128 | 108.337 | 107.279 | 108.05 | 36504.0 |
| 2022-11-01 | E1 | Futures | 1.10022 | 1.11118 | 1.09929 | 1.10181 | 21238.0 |
| 2022-11-01 | E6 | Futures | 1.03197 | 1.03956 | 1.02895 | 1.03207 | 184396.0 |
| 2022-11-01 | E7 | Futures | 1.0302 | 1.0377 | 1.0272 | 1.0304 | 6331.0 |
| 2022-11-01 | EBM | Futures | 496.14 | 510.33 | 495.43 | 507.49 | 21561.0 |
| 2022-11-01 | ED | Futures | 94.0178 | 94.0722 | 93.993 | 94.0128 | 137265.0 |
| 2022-11-01 | ER | Futures | 97.706 | 97.716 | 97.686 | 97.696 | 87948.0 |
| 2022-11-01 | ESG | Futures | 374.39 | 376.41 | 368.65 | 369.87 | 1037.0 |
| 2022-11-01 | EW | Futures | 2640.8 | 2672.6 | 2634.1 | 2649.6 | 15730.0 |
| 2022-11-01 | FBON | Futures | 123.1 | 123.96 | 122.65 | 122.93 | 119.0 |
| 2022-11-01 | FBTP | Futures | 108.83 | 110.06 | 108.3 | 108.86 | 132612.0 |
| 2022-11-01 | FBTS | Futures | 106.038 | 106.218 | 105.909 | 106.018 | 92459.0 |
| 2022-11-01 | FCE | Futures | 6893.3 | 6966.4 | 6879.7 | 6904.8 | 56505.0 |
| 2022-11-01 | FDAX | Futures | 14537.3 | 14697.8 | 14516.5 | 14568.9 | 61030.0 |
| 2022-11-01 | FDIV | Futures | 159.03 | 159.03 | 158.88 | 158.88 | 20.0 |
| 2022-11-01 | FDXM | Futures | 14310.4 | 14478.2 | 14299.7 | 14352.4 | 53443.0 |
| 2022-11-01 | FDXS | Futures | 14220.0 | 14408.3 | 14220.0 | 14281.0 | 17329.0 |
| 2022-11-01 | FESX | Futures | 3591.3 | 3640.8 | 3586.4 | 3609.1 | 863208.0 |
| 2022-11-01 | FGBL | Futures | 138.27 | 139.74 | 138.2 | 138.63 | 636525.0 |
| 2022-11-01 | FGBM | Futures | 121.54 | 122.22 | 121.48 | 121.71 | 380500.0 |
| 2022-11-01 | FGBS | Futures | 109.223 | 109.443 | 109.218 | 109.264 | 386244.0 |
| 2022-11-01 | FGBX | Futures | 147.78 | 150.38 | 147.05 | 148.21 | 57607.0 |
| 2022-11-01 | FMWO | Futures | 9171.2 | 9234.0 | 9069.0 | 9093.4 | 6806.0 |
| 2022-11-01 | FOAT | Futures | 128.2 | 129.64 | 128.06 | 128.5 | 120321.0 |
| 2022-11-01 | FSMX | Futures | 25588.0 | 25803.7 | 25353.2 | 25424.1 | 796.0 |
| 2022-11-01 | FTDX | Futures | 3062.0 | 3078.0 | 3039.1 | 3044.4 | 28.0 |
| 2022-11-01 | FTI | Futures | 686.62 | 690.29 | 682.5 | 683.37 | 22369.0 |
| 2022-11-01 | FTUK | Futures | 7180.5 | 7286.0 | 7180.5 | 7247.6 | 103572.0 |
| 2022-11-01 | FVSA | Futures | 58.21 | 58.56 | 56.82 | 57.52 | 18137.0 |
> showing 50 of 126 rows — these rows as CSV