PREVIEW / futures_daily / 2018-03-02
file: by_date/futures_daily/2018/2018-03-02.parquet size: 9 KB rows: 110
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 |
|---|---|---|---|---|---|---|---|
| 2018-03-02 | ES | Futures | 2911.48 | 2930.23 | 2876.97 | 2923.98 | 2171819.0 |
| 2018-03-02 | NQ | Futures | 7921.57 | 7991.25 | 7783.66 | 7969.58 | 636240.0 |
| 2018-03-02 | YM | Futures | 25960.2 | 26017.2 | 25525.7 | 25874.8 | 397219.0 |
| 2018-03-02 | CL | Futures | 61.77 | 62.04 | 60.56 | 61.68 | 613514.0 |
| 2018-03-02 | GC | Futures | 1683.5 | 1694.5 | 1681.2 | 1690.4 | 264391.0 |
| 2018-03-02 | ZN | Futures | 119.630402 | 119.753812 | 119.152189 | 119.260173 | 62175.0 |
| 2018-03-02 | A6 | Futures | 0.79853 | 0.79966 | 0.79586 | 0.79761 | 103251.0 |
| 2018-03-02 | AD | Futures | 0.79122 | 0.79209 | 0.7862 | 0.78736 | 88698.0 |
| 2018-03-02 | B | Futures | 46.24 | 46.65 | 45.61 | 46.46 | 266382.0 |
| 2018-03-02 | B6 | Futures | 1.4333 | 1.4378 | 1.4313 | 1.4348 | 124086.0 |
| 2018-03-02 | BTC | Futures | 15307.6 | 15557.3 | 14926.2 | 15342.3 | 748.0 |
| 2018-03-02 | BZ | Futures | 45.8 | 46.11 | 45.05 | 45.89 | 39587.0 |
| 2018-03-02 | C | Futures | 1471.0 | 1498.0 | 1461.0 | 1498.0 | 9303.0 |
| 2018-03-02 | CB | Futures | 282.328 | 282.575 | 281.679 | 281.679 | 31.0 |
| 2018-03-02 | CC | Futures | 1673.0 | 1717.0 | 1652.0 | 1697.0 | 29768.0 |
| 2018-03-02 | CNH | Futures | 6.4731 | 6.4916 | 6.4561 | 6.4561 | 67.0 |
| 2018-03-02 | CSC | Futures | 3.337 | 3.337 | 3.337 | 3.337 | 10.0 |
| 2018-03-02 | CT | Futures | 93.72 | 94.51 | 93.22 | 94.36 | 12743.0 |
| 2018-03-02 | DC | Futures | 26.31 | 26.4 | 26.28 | 26.4 | 36.0 |
| 2018-03-02 | DX | Futures | 84.707 | 84.763 | 84.364 | 84.431 | 25816.0 |
| 2018-03-02 | E1 | Futures | 1.29052 | 1.30132 | 1.28942 | 1.29695 | 37451.0 |
| 2018-03-02 | E6 | Futures | 1.39254 | 1.3998 | 1.39016 | 1.39906 | 208998.0 |
| 2018-03-02 | E7 | Futures | 1.3856 | 1.3927 | 1.3832 | 1.392 | 3594.0 |
| 2018-03-02 | EBM | Futures | 180.17 | 180.17 | 175.86 | 176.4 | 10214.0 |
| 2018-03-02 | ED | Futures | 95.1052 | 95.1368 | 95.1004 | 95.1174 | 510424.0 |
| 2018-03-02 | ER | Futures | 98.337 | 98.337 | 98.332 | 98.332 | 52376.0 |
| 2018-03-02 | EW | Futures | 1971.0 | 1994.9 | 1950.7 | 1991.8 | 23614.0 |
| 2018-03-02 | FBON | Futures | 126.89 | 127.21 | 126.46 | 126.71 | 897.0 |
| 2018-03-02 | FBTP | Futures | 112.11 | 112.63 | 111.78 | 112.09 | 168129.0 |
| 2018-03-02 | FBTS | Futures | 103.695 | 103.741 | 103.613 | 103.677 | 83024.0 |
| 2018-03-02 | FCE | Futures | 4619.6 | 4626.7 | 4521.5 | 4536.1 | 113732.0 |
| 2018-03-02 | FDAX | Futures | 12538.9 | 12552.4 | 12311.7 | 12365.6 | 136360.0 |
| 2018-03-02 | FDIV | Futures | 138.37 | 138.37 | 137.91 | 137.91 | 30.0 |
| 2018-03-02 | FDXM | Futures | 12557.1 | 12573.7 | 12335.7 | 12386.6 | 50865.0 |
| 2018-03-02 | FESX | Futures | 2755.5 | 2758.7 | 2705.6 | 2715.5 | 1576410.0 |
| 2018-03-02 | FGBL | Futures | 148.19 | 148.48 | 147.9 | 148.07 | 915793.0 |
| 2018-03-02 | FGBM | Futures | 128.94 | 129.07 | 128.89 | 128.95 | 913252.0 |
| 2018-03-02 | FGBS | Futures | 112.402 | 112.432 | 112.397 | 112.412 | 768545.0 |
| 2018-03-02 | FGBX | Futures | 167.26 | 167.78 | 166.48 | 166.85 | 95853.0 |
| 2018-03-02 | FMWO | Futures | 6878.0 | 6897.8 | 6813.8 | 6840.6 | 4330.0 |
| 2018-03-02 | FOAT | Futures | 137.06 | 137.29 | 136.81 | 137.0 | 188700.0 |
| 2018-03-02 | FTDX | Futures | 2528.4 | 2528.4 | 2455.6 | 2475.0 | 899.0 |
| 2018-03-02 | FTI | Futures | 483.08 | 483.45 | 474.72 | 476.14 | 39089.0 |
| 2018-03-02 | FTUK | Futures | 6220.8 | 6248.3 | 6160.9 | 6176.7 | 140283.0 |
| 2018-03-02 | FVSA | Futures | 472.75 | 508.45 | 456.75 | 489.99 | 60157.0 |
| 2018-03-02 | FXXP | Futures | 317.1 | 317.1 | 311.9 | 312.5 | 106720.0 |
| 2018-03-02 | G | Futures | 113.3 | 113.57 | 113.02 | 113.18 | 196174.0 |
| 2018-03-02 | GF | Futures | 317.921 | 318.47 | 314.078 | 315.506 | 2456.0 |
| 2018-03-02 | GSCI | Futures | 500.75 | 503.76 | 498.19 | 502.06 | 740.0 |
| 2018-03-02 | HE | Futures | 86.611 | 87.317 | 85.904 | 86.771 | 21360.0 |
> showing 50 of 110 rows — these rows as CSV