PREVIEW / futures_daily / 2020-10-22
file: by_date/futures_daily/2020/2020-10-22.parquet size: 10 KB rows: 120
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 |
|---|---|---|---|---|---|---|---|
| 2020-10-22 | ES | Futures | 3853.82 | 3879.38 | 3822.64 | 3875.17 | 1501259.0 |
| 2020-10-22 | NQ | Futures | 13526.09 | 13572.98 | 13326.39 | 13487.02 | 583669.0 |
| 2020-10-22 | YM | Futures | 30284.2 | 30481.2 | 30032.3 | 30432.7 | 152049.0 |
| 2020-10-22 | CL | Futures | 28.54 | 29.24 | 28.31 | 28.97 | 307494.0 |
| 2020-10-22 | GC | Futures | 2276.3 | 2278.6 | 2237.1 | 2249.4 | 215581.0 |
| 2020-10-22 | ZN | Futures | 137.365877 | 137.489854 | 137.024942 | 137.19541 | 1390076.0 |
| 2020-10-22 | A6 | Futures | 0.7304 | 0.73163 | 0.72753 | 0.7304 | 79198.0 |
| 2020-10-22 | AD | Futures | 0.77139 | 0.77225 | 0.76916 | 0.77119 | 65128.0 |
| 2020-10-22 | ALI | Futures | 2199.53 | 2203.98 | 2199.53 | 2201.9 | 32.0 |
| 2020-10-22 | B | Futures | 26.24 | 27.0 | 26.16 | 26.79 | 257199.0 |
| 2020-10-22 | B6 | Futures | 1.3328 | 1.334 | 1.3256 | 1.3264 | 79269.0 |
| 2020-10-22 | BR | Futures | 0.13987 | 0.14108 | 0.13967 | 0.14026 | 1175.0 |
| 2020-10-22 | BTC | Futures | 17420.3 | 17850.3 | 17097.8 | 17675.6 | 7369.0 |
| 2020-10-22 | BZ | Futures | 25.81 | 26.48 | 25.66 | 26.27 | 30590.0 |
| 2020-10-22 | C | Futures | 1472.0 | 1506.0 | 1472.0 | 1500.0 | 3503.0 |
| 2020-10-22 | CB | Futures | 153.348 | 156.524 | 153.119 | 154.466 | 8.0 |
| 2020-10-22 | CC | Futures | 1593.0 | 1626.0 | 1591.0 | 1625.0 | 9780.0 |
| 2020-10-22 | CNH | Futures | 6.5275 | 6.5572 | 6.5229 | 6.5507 | 910.0 |
| 2020-10-22 | CSC | Futures | 3.628 | 3.774 | 3.628 | 3.774 | 219.0 |
| 2020-10-22 | CT | Futures | 70.17 | 71.25 | 69.99 | 71.1 | 16513.0 |
| 2020-10-22 | DC | Futures | 29.48 | 30.96 | 29.48 | 30.91 | 871.0 |
| 2020-10-22 | DX | Futures | 89.569 | 89.825 | 89.458 | 89.8 | 12272.0 |
| 2020-10-22 | E1 | Futures | 1.25303 | 1.25326 | 1.24862 | 1.24975 | 17067.0 |
| 2020-10-22 | E6 | Futures | 1.272 | 1.27254 | 1.26654 | 1.26734 | 151595.0 |
| 2020-10-22 | E7 | Futures | 1.2655 | 1.2661 | 1.2601 | 1.2609 | 4901.0 |
| 2020-10-22 | EBM | Futures | 253.46 | 254.37 | 251.65 | 251.96 | 49564.0 |
| 2020-10-22 | ED | Futures | 96.4939 | 96.4987 | 96.4939 | 96.4939 | 47777.0 |
| 2020-10-22 | ER | Futures | 98.445 | 98.45 | 98.44 | 98.445 | 118407.0 |
| 2020-10-22 | ESG | Futures | 320.0 | 321.08 | 318.37 | 320.39 | 114.0 |
| 2020-10-22 | EW | Futures | 2102.4 | 2143.3 | 2087.2 | 2137.8 | 11791.0 |
| 2020-10-22 | FBON | Futures | 148.46 | 148.73 | 148.3 | 148.3 | 440.0 |
| 2020-10-22 | FBTP | Futures | 136.29 | 136.41 | 135.92 | 136.0 | 177227.0 |
| 2020-10-22 | FBTS | Futures | 109.585 | 109.672 | 109.585 | 109.595 | 99691.0 |
| 2020-10-22 | FCE | Futures | 4658.4 | 4710.6 | 4620.2 | 4687.4 | 75416.0 |
| 2020-10-22 | FDAX | Futures | 13304.2 | 13424.7 | 13144.3 | 13355.4 | 93767.0 |
| 2020-10-22 | FDIV | Futures | 142.51 | 144.5 | 142.51 | 144.17 | 135.0 |
| 2020-10-22 | FDXM | Futures | 13251.4 | 13364.9 | 13078.5 | 13288.0 | 55270.0 |
| 2020-10-22 | FESX | Futures | 2915.9 | 2939.0 | 2889.1 | 2923.3 | 985549.0 |
| 2020-10-22 | FEU3 | Futures | 99.183 | 99.183 | 99.183 | 99.183 | 75.0 |
| 2020-10-22 | FGBL | Futures | 170.71 | 170.9 | 170.35 | 170.37 | 613665.0 |
| 2020-10-22 | FGBM | Futures | 135.62 | 135.65 | 135.47 | 135.49 | 295272.0 |
| 2020-10-22 | FGBS | Futures | 112.89 | 112.91 | 112.865 | 112.87 | 443963.0 |
| 2020-10-22 | FGBX | Futures | 236.1 | 236.67 | 234.54 | 234.66 | 78440.0 |
| 2020-10-22 | FMWO | Futures | 8463.9 | 8531.4 | 8442.6 | 8494.7 | 3367.0 |
| 2020-10-22 | FOAT | Futures | 158.65 | 158.83 | 158.26 | 158.28 | 135138.0 |
| 2020-10-22 | FTDX | Futures | 3127.5 | 3140.4 | 3102.8 | 3134.7 | 163.0 |
| 2020-10-22 | FTI | Futures | 513.37 | 515.46 | 508.36 | 512.71 | 24094.0 |
| 2020-10-22 | FTUK | Futures | 5462.6 | 5529.1 | 5437.8 | 5508.5 | 80881.0 |
| 2020-10-22 | FVSA | Futures | 188.59 | 193.96 | 181.8 | 186.09 | 22486.0 |
| 2020-10-22 | FXXP | Futures | 331.9 | 334.5 | 329.2 | 332.9 | 53814.0 |
> showing 50 of 120 rows — these rows as CSV