PREVIEW / futures_daily / 2016-11-15
file: by_date/futures_daily/2016/2016-11-15.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-11-15 | ES | Futures | 2337.33 | 2357.61 | 2334.63 | 2357.07 | 1443589.0 |
| 2016-11-15 | NQ | Futures | 5530.63 | 5632.58 | 5525.04 | 5616.96 | 238486.0 |
| 2016-11-15 | YM | Futures | 19762.9 | 19830.1 | 19694.7 | 19824.9 | 146311.0 |
| 2016-11-15 | CL | Futures | 47.8 | 50.39 | 47.63 | 50.06 | 407942.0 |
| 2016-11-15 | GC | Futures | 1567.6 | 1579.9 | 1563.5 | 1571.0 | 234172.0 |
| 2016-11-15 | ZN | Futures | 122.970018 | 123.532427 | 122.894016 | 122.985218 | 1750696.0 |
| 2016-11-15 | A6 | Futures | 0.77081 | 0.77285 | 0.76571 | 0.76969 | 106838.0 |
| 2016-11-15 | AD | Futures | 0.75614 | 0.76213 | 0.75594 | 0.76091 | 74514.0 |
| 2016-11-15 | ALI | Futures | 2370.74 | 2370.74 | 2370.74 | 2370.74 | 0.0 |
| 2016-11-15 | B | Futures | 33.95 | 35.89 | 33.93 | 35.66 | 354268.0 |
| 2016-11-15 | B6 | Futures | 1.3169 | 1.3198 | 1.304 | 1.3136 | 139387.0 |
| 2016-11-15 | BFX | Futures | 4130.0 | 4138.4 | 4130.0 | 4138.4 | 35.0 |
| 2016-11-15 | BR | Futures | 0.19855 | 0.20102 | 0.19855 | 0.1992 | 769.0 |
| 2016-11-15 | BZ | Futures | 33.81 | 35.73 | 33.78 | 35.49 | 43809.0 |
| 2016-11-15 | C | Futures | 2165.0 | 2169.0 | 2149.0 | 2154.0 | 3715.0 |
| 2016-11-15 | CC | Futures | 1832.0 | 1839.0 | 1816.0 | 1823.0 | 19271.0 |
| 2016-11-15 | CNH | Futures | 7.3772 | 7.4055 | 7.3772 | 7.4038 | 115.0 |
| 2016-11-15 | CSC | Futures | 3.932 | 3.969 | 3.921 | 3.962 | 28.0 |
| 2016-11-15 | CT | Futures | 77.41 | 79.92 | 77.4 | 79.19 | 20270.0 |
| 2016-11-15 | DC | Futures | 31.23 | 31.66 | 31.18 | 31.45 | 367.0 |
| 2016-11-15 | DX | Futures | 92.895 | 93.333 | 92.583 | 93.305 | 43937.0 |
| 2016-11-15 | E1 | Futures | 1.25117 | 1.25677 | 1.24357 | 1.24531 | 30189.0 |
| 2016-11-15 | E6 | Futures | 1.24716 | 1.25545 | 1.24357 | 1.24386 | 213822.0 |
| 2016-11-15 | E7 | Futures | 1.2402 | 1.2486 | 1.2366 | 1.2371 | 5144.0 |
| 2016-11-15 | EBM | Futures | 190.35 | 192.41 | 190.06 | 191.82 | 26155.0 |
| 2016-11-15 | ED | Futures | 95.6055 | 95.62 | 95.6031 | 95.608 | 354342.0 |
| 2016-11-15 | ER | Futures | 98.274 | 98.274 | 98.269 | 98.269 | 18576.0 |
| 2016-11-15 | EW | Futures | 1685.6 | 1698.2 | 1682.4 | 1695.3 | 13640.0 |
| 2016-11-15 | FBON | Futures | 121.08 | 121.62 | 120.89 | 121.2 | 585.0 |
| 2016-11-15 | FBTP | Futures | 103.05 | 104.29 | 103.03 | 103.99 | 150329.0 |
| 2016-11-15 | FBTS | Futures | 100.637 | 100.799 | 100.637 | 100.754 | 39744.0 |
| 2016-11-15 | FCE | Futures | 3984.2 | 4015.9 | 3972.7 | 4000.5 | 130720.0 |
| 2016-11-15 | FDAX | Futures | 11311.4 | 11367.4 | 11265.4 | 11351.0 | 81770.0 |
| 2016-11-15 | FDXM | Futures | 11288.0 | 11341.8 | 11240.6 | 11326.5 | 21773.0 |
| 2016-11-15 | FESX | Futures | 2435.8 | 2451.0 | 2424.6 | 2443.8 | 871287.0 |
| 2016-11-15 | FEU3 | Futures | 98.947 | 98.952 | 98.947 | 98.952 | 1.0 |
| 2016-11-15 | FGBL | Futures | 146.28 | 146.66 | 146.22 | 146.46 | 882925.0 |
| 2016-11-15 | FGBM | Futures | 127.94 | 128.01 | 127.89 | 127.94 | 547264.0 |
| 2016-11-15 | FGBS | Futures | 111.847 | 111.867 | 111.837 | 111.852 | 325873.0 |
| 2016-11-15 | FGBX | Futures | 171.45 | 173.12 | 171.42 | 172.67 | 54452.0 |
| 2016-11-15 | FMWO | Futures | 5675.9 | 5680.8 | 5671.1 | 5677.1 | 1940.0 |
| 2016-11-15 | FOAT | Futures | 131.96 | 133.0 | 131.86 | 132.69 | 176621.0 |
| 2016-11-15 | FTDX | Futures | 1658.3 | 1667.1 | 1654.8 | 1665.1 | 81.0 |
| 2016-11-15 | FTI | Futures | 408.63 | 412.46 | 408.13 | 410.55 | 24374.0 |
| 2016-11-15 | FTUK | Futures | 5711.5 | 5751.2 | 5702.6 | 5725.8 | 106683.0 |
| 2016-11-15 | FVSA | Futures | 1398.16 | 1404.44 | 1347.89 | 1357.31 | 14265.0 |
| 2016-11-15 | FXXP | Futures | 279.2 | 281.1 | 277.9 | 280.0 | 18023.0 |
| 2016-11-15 | G | Futures | 110.34 | 110.96 | 110.27 | 110.71 | 214252.0 |
| 2016-11-15 | GF | Futures | 273.775 | 275.002 | 271.321 | 274.444 | 3541.0 |
| 2016-11-15 | GSCI | Futures | 485.78 | 490.96 | 485.17 | 490.01 | 112.0 |
> showing 50 of 109 rows — these rows as CSV