PREVIEW / futures_daily / 2020-02-14
file: by_date/futures_daily/2020/2020-02-14.parquet size: 10 KB rows: 119
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-14 | ES | Futures | 3649.91 | 3659.63 | 3634.52 | 3651.53 | 1334897.0 |
| 2020-02-14 | NQ | Futures | 11041.49 | 11079.34 | 10997.62 | 11048.38 | 489387.0 |
| 2020-02-14 | YM | Futures | 30924.3 | 31001.0 | 30736.4 | 30870.8 | 174890.0 |
| 2020-02-14 | CL | Futures | 52.82 | 53.67 | 52.63 | 53.42 | 281387.0 |
| 2020-02-14 | GC | Futures | 1925.2 | 1936.4 | 1921.5 | 1934.2 | 227109.0 |
| 2020-02-14 | ZN | Futures | 129.573781 | 129.960939 | 129.573781 | 129.821562 | 1496111.0 |
| 2020-02-14 | A6 | Futures | 0.68902 | 0.69046 | 0.6882 | 0.6883 | 64462.0 |
| 2020-02-14 | AD | Futures | 0.7596 | 0.76131 | 0.7594 | 0.76035 | 55389.0 |
| 2020-02-14 | ALI | Futures | 2115.46 | 2115.46 | 2115.46 | 2115.46 | 0.0 |
| 2020-02-14 | B | Futures | 46.75 | 47.68 | 46.54 | 47.51 | 258139.0 |
| 2020-02-14 | B6 | Futures | 1.3237 | 1.3258 | 1.3194 | 1.3227 | 89996.0 |
| 2020-02-14 | BR | Futures | 0.18683 | 0.18894 | 0.18679 | 0.18853 | 8204.0 |
| 2020-02-14 | BTC | Futures | 15464.0 | 15959.2 | 15321.4 | 15749.1 | 8771.0 |
| 2020-02-14 | BZ | Futures | 46.06 | 46.98 | 45.86 | 46.81 | 41913.0 |
| 2020-02-14 | C | Futures | 1877.0 | 1889.0 | 1863.0 | 1866.0 | 3289.0 |
| 2020-02-14 | CB | Futures | 224.167 | 224.462 | 224.019 | 224.403 | 46.0 |
| 2020-02-14 | CC | Futures | 1895.0 | 1913.0 | 1883.0 | 1890.0 | 14805.0 |
| 2020-02-14 | CNH | Futures | 6.9553 | 6.9628 | 6.9476 | 6.9605 | 648.0 |
| 2020-02-14 | CSC | Futures | 3.34 | 3.34 | 3.309 | 3.318 | 105.0 |
| 2020-02-14 | CT | Futures | 64.45 | 64.61 | 63.93 | 64.12 | 11553.0 |
| 2020-02-14 | DC | Futures | 27.7 | 27.78 | 27.44 | 27.51 | 361.0 |
| 2020-02-14 | DX | Futures | 96.084 | 96.132 | 95.967 | 96.092 | 16176.0 |
| 2020-02-14 | E1 | Futures | 1.16862 | 1.16896 | 1.16519 | 1.16565 | 30304.0 |
| 2020-02-14 | E6 | Futures | 1.16984 | 1.17215 | 1.16844 | 1.16984 | 163585.0 |
| 2020-02-14 | E7 | Futures | 1.1637 | 1.1661 | 1.1623 | 1.1637 | 4532.0 |
| 2020-02-14 | EBM | Futures | 212.09 | 213.74 | 212.09 | 213.19 | 18498.0 |
| 2020-02-14 | ED | Futures | 95.3908 | 95.4005 | 95.3908 | 95.3956 | 182052.0 |
| 2020-02-14 | ER | Futures | 98.401 | 98.401 | 98.391 | 98.401 | 45032.0 |
| 2020-02-14 | ESG | Futures | 302.92 | 303.07 | 301.83 | 302.85 | 376.0 |
| 2020-02-14 | EW | Futures | 2211.0 | 2218.5 | 2199.1 | 2207.5 | 10134.0 |
| 2020-02-14 | FBON | Futures | 145.6 | 145.78 | 145.51 | 145.68 | 542.0 |
| 2020-02-14 | FBTP | Futures | 133.0 | 133.12 | 132.75 | 132.82 | 92940.0 |
| 2020-02-14 | FBTS | Futures | 108.711 | 108.711 | 108.634 | 108.653 | 56056.0 |
| 2020-02-14 | FCE | Futures | 5510.1 | 5513.7 | 5478.9 | 5486.6 | 2859.0 |
| 2020-02-14 | FDAX | Futures | 14517.7 | 14581.6 | 14493.3 | 14526.7 | 78828.0 |
| 2020-02-14 | FDIV | Futures | 161.03 | 161.68 | 160.7 | 160.7 | 71.0 |
| 2020-02-14 | FDXM | Futures | 14330.2 | 14398.1 | 14312.5 | 14344.3 | 53629.0 |
| 2020-02-14 | FESX | Futures | 3379.6 | 3392.9 | 3370.0 | 3379.6 | 900392.0 |
| 2020-02-14 | FGBL | Futures | 166.47 | 166.76 | 166.29 | 166.66 | 470649.0 |
| 2020-02-14 | FGBM | Futures | 134.26 | 134.35 | 134.18 | 134.31 | 283811.0 |
| 2020-02-14 | FGBS | Futures | 112.739 | 112.769 | 112.724 | 112.754 | 294965.0 |
| 2020-02-14 | FGBX | Futures | 217.5 | 218.51 | 217.15 | 218.32 | 43871.0 |
| 2020-02-14 | FMWO | Futures | 8116.2 | 8116.2 | 8076.5 | 8093.5 | 1893.0 |
| 2020-02-14 | FOAT | Futures | 154.25 | 154.47 | 154.06 | 154.35 | 111544.0 |
| 2020-02-14 | FTDX | Futures | 3299.1 | 3303.1 | 3274.0 | 3278.0 | 96.0 |
| 2020-02-14 | FTI | Futures | 603.81 | 604.24 | 601.61 | 603.2 | 547.0 |
| 2020-02-14 | FTUK | Futures | 6943.4 | 6965.4 | 6885.7 | 6904.0 | 102726.0 |
| 2020-02-14 | FVSA | Futures | 113.48 | 114.29 | 111.44 | 111.44 | 19580.0 |
| 2020-02-14 | FXXP | Futures | 392.4 | 393.3 | 390.9 | 391.7 | 50765.0 |
| 2020-02-14 | G | Futures | 121.7 | 122.11 | 121.64 | 121.97 | 214135.0 |
> showing 50 of 119 rows — these rows as CSV