PREVIEW / futures_daily / 2021-12-20
file: by_date/futures_daily/2021/2021-12-20.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-20 | ES | Futures | 5194.4 | 5205.1 | 5091.06 | 5134.14 | 2097624.0 |
| 2021-12-20 | NQ | Futures | 18223.85 | 18272.56 | 17857.87 | 18006.86 | 676197.0 |
| 2021-12-20 | YM | Futures | 38457.5 | 38539.3 | 37687.3 | 37977.5 | 220121.0 |
| 2021-12-20 | CL | Futures | 52.84 | 52.92 | 50.0 | 51.88 | 492217.0 |
| 2021-12-20 | GC | Futures | 2100.2 | 2105.3 | 2087.1 | 2093.7 | 105386.0 |
| 2021-12-20 | ZN | Futures | 134.135514 | 134.51885 | 133.975791 | 134.071625 | 1215343.0 |
| 2021-12-20 | A6 | Futures | 0.73056 | 0.73076 | 0.72584 | 0.72866 | 74521.0 |
| 2021-12-20 | AD | Futures | 0.787 | 0.7872 | 0.78243 | 0.7834 | 70614.0 |
| 2021-12-20 | ALI | Futures | 2933.45 | 2936.75 | 2911.48 | 2921.09 | 1860.0 |
| 2021-12-20 | B | Futures | 50.51 | 50.55 | 48.06 | 49.61 | 333764.0 |
| 2021-12-20 | B6 | Futures | 1.3426 | 1.3427 | 1.3354 | 1.3384 | 81993.0 |
| 2021-12-20 | BR | Futures | 0.14344 | 0.14373 | 0.1417 | 0.14203 | 1395.0 |
| 2021-12-20 | BTC | Futures | 61957.1 | 62317.5 | 59644.2 | 61668.8 | 4303.0 |
| 2021-12-20 | BZ | Futures | 48.77 | 48.78 | 46.24 | 47.74 | 36842.0 |
| 2021-12-20 | C | Futures | 1346.0 | 1352.0 | 1331.0 | 1334.0 | 8302.0 |
| 2021-12-20 | CB | Futures | 162.304 | 162.889 | 161.523 | 162.616 | 54.0 |
| 2021-12-20 | CC | Futures | 1552.0 | 1558.0 | 1521.0 | 1524.0 | 18335.0 |
| 2021-12-20 | CNH | Futures | 6.112 | 6.112 | 6.1038 | 6.1054 | 366.0 |
| 2021-12-20 | CSC | Futures | 2.572 | 2.572 | 2.546 | 2.553 | 61.0 |
| 2021-12-20 | CT | Futures | 104.59 | 104.59 | 101.27 | 102.51 | 14244.0 |
| 2021-12-20 | DC | Futures | 24.64 | 24.64 | 24.39 | 24.46 | 149.0 |
| 2021-12-20 | DX | Futures | 93.373 | 93.421 | 93.092 | 93.3 | 13681.0 |
| 2021-12-20 | E1 | Futures | 1.21049 | 1.21696 | 1.20937 | 1.21283 | 14222.0 |
| 2021-12-20 | E6 | Futures | 1.19349 | 1.20022 | 1.19296 | 1.19709 | 122480.0 |
| 2021-12-20 | E7 | Futures | 1.1869 | 1.1934 | 1.1863 | 1.1904 | 3659.0 |
| 2021-12-20 | EBM | Futures | 393.7 | 400.86 | 390.48 | 400.5 | 15249.0 |
| 2021-12-20 | ED | Futures | 96.4914 | 96.5107 | 96.4768 | 96.4962 | 86907.0 |
| 2021-12-20 | ER | Futures | 98.524 | 98.529 | 98.519 | 98.524 | 21864.0 |
| 2021-12-20 | ESG | Futures | 426.12 | 427.69 | 424.15 | 427.5 | 747.0 |
| 2021-12-20 | EW | Futures | 2937.6 | 2939.4 | 2846.1 | 2884.1 | 19856.0 |
| 2021-12-20 | FBON | Futures | 151.05 | 151.28 | 150.08 | 150.75 | 342.0 |
| 2021-12-20 | FBTP | Futures | 138.61 | 138.66 | 137.95 | 138.2 | 63688.0 |
| 2021-12-20 | FBTS | Futures | 110.419 | 110.458 | 110.351 | 110.39 | 33792.0 |
| 2021-12-20 | FCE | Futures | 6828.0 | 6972.7 | 6779.0 | 6919.3 | 66088.0 |
| 2021-12-20 | FDAX | Futures | 16475.3 | 16538.6 | 16144.8 | 16331.5 | 80510.0 |
| 2021-12-20 | FDIV | Futures | 178.8 | 180.74 | 178.6 | 180.74 | 2.0 |
| 2021-12-20 | FDXM | Futures | 16584.3 | 16584.3 | 16215.8 | 16403.3 | 58908.0 |
| 2021-12-20 | FDXS | Futures | 16461.3 | 16461.3 | 15856.8 | 16254.1 | 30583.0 |
| 2021-12-20 | FESX | Futures | 3938.4 | 3962.4 | 3871.1 | 3932.6 | 704016.0 |
| 2021-12-20 | FGBL | Futures | 170.26 | 170.45 | 169.62 | 169.94 | 403160.0 |
| 2021-12-20 | FGBM | Futures | 135.16 | 135.31 | 135.06 | 135.19 | 227322.0 |
| 2021-12-20 | FGBS | Futures | 112.825 | 112.88 | 112.825 | 112.855 | 133672.0 |
| 2021-12-20 | FGBX | Futures | 234.53 | 235.73 | 232.21 | 233.08 | 45989.0 |
| 2021-12-20 | FMWO | Futures | 11135.2 | 11135.2 | 10989.7 | 11024.0 | 10338.0 |
| 2021-12-20 | FOAT | Futures | 157.68 | 157.85 | 157.14 | 157.38 | 93612.0 |
| 2021-12-20 | FSMX | Futures | 35380.5 | 35712.1 | 35256.7 | 35640.7 | 126.0 |
| 2021-12-20 | FTDX | Futures | 3890.4 | 3916.2 | 3872.8 | 3916.2 | 55.0 |
| 2021-12-20 | FTI | Futures | 726.44 | 737.14 | 721.65 | 731.81 | 21521.0 |
| 2021-12-20 | FTUK | Futures | 7109.0 | 7146.9 | 7002.6 | 7098.6 | 98288.0 |
| 2021-12-20 | FVSA | Futures | 77.78 | 86.35 | 76.84 | 84.32 | 51627.0 |
> showing 50 of 126 rows — these rows as CSV