PREVIEW / futures_daily / 2016-06-14
file: by_date/futures_daily/2016/2016-06-14.parquet size: 9 KB rows: 109
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-06-14 | ES | Futures | 2231.99 | 2237.93 | 2218.49 | 2230.64 | 2770212.0 |
| 2016-06-14 | NQ | Futures | 5200.88 | 5225.04 | 5167.58 | 5207.65 | 323188.0 |
| 2016-06-14 | YM | Futures | 18404.4 | 18453.5 | 18279.1 | 18354.3 | 209569.0 |
| 2016-06-14 | CL | Futures | 57.12 | 57.23 | 56.23 | 56.99 | 224661.0 |
| 2016-06-14 | GC | Futures | 1654.7 | 1663.5 | 1644.9 | 1657.2 | 193067.0 |
| 2016-06-14 | ZN | Futures | 127.290393 | 127.712933 | 127.169667 | 127.275302 | 1599495.0 |
| 2016-06-14 | A6 | Futures | 0.74893 | 0.75066 | 0.74323 | 0.74587 | 96345.0 |
| 2016-06-14 | AD | Futures | 0.79782 | 0.79864 | 0.79495 | 0.79629 | 55235.0 |
| 2016-06-14 | ALI | Futures | 2142.24 | 2153.18 | 2142.24 | 2153.18 | 3.0 |
| 2016-06-14 | B | Futures | 40.44 | 40.57 | 39.88 | 40.39 | 224005.0 |
| 2016-06-14 | B6 | Futures | 1.4994 | 1.5004 | 1.4863 | 1.4877 | 143271.0 |
| 2016-06-14 | BFX | Futures | 3918.4 | 3939.6 | 3885.0 | 3885.0 | 27.0 |
| 2016-06-14 | BR | Futures | 0.18692 | 0.18805 | 0.18586 | 0.18616 | 1153.0 |
| 2016-06-14 | BZ | Futures | 40.43 | 40.47 | 39.77 | 40.29 | 20904.0 |
| 2016-06-14 | C | Futures | 2410.0 | 2418.0 | 2397.0 | 2414.0 | 3643.0 |
| 2016-06-14 | CB | Futures | 277.93 | 285.93 | 277.93 | 282.531 | 47.0 |
| 2016-06-14 | CC | Futures | 2269.0 | 2284.0 | 2260.0 | 2276.0 | 19831.0 |
| 2016-06-14 | CNH | Futures | 7.1589 | 7.1687 | 7.1589 | 7.1666 | 24.0 |
| 2016-06-14 | CSC | Futures | 3.678 | 3.8 | 3.591 | 3.638 | 244.0 |
| 2016-06-14 | CT | Futures | 72.56 | 72.56 | 71.18 | 71.71 | 19214.0 |
| 2016-06-14 | DC | Futures | 29.5 | 30.63 | 28.8 | 29.21 | 536.0 |
| 2016-06-14 | DX | Futures | 87.872 | 88.486 | 87.793 | 88.393 | 22522.0 |
| 2016-06-14 | E1 | Futures | 1.30547 | 1.30822 | 1.30184 | 1.30647 | 22726.0 |
| 2016-06-14 | E6 | Futures | 1.31856 | 1.31972 | 1.30703 | 1.30878 | 175765.0 |
| 2016-06-14 | E7 | Futures | 1.3114 | 1.3126 | 1.3 | 1.3018 | 3424.0 |
| 2016-06-14 | EBM | Futures | 202.38 | 203.29 | 198.48 | 199.08 | 14934.0 |
| 2016-06-14 | ED | Futures | 95.7714 | 95.7811 | 95.7473 | 95.757 | 363720.0 |
| 2016-06-14 | ER | Futures | 98.264 | 98.269 | 98.264 | 98.264 | 55194.0 |
| 2016-06-14 | EW | Futures | 1564.5 | 1569.3 | 1553.6 | 1562.6 | 36785.0 |
| 2016-06-14 | FBON | Futures | 119.32 | 119.32 | 118.73 | 118.84 | 1058.0 |
| 2016-06-14 | FBTP | Futures | 107.28 | 107.33 | 106.56 | 106.7 | 150580.0 |
| 2016-06-14 | FBTS | Futures | 100.997 | 101.006 | 100.89 | 100.925 | 48303.0 |
| 2016-06-14 | FCE | Futures | 3657.4 | 3659.6 | 3584.2 | 3587.7 | 162907.0 |
| 2016-06-14 | FDAX | Futures | 10328.5 | 10347.3 | 10209.2 | 10218.4 | 185154.0 |
| 2016-06-14 | FDXM | Futures | 9969.0 | 9977.3 | 9847.7 | 9854.9 | 2426.0 |
| 2016-06-14 | FESX | Futures | 2215.5 | 2217.8 | 2177.9 | 2178.7 | 2141144.0 |
| 2016-06-14 | FGBL | Futures | 148.35 | 149.02 | 148.22 | 148.66 | 787779.0 |
| 2016-06-14 | FGBM | Futures | 128.09 | 128.36 | 128.06 | 128.31 | 708013.0 |
| 2016-06-14 | FGBS | Futures | 111.713 | 111.817 | 111.708 | 111.798 | 425350.0 |
| 2016-06-14 | FGBX | Futures | 181.46 | 184.46 | 181.1 | 183.85 | 51305.0 |
| 2016-06-14 | FMWO | Futures | 5580.5 | 5586.7 | 5533.3 | 5533.3 | 954.0 |
| 2016-06-14 | FOAT | Futures | 135.44 | 135.78 | 135.03 | 135.27 | 126318.0 |
| 2016-06-14 | FTDX | Futures | 1533.9 | 1536.8 | 1515.6 | 1517.0 | 593.0 |
| 2016-06-14 | FTI | Futures | 383.11 | 383.65 | 376.09 | 376.45 | 34179.0 |
| 2016-06-14 | FTUK | Futures | 4995.0 | 4995.0 | 4879.1 | 4893.2 | 301467.0 |
| 2016-06-14 | FVSA | Futures | 3033.94 | 3084.51 | 2927.75 | 3064.28 | 49773.0 |
| 2016-06-14 | FXXP | Futures | 260.9 | 260.9 | 257.4 | 257.5 | 195064.0 |
| 2016-06-14 | G | Futures | 111.14 | 111.76 | 111.02 | 111.56 | 223823.0 |
| 2016-06-14 | GF | Futures | 281.653 | 284.898 | 279.556 | 283.85 | 4979.0 |
| 2016-06-14 | GSCI | Futures | 547.91 | 550.66 | 545.73 | 549.86 | 1034.0 |
> showing 50 of 109 rows — these rows as CSV