PREVIEW / futures_daily / 2023-10-19
file: by_date/futures_daily/2023/2023-10-19.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-19 | ES | Futures | 4652.39 | 4673.8 | 4594.85 | 4605.83 | 2741942.0 |
| 2023-10-19 | NQ | Futures | 16236.87 | 16337.5 | 16015.09 | 16069.59 | 1019700.0 |
| 2023-10-19 | YM | Futures | 35599.2 | 35769.7 | 35245.6 | 35303.5 | 286548.0 |
| 2023-10-19 | CL | Futures | 78.08 | 80.15 | 76.48 | 79.11 | 384030.0 |
| 2023-10-19 | GC | Futures | 2110.4 | 2142.8 | 2107.1 | 2132.4 | 264821.0 |
| 2023-10-19 | ZN | Futures | 107.284049 | 107.426629 | 106.792938 | 106.887991 | 2395898.0 |
| 2023-10-19 | A6 | Futures | 0.63999 | 0.64211 | 0.63596 | 0.63919 | 111627.0 |
| 2023-10-19 | AD | Futures | 0.73568 | 0.73754 | 0.73426 | 0.73537 | 97404.0 |
| 2023-10-19 | ALI | Futures | 2396.09 | 2404.31 | 2386.78 | 2399.38 | 3854.0 |
| 2023-10-19 | B | Futures | 82.19 | 84.11 | 80.59 | 83.12 | 308996.0 |
| 2023-10-19 | B6 | Futures | 1.2148 | 1.22 | 1.2099 | 1.2151 | 115345.0 |
| 2023-10-19 | BR | Futures | 0.18474 | 0.18653 | 0.18451 | 0.1854 | 981.0 |
| 2023-10-19 | BTC | Futures | 37838.7 | 38853.6 | 37625.1 | 38593.2 | 7780.0 |
| 2023-10-19 | BZ | Futures | 82.01 | 83.92 | 80.38 | 82.94 | 34880.0 |
| 2023-10-19 | C | Futures | 2645.0 | 2707.0 | 2645.0 | 2674.0 | 9542.0 |
| 2023-10-19 | CB | Futures | 271.489 | 273.891 | 271.489 | 273.396 | 58.0 |
| 2023-10-19 | CC | Futures | 2135.0 | 2159.0 | 2118.0 | 2128.0 | 21540.0 |
| 2023-10-19 | CNH | Futures | 7.0794 | 7.106 | 7.0774 | 7.0978 | 804.0 |
| 2023-10-19 | CSC | Futures | 2.071 | 2.094 | 2.04 | 2.059 | 433.0 |
| 2023-10-19 | CT | Futures | 102.64 | 102.89 | 100.48 | 102.75 | 20510.0 |
| 2023-10-19 | DC | Futures | 20.04 | 20.3 | 19.66 | 19.82 | 901.0 |
| 2023-10-19 | DX | Futures | 104.929 | 105.043 | 104.313 | 104.61 | 17783.0 |
| 2023-10-19 | E1 | Futures | 1.17487 | 1.18494 | 1.17277 | 1.18163 | 27134.0 |
| 2023-10-19 | E6 | Futures | 1.07465 | 1.08268 | 1.07368 | 1.07912 | 238062.0 |
| 2023-10-19 | E7 | Futures | 1.0749 | 1.0828 | 1.0739 | 1.0794 | 5538.0 |
| 2023-10-19 | EBM | Futures | 330.03 | 330.37 | 325.22 | 326.94 | 34265.0 |
| 2023-10-19 | ER | Futures | 97.751 | 97.751 | 97.741 | 97.746 | 134299.0 |
| 2023-10-19 | ESG | Futures | 400.89 | 404.71 | 398.09 | 399.03 | 720.0 |
| 2023-10-19 | EW | Futures | 2586.6 | 2595.0 | 2537.5 | 2545.4 | 14460.0 |
| 2023-10-19 | FBON | Futures | 116.54 | 117.09 | 116.43 | 116.86 | 154.0 |
| 2023-10-19 | FBTP | Futures | 106.41 | 107.38 | 106.24 | 106.91 | 195506.0 |
| 2023-10-19 | FBTS | Futures | 104.944 | 105.197 | 104.914 | 105.086 | 134981.0 |
| 2023-10-19 | FCE | Futures | 7413.6 | 7428.0 | 7341.0 | 7404.5 | 65601.0 |
| 2023-10-19 | FDAX | Futures | 15972.5 | 16010.4 | 15840.8 | 15944.1 | 69171.0 |
| 2023-10-19 | FDIV | Futures | 169.58 | 171.27 | 169.43 | 169.43 | 9.0 |
| 2023-10-19 | FDXM | Futures | 15946.2 | 16003.1 | 15835.6 | 15937.8 | 47094.0 |
| 2023-10-19 | FDXS | Futures | 15850.4 | 15898.6 | 15733.3 | 15833.7 | 26514.0 |
| 2023-10-19 | FESX | Futures | 4140.1 | 4156.2 | 4100.9 | 4134.1 | 926454.0 |
| 2023-10-19 | FEU3 | Futures | 97.741 | 97.741 | 97.741 | 97.741 | 0.0 |
| 2023-10-19 | FGBL | Futures | 129.79 | 130.01 | 129.4 | 129.65 | 1053433.0 |
| 2023-10-19 | FGBM | Futures | 116.63 | 116.73 | 116.45 | 116.53 | 694655.0 |
| 2023-10-19 | FGBS | Futures | 106.887 | 106.943 | 106.841 | 106.861 | 610547.0 |
| 2023-10-19 | FGBX | Futures | 123.12 | 123.76 | 121.77 | 123.08 | 100349.0 |
| 2023-10-19 | FMWO | Futures | 9828.4 | 9897.9 | 9747.8 | 9829.5 | 13958.0 |
| 2023-10-19 | FOAT | Futures | 120.63 | 121.0 | 120.26 | 120.65 | 242857.0 |
| 2023-10-19 | FSMX | Futures | 25431.9 | 25505.8 | 25201.8 | 25221.3 | 443.0 |
| 2023-10-19 | FTDX | Futures | 3057.6 | 3065.9 | 3024.3 | 3025.4 | 32.0 |
| 2023-10-19 | FTI | Futures | 747.32 | 752.53 | 743.77 | 749.01 | 13947.0 |
| 2023-10-19 | FTUK | Futures | 7658.1 | 7675.2 | 7551.8 | 7591.6 | 116767.0 |
| 2023-10-19 | FVSA | Futures | 28.07 | 29.78 | 28.0 | 28.75 | 30060.0 |
> showing 50 of 129 rows — these rows as CSV