PREVIEW / futures_daily / 2018-02-12
file: by_date/futures_daily/2018/2018-02-12.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-02-12 | ES | Futures | 2856.59 | 2903.6 | 2847.62 | 2885.93 | 2170447.0 |
| 2018-02-12 | NQ | Futures | 7535.95 | 7691.72 | 7512.24 | 7649.85 | 406083.0 |
| 2018-02-12 | YM | Futures | 25575.3 | 26084.6 | 25540.5 | 25925.4 | 300836.0 |
| 2018-02-12 | CL | Futures | 59.19 | 61.04 | 59.19 | 59.5 | 298895.0 |
| 2018-02-12 | GC | Futures | 1682.4 | 1698.9 | 1681.4 | 1694.3 | 208066.0 |
| 2018-02-12 | ZN | Futures | 119.399009 | 119.506993 | 119.090484 | 119.35273 | 1422174.0 |
| 2018-02-12 | A6 | Futures | 0.80398 | 0.80882 | 0.80316 | 0.80645 | 100866.0 |
| 2018-02-12 | AD | Futures | 0.80691 | 0.80894 | 0.80457 | 0.80518 | 59024.0 |
| 2018-02-12 | B | Futures | 44.85 | 46.21 | 44.85 | 44.91 | 349667.0 |
| 2018-02-12 | B6 | Futures | 1.4394 | 1.4452 | 1.4367 | 1.4397 | 102745.0 |
| 2018-02-12 | BR | Futures | 0.23002 | 0.23082 | 0.22972 | 0.23051 | 1268.0 |
| 2018-02-12 | BTC | Futures | 10904.3 | 11607.0 | 10507.5 | 11528.9 | 679.0 |
| 2018-02-12 | BZ | Futures | 44.36 | 45.61 | 44.3 | 44.32 | 33192.0 |
| 2018-02-12 | C | Futures | 1345.0 | 1345.0 | 1305.0 | 1313.0 | 10791.0 |
| 2018-02-12 | CB | Futures | 259.441 | 259.75 | 258.669 | 259.75 | 49.0 |
| 2018-02-12 | CC | Futures | 1509.0 | 1522.0 | 1461.0 | 1473.0 | 33622.0 |
| 2018-02-12 | CNH | Futures | 6.4499 | 6.4816 | 6.4396 | 6.4676 | 129.0 |
| 2018-02-12 | CSC | Futures | 3.199 | 3.223 | 3.178 | 3.189 | 55.0 |
| 2018-02-12 | CT | Futures | 89.56 | 90.48 | 88.88 | 89.29 | 27908.0 |
| 2018-02-12 | DC | Futures | 25.24 | 25.31 | 25.02 | 25.09 | 260.0 |
| 2018-02-12 | DX | Futures | 84.754 | 84.81 | 84.477 | 84.609 | 19214.0 |
| 2018-02-12 | E1 | Futures | 1.29501 | 1.29986 | 1.29464 | 1.2961 | 17362.0 |
| 2018-02-12 | E6 | Futures | 1.39186 | 1.39747 | 1.3901 | 1.39538 | 170502.0 |
| 2018-02-12 | E7 | Futures | 1.3849 | 1.3903 | 1.3832 | 1.3884 | 3192.0 |
| 2018-02-12 | EBM | Futures | 172.62 | 173.16 | 172.35 | 172.89 | 19772.0 |
| 2018-02-12 | ED | Futures | 95.2145 | 95.2145 | 95.1805 | 95.1999 | 343127.0 |
| 2018-02-12 | ER | Futures | 98.332 | 98.337 | 98.332 | 98.332 | 16356.0 |
| 2018-02-12 | EW | Futures | 1931.5 | 1959.5 | 1920.3 | 1948.9 | 22136.0 |
| 2018-02-12 | FBON | Futures | 126.28 | 126.56 | 126.28 | 126.39 | 167.0 |
| 2018-02-12 | FBTP | Futures | 110.6 | 111.21 | 110.6 | 111.02 | 76940.0 |
| 2018-02-12 | FBTS | Futures | 103.659 | 103.732 | 103.659 | 103.714 | 32822.0 |
| 2018-02-12 | FCE | Futures | 4527.3 | 4568.8 | 4513.1 | 4537.4 | 54528.0 |
| 2018-02-12 | FDAX | Futures | 12780.6 | 12836.7 | 12668.6 | 12763.5 | 102493.0 |
| 2018-02-12 | FDXM | Futures | 12784.7 | 12858.4 | 12690.1 | 12785.2 | 62716.0 |
| 2018-02-12 | FESX | Futures | 2753.0 | 2768.6 | 2735.9 | 2754.7 | 1428849.0 |
| 2018-02-12 | FGBL | Futures | 146.2 | 146.59 | 146.01 | 146.4 | 637061.0 |
| 2018-02-12 | FGBM | Futures | 128.2 | 128.4 | 128.18 | 128.32 | 432591.0 |
| 2018-02-12 | FGBS | Futures | 112.281 | 112.316 | 112.271 | 112.306 | 274475.0 |
| 2018-02-12 | FGBX | Futures | 163.8 | 164.4 | 163.19 | 164.01 | 63132.0 |
| 2018-02-12 | FMWO | Futures | 6807.9 | 6881.5 | 6789.3 | 6827.8 | 2278.0 |
| 2018-02-12 | FOAT | Futures | 135.48 | 135.96 | 135.46 | 135.79 | 73068.0 |
| 2018-02-12 | FTDX | Futures | 2484.5 | 2493.5 | 2463.1 | 2475.5 | 192.0 |
| 2018-02-12 | FTI | Futures | 480.09 | 482.44 | 477.52 | 479.63 | 11381.0 |
| 2018-02-12 | FTUK | Futures | 6185.0 | 6250.1 | 6182.3 | 6221.2 | 137108.0 |
| 2018-02-12 | FVSA | Futures | 499.84 | 520.76 | 487.52 | 505.99 | 50323.0 |
| 2018-02-12 | FXXP | Futures | 316.5 | 318.9 | 315.6 | 317.3 | 58721.0 |
| 2018-02-12 | G | Futures | 111.59 | 111.83 | 111.37 | 111.72 | 161537.0 |
| 2018-02-12 | GF | Futures | 320.611 | 326.431 | 319.568 | 324.289 | 6299.0 |
| 2018-02-12 | GSCI | Futures | 491.88 | 494.15 | 490.91 | 490.91 | 3591.0 |
| 2018-02-12 | HE | Futures | 88.216 | 90.816 | 88.023 | 90.559 | 25682.0 |
> showing 50 of 110 rows — these rows as CSV