PREVIEW / futures_daily / 2016-11-25
file: by_date/futures_daily/2016/2016-11-25.parquet size: 9 KB rows: 106
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 |
|---|---|---|---|---|---|---|---|
| 2016-11-25 | ES | Futures | 2380.59 | 2392.22 | 2376.81 | 2391.68 | 561560.0 |
| 2016-11-25 | NQ | Futures | 5716.55 | 5739.53 | 5703.59 | 5737.76 | 75485.0 |
| 2016-11-25 | YM | Futures | 20019.2 | 20106.3 | 19984.5 | 20102.1 | 84532.0 |
| 2016-11-25 | CL | Futures | 51.76 | 52.07 | 49.51 | 49.7 | 465977.0 |
| 2016-11-25 | GC | Futures | 1525.9 | 1535.1 | 1506.1 | 1516.6 | 90855.0 |
| 2016-11-25 | ZN | Futures | 121.966801 | 121.982001 | 121.404392 | 121.799598 | 1479196.0 |
| 2016-11-25 | A6 | Futures | 0.75285 | 0.76163 | 0.75091 | 0.75734 | 110680.0 |
| 2016-11-25 | AD | Futures | 0.75922 | 0.76147 | 0.75691 | 0.75778 | 60567.0 |
| 2016-11-25 | ALI | Futures | 2397.68 | 2397.68 | 2397.68 | 2397.68 | 0.0 |
| 2016-11-25 | B | Futures | 37.22 | 37.27 | 35.64 | 35.94 | 172828.0 |
| 2016-11-25 | B6 | Futures | 1.3087 | 1.316 | 1.3061 | 1.3119 | 113603.0 |
| 2016-11-25 | BFX | Futures | 4121.1 | 4153.9 | 4121.1 | 4153.9 | 1.0 |
| 2016-11-25 | BR | Futures | 0.20153 | 0.20327 | 0.20153 | 0.20327 | 1115.0 |
| 2016-11-25 | BZ | Futures | 37.0 | 37.14 | 35.53 | 35.67 | 14787.0 |
| 2016-11-25 | C | Futures | 2200.0 | 2203.0 | 2155.0 | 2180.0 | 4255.0 |
| 2016-11-25 | CC | Futures | 1852.0 | 1861.0 | 1827.0 | 1838.0 | 9716.0 |
| 2016-11-25 | CNH | Futures | 7.4903 | 7.4903 | 7.4582 | 7.4693 | 59.0 |
| 2016-11-25 | CT | Futures | 81.87 | 82.11 | 80.87 | 81.85 | 8549.0 |
| 2016-11-25 | DX | Futures | 94.785 | 94.906 | 94.231 | 94.511 | 31655.0 |
| 2016-11-25 | E1 | Futures | 1.22612 | 1.23422 | 1.22376 | 1.23048 | 27609.0 |
| 2016-11-25 | E6 | Futures | 1.22415 | 1.23302 | 1.22032 | 1.22884 | 247723.0 |
| 2016-11-25 | E7 | Futures | 1.2174 | 1.2263 | 1.2138 | 1.2222 | 4897.0 |
| 2016-11-25 | EBM | Futures | 198.29 | 198.88 | 197.7 | 198.0 | 7908.0 |
| 2016-11-25 | ED | Futures | 95.5862 | 95.5862 | 95.5718 | 95.579 | 218074.0 |
| 2016-11-25 | ER | Futures | 98.279 | 98.279 | 98.274 | 98.274 | 16663.0 |
| 2016-11-25 | EW | Futures | 1738.5 | 1746.2 | 1736.5 | 1744.5 | 4965.0 |
| 2016-11-25 | FBON | Futures | 119.67 | 119.9 | 119.67 | 119.76 | 133.0 |
| 2016-11-25 | FBTP | Futures | 102.98 | 103.32 | 102.65 | 103.14 | 90243.0 |
| 2016-11-25 | FBTS | Futures | 100.574 | 100.637 | 100.556 | 100.601 | 39574.0 |
| 2016-11-25 | FCE | Futures | 4014.2 | 4027.4 | 3989.0 | 4012.9 | 58448.0 |
| 2016-11-25 | FDAX | Futures | 11312.5 | 11322.5 | 11250.1 | 11297.7 | 48867.0 |
| 2016-11-25 | FDXM | Futures | 11281.7 | 11297.5 | 11226.9 | 11273.3 | 12782.0 |
| 2016-11-25 | FESX | Futures | 2440.6 | 2450.2 | 2424.6 | 2439.0 | 664686.0 |
| 2016-11-25 | FGBL | Futures | 147.08 | 147.54 | 147.03 | 147.33 | 609589.0 |
| 2016-11-25 | FGBM | Futures | 128.52 | 128.69 | 128.52 | 128.6 | 476124.0 |
| 2016-11-25 | FGBS | Futures | 112.082 | 112.127 | 112.082 | 112.117 | 281758.0 |
| 2016-11-25 | FGBX | Futures | 172.89 | 174.42 | 172.46 | 173.54 | 34904.0 |
| 2016-11-25 | FMWO | Futures | 5738.8 | 5748.5 | 5738.8 | 5748.5 | 419.0 |
| 2016-11-25 | FOAT | Futures | 132.07 | 132.35 | 131.82 | 132.07 | 105491.0 |
| 2016-11-25 | FTDX | Futures | 1690.6 | 1690.6 | 1684.7 | 1690.1 | 35.0 |
| 2016-11-25 | FTI | Futures | 417.02 | 418.2 | 415.29 | 417.34 | 17577.0 |
| 2016-11-25 | FTUK | Futures | 5759.2 | 5783.7 | 5752.8 | 5771.4 | 57797.0 |
| 2016-11-25 | FVSA | Futures | 1303.9 | 1325.9 | 1291.33 | 1313.33 | 12601.0 |
| 2016-11-25 | FXXP | Futures | 282.1 | 283.3 | 281.1 | 282.6 | 19418.0 |
| 2016-11-25 | G | Futures | 110.1 | 110.51 | 110.0 | 110.27 | 225035.0 |
| 2016-11-25 | GF | Futures | 280.523 | 284.427 | 280.523 | 283.813 | 3647.0 |
| 2016-11-25 | GSCI | Futures | 503.3 | 503.43 | 498.66 | 498.73 | 354.0 |
| 2016-11-25 | HE | Futures | 76.189 | 77.068 | 75.749 | 76.73 | 9204.0 |
| 2016-11-25 | HG | Futures | 3.2594 | 3.365 | 3.2563 | 3.3296 | 77262.0 |
| 2016-11-25 | HH | Futures | 23.619 | 24.017 | 23.612 | 24.017 | 280.0 |
> showing 50 of 106 rows — these rows as CSV