PREVIEW / futures_daily / 2016-05-20
file: by_date/futures_daily/2016/2016-05-20.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-05-20 | ES | Futures | 2189.04 | 2207.03 | 2187.43 | 2201.12 | 1583721.0 |
| 2016-05-20 | NQ | Futures | 5072.51 | 5145.36 | 5069.57 | 5125.67 | 244244.0 |
| 2016-05-20 | YM | Futures | 18107.3 | 18244.5 | 18094.8 | 18177.0 | 128694.0 |
| 2016-05-20 | CL | Futures | 57.11 | 57.78 | 56.21 | 56.75 | 538047.0 |
| 2016-05-20 | GC | Futures | 1619.3 | 1625.6 | 1610.6 | 1614.9 | 205159.0 |
| 2016-05-20 | ZN | Futures | 125.177988 | 125.328859 | 125.042204 | 125.238337 | 896676.0 |
| 2016-05-20 | A6 | Futures | 0.73053 | 0.73306 | 0.72921 | 0.73013 | 70484.0 |
| 2016-05-20 | AD | Futures | 0.78055 | 0.78239 | 0.77676 | 0.7783 | 57210.0 |
| 2016-05-20 | ALI | Futures | 2105.89 | 2105.89 | 2081.44 | 2081.44 | 3.0 |
| 2016-05-20 | B | Futures | 40.59 | 41.0 | 39.9 | 40.44 | 255583.0 |
| 2016-05-20 | B6 | Futures | 1.5378 | 1.5388 | 1.5253 | 1.5275 | 84027.0 |
| 2016-05-20 | BFX | Futures | 3979.6 | 3979.6 | 3976.0 | 3976.0 | 19.0 |
| 2016-05-20 | BR | Futures | 0.18119 | 0.18419 | 0.18119 | 0.18399 | 1152.0 |
| 2016-05-20 | BZ | Futures | 40.29 | 40.82 | 39.74 | 40.31 | 26839.0 |
| 2016-05-20 | C | Futures | 2223.0 | 2251.0 | 2222.0 | 2247.0 | 10788.0 |
| 2016-05-20 | CB | Futures | 258.89 | 258.89 | 257.915 | 257.915 | 7.0 |
| 2016-05-20 | CC | Futures | 2129.0 | 2140.0 | 2117.0 | 2130.0 | 16860.0 |
| 2016-05-20 | CSC | Futures | 3.265 | 3.293 | 3.231 | 3.277 | 87.0 |
| 2016-05-20 | CT | Futures | 69.64 | 70.6 | 69.47 | 70.15 | 12731.0 |
| 2016-05-20 | DC | Futures | 25.53 | 25.84 | 25.3 | 25.78 | 431.0 |
| 2016-05-20 | DX | Futures | 88.845 | 89.003 | 88.738 | 88.89 | 10923.0 |
| 2016-05-20 | E1 | Futures | 1.26954 | 1.27079 | 1.26665 | 1.26916 | 15012.0 |
| 2016-05-20 | E6 | Futures | 1.30712 | 1.31132 | 1.30654 | 1.30916 | 106002.0 |
| 2016-05-20 | E7 | Futures | 1.3 | 1.3043 | 1.2997 | 1.3021 | 1741.0 |
| 2016-05-20 | EBM | Futures | 195.17 | 197.27 | 194.57 | 196.67 | 9127.0 |
| 2016-05-20 | ED | Futures | 95.6798 | 95.6871 | 95.6702 | 95.6798 | 178926.0 |
| 2016-05-20 | ER | Futures | 98.259 | 98.264 | 98.259 | 98.264 | 7656.0 |
| 2016-05-20 | EW | Futures | 1512.6 | 1533.1 | 1512.2 | 1530.4 | 19886.0 |
| 2016-05-20 | FBON | Futures | 118.24 | 118.43 | 118.24 | 118.29 | 405.0 |
| 2016-05-20 | FBTP | Futures | 106.13 | 106.42 | 106.12 | 106.24 | 73392.0 |
| 2016-05-20 | FBTS | Futures | 101.078 | 101.114 | 101.078 | 101.096 | 14366.0 |
| 2016-05-20 | FCE | Futures | 3684.2 | 3708.8 | 3670.0 | 3706.2 | 116168.0 |
| 2016-05-20 | FDAX | Futures | 10630.8 | 10657.7 | 10576.6 | 10644.8 | 88071.0 |
| 2016-05-20 | FDXM | Futures | 10233.0 | 10264.1 | 10184.4 | 10249.6 | 17215.0 |
| 2016-05-20 | FESX | Futures | 2283.0 | 2293.2 | 2272.9 | 2289.3 | 1269750.0 |
| 2016-05-20 | FEU3 | Futures | 98.917 | 98.917 | 98.917 | 98.917 | 7.0 |
| 2016-05-20 | FGBL | Futures | 146.38 | 146.46 | 146.09 | 146.29 | 463959.0 |
| 2016-05-20 | FGBM | Futures | 127.64 | 127.65 | 127.55 | 127.59 | 370631.0 |
| 2016-05-20 | FGBS | Futures | 111.648 | 111.658 | 111.638 | 111.653 | 116076.0 |
| 2016-05-20 | FGBX | Futures | 172.9 | 173.23 | 172.05 | 172.53 | 23849.0 |
| 2016-05-20 | FMWO | Futures | 5571.8 | 5590.5 | 5568.1 | 5589.2 | 312.0 |
| 2016-05-20 | FOAT | Futures | 133.97 | 134.08 | 133.68 | 133.89 | 58562.0 |
| 2016-05-20 | FTDX | Futures | 1584.2 | 1594.7 | 1579.5 | 1587.1 | 170.0 |
| 2016-05-20 | FTI | Futures | 387.68 | 389.74 | 387.32 | 389.52 | 35032.0 |
| 2016-05-20 | FTUK | Futures | 5016.4 | 5070.4 | 5012.3 | 5063.0 | 123509.0 |
| 2016-05-20 | FVSA | Futures | 2504.04 | 2545.93 | 2485.42 | 2518.0 | 15380.0 |
| 2016-05-20 | FXXP | Futures | 269.1 | 270.4 | 268.7 | 270.0 | 20738.0 |
| 2016-05-20 | G | Futures | 108.65 | 108.66 | 108.27 | 108.42 | 166525.0 |
| 2016-05-20 | GF | Futures | 296.48 | 297.129 | 293.185 | 295.381 | 3516.0 |
| 2016-05-20 | GSCI | Futures | 531.82 | 533.7 | 527.77 | 530.52 | 126.0 |
> showing 50 of 109 rows — these rows as CSV