PREVIEW / futures_daily / 2023-10-31
file: by_date/futures_daily/2023/2023-10-31.parquet size: 10 KB rows: 129
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-10-31 | ES | Futures | 4478.72 | 4511.63 | 4459.99 | 4508.69 | 1836212.0 |
| 2023-10-31 | NQ | Futures | 15552.1 | 15652.74 | 15444.99 | 15638.17 | 712605.0 |
| 2023-10-31 | YM | Futures | 34754.2 | 34959.4 | 34589.0 | 34869.9 | 189649.0 |
| 2023-10-31 | CL | Futures | 73.93 | 74.63 | 72.28 | 72.53 | 346007.0 |
| 2023-10-31 | GC | Futures | 2159.4 | 2172.4 | 2139.8 | 2147.2 | 214776.0 |
| 2023-10-31 | ZN | Futures | 107.56921 | 108.139533 | 107.347418 | 107.648422 | 2355214.0 |
| 2023-10-31 | A6 | Futures | 0.64337 | 0.64367 | 0.63757 | 0.64034 | 117285.0 |
| 2023-10-31 | AD | Futures | 0.72963 | 0.73028 | 0.72615 | 0.72751 | 75841.0 |
| 2023-10-31 | ALI | Futures | 2468.68 | 2476.07 | 2459.64 | 2467.86 | 1409.0 |
| 2023-10-31 | B | Futures | 78.79 | 79.45 | 77.07 | 77.3 | 413756.0 |
| 2023-10-31 | B6 | Futures | 1.2176 | 1.221 | 1.2128 | 1.2159 | 91019.0 |
| 2023-10-31 | BR | Futures | 0.18611 | 0.18733 | 0.18512 | 0.18634 | 13746.0 |
| 2023-10-31 | BTC | Futures | 45584.5 | 46023.7 | 44955.3 | 45755.0 | 5971.0 |
| 2023-10-31 | BZ | Futures | 78.36 | 79.08 | 76.71 | 76.95 | 35673.0 |
| 2023-10-31 | C | Futures | 2833.0 | 2840.0 | 2800.0 | 2808.0 | 5994.0 |
| 2023-10-31 | CB | Futures | 267.453 | 274.882 | 267.453 | 271.415 | 28.0 |
| 2023-10-31 | CC | Futures | 2240.0 | 2260.0 | 2214.0 | 2227.0 | 22845.0 |
| 2023-10-31 | CNH | Futures | 7.0769 | 7.0934 | 7.0735 | 7.091 | 608.0 |
| 2023-10-31 | CSC | Futures | 1.949 | 1.959 | 1.937 | 1.937 | 89.0 |
| 2023-10-31 | CT | Futures | 101.14 | 101.32 | 98.94 | 99.03 | 26784.0 |
| 2023-10-31 | DC | Futures | 18.41 | 18.58 | 18.31 | 18.34 | 504.0 |
| 2023-10-31 | DX | Futures | 104.56 | 105.245 | 104.293 | 105.052 | 18445.0 |
| 2023-10-31 | E1 | Futures | 1.16941 | 1.17046 | 1.15808 | 1.15976 | 28944.0 |
| 2023-10-31 | E6 | Futures | 1.08202 | 1.08823 | 1.07622 | 1.07872 | 242212.0 |
| 2023-10-31 | E7 | Futures | 1.0823 | 1.0884 | 1.0764 | 1.079 | 5557.0 |
| 2023-10-31 | EBM | Futures | 316.99 | 318.36 | 313.56 | 314.93 | 46144.0 |
| 2023-10-31 | ER | Futures | 97.807 | 97.812 | 97.802 | 97.807 | 131243.0 |
| 2023-10-31 | ESG | Futures | 388.74 | 390.69 | 386.7 | 390.54 | 350.0 |
| 2023-10-31 | EW | Futures | 2460.8 | 2491.3 | 2451.1 | 2486.1 | 13854.0 |
| 2023-10-31 | FBON | Futures | 119.01 | 119.14 | 118.64 | 118.7 | 111.0 |
| 2023-10-31 | FBTP | Futures | 109.1 | 109.5 | 108.92 | 109.0 | 260638.0 |
| 2023-10-31 | FBTS | Futures | 105.784 | 105.845 | 105.693 | 105.734 | 157232.0 |
| 2023-10-31 | FCE | Futures | 7308.5 | 7378.4 | 7297.8 | 7358.1 | 48579.0 |
| 2023-10-31 | FDAX | Futures | 15608.0 | 15722.8 | 15557.4 | 15656.5 | 65058.0 |
| 2023-10-31 | FDIV | Futures | 164.45 | 165.45 | 164.45 | 165.45 | 6.0 |
| 2023-10-31 | FDXM | Futures | 15601.9 | 15716.6 | 15550.3 | 15650.3 | 44357.0 |
| 2023-10-31 | FDXS | Futures | 15505.2 | 15616.1 | 15449.7 | 15548.1 | 25838.0 |
| 2023-10-31 | FESX | Futures | 4074.7 | 4116.0 | 4059.6 | 4098.8 | 820589.0 |
| 2023-10-31 | FEU3 | Futures | 97.797 | 97.807 | 97.792 | 97.807 | 24.0 |
| 2023-10-31 | FGBL | Futures | 130.82 | 131.62 | 130.64 | 131.13 | 1209272.0 |
| 2023-10-31 | FGBM | Futures | 117.46 | 117.78 | 117.44 | 117.62 | 831042.0 |
| 2023-10-31 | FGBS | Futures | 107.208 | 107.274 | 107.178 | 107.223 | 694542.0 |
| 2023-10-31 | FGBX | Futures | 123.1 | 124.85 | 122.14 | 123.51 | 127977.0 |
| 2023-10-31 | FMWO | Futures | 9506.1 | 9598.8 | 9506.1 | 9544.7 | 3044.0 |
| 2023-10-31 | FOAT | Futures | 121.76 | 122.53 | 121.55 | 122.0 | 235820.0 |
| 2023-10-31 | FSMX | Futures | 24819.7 | 24884.4 | 24786.8 | 24799.2 | 105.0 |
| 2023-10-31 | FTDX | Futures | 2958.4 | 2973.4 | 2954.7 | 2968.2 | 7.0 |
| 2023-10-31 | FTI | Futures | 735.17 | 742.07 | 733.88 | 739.07 | 13815.0 |
| 2023-10-31 | FTUK | Futures | 7400.2 | 7445.5 | 7378.0 | 7383.1 | 100045.0 |
| 2023-10-31 | FVSA | Futures | 27.86 | 27.93 | 25.87 | 26.69 | 21217.0 |
> showing 50 of 129 rows — these rows as CSV