PREVIEW / futures_daily / 2020-10-05
file: by_date/futures_daily/2020/2020-10-05.parquet size: 10 KB rows: 118
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-10-05 | ES | Futures | 3774.9 | 3819.83 | 3759.73 | 3811.97 | 1077474.0 |
| 2020-10-05 | NQ | Futures | 13091.95 | 13310.76 | 13044.49 | 13278.05 | 398444.0 |
| 2020-10-05 | YM | Futures | 29864.3 | 30189.4 | 29763.1 | 30138.8 | 169813.0 |
| 2020-10-05 | CL | Futures | 26.57 | 28.52 | 26.57 | 28.16 | 378579.0 |
| 2020-10-05 | GC | Futures | 2256.8 | 2273.3 | 2233.5 | 2267.7 | 177587.0 |
| 2020-10-05 | ZN | Futures | 138.233712 | 138.311197 | 137.61383 | 137.784298 | 1339887.0 |
| 2020-10-05 | A6 | Futures | 0.73543 | 0.73851 | 0.73502 | 0.73666 | 56114.0 |
| 2020-10-05 | AD | Futures | 0.76237 | 0.7646 | 0.76186 | 0.76359 | 52110.0 |
| 2020-10-05 | ALI | Futures | 2132.93 | 2138.27 | 2132.33 | 2136.19 | 73.0 |
| 2020-10-05 | B | Futures | 24.73 | 26.36 | 24.7 | 26.05 | 273764.0 |
| 2020-10-05 | B6 | Futures | 1.3109 | 1.3179 | 1.3085 | 1.3158 | 70911.0 |
| 2020-10-05 | BR | Futures | 0.13869 | 0.14108 | 0.13849 | 0.14108 | 45.0 |
| 2020-10-05 | BTC | Futures | 14376.9 | 14598.6 | 14336.6 | 14531.5 | 4462.0 |
| 2020-10-05 | BZ | Futures | 24.27 | 25.85 | 24.26 | 25.55 | 30456.0 |
| 2020-10-05 | C | Futures | 1534.0 | 1542.0 | 1515.0 | 1533.0 | 6553.0 |
| 2020-10-05 | CB | Futures | 165.85 | 165.85 | 163.36 | 165.672 | 103.0 |
| 2020-10-05 | CC | Futures | 1621.0 | 1640.0 | 1606.0 | 1615.0 | 20220.0 |
| 2020-10-05 | CNH | Futures | 6.6306 | 6.641 | 6.6017 | 6.6098 | 862.0 |
| 2020-10-05 | CSC | Futures | 3.456 | 3.478 | 3.45 | 3.478 | 69.0 |
| 2020-10-05 | CT | Futures | 64.93 | 66.35 | 64.88 | 65.25 | 25737.0 |
| 2020-10-05 | DC | Futures | 28.44 | 28.67 | 28.32 | 28.62 | 152.0 |
| 2020-10-05 | DX | Futures | 90.718 | 90.757 | 90.235 | 90.361 | 17459.0 |
| 2020-10-05 | E1 | Futures | 1.23311 | 1.24058 | 1.23311 | 1.23865 | 22756.0 |
| 2020-10-05 | E6 | Futures | 1.25652 | 1.26563 | 1.25599 | 1.26322 | 151729.0 |
| 2020-10-05 | E7 | Futures | 1.2504 | 1.2591 | 1.2497 | 1.2568 | 3975.0 |
| 2020-10-05 | EBM | Futures | 239.0 | 239.3 | 237.49 | 238.39 | 31836.0 |
| 2020-10-05 | ED | Futures | 96.4939 | 96.5035 | 96.4842 | 96.4939 | 118559.0 |
| 2020-10-05 | ER | Futures | 98.44 | 98.445 | 98.44 | 98.445 | 27159.0 |
| 2020-10-05 | ESG | Futures | 311.86 | 316.01 | 311.86 | 315.96 | 29.0 |
| 2020-10-05 | EW | Futures | 2041.8 | 2077.2 | 2035.3 | 2076.3 | 11985.0 |
| 2020-10-05 | FBON | Futures | 148.31 | 148.57 | 147.88 | 147.97 | 303.0 |
| 2020-10-05 | FBTP | Futures | 136.11 | 136.35 | 135.84 | 135.96 | 101483.0 |
| 2020-10-05 | FBTS | Futures | 109.518 | 109.576 | 109.508 | 109.527 | 70235.0 |
| 2020-10-05 | FCE | Futures | 4712.8 | 4742.4 | 4692.4 | 4722.5 | 49523.0 |
| 2020-10-05 | FDAX | Futures | 13600.1 | 13724.8 | 13550.5 | 13668.3 | 50854.0 |
| 2020-10-05 | FDXM | Futures | 13543.2 | 13656.7 | 13481.6 | 13599.4 | 37778.0 |
| 2020-10-05 | FESX | Futures | 2961.2 | 2984.3 | 2948.2 | 2971.3 | 611351.0 |
| 2020-10-05 | FGBL | Futures | 169.87 | 170.09 | 169.4 | 169.63 | 530712.0 |
| 2020-10-05 | FGBM | Futures | 135.2 | 135.3 | 135.03 | 135.11 | 310564.0 |
| 2020-10-05 | FGBS | Futures | 112.775 | 112.795 | 112.739 | 112.759 | 242350.0 |
| 2020-10-05 | FGBX | Futures | 232.45 | 233.18 | 231.18 | 232.28 | 55172.0 |
| 2020-10-05 | FMWO | Futures | 8378.6 | 8435.5 | 8358.5 | 8429.6 | 765.0 |
| 2020-10-05 | FOAT | Futures | 157.9 | 158.19 | 157.6 | 157.78 | 132152.0 |
| 2020-10-05 | FTDX | Futures | 3244.8 | 3244.8 | 3188.2 | 3206.7 | 88.0 |
| 2020-10-05 | FTI | Futures | 518.74 | 522.56 | 517.3 | 519.78 | 18391.0 |
| 2020-10-05 | FTUK | Futures | 5635.6 | 5686.8 | 5628.5 | 5661.0 | 73198.0 |
| 2020-10-05 | FVSA | Futures | 206.16 | 207.64 | 199.47 | 204.3 | 11478.0 |
| 2020-10-05 | FXXP | Futures | 337.3 | 339.3 | 336.3 | 338.0 | 30848.0 |
| 2020-10-05 | G | Futures | 126.59 | 126.68 | 126.03 | 126.16 | 182837.0 |
| 2020-10-05 | GF | Futures | 267.148 | 267.671 | 265.627 | 266.292 | 928.0 |
> showing 50 of 118 rows — these rows as CSV