PREVIEW / futures_daily / 2016-05-16
file: by_date/futures_daily/2016/2016-05-16.parquet size: 9 KB rows: 103
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-16 | ES | Futures | 2191.73 | 2220.98 | 2185.02 | 2214.81 | 1421736.0 |
| 2016-05-16 | NQ | Futures | 5071.33 | 5160.63 | 5058.99 | 5140.95 | 197887.0 |
| 2016-05-16 | YM | Futures | 18162.4 | 18408.8 | 18113.5 | 18366.2 | 135180.0 |
| 2016-05-16 | CL | Futures | 55.05 | 57.05 | 54.91 | 56.76 | 273392.0 |
| 2016-05-16 | GC | Futures | 1640.9 | 1663.2 | 1639.0 | 1642.4 | 198783.0 |
| 2016-05-16 | ZN | Futures | 126.520743 | 126.596179 | 125.992693 | 126.022868 | 906695.0 |
| 2016-05-16 | A6 | Futures | 0.73336 | 0.73893 | 0.73286 | 0.73681 | 70109.0 |
| 2016-05-16 | AD | Futures | 0.78975 | 0.79425 | 0.78873 | 0.79271 | 38487.0 |
| 2016-05-16 | ALI | Futures | 2078.22 | 2087.55 | 2078.22 | 2087.55 | 6.0 |
| 2016-05-16 | B | Futures | 39.68 | 41.06 | 39.65 | 40.65 | 294377.0 |
| 2016-05-16 | B6 | Futures | 1.5113 | 1.518 | 1.5092 | 1.5153 | 56617.0 |
| 2016-05-16 | BR | Futures | 0.18412 | 0.18516 | 0.18396 | 0.18513 | 257.0 |
| 2016-05-16 | BZ | Futures | 39.55 | 40.93 | 39.55 | 40.51 | 34770.0 |
| 2016-05-16 | C | Futures | 2291.0 | 2302.0 | 2240.0 | 2256.0 | 12196.0 |
| 2016-05-16 | CC | Futures | 2164.0 | 2187.0 | 2126.0 | 2141.0 | 24092.0 |
| 2016-05-16 | CNH | Futures | 7.1292 | 7.1292 | 7.1212 | 7.1229 | 6.0 |
| 2016-05-16 | CSC | Futures | 3.238 | 3.269 | 3.231 | 3.269 | 40.0 |
| 2016-05-16 | CT | Futures | 69.02 | 69.98 | 68.96 | 69.38 | 14240.0 |
| 2016-05-16 | DC | Futures | 25.2 | 25.57 | 25.2 | 25.55 | 132.0 |
| 2016-05-16 | DX | Futures | 88.206 | 88.267 | 87.992 | 88.15 | 13134.0 |
| 2016-05-16 | E1 | Futures | 1.28889 | 1.29052 | 1.28549 | 1.286 | 10005.0 |
| 2016-05-16 | E6 | Futures | 1.31919 | 1.32386 | 1.31908 | 1.321 | 84564.0 |
| 2016-05-16 | E7 | Futures | 1.3117 | 1.3167 | 1.3117 | 1.3138 | 1495.0 |
| 2016-05-16 | EBM | Futures | 196.97 | 197.87 | 194.57 | 196.07 | 6160.0 |
| 2016-05-16 | ED | Futures | 95.7618 | 95.7618 | 95.7545 | 95.7545 | 111055.0 |
| 2016-05-16 | ER | Futures | 98.264 | 98.269 | 98.259 | 98.259 | 45226.0 |
| 2016-05-16 | EW | Futures | 1520.1 | 1540.8 | 1515.5 | 1535.0 | 16952.0 |
| 2016-05-16 | FBON | Futures | 117.78 | 117.87 | 117.78 | 117.87 | 5.0 |
| 2016-05-16 | FBTP | Futures | 106.34 | 106.35 | 105.94 | 106.09 | 55973.0 |
| 2016-05-16 | FBTS | Futures | 101.105 | 101.114 | 101.078 | 101.105 | 19311.0 |
| 2016-05-16 | FCE | Futures | 3646.4 | 3679.1 | 3627.0 | 3665.7 | 40182.0 |
| 2016-05-16 | FESX | Futures | 2271.3 | 2289.3 | 2253.4 | 2278.4 | 437206.0 |
| 2016-05-16 | FGBL | Futures | 146.93 | 146.93 | 146.46 | 146.61 | 311410.0 |
| 2016-05-16 | FGBM | Futures | 127.78 | 127.78 | 127.66 | 127.7 | 211309.0 |
| 2016-05-16 | FGBS | Futures | 111.683 | 111.683 | 111.668 | 111.673 | 76419.0 |
| 2016-05-16 | FGBX | Futures | 174.4 | 174.52 | 173.06 | 173.54 | 20131.0 |
| 2016-05-16 | FMWO | Futures | 5564.4 | 5600.4 | 5564.4 | 5600.4 | 300.0 |
| 2016-05-16 | FOAT | Futures | 134.37 | 134.42 | 133.88 | 134.06 | 47383.0 |
| 2016-05-16 | FTI | Futures | 383.77 | 388.08 | 382.74 | 387.59 | 8959.0 |
| 2016-05-16 | FTUK | Futures | 4993.3 | 5072.1 | 4993.3 | 5051.0 | 67892.0 |
| 2016-05-16 | FVSA | Futures | 2620.4 | 2652.98 | 2545.93 | 2555.23 | 17224.0 |
| 2016-05-16 | FXXP | Futures | 266.3 | 267.9 | 264.4 | 267.2 | 10908.0 |
| 2016-05-16 | G | Futures | 109.13 | 109.27 | 108.84 | 108.93 | 112783.0 |
| 2016-05-16 | GF | Futures | 294.732 | 298.177 | 294.533 | 294.982 | 4129.0 |
| 2016-05-16 | GSCI | Futures | 529.51 | 532.83 | 529.51 | 531.82 | 94.0 |
| 2016-05-16 | HE | Futures | 99.986 | 101.203 | 99.286 | 101.051 | 12512.0 |
| 2016-05-16 | HG | Futures | 2.5973 | 2.638 | 2.5829 | 2.6161 | 62451.0 |
| 2016-05-16 | HH | Futures | 20.522 | 20.522 | 19.961 | 19.971 | 2051.0 |
| 2016-05-16 | HO | Futures | 1.0265 | 1.0685 | 1.0257 | 1.0555 | 63782.0 |
| 2016-05-16 | HRC | Futures | 1513.3 | 1513.3 | 1513.3 | 1513.3 | 0.0 |
> showing 50 of 103 rows — these rows as CSV