PREVIEW / futures_daily / 2020-02-05
file: by_date/futures_daily/2020/2020-02-05.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-02-05 | ES | Futures | 3564.32 | 3605.09 | 3551.36 | 3601.85 | 2046111.0 |
| 2020-02-05 | NQ | Futures | 10732.66 | 10853.96 | 10687.64 | 10760.76 | 729548.0 |
| 2020-02-05 | YM | Futures | 30220.7 | 30744.8 | 30132.5 | 30709.0 | 276317.0 |
| 2020-02-05 | CL | Futures | 50.77 | 53.21 | 50.73 | 52.05 | 887946.0 |
| 2020-02-05 | GC | Futures | 1897.3 | 1909.6 | 1891.2 | 1905.5 | 306051.0 |
| 2020-02-05 | ZN | Futures | 129.759617 | 129.976425 | 129.20211 | 129.387946 | 2584163.0 |
| 2020-02-05 | A6 | Futures | 0.69138 | 0.69497 | 0.68984 | 0.69199 | 107887.0 |
| 2020-02-05 | AD | Futures | 0.75879 | 0.75975 | 0.75748 | 0.75799 | 83767.0 |
| 2020-02-05 | ALI | Futures | 2077.99 | 2099.87 | 2077.99 | 2079.19 | 150.0 |
| 2020-02-05 | B | Futures | 44.8 | 46.79 | 44.8 | 45.82 | 412265.0 |
| 2020-02-05 | B6 | Futures | 1.3226 | 1.3269 | 1.3153 | 1.3185 | 122646.0 |
| 2020-02-05 | BFX | Futures | 4837.9 | 4849.1 | 4837.9 | 4849.1 | 18.0 |
| 2020-02-05 | BR | Futures | 0.18999 | 0.19165 | 0.18995 | 0.19048 | 3959.0 |
| 2020-02-05 | BTC | Futures | 13873.3 | 14923.8 | 13843.3 | 14751.2 | 14307.0 |
| 2020-02-05 | BZ | Futures | 44.0 | 46.11 | 44.0 | 45.14 | 56117.0 |
| 2020-02-05 | C | Futures | 1822.0 | 1880.0 | 1822.0 | 1873.0 | 12383.0 |
| 2020-02-05 | CB | Futures | 235.309 | 235.309 | 229.944 | 229.944 | 34.0 |
| 2020-02-05 | CC | Futures | 1821.0 | 1856.0 | 1821.0 | 1843.0 | 37355.0 |
| 2020-02-05 | CNH | Futures | 6.9657 | 6.9799 | 6.9356 | 6.9454 | 498.0 |
| 2020-02-05 | CSC | Futures | 3.348 | 3.359 | 3.324 | 3.325 | 141.0 |
| 2020-02-05 | CT | Futures | 64.3 | 65.08 | 64.03 | 64.21 | 24834.0 |
| 2020-02-05 | DC | Futures | 27.8 | 28.07 | 27.49 | 27.59 | 721.0 |
| 2020-02-05 | DX | Futures | 94.924 | 95.293 | 94.885 | 95.272 | 18141.0 |
| 2020-02-05 | E1 | Futures | 1.18187 | 1.18335 | 1.17501 | 1.17604 | 28845.0 |
| 2020-02-05 | E6 | Futures | 1.19273 | 1.19305 | 1.18718 | 1.18751 | 197878.0 |
| 2020-02-05 | E7 | Futures | 1.1868 | 1.1868 | 1.181 | 1.1813 | 1995.0 |
| 2020-02-05 | EBM | Futures | 210.72 | 213.47 | 210.44 | 212.92 | 28649.0 |
| 2020-02-05 | ED | Futures | 95.3665 | 95.3811 | 95.352 | 95.3665 | 232196.0 |
| 2020-02-05 | ER | Futures | 98.386 | 98.391 | 98.382 | 98.391 | 54353.0 |
| 2020-02-05 | ESG | Futures | 297.8 | 298.39 | 296.7 | 298.35 | 30.0 |
| 2020-02-05 | EW | Futures | 2168.4 | 2193.1 | 2160.6 | 2190.3 | 14173.0 |
| 2020-02-05 | FBON | Futures | 145.37 | 145.6 | 145.0 | 145.12 | 735.0 |
| 2020-02-05 | FBTP | Futures | 132.65 | 132.87 | 132.26 | 132.34 | 110938.0 |
| 2020-02-05 | FBTS | Futures | 108.682 | 108.682 | 108.615 | 108.644 | 63253.0 |
| 2020-02-05 | FCE | Futures | 5359.6 | 5441.7 | 5357.4 | 5424.0 | 92376.0 |
| 2020-02-05 | FDAX | Futures | 14037.5 | 14292.9 | 13979.4 | 14252.2 | 125918.0 |
| 2020-02-05 | FDIV | Futures | 156.2 | 158.71 | 156.2 | 158.52 | 191.0 |
| 2020-02-05 | FDXM | Futures | 13866.6 | 14113.0 | 13803.9 | 14073.3 | 78082.0 |
| 2020-02-05 | FESX | Futures | 3274.8 | 3331.2 | 3263.4 | 3320.6 | 1451675.0 |
| 2020-02-05 | FGBL | Futures | 166.51 | 166.8 | 165.86 | 166.12 | 947980.0 |
| 2020-02-05 | FGBM | Futures | 134.32 | 134.4 | 134.13 | 134.19 | 547997.0 |
| 2020-02-05 | FGBS | Futures | 112.734 | 112.759 | 112.719 | 112.729 | 360662.0 |
| 2020-02-05 | FGBX | Futures | 217.92 | 218.97 | 215.51 | 216.27 | 84001.0 |
| 2020-02-05 | FMWO | Futures | 7947.2 | 8031.1 | 7924.5 | 8008.4 | 3957.0 |
| 2020-02-05 | FOAT | Futures | 154.14 | 154.25 | 153.44 | 153.65 | 191232.0 |
| 2020-02-05 | FTDX | Futures | 3146.4 | 3224.7 | 3146.4 | 3208.7 | 154.0 |
| 2020-02-05 | FTI | Futures | 577.14 | 588.54 | 576.8 | 586.42 | 42630.0 |
| 2020-02-05 | FTUK | Futures | 6890.8 | 6987.0 | 6879.6 | 6960.7 | 115595.0 |
| 2020-02-05 | FVSA | Futures | 124.57 | 125.42 | 116.07 | 116.49 | 43300.0 |
| 2020-02-05 | FXXP | Futures | 379.1 | 386.1 | 379.0 | 385.2 | 110192.0 |
> showing 50 of 120 rows — these rows as CSV