PREVIEW / futures_daily / 2022-11-02
file: by_date/futures_daily/2022/2022-11-02.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-02 | ES | Futures | 4305.61 | 4354.66 | 4191.09 | 4200.56 | 2210708.0 |
| 2022-11-02 | NQ | Futures | 12828.67 | 12987.04 | 12362.62 | 12402.85 | 770983.0 |
| 2022-11-02 | YM | Futures | 35535.8 | 36024.4 | 34952.6 | 35014.6 | 260433.0 |
| 2022-11-02 | CL | Futures | 76.58 | 78.08 | 75.8 | 77.77 | 280961.0 |
| 2022-11-02 | GC | Futures | 1889.9 | 1914.7 | 1873.8 | 1888.3 | 220926.0 |
| 2022-11-02 | ZN | Futures | 113.744229 | 114.483663 | 113.326288 | 113.808528 | 1606698.0 |
| 2022-11-02 | A6 | Futures | 0.65499 | 0.66512 | 0.65019 | 0.65734 | 107219.0 |
| 2022-11-02 | AD | Futures | 0.74434 | 0.74895 | 0.73977 | 0.74393 | 90422.0 |
| 2022-11-02 | ALI | Futures | 2558.39 | 2585.24 | 2540.58 | 2555.28 | 1566.0 |
| 2022-11-02 | B | Futures | 82.99 | 84.44 | 82.26 | 84.14 | 253003.0 |
| 2022-11-02 | B6 | Futures | 1.161 | 1.1693 | 1.151 | 1.1598 | 106446.0 |
| 2022-11-02 | BR | Futures | 0.17035 | 0.1722 | 0.16886 | 0.16908 | 6381.0 |
| 2022-11-02 | BTC | Futures | 28110.5 | 28617.9 | 27568.9 | 27788.3 | 9266.0 |
| 2022-11-02 | BZ | Futures | 81.22 | 82.76 | 80.63 | 82.49 | 28689.0 |
| 2022-11-02 | C | Futures | 1387.0 | 1405.0 | 1384.0 | 1403.0 | 6364.0 |
| 2022-11-02 | CB | Futures | 223.565 | 223.565 | 220.349 | 223.086 | 121.0 |
| 2022-11-02 | CC | Futures | 1379.0 | 1399.0 | 1378.0 | 1393.0 | 30594.0 |
| 2022-11-02 | CNH | Futures | 6.8787 | 6.903 | 6.8383 | 6.8794 | 1467.0 |
| 2022-11-02 | CSC | Futures | 2.383 | 2.406 | 2.379 | 2.395 | 109.0 |
| 2022-11-02 | CT | Futures | 101.53 | 102.31 | 99.1 | 102.31 | 31098.0 |
| 2022-11-02 | DC | Futures | 23.02 | 23.27 | 22.79 | 23.05 | 352.0 |
| 2022-11-02 | DX | Futures | 108.056 | 108.696 | 106.983 | 107.921 | 48147.0 |
| 2022-11-02 | E1 | Futures | 1.10115 | 1.11146 | 1.0971 | 1.10368 | 18603.0 |
| 2022-11-02 | E6 | Futures | 1.0315 | 1.04185 | 1.02468 | 1.03243 | 236032.0 |
| 2022-11-02 | E7 | Futures | 1.0295 | 1.04 | 1.023 | 1.0307 | 8500.0 |
| 2022-11-02 | EBM | Futures | 506.78 | 507.49 | 480.54 | 484.08 | 48390.0 |
| 2022-11-02 | ED | Futures | 94.0178 | 94.0822 | 93.9831 | 94.0178 | 181158.0 |
| 2022-11-02 | ER | Futures | 97.696 | 97.711 | 97.671 | 97.681 | 98806.0 |
| 2022-11-02 | ESG | Futures | 369.92 | 373.89 | 360.18 | 360.47 | 848.0 |
| 2022-11-02 | EW | Futures | 2648.6 | 2664.4 | 2565.7 | 2571.5 | 14046.0 |
| 2022-11-02 | FBON | Futures | 122.68 | 122.88 | 122.33 | 122.63 | 70.0 |
| 2022-11-02 | FBTP | Futures | 108.82 | 108.94 | 108.01 | 108.44 | 97732.0 |
| 2022-11-02 | FBTS | Futures | 105.978 | 106.038 | 105.879 | 105.949 | 79088.0 |
| 2022-11-02 | FCE | Futures | 6927.2 | 6959.3 | 6784.2 | 6849.2 | 59241.0 |
| 2022-11-02 | FDAX | Futures | 14600.6 | 14669.4 | 14357.2 | 14493.6 | 62991.0 |
| 2022-11-02 | FDIV | Futures | 157.39 | 157.63 | 157.39 | 157.63 | 118.0 |
| 2022-11-02 | FDXM | Futures | 14381.4 | 14449.1 | 14143.7 | 14278.2 | 59172.0 |
| 2022-11-02 | FDXS | Futures | 14296.0 | 14377.3 | 14072.3 | 14207.2 | 19770.0 |
| 2022-11-02 | FESX | Futures | 3615.1 | 3636.9 | 3541.8 | 3582.4 | 860740.0 |
| 2022-11-02 | FGBL | Futures | 138.54 | 139.03 | 137.88 | 138.43 | 541672.0 |
| 2022-11-02 | FGBM | Futures | 121.64 | 121.87 | 121.28 | 121.46 | 407674.0 |
| 2022-11-02 | FGBS | Futures | 109.233 | 109.315 | 109.136 | 109.182 | 319974.0 |
| 2022-11-02 | FGBX | Futures | 148.21 | 150.3 | 146.97 | 149.32 | 61414.0 |
| 2022-11-02 | FMWO | Futures | 9131.7 | 9143.4 | 8885.5 | 9037.7 | 6173.0 |
| 2022-11-02 | FOAT | Futures | 128.37 | 128.86 | 127.7 | 128.34 | 117207.0 |
| 2022-11-02 | FSMX | Futures | 25537.2 | 25537.2 | 24879.5 | 25117.4 | 402.0 |
| 2022-11-02 | FTDX | Futures | 3055.6 | 3055.6 | 3029.0 | 3029.0 | 41.0 |
| 2022-11-02 | FTI | Futures | 685.3 | 687.54 | 668.0 | 677.19 | 17977.0 |
| 2022-11-02 | FTUK | Futures | 7247.1 | 7272.3 | 7155.8 | 7210.8 | 102230.0 |
| 2022-11-02 | FVSA | Futures | 57.05 | 57.98 | 56.12 | 57.52 | 23491.0 |
> showing 50 of 126 rows — these rows as CSV