PREVIEW / futures_daily / 2020-11-25
file: by_date/futures_daily/2020/2020-11-25.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-11-25 | ES | Futures | 4084.41 | 4106.32 | 4061.66 | 4075.15 | 1016343.0 |
| 2020-11-25 | NQ | Futures | 14006.54 | 14098.29 | 13982.23 | 14068.77 | 386232.0 |
| 2020-11-25 | YM | Futures | 32328.6 | 32475.0 | 32035.8 | 32112.2 | 138712.0 |
| 2020-11-25 | CL | Futures | 31.88 | 32.9 | 31.82 | 32.51 | 417182.0 |
| 2020-11-25 | GC | Futures | 2131.3 | 2142.7 | 2122.7 | 2130.3 | 133601.0 |
| 2020-11-25 | ZN | Futures | 137.117924 | 137.334883 | 136.993948 | 137.133421 | 1841962.0 |
| 2020-11-25 | A6 | Futures | 0.7556 | 0.75704 | 0.75211 | 0.75627 | 83782.0 |
| 2020-11-25 | AD | Futures | 0.7797 | 0.78041 | 0.77782 | 0.77985 | 62585.0 |
| 2020-11-25 | ALI | Futures | 2345.6 | 2345.6 | 2322.91 | 2322.91 | 43.0 |
| 2020-11-25 | B | Futures | 30.16 | 30.94 | 30.1 | 30.67 | 358407.0 |
| 2020-11-25 | B6 | Futures | 1.3549 | 1.3582 | 1.3492 | 1.3571 | 91345.0 |
| 2020-11-25 | BR | Futures | 0.14478 | 0.14657 | 0.14478 | 0.14622 | 1865.0 |
| 2020-11-25 | BTC | Futures | 25292.8 | 25879.0 | 24608.8 | 24980.1 | 4270.0 |
| 2020-11-25 | BZ | Futures | 29.52 | 30.25 | 29.37 | 30.0 | 33029.0 |
| 2020-11-25 | C | Futures | 1672.0 | 1684.0 | 1627.0 | 1637.0 | 3003.0 |
| 2020-11-25 | CB | Futures | 143.963 | 147.654 | 143.963 | 145.163 | 37.0 |
| 2020-11-25 | CC | Futures | 1813.0 | 1819.0 | 1765.0 | 1790.0 | 22647.0 |
| 2020-11-25 | CNH | Futures | 6.4492 | 6.4534 | 6.4324 | 6.4324 | 517.0 |
| 2020-11-25 | CSC | Futures | 3.0 | 3.002 | 2.988 | 2.988 | 62.0 |
| 2020-11-25 | CT | Futures | 70.38 | 70.67 | 69.85 | 69.91 | 9859.0 |
| 2020-11-25 | DC | Futures | 24.9 | 24.93 | 24.82 | 24.88 | 68.0 |
| 2020-11-25 | DX | Futures | 88.994 | 89.115 | 88.777 | 88.836 | 22732.0 |
| 2020-11-25 | E1 | Futures | 1.24341 | 1.24805 | 1.23967 | 1.24692 | 23393.0 |
| 2020-11-25 | E6 | Futures | 1.27452 | 1.27848 | 1.27329 | 1.27704 | 182930.0 |
| 2020-11-25 | E7 | Futures | 1.2679 | 1.2719 | 1.2669 | 1.2706 | 7043.0 |
| 2020-11-25 | EBM | Futures | 256.78 | 257.68 | 254.06 | 254.37 | 11170.0 |
| 2020-11-25 | ED | Futures | 96.4818 | 96.4842 | 96.4769 | 96.4818 | 124958.0 |
| 2020-11-25 | ER | Futures | 98.455 | 98.46 | 98.455 | 98.46 | 16390.0 |
| 2020-11-25 | ESG | Futures | 335.01 | 335.31 | 334.27 | 335.12 | 1271.0 |
| 2020-11-25 | EW | Futures | 2371.1 | 2381.7 | 2340.0 | 2352.6 | 12862.0 |
| 2020-11-25 | FBON | Futures | 150.33 | 150.71 | 150.27 | 150.5 | 171.0 |
| 2020-11-25 | FBTP | Futures | 138.6 | 138.85 | 138.47 | 138.63 | 84206.0 |
| 2020-11-25 | FBTS | Futures | 110.058 | 110.077 | 110.029 | 110.049 | 63279.0 |
| 2020-11-25 | FCE | Futures | 5421.3 | 5445.2 | 5399.8 | 5426.1 | 57277.0 |
| 2020-11-25 | FDAX | Futures | 14227.5 | 14255.2 | 14101.2 | 14179.0 | 57823.0 |
| 2020-11-25 | FDIV | Futures | 158.86 | 159.95 | 158.86 | 159.95 | 90.0 |
| 2020-11-25 | FDXM | Futures | 14159.5 | 14204.0 | 14030.1 | 14107.5 | 30255.0 |
| 2020-11-25 | FESX | Futures | 3253.3 | 3262.6 | 3226.5 | 3246.9 | 770139.0 |
| 2020-11-25 | FGBL | Futures | 170.29 | 170.64 | 170.15 | 170.51 | 507662.0 |
| 2020-11-25 | FGBM | Futures | 135.3 | 135.42 | 135.26 | 135.37 | 307231.0 |
| 2020-11-25 | FGBS | Futures | 112.805 | 112.825 | 112.795 | 112.815 | 224569.0 |
| 2020-11-25 | FGBX | Futures | 235.08 | 236.69 | 234.52 | 236.12 | 70729.0 |
| 2020-11-25 | FMWO | Futures | 9136.7 | 9140.2 | 9088.1 | 9113.0 | 13140.0 |
| 2020-11-25 | FOAT | Futures | 158.92 | 159.21 | 158.77 | 159.06 | 115647.0 |
| 2020-11-25 | FTDX | Futures | 3117.7 | 3140.4 | 3111.6 | 3136.3 | 177.0 |
| 2020-11-25 | FTI | Futures | 567.84 | 568.22 | 563.82 | 566.53 | 17074.0 |
| 2020-11-25 | FTUK | Futures | 6160.4 | 6186.7 | 6078.2 | 6091.6 | 92572.0 |
| 2020-11-25 | FVSA | Futures | 154.68 | 157.27 | 150.24 | 153.2 | 12551.0 |
| 2020-11-25 | FXXP | Futures | 363.4 | 364.7 | 361.8 | 363.1 | 50701.0 |
| 2020-11-25 | G | Futures | 125.76 | 126.11 | 125.67 | 126.01 | 239587.0 |
> showing 50 of 120 rows — these rows as CSV