PREVIEW / futures_daily / 2022-10-18
file: by_date/futures_daily/2022/2022-10-18.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-10-18 | ES | Futures | 4130.9 | 4210.04 | 4120.87 | 4160.44 | 2746886.0 |
| 2022-10-18 | NQ | Futures | 12648.48 | 12955.03 | 12558.11 | 12690.98 | 832215.0 |
| 2022-10-18 | YM | Futures | 33007.0 | 33598.9 | 33007.0 | 33271.4 | 217313.0 |
| 2022-10-18 | CL | Futures | 73.28 | 73.91 | 70.25 | 70.92 | 367498.0 |
| 2022-10-18 | GC | Futures | 1895.0 | 1906.6 | 1889.0 | 1894.9 | 163168.0 |
| 2022-10-18 | ZN | Futures | 113.904976 | 114.338991 | 113.631707 | 114.097872 | 1330805.0 |
| 2022-10-18 | A6 | Futures | 0.64456 | 0.64952 | 0.6419 | 0.64487 | 84936.0 |
| 2022-10-18 | AD | Futures | 0.73967 | 0.74276 | 0.73455 | 0.73648 | 87765.0 |
| 2022-10-18 | ALI | Futures | 2555.28 | 2564.05 | 2475.01 | 2498.75 | 1075.0 |
| 2022-10-18 | B | Futures | 78.89 | 79.46 | 76.12 | 77.2 | 320421.0 |
| 2022-10-18 | B6 | Futures | 1.1487 | 1.1533 | 1.1376 | 1.144 | 114526.0 |
| 2022-10-18 | BR | Futures | 0.16573 | 0.16578 | 0.16547 | 0.16578 | 106.0 |
| 2022-10-18 | BTC | Futures | 27178.0 | 27442.5 | 26509.9 | 26697.8 | 8664.0 |
| 2022-10-18 | BZ | Futures | 77.31 | 77.84 | 74.58 | 75.64 | 40941.0 |
| 2022-10-18 | C | Futures | 1387.0 | 1392.0 | 1376.0 | 1378.0 | 9295.0 |
| 2022-10-18 | CB | Futures | 239.076 | 240.422 | 238.141 | 240.399 | 79.0 |
| 2022-10-18 | CC | Futures | 1369.0 | 1372.0 | 1348.0 | 1350.0 | 27372.0 |
| 2022-10-18 | CNH | Futures | 6.7814 | 6.812 | 6.7735 | 6.806 | 1209.0 |
| 2022-10-18 | CSC | Futures | 2.47 | 2.47 | 2.456 | 2.465 | 110.0 |
| 2022-10-18 | CT | Futures | 107.61 | 108.46 | 105.91 | 106.57 | 15750.0 |
| 2022-10-18 | DC | Futures | 24.07 | 24.07 | 23.65 | 23.83 | 256.0 |
| 2022-10-18 | DX | Futures | 108.643 | 109.011 | 108.313 | 108.666 | 41676.0 |
| 2022-10-18 | E1 | Futures | 1.10784 | 1.11201 | 1.10526 | 1.10844 | 17044.0 |
| 2022-10-18 | E6 | Futures | 1.02874 | 1.03243 | 1.02577 | 1.02968 | 170322.0 |
| 2022-10-18 | E7 | Futures | 1.0275 | 1.0306 | 1.0241 | 1.028 | 5756.0 |
| 2022-10-18 | EBM | Futures | 488.69 | 488.69 | 473.09 | 474.86 | 43104.0 |
| 2022-10-18 | ED | Futures | 94.0376 | 94.0722 | 94.0227 | 94.0623 | 138399.0 |
| 2022-10-18 | ER | Futures | 97.666 | 97.696 | 97.656 | 97.686 | 96089.0 |
| 2022-10-18 | ESG | Futures | 359.83 | 362.75 | 355.1 | 358.14 | 2990.0 |
| 2022-10-18 | EW | Futures | 2512.6 | 2572.2 | 2512.6 | 2539.8 | 13763.0 |
| 2022-10-18 | FBON | Futures | 120.53 | 120.85 | 119.68 | 120.48 | 89.0 |
| 2022-10-18 | FBTP | Futures | 105.06 | 105.45 | 103.77 | 104.96 | 117445.0 |
| 2022-10-18 | FBTS | Futures | 105.22 | 105.36 | 105.01 | 105.21 | 68345.0 |
| 2022-10-18 | FCE | Futures | 6654.4 | 6701.9 | 6607.0 | 6621.7 | 54914.0 |
| 2022-10-18 | FDAX | Futures | 13894.3 | 14138.8 | 13832.1 | 13982.7 | 78005.0 |
| 2022-10-18 | FDIV | Futures | 152.52 | 152.52 | 150.43 | 151.33 | 32.0 |
| 2022-10-18 | FDXM | Futures | 13677.0 | 13927.6 | 13627.5 | 13774.9 | 55918.0 |
| 2022-10-18 | FDXS | Futures | 13585.5 | 13859.4 | 13568.3 | 13706.4 | 30118.0 |
| 2022-10-18 | FESX | Futures | 3423.1 | 3472.6 | 3402.3 | 3432.0 | 1032951.0 |
| 2022-10-18 | FEU3 | Futures | 97.672 | 97.757 | 97.672 | 97.757 | 1.0 |
| 2022-10-18 | FGBL | Futures | 136.57 | 137.47 | 135.72 | 137.01 | 783972.0 |
| 2022-10-18 | FGBM | Futures | 120.86 | 121.23 | 120.49 | 121.01 | 444298.0 |
| 2022-10-18 | FGBS | Futures | 109.111 | 109.208 | 108.998 | 109.136 | 466396.0 |
| 2022-10-18 | FGBX | Futures | 141.98 | 144.45 | 140.09 | 143.14 | 61290.0 |
| 2022-10-18 | FMWO | Futures | 8768.2 | 8885.5 | 8714.8 | 8731.0 | 22892.0 |
| 2022-10-18 | FOAT | Futures | 125.94 | 126.78 | 125.04 | 126.32 | 134485.0 |
| 2022-10-18 | FSMX | Futures | 24710.4 | 25257.0 | 24557.0 | 24667.0 | 1147.0 |
| 2022-10-18 | FTDX | Futures | 2988.5 | 3013.0 | 2981.6 | 2993.3 | 236.0 |
| 2022-10-18 | FTI | Futures | 655.99 | 660.24 | 651.01 | 652.02 | 15045.0 |
| 2022-10-18 | FTUK | Futures | 7010.6 | 7085.2 | 6987.4 | 7007.0 | 94784.0 |
> showing 50 of 126 rows — these rows as CSV