PREVIEW / futures_daily / 2020-02-07
file: by_date/futures_daily/2020/2020-02-07.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-07 | ES | Futures | 3616.97 | 3618.05 | 3586.46 | 3591.59 | 1698940.0 |
| 2020-02-07 | NQ | Futures | 10858.83 | 10863.42 | 10764.77 | 10792.88 | 592695.0 |
| 2020-02-07 | YM | Futures | 30830.9 | 30841.4 | 30462.2 | 30502.2 | 228295.0 |
| 2020-02-07 | CL | Futures | 52.42 | 52.8 | 51.37 | 51.61 | 768345.0 |
| 2020-02-07 | GC | Futures | 1915.1 | 1923.7 | 1906.3 | 1918.4 | 286422.0 |
| 2020-02-07 | ZN | Futures | 129.387946 | 129.976425 | 129.356973 | 129.91448 | 2331670.0 |
| 2020-02-07 | A6 | Futures | 0.69046 | 0.69097 | 0.68338 | 0.68492 | 106829.0 |
| 2020-02-07 | AD | Futures | 0.75829 | 0.75884 | 0.75632 | 0.75758 | 82816.0 |
| 2020-02-07 | ALI | Futures | 2104.37 | 2106.76 | 2078.89 | 2091.18 | 103.0 |
| 2020-02-07 | B | Futures | 45.7 | 45.92 | 44.93 | 45.15 | 270802.0 |
| 2020-02-07 | B6 | Futures | 1.3121 | 1.3155 | 1.3075 | 1.3081 | 93990.0 |
| 2020-02-07 | BR | Futures | 0.18959 | 0.18959 | 0.18739 | 0.18784 | 6698.0 |
| 2020-02-07 | BTC | Futures | 14713.7 | 15051.3 | 14616.1 | 14773.7 | 8523.0 |
| 2020-02-07 | BZ | Futures | 45.21 | 45.3 | 44.27 | 44.48 | 43796.0 |
| 2020-02-07 | C | Futures | 1900.0 | 1943.0 | 1895.0 | 1913.0 | 9053.0 |
| 2020-02-07 | CB | Futures | 229.944 | 230.268 | 229.62 | 229.915 | 48.0 |
| 2020-02-07 | CC | Futures | 1887.0 | 1922.0 | 1887.0 | 1898.0 | 46360.0 |
| 2020-02-07 | CNH | Futures | 6.9557 | 6.9771 | 6.9455 | 6.9771 | 416.0 |
| 2020-02-07 | CSC | Futures | 3.355 | 3.364 | 3.329 | 3.364 | 94.0 |
| 2020-02-07 | CT | Futures | 64.54 | 64.68 | 63.82 | 64.44 | 27935.0 |
| 2020-02-07 | DC | Futures | 27.86 | 28.17 | 27.77 | 28.17 | 475.0 |
| 2020-02-07 | DX | Futures | 95.443 | 95.701 | 95.409 | 95.672 | 13512.0 |
| 2020-02-07 | E1 | Futures | 1.17456 | 1.17559 | 1.17067 | 1.1717 | 27752.0 |
| 2020-02-07 | E6 | Futures | 1.1854 | 1.18594 | 1.18136 | 1.1818 | 191000.0 |
| 2020-02-07 | E7 | Futures | 1.1794 | 1.1798 | 1.1752 | 1.1756 | 3575.0 |
| 2020-02-07 | EBM | Futures | 212.09 | 212.92 | 211.54 | 212.37 | 21377.0 |
| 2020-02-07 | ED | Futures | 95.3714 | 95.3956 | 95.3665 | 95.3956 | 280184.0 |
| 2020-02-07 | ER | Futures | 98.386 | 98.391 | 98.386 | 98.386 | 23520.0 |
| 2020-02-07 | ESG | Futures | 299.18 | 299.18 | 298.03 | 298.03 | 40.0 |
| 2020-02-07 | EW | Futures | 2182.5 | 2183.7 | 2154.4 | 2157.9 | 14158.0 |
| 2020-02-07 | FBON | Futures | 145.15 | 145.42 | 145.15 | 145.28 | 115.0 |
| 2020-02-07 | FBTP | Futures | 132.3 | 132.78 | 132.27 | 132.62 | 77059.0 |
| 2020-02-07 | FBTS | Futures | 108.634 | 108.672 | 108.595 | 108.653 | 43827.0 |
| 2020-02-07 | FCE | Futures | 5477.9 | 5482.9 | 5436.7 | 5464.8 | 59871.0 |
| 2020-02-07 | FDAX | Futures | 14371.7 | 14376.0 | 14227.4 | 14290.8 | 91068.0 |
| 2020-02-07 | FDIV | Futures | 158.48 | 158.48 | 157.74 | 158.29 | 50.0 |
| 2020-02-07 | FDXM | Futures | 14173.6 | 14194.5 | 14050.4 | 14111.4 | 59055.0 |
| 2020-02-07 | FESX | Futures | 3351.5 | 3351.5 | 3326.8 | 3340.9 | 1080388.0 |
| 2020-02-07 | FGBL | Futures | 166.07 | 166.6 | 166.04 | 166.37 | 725162.0 |
| 2020-02-07 | FGBM | Futures | 134.14 | 134.28 | 134.13 | 134.22 | 365766.0 |
| 2020-02-07 | FGBS | Futures | 112.704 | 112.739 | 112.704 | 112.729 | 233191.0 |
| 2020-02-07 | FGBX | Futures | 215.74 | 218.15 | 215.74 | 217.19 | 67997.0 |
| 2020-02-07 | FMWO | Futures | 8045.9 | 8053.8 | 7990.3 | 8022.1 | 4592.0 |
| 2020-02-07 | FOAT | Futures | 153.76 | 154.22 | 153.7 | 154.0 | 143633.0 |
| 2020-02-07 | FTDX | Futures | 3220.7 | 3220.7 | 3185.5 | 3198.1 | 61.0 |
| 2020-02-07 | FTI | Futures | 591.71 | 591.9 | 586.91 | 589.27 | 27360.0 |
| 2020-02-07 | FTUK | Futures | 6980.0 | 6987.5 | 6919.0 | 6943.8 | 80912.0 |
| 2020-02-07 | FVSA | Futures | 113.94 | 122.44 | 113.94 | 117.34 | 38995.0 |
| 2020-02-07 | FXXP | Futures | 387.3 | 387.3 | 384.3 | 385.7 | 55767.0 |
| 2020-02-07 | G | Futures | 122.47 | 122.68 | 122.22 | 122.5 | 200428.0 |
> showing 50 of 119 rows — these rows as CSV