PREVIEW / futures_daily / 2021-12-22
file: by_date/futures_daily/2021/2021-12-22.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 |
|---|---|---|---|---|---|---|---|
| 2021-12-22 | ES | Futures | 5227.9 | 5282.81 | 5205.94 | 5277.74 | 1104688.0 |
| 2021-12-22 | NQ | Futures | 18419.24 | 18654.39 | 18306.85 | 18639.12 | 476670.0 |
| 2021-12-22 | YM | Futures | 38623.3 | 38903.7 | 38493.5 | 38871.0 | 110144.0 |
| 2021-12-22 | CL | Futures | 53.89 | 55.32 | 53.54 | 55.02 | 306709.0 |
| 2021-12-22 | GC | Futures | 2087.6 | 2107.3 | 2083.4 | 2102.5 | 110408.0 |
| 2021-12-22 | ZN | Futures | 133.656345 | 133.800096 | 133.432733 | 133.640373 | 760008.0 |
| 2021-12-22 | A6 | Futures | 0.73281 | 0.73993 | 0.72974 | 0.73937 | 60468.0 |
| 2021-12-22 | AD | Futures | 0.78543 | 0.7905 | 0.78482 | 0.78984 | 58518.0 |
| 2021-12-22 | ALI | Futures | 3113.09 | 3147.97 | 3113.09 | 3141.1 | 1274.0 |
| 2021-12-22 | B | Futures | 51.36 | 52.49 | 51.07 | 52.22 | 166713.0 |
| 2021-12-22 | B6 | Futures | 1.345 | 1.3547 | 1.3421 | 1.3542 | 73602.0 |
| 2021-12-22 | BR | Futures | 0.14166 | 0.14484 | 0.14166 | 0.14373 | 394.0 |
| 2021-12-22 | BTC | Futures | 64578.0 | 65043.2 | 63555.8 | 64270.0 | 2811.0 |
| 2021-12-22 | BZ | Futures | 49.43 | 50.53 | 49.13 | 50.26 | 28541.0 |
| 2021-12-22 | C | Futures | 1351.0 | 1362.0 | 1341.0 | 1345.0 | 3676.0 |
| 2021-12-22 | CB | Futures | 165.425 | 167.395 | 165.425 | 166.985 | 46.0 |
| 2021-12-22 | CC | Futures | 1554.0 | 1572.0 | 1545.0 | 1551.0 | 13069.0 |
| 2021-12-22 | CNH | Futures | 6.1 | 6.1041 | 6.0985 | 6.1003 | 361.0 |
| 2021-12-22 | CSC | Futures | 2.572 | 2.617 | 2.572 | 2.617 | 65.0 |
| 2021-12-22 | CT | Futures | 103.95 | 106.21 | 103.51 | 105.7 | 9278.0 |
| 2021-12-22 | DC | Futures | 24.57 | 25.19 | 24.45 | 25.06 | 203.0 |
| 2021-12-22 | DX | Futures | 93.228 | 93.339 | 92.783 | 92.831 | 12706.0 |
| 2021-12-22 | E1 | Futures | 1.21093 | 1.21741 | 1.20904 | 1.2164 | 14177.0 |
| 2021-12-22 | E6 | Futures | 1.19773 | 1.20414 | 1.19577 | 1.20308 | 127139.0 |
| 2021-12-22 | E7 | Futures | 1.1911 | 1.1974 | 1.1891 | 1.1963 | 3397.0 |
| 2021-12-22 | EBM | Futures | 411.96 | 419.47 | 409.81 | 418.4 | 25519.0 |
| 2021-12-22 | ED | Futures | 96.4865 | 96.4914 | 96.4768 | 96.4817 | 92401.0 |
| 2021-12-22 | ER | Futures | 98.524 | 98.524 | 98.514 | 98.519 | 20924.0 |
| 2021-12-22 | ESG | Futures | 434.38 | 440.09 | 434.2 | 439.88 | 654.0 |
| 2021-12-22 | EW | Futures | 2963.8 | 2991.1 | 2952.1 | 2987.5 | 11932.0 |
| 2021-12-22 | FBON | Futures | 149.61 | 149.85 | 149.09 | 149.3 | 187.0 |
| 2021-12-22 | FBTP | Futures | 137.35 | 137.46 | 136.61 | 136.8 | 77245.0 |
| 2021-12-22 | FBTS | Futures | 110.264 | 110.303 | 110.147 | 110.196 | 29206.0 |
| 2021-12-22 | FCE | Futures | 7037.3 | 7128.1 | 7012.1 | 7102.9 | 35886.0 |
| 2021-12-22 | FDAX | Futures | 16630.9 | 16767.2 | 16534.3 | 16685.6 | 46317.0 |
| 2021-12-22 | FDIV | Futures | 182.72 | 183.22 | 182.72 | 183.22 | 15.0 |
| 2021-12-22 | FDXM | Futures | 16705.0 | 16839.8 | 16604.8 | 16758.9 | 26538.0 |
| 2021-12-22 | FDXS | Futures | 16517.9 | 16687.7 | 16456.0 | 16606.5 | 9832.0 |
| 2021-12-22 | FESX | Futures | 4018.7 | 4052.8 | 3989.4 | 4030.2 | 386364.0 |
| 2021-12-22 | FGBL | Futures | 169.02 | 169.07 | 168.34 | 168.7 | 363084.0 |
| 2021-12-22 | FGBM | Futures | 134.85 | 134.89 | 134.55 | 134.71 | 223117.0 |
| 2021-12-22 | FGBS | Futures | 112.779 | 112.8 | 112.744 | 112.764 | 152599.0 |
| 2021-12-22 | FGBX | Futures | 229.57 | 230.0 | 228.16 | 229.4 | 43754.0 |
| 2021-12-22 | FMWO | Futures | 11268.9 | 11394.3 | 11226.3 | 11348.2 | 5498.0 |
| 2021-12-22 | FOAT | Futures | 156.34 | 156.46 | 155.74 | 156.07 | 85215.0 |
| 2021-12-22 | FSMX | Futures | 35953.4 | 36502.1 | 35953.4 | 36193.6 | 72.0 |
| 2021-12-22 | FTDX | Futures | 3934.2 | 3994.6 | 3925.5 | 3963.1 | 43.0 |
| 2021-12-22 | FTI | Futures | 745.87 | 752.49 | 742.03 | 750.05 | 12848.0 |
| 2021-12-22 | FTUK | Futures | 7193.1 | 7265.3 | 7174.7 | 7227.5 | 62850.0 |
| 2021-12-22 | FVSA | Futures | 76.37 | 76.37 | 70.92 | 72.79 | 19369.0 |
> showing 50 of 126 rows — these rows as CSV