PREVIEW / futures_daily / 2016-06-30
file: by_date/futures_daily/2016/2016-06-30.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 |
|---|---|---|---|---|---|---|---|
| 2016-06-30 | ES | Futures | 2237.39 | 2257.9 | 2220.38 | 2256.82 | 2301226.0 |
| 2016-06-30 | NQ | Futures | 5156.97 | 5198.81 | 5113.94 | 5194.69 | 242965.0 |
| 2016-06-30 | YM | Futures | 18456.6 | 18621.7 | 18338.6 | 18612.3 | 173079.0 |
| 2016-06-30 | CL | Futures | 57.56 | 57.64 | 55.95 | 56.14 | 508736.0 |
| 2016-06-30 | GC | Futures | 1699.5 | 1706.6 | 1692.1 | 1699.0 | 192947.0 |
| 2016-06-30 | ZN | Futures | 128.165656 | 128.678741 | 127.909113 | 128.437289 | 1943875.0 |
| 2016-06-30 | A6 | Futures | 0.75534 | 0.75819 | 0.74791 | 0.75534 | 123104.0 |
| 2016-06-30 | AD | Futures | 0.79096 | 0.7926 | 0.78626 | 0.78922 | 70346.0 |
| 2016-06-30 | ALI | Futures | 2153.18 | 2159.52 | 2153.18 | 2159.52 | 21.0 |
| 2016-06-30 | B | Futures | 40.67 | 40.73 | 39.54 | 39.69 | 309512.0 |
| 2016-06-30 | B6 | Futures | 1.4179 | 1.4234 | 1.3931 | 1.3966 | 182471.0 |
| 2016-06-30 | BFX | Futures | 3856.2 | 3931.4 | 3856.2 | 3931.4 | 1.0 |
| 2016-06-30 | BR | Futures | 0.20113 | 0.20503 | 0.20113 | 0.20346 | 531.0 |
| 2016-06-30 | BZ | Futures | 40.48 | 40.56 | 39.4 | 39.54 | 25855.0 |
| 2016-06-30 | C | Futures | 2502.0 | 2510.0 | 2468.0 | 2495.0 | 18168.0 |
| 2016-06-30 | CB | Futures | 281.945 | 282.209 | 280.743 | 281.915 | 32.0 |
| 2016-06-30 | CC | Futures | 2221.0 | 2229.0 | 2167.0 | 2172.0 | 18093.0 |
| 2016-06-30 | CNH | Futures | 7.2257 | 7.2609 | 7.2257 | 7.2387 | 36.0 |
| 2016-06-30 | CSC | Futures | 3.716 | 3.722 | 3.635 | 3.657 | 58.0 |
| 2016-06-30 | CT | Futures | 75.05 | 76.01 | 73.2 | 73.2 | 73.0 |
| 2016-06-30 | DC | Futures | 30.02 | 30.2 | 29.28 | 29.48 | 240.0 |
| 2016-06-30 | DX | Futures | 89.006 | 89.732 | 88.839 | 89.474 | 40027.0 |
| 2016-06-30 | E1 | Futures | 1.28381 | 1.2927 | 1.28055 | 1.28518 | 23708.0 |
| 2016-06-30 | E6 | Futures | 1.29848 | 1.30208 | 1.28666 | 1.29312 | 220001.0 |
| 2016-06-30 | E7 | Futures | 1.2919 | 1.295 | 1.2799 | 1.2863 | 4812.0 |
| 2016-06-30 | EBM | Futures | 188.85 | 189.15 | 186.75 | 187.35 | 17491.0 |
| 2016-06-30 | ED | Futures | 95.8341 | 95.8534 | 95.8293 | 95.8438 | 209268.0 |
| 2016-06-30 | ER | Futures | 98.308 | 98.323 | 98.303 | 98.313 | 116901.0 |
| 2016-06-30 | EW | Futures | 1557.1 | 1583.5 | 1545.8 | 1582.5 | 29309.0 |
| 2016-06-30 | FBON | Futures | 121.72 | 124.43 | 121.48 | 122.06 | 609.0 |
| 2016-06-30 | FBTP | Futures | 108.04 | 110.71 | 107.68 | 108.43 | 167562.0 |
| 2016-06-30 | FBTS | Futures | 101.203 | 101.499 | 101.167 | 101.248 | 42961.0 |
| 2016-06-30 | FCE | Futures | 3647.8 | 3742.4 | 3616.0 | 3689.2 | 125595.0 |
| 2016-06-30 | FDAX | Futures | 10233.3 | 10412.1 | 10110.4 | 10288.6 | 110053.0 |
| 2016-06-30 | FDXM | Futures | 9975.2 | 10149.5 | 9854.9 | 10028.7 | 25930.0 |
| 2016-06-30 | FESX | Futures | 2210.8 | 2270.3 | 2186.5 | 2235.9 | 1823556.0 |
| 2016-06-30 | FEU3 | Futures | 98.961 | 98.966 | 98.961 | 98.966 | 152.0 |
| 2016-06-30 | FGBL | Futures | 150.0 | 150.57 | 148.93 | 150.38 | 852129.0 |
| 2016-06-30 | FGBM | Futures | 128.85 | 128.96 | 128.49 | 128.91 | 559474.0 |
| 2016-06-30 | FGBS | Futures | 111.937 | 111.952 | 111.798 | 111.932 | 284862.0 |
| 2016-06-30 | FGBX | Futures | 189.39 | 191.79 | 184.59 | 191.2 | 60115.0 |
| 2016-06-30 | FMWO | Futures | 5425.4 | 5492.3 | 5425.4 | 5482.6 | 360.0 |
| 2016-06-30 | FOAT | Futures | 137.37 | 138.27 | 137.01 | 137.88 | 111473.0 |
| 2016-06-30 | FTDX | Futures | 1512.7 | 1562.3 | 1512.7 | 1539.7 | 68.0 |
| 2016-06-30 | FTI | Futures | 386.3 | 396.74 | 384.32 | 391.75 | 39712.0 |
| 2016-06-30 | FTUK | Futures | 5252.4 | 5446.8 | 5216.1 | 5357.9 | 229010.0 |
| 2016-06-30 | FVSA | Futures | 2679.98 | 2771.0 | 2538.4 | 2594.02 | 22631.0 |
| 2016-06-30 | FXXP | Futures | 261.9 | 268.6 | 260.2 | 264.8 | 53943.0 |
| 2016-06-30 | G | Futures | 113.16 | 114.3 | 112.83 | 113.7 | 202650.0 |
| 2016-06-30 | GF | Futures | 286.146 | 289.74 | 286.146 | 288.143 | 5338.0 |
> showing 50 of 110 rows — these rows as CSV