PREVIEW / futures_daily / 2023-10-05
file: by_date/futures_daily/2023/2023-10-05.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-10-05 | ES | Futures | 4593.52 | 4604.76 | 4557.66 | 4592.71 | 1673477.0 |
| 2023-10-05 | NQ | Futures | 16083.62 | 16143.78 | 15882.07 | 16039.1 | 676461.0 |
| 2023-10-05 | YM | Futures | 35016.2 | 35114.1 | 34857.3 | 35047.8 | 181562.0 |
| 2023-10-05 | CL | Futures | 74.46 | 74.87 | 72.43 | 72.57 | 465997.0 |
| 2023-10-05 | GC | Futures | 1978.5 | 1984.9 | 1966.2 | 1972.3 | 172464.0 |
| 2023-10-05 | ZN | Futures | 108.567275 | 108.884121 | 108.377167 | 108.80491 | 1823513.0 |
| 2023-10-05 | A6 | Futures | 0.63944 | 0.64458 | 0.63919 | 0.64397 | 108516.0 |
| 2023-10-05 | AD | Futures | 0.73431 | 0.73638 | 0.73205 | 0.73578 | 95417.0 |
| 2023-10-05 | ALI | Futures | 2484.36 | 2484.36 | 2455.46 | 2460.96 | 1436.0 |
| 2023-10-05 | B | Futures | 77.27 | 77.85 | 75.44 | 75.64 | 510684.0 |
| 2023-10-05 | B6 | Futures | 1.2148 | 1.2205 | 1.2117 | 1.2204 | 105366.0 |
| 2023-10-05 | BFX | Futures | 3760.7 | 3760.7 | 3760.7 | 3760.7 | 0.0 |
| 2023-10-05 | BR | Futures | 0.18126 | 0.18126 | 0.18031 | 0.18097 | 317.0 |
| 2023-10-05 | BTC | Futures | 37197.7 | 37845.4 | 36676.9 | 36863.9 | 10419.0 |
| 2023-10-05 | BZ | Futures | 77.24 | 77.67 | 75.28 | 75.48 | 44895.0 |
| 2023-10-05 | C | Futures | 2457.0 | 2476.0 | 2429.0 | 2442.0 | 6567.0 |
| 2023-10-05 | CB | Futures | 269.434 | 271.39 | 269.434 | 271.39 | 11.0 |
| 2023-10-05 | CC | Futures | 2006.0 | 2010.0 | 1969.0 | 1984.0 | 22992.0 |
| 2023-10-05 | CNH | Futures | 7.0745 | 7.0823 | 7.0629 | 7.0629 | 393.0 |
| 2023-10-05 | CSC | Futures | 1.988 | 1.995 | 1.978 | 1.995 | 137.0 |
| 2023-10-05 | CT | Futures | 106.09 | 107.37 | 105.4 | 105.51 | 19265.0 |
| 2023-10-05 | DC | Futures | 18.67 | 18.84 | 18.57 | 18.82 | 379.0 |
| 2023-10-05 | DX | Futures | 105.082 | 105.166 | 104.614 | 104.629 | 16177.0 |
| 2023-10-05 | E1 | Futures | 1.15336 | 1.15897 | 1.15136 | 1.15808 | 16967.0 |
| 2023-10-05 | E6 | Futures | 1.07236 | 1.07678 | 1.07149 | 1.07668 | 178463.0 |
| 2023-10-05 | E7 | Futures | 1.0725 | 1.0769 | 1.0717 | 1.0769 | 3782.0 |
| 2023-10-05 | EBM | Futures | 320.42 | 323.51 | 318.36 | 322.82 | 30794.0 |
| 2023-10-05 | ER | Futures | 97.777 | 97.787 | 97.766 | 97.782 | 126534.0 |
| 2023-10-05 | ESG | Futures | 397.3 | 398.59 | 394.86 | 397.59 | 572.0 |
| 2023-10-05 | EW | Futures | 2567.6 | 2579.2 | 2551.2 | 2567.6 | 13960.0 |
| 2023-10-05 | FBON | Futures | 117.28 | 117.39 | 116.7 | 117.37 | 94.0 |
| 2023-10-05 | FBTP | Futures | 107.78 | 107.86 | 106.99 | 107.59 | 223669.0 |
| 2023-10-05 | FBTS | Futures | 105.4 | 105.42 | 105.299 | 105.4 | 122064.0 |
| 2023-10-05 | FCE | Futures | 7576.3 | 7579.6 | 7515.5 | 7547.3 | 55819.0 |
| 2023-10-05 | FDAX | Futures | 16060.0 | 16111.6 | 15972.5 | 15998.8 | 55413.0 |
| 2023-10-05 | FDIV | Futures | 172.17 | 172.17 | 172.17 | 172.17 | 0.0 |
| 2023-10-05 | FDXM | Futures | 16053.6 | 16105.2 | 15967.3 | 15992.6 | 40447.0 |
| 2023-10-05 | FDXS | Futures | 15973.9 | 16001.1 | 15861.9 | 15888.1 | 27264.0 |
| 2023-10-05 | FESX | Futures | 4156.2 | 4179.4 | 4140.1 | 4151.2 | 689677.0 |
| 2023-10-05 | FEU3 | Futures | 97.776 | 97.776 | 97.776 | 97.776 | 0.0 |
| 2023-10-05 | FGBL | Futures | 129.65 | 130.41 | 129.33 | 130.2 | 971522.0 |
| 2023-10-05 | FGBM | Futures | 116.75 | 117.14 | 116.63 | 117.06 | 673218.0 |
| 2023-10-05 | FGBS | Futures | 107.065 | 107.162 | 107.03 | 107.142 | 519324.0 |
| 2023-10-05 | FGBX | Futures | 122.2 | 123.35 | 120.85 | 122.69 | 120562.0 |
| 2023-10-05 | FMWO | Futures | 9775.4 | 9789.8 | 9713.6 | 9724.7 | 7506.0 |
| 2023-10-05 | FOAT | Futures | 120.67 | 121.26 | 120.32 | 121.1 | 289096.0 |
| 2023-10-05 | FSMX | Futures | 26310.1 | 26310.1 | 26011.2 | 26011.2 | 52.0 |
| 2023-10-05 | FTDX | Futures | 3144.8 | 3144.8 | 3116.8 | 3116.8 | 2.0 |
| 2023-10-05 | FTI | Futures | 752.77 | 754.85 | 749.29 | 750.26 | 16144.0 |
| 2023-10-05 | FTUK | Futures | 7519.1 | 7585.1 | 7501.4 | 7547.8 | 98538.0 |
> showing 50 of 130 rows — these rows as CSV