PREVIEW / futures_daily / 2020-06-16
file: by_date/futures_daily/2020/2020-06-16.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-06-16 | ES | Futures | 3450.21 | 3552.63 | 3444.58 | 3509.86 | 2997253.0 |
| 2020-06-16 | NQ | Futures | 11373.98 | 11608.43 | 11358.6 | 11561.71 | 596508.0 |
| 2020-06-16 | YM | Futures | 27560.7 | 28569.1 | 27499.6 | 28070.8 | 340025.0 |
| 2020-06-16 | CL | Futures | 27.1 | 28.53 | 26.58 | 28.02 | 299659.0 |
| 2020-06-16 | GC | Futures | 2079.8 | 2090.6 | 2067.2 | 2084.9 | 182423.0 |
| 2020-06-16 | ZN | Futures | 137.319885 | 137.443764 | 136.979218 | 137.196006 | 1553819.0 |
| 2020-06-16 | A6 | Futures | 0.71185 | 0.71792 | 0.7028 | 0.70917 | 136648.0 |
| 2020-06-16 | AD | Futures | 0.7485 | 0.75175 | 0.74525 | 0.74835 | 75597.0 |
| 2020-06-16 | ALI | Futures | 1957.09 | 1981.88 | 1956.79 | 1960.72 | 152.0 |
| 2020-06-16 | B | Futures | 26.14 | 27.26 | 25.5 | 26.81 | 248578.0 |
| 2020-06-16 | B6 | Futures | 1.2814 | 1.2889 | 1.2751 | 1.2777 | 108518.0 |
| 2020-06-16 | BR | Futures | 0.15554 | 0.15554 | 0.1519 | 0.1519 | 6.0 |
| 2020-06-16 | BTC | Futures | 13178.1 | 13393.7 | 13094.7 | 13254.6 | 3436.0 |
| 2020-06-16 | BZ | Futures | 25.43 | 26.63 | 24.91 | 26.19 | 35087.0 |
| 2020-06-16 | C | Futures | 1771.0 | 1786.0 | 1763.0 | 1765.0 | 1260.0 |
| 2020-06-16 | CB | Futures | 209.992 | 210.767 | 209.992 | 210.233 | 24.0 |
| 2020-06-16 | CC | Futures | 1504.0 | 1522.0 | 1484.0 | 1488.0 | 14992.0 |
| 2020-06-16 | CNH | Futures | 6.9969 | 7.0225 | 6.991 | 7.0146 | 649.0 |
| 2020-06-16 | CSC | Futures | 3.552 | 3.552 | 3.543 | 3.55 | 14.0 |
| 2020-06-16 | CT | Futures | 57.9 | 58.86 | 57.66 | 58.55 | 5735.0 |
| 2020-06-16 | DC | Futures | 29.42 | 29.85 | 29.28 | 29.61 | 384.0 |
| 2020-06-16 | DX | Futures | 93.203 | 93.927 | 93.101 | 93.631 | 21707.0 |
| 2020-06-16 | E1 | Futures | 1.20002 | 1.20354 | 1.19571 | 1.19934 | 19443.0 |
| 2020-06-16 | E6 | Futures | 1.21766 | 1.22083 | 1.20725 | 1.21203 | 183980.0 |
| 2020-06-16 | E7 | Futures | 1.2116 | 1.2148 | 1.2012 | 1.206 | 7576.0 |
| 2020-06-16 | EBM | Futures | 217.36 | 217.96 | 214.96 | 215.26 | 17692.0 |
| 2020-06-16 | ED | Futures | 96.3702 | 96.375 | 96.3605 | 96.3653 | 174686.0 |
| 2020-06-16 | ER | Futures | 98.328 | 98.338 | 98.323 | 98.333 | 65134.0 |
| 2020-06-16 | ESG | Futures | 283.47 | 283.83 | 279.26 | 281.17 | 1991.0 |
| 2020-06-16 | EW | Futures | 1907.1 | 1976.1 | 1898.9 | 1932.3 | 30961.0 |
| 2020-06-16 | FBON | Futures | 143.54 | 144.27 | 143.51 | 144.13 | 389.0 |
| 2020-06-16 | FBTP | Futures | 128.17 | 128.83 | 128.09 | 128.53 | 70810.0 |
| 2020-06-16 | FBTS | Futures | 108.318 | 108.405 | 108.221 | 108.328 | 59064.0 |
| 2020-06-16 | FCE | Futures | 4820.8 | 4870.3 | 4752.2 | 4816.4 | 78929.0 |
| 2020-06-16 | FDAX | Futures | 12882.1 | 13156.0 | 12833.4 | 13032.3 | 147413.0 |
| 2020-06-16 | FDIV | Futures | 141.33 | 142.28 | 141.33 | 142.28 | 200.0 |
| 2020-06-16 | FDXM | Futures | 12869.9 | 13138.8 | 12836.0 | 13022.3 | 2629.0 |
| 2020-06-16 | FESX | Futures | 2920.7 | 2999.2 | 2916.1 | 2967.8 | 1901083.0 |
| 2020-06-16 | FEU3 | Futures | 99.08 | 99.08 | 99.08 | 99.08 | 200.0 |
| 2020-06-16 | FGBL | Futures | 167.42 | 167.76 | 167.11 | 167.59 | 592816.0 |
| 2020-06-16 | FGBM | Futures | 134.52 | 134.6 | 134.41 | 134.54 | 332230.0 |
| 2020-06-16 | FGBS | Futures | 112.719 | 112.739 | 112.699 | 112.729 | 217570.0 |
| 2020-06-16 | FGBX | Futures | 223.41 | 224.17 | 221.92 | 223.61 | 48564.0 |
| 2020-06-16 | FMWO | Futures | 7685.6 | 7812.7 | 7635.0 | 7718.6 | 29747.0 |
| 2020-06-16 | FOAT | Futures | 154.16 | 154.75 | 154.05 | 154.62 | 131932.0 |
| 2020-06-16 | FTDX | Futures | 3186.0 | 3225.8 | 3173.7 | 3215.6 | 581.0 |
| 2020-06-16 | FTI | Futures | 514.99 | 522.92 | 510.77 | 518.55 | 14919.0 |
| 2020-06-16 | FTUK | Futures | 5796.0 | 5919.4 | 5789.9 | 5867.4 | 347515.0 |
| 2020-06-16 | FVSA | Futures | 282.99 | 304.97 | 273.13 | 290.62 | 31191.0 |
| 2020-06-16 | FXXP | Futures | 328.7 | 336.3 | 328.7 | 333.5 | 258445.0 |
> showing 50 of 120 rows — these rows as CSV