PREVIEW / futures_daily / 2020-11-19
file: by_date/futures_daily/2020/2020-11-19.parquet size: 10 KB rows: 122
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-19 | ES | Futures | 4001.84 | 4025.15 | 3979.65 | 4022.06 | 1291117.0 |
| 2020-11-19 | NQ | Futures | 13748.95 | 13892.51 | 13666.18 | 13877.75 | 421691.0 |
| 2020-11-19 | YM | Futures | 31619.1 | 31733.3 | 31416.7 | 31697.7 | 161849.0 |
| 2020-11-19 | CL | Futures | 29.78 | 29.98 | 29.35 | 29.8 | 313376.0 |
| 2020-11-19 | GC | Futures | 2210.9 | 2211.6 | 2184.9 | 2198.5 | 222347.0 |
| 2020-11-19 | ZN | Futures | 137.08693 | 137.381374 | 137.08693 | 137.226404 | 1522705.0 |
| 2020-11-19 | A6 | Futures | 0.7498 | 0.75011 | 0.74488 | 0.74857 | 80909.0 |
| 2020-11-19 | AD | Futures | 0.77478 | 0.77646 | 0.77225 | 0.77575 | 54956.0 |
| 2020-11-19 | ALI | Futures | 2352.67 | 2360.04 | 2346.78 | 2349.13 | 146.0 |
| 2020-11-19 | B | Futures | 27.7 | 28.08 | 27.59 | 27.85 | 210299.0 |
| 2020-11-19 | B6 | Futures | 1.3454 | 1.3467 | 1.3382 | 1.3443 | 92014.0 |
| 2020-11-19 | BFX | Futures | 3861.9 | 3864.4 | 3861.9 | 3864.4 | 30.0 |
| 2020-11-19 | BR | Futures | 0.14627 | 0.1484 | 0.14608 | 0.14793 | 7025.0 |
| 2020-11-19 | BTC | Futures | 23629.7 | 24098.2 | 22930.3 | 23880.5 | 6743.0 |
| 2020-11-19 | BZ | Futures | 27.24 | 27.5 | 27.01 | 27.26 | 25836.0 |
| 2020-11-19 | C | Futures | 1549.0 | 1578.0 | 1543.0 | 1574.0 | 3884.0 |
| 2020-11-19 | CB | Futures | 149.664 | 149.816 | 149.155 | 149.155 | 33.0 |
| 2020-11-19 | CC | Futures | 1708.0 | 1755.0 | 1693.0 | 1752.0 | 27625.0 |
| 2020-11-19 | CNH | Futures | 6.4328 | 6.4618 | 6.4291 | 6.4458 | 945.0 |
| 2020-11-19 | CSC | Futures | 3.075 | 3.081 | 3.004 | 3.011 | 268.0 |
| 2020-11-19 | CT | Futures | 68.68 | 69.08 | 68.34 | 68.51 | 5281.0 |
| 2020-11-19 | DC | Futures | 25.5 | 25.63 | 24.77 | 24.83 | 1021.0 |
| 2020-11-19 | DX | Futures | 89.356 | 89.564 | 89.086 | 89.143 | 20049.0 |
| 2020-11-19 | E1 | Futures | 1.24352 | 1.24511 | 1.23967 | 1.24443 | 17349.0 |
| 2020-11-19 | E6 | Futures | 1.27039 | 1.2735 | 1.26638 | 1.27275 | 141175.0 |
| 2020-11-19 | E7 | Futures | 1.264 | 1.267 | 1.26 | 1.2663 | 5721.0 |
| 2020-11-19 | EBM | Futures | 255.27 | 256.17 | 253.46 | 253.76 | 14194.0 |
| 2020-11-19 | ED | Futures | 96.4793 | 96.489 | 96.4769 | 96.4866 | 145098.0 |
| 2020-11-19 | ER | Futures | 98.465 | 98.465 | 98.455 | 98.46 | 42891.0 |
| 2020-11-19 | ESG | Futures | 329.41 | 334.77 | 328.55 | 331.3 | 303.0 |
| 2020-11-19 | EW | Futures | 2275.8 | 2297.6 | 2260.1 | 2296.5 | 11459.0 |
| 2020-11-19 | FBON | Futures | 150.14 | 150.44 | 150.1 | 150.38 | 362.0 |
| 2020-11-19 | FBTP | Futures | 138.01 | 138.26 | 137.88 | 138.21 | 88474.0 |
| 2020-11-19 | FBTS | Futures | 109.971 | 110.02 | 109.952 | 110.01 | 64118.0 |
| 2020-11-19 | FCE | Futures | 5331.0 | 5376.4 | 5306.6 | 5332.0 | 60850.0 |
| 2020-11-19 | FDAX | Futures | 13955.1 | 14011.1 | 13886.4 | 13949.8 | 57499.0 |
| 2020-11-19 | FDIV | Futures | 155.97 | 155.97 | 155.55 | 155.59 | 65.0 |
| 2020-11-19 | FDXM | Futures | 13895.3 | 13942.0 | 13817.9 | 13879.4 | 34899.0 |
| 2020-11-19 | FESX | Futures | 3187.7 | 3204.3 | 3176.6 | 3188.6 | 729978.0 |
| 2020-11-19 | FGBL | Futures | 170.38 | 170.59 | 170.29 | 170.51 | 522299.0 |
| 2020-11-19 | FGBM | Futures | 135.31 | 135.35 | 135.26 | 135.31 | 288449.0 |
| 2020-11-19 | FGBS | Futures | 112.79 | 112.805 | 112.775 | 112.79 | 271317.0 |
| 2020-11-19 | FGBX | Futures | 235.85 | 237.11 | 235.69 | 236.79 | 55353.0 |
| 2020-11-19 | FMWO | Futures | 8936.5 | 8991.0 | 8865.4 | 8944.8 | 3720.0 |
| 2020-11-19 | FOAT | Futures | 158.92 | 159.18 | 158.84 | 159.09 | 147214.0 |
| 2020-11-19 | FTDX | Futures | 3095.6 | 3117.7 | 3087.9 | 3116.7 | 67.0 |
| 2020-11-19 | FTI | Futures | 557.42 | 558.92 | 554.9 | 556.82 | 11193.0 |
| 2020-11-19 | FTUK | Futures | 6019.9 | 6077.7 | 6018.4 | 6044.7 | 113086.0 |
| 2020-11-19 | FVSA | Futures | 160.6 | 164.3 | 158.01 | 160.23 | 15484.0 |
| 2020-11-19 | FXXP | Futures | 359.5 | 360.5 | 357.7 | 358.9 | 47726.0 |
> showing 50 of 122 rows — these rows as CSV