PREVIEW / futures_daily / 2017-02-08
file: by_date/futures_daily/2017/2017-02-08.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 |
|---|---|---|---|---|---|---|---|
| 2017-02-08 | ES | Futures | 2477.98 | 2484.76 | 2472.83 | 2482.86 | 1283261.0 |
| 2017-02-08 | NQ | Futures | 6099.3 | 6125.23 | 6085.74 | 6118.45 | 166260.0 |
| 2017-02-08 | YM | Futures | 21072.3 | 21120.7 | 21030.1 | 21068.1 | 107592.0 |
| 2017-02-08 | CL | Futures | 55.26 | 56.36 | 54.81 | 56.01 | 767379.0 |
| 2017-02-08 | GC | Futures | 1577.9 | 1592.5 | 1573.0 | 1583.4 | 221914.0 |
| 2017-02-08 | ZN | Futures | 122.302106 | 122.806413 | 122.240978 | 122.607747 | 1724286.0 |
| 2017-02-08 | A6 | Futures | 0.78037 | 0.78437 | 0.77884 | 0.78099 | 67049.0 |
| 2017-02-08 | AD | Futures | 0.77474 | 0.77786 | 0.77403 | 0.77663 | 41320.0 |
| 2017-02-08 | ALI | Futures | 2496.96 | 2503.06 | 2495.68 | 2503.06 | 150.0 |
| 2017-02-08 | B | Futures | 40.19 | 41.06 | 40.15 | 40.65 | 409826.0 |
| 2017-02-08 | B6 | Futures | 1.3127 | 1.3171 | 1.3092 | 1.3146 | 79337.0 |
| 2017-02-08 | BFX | Futures | 4341.4 | 4346.3 | 4341.4 | 4346.3 | 1.0 |
| 2017-02-08 | BR | Futures | 0.22703 | 0.22756 | 0.22617 | 0.22713 | 721.0 |
| 2017-02-08 | BZ | Futures | 40.02 | 40.84 | 39.77 | 40.44 | 44864.0 |
| 2017-02-08 | C | Futures | 1698.0 | 1707.0 | 1678.0 | 1684.0 | 9680.0 |
| 2017-02-08 | CB | Futures | 269.625 | 269.748 | 269.137 | 269.137 | 43.0 |
| 2017-02-08 | CC | Futures | 1531.0 | 1548.0 | 1528.0 | 1535.0 | 29116.0 |
| 2017-02-08 | CNH | Futures | 7.2451 | 7.2556 | 7.2419 | 7.2419 | 38.0 |
| 2017-02-08 | CSC | Futures | 3.88 | 3.903 | 3.875 | 3.9 | 92.0 |
| 2017-02-08 | CT | Futures | 86.42 | 86.98 | 86.24 | 86.44 | 28975.0 |
| 2017-02-08 | DC | Futures | 32.33 | 32.44 | 32.08 | 32.42 | 230.0 |
| 2017-02-08 | DX | Futures | 93.514 | 93.695 | 93.137 | 93.355 | 31539.0 |
| 2017-02-08 | E1 | Futures | 1.24483 | 1.25016 | 1.24148 | 1.24731 | 17643.0 |
| 2017-02-08 | E6 | Futures | 1.23535 | 1.23911 | 1.2305 | 1.23576 | 190456.0 |
| 2017-02-08 | E7 | Futures | 1.2288 | 1.2327 | 1.2243 | 1.2295 | 3675.0 |
| 2017-02-08 | EBM | Futures | 193.42 | 195.41 | 193.42 | 194.84 | 20119.0 |
| 2017-02-08 | ED | Futures | 95.581 | 95.5906 | 95.5713 | 95.5858 | 279362.0 |
| 2017-02-08 | ER | Futures | 98.298 | 98.303 | 98.293 | 98.298 | 62820.0 |
| 2017-02-08 | EW | Futures | 1801.2 | 1805.6 | 1788.1 | 1803.1 | 14156.0 |
| 2017-02-08 | FBON | Futures | 119.43 | 120.04 | 119.24 | 119.95 | 1093.0 |
| 2017-02-08 | FBTP | Futures | 102.89 | 103.91 | 102.64 | 103.72 | 133460.0 |
| 2017-02-08 | FBTS | Futures | 101.458 | 101.575 | 101.439 | 101.557 | 28047.0 |
| 2017-02-08 | FCE | Futures | 4198.6 | 4220.2 | 4168.6 | 4197.7 | 94603.0 |
| 2017-02-08 | FDAX | Futures | 12212.5 | 12232.5 | 12113.2 | 12183.4 | 88587.0 |
| 2017-02-08 | FDXM | Futures | 12158.0 | 12182.2 | 12064.4 | 12134.3 | 28703.0 |
| 2017-02-08 | FESX | Futures | 2595.9 | 2599.1 | 2568.7 | 2587.9 | 1180060.0 |
| 2017-02-08 | FEU3 | Futures | 98.966 | 98.966 | 98.966 | 98.966 | 8.0 |
| 2017-02-08 | FGBL | Futures | 147.48 | 148.27 | 147.4 | 148.1 | 993816.0 |
| 2017-02-08 | FGBM | Futures | 129.17 | 129.45 | 129.13 | 129.41 | 712688.0 |
| 2017-02-08 | FGBS | Futures | 112.247 | 112.287 | 112.237 | 112.277 | 329779.0 |
| 2017-02-08 | FGBX | Futures | 165.88 | 168.65 | 165.64 | 167.8 | 68497.0 |
| 2017-02-08 | FMWO | Futures | 6008.2 | 6022.7 | 5999.8 | 6017.9 | 791.0 |
| 2017-02-08 | FOAT | Futures | 129.82 | 130.94 | 129.53 | 130.84 | 182387.0 |
| 2017-02-08 | FTDX | Futures | 1806.8 | 1817.6 | 1796.5 | 1817.6 | 140.0 |
| 2017-02-08 | FTI | Futures | 442.29 | 442.61 | 436.63 | 439.69 | 32466.0 |
| 2017-02-08 | FTUK | Futures | 6030.0 | 6044.9 | 6002.0 | 6041.5 | 104688.0 |
| 2017-02-08 | FVSA | Futures | 810.0 | 850.27 | 802.9 | 817.11 | 20187.0 |
| 2017-02-08 | FXXP | Futures | 301.2 | 301.8 | 299.0 | 301.0 | 37426.0 |
| 2017-02-08 | G | Futures | 112.05 | 112.9 | 112.04 | 112.72 | 224349.0 |
| 2017-02-08 | GF | Futures | 283.143 | 283.77 | 278.014 | 278.812 | 7345.0 |
> showing 50 of 110 rows — these rows as CSV