PREVIEW / futures_daily / 2016-07-13
file: by_date/futures_daily/2016/2016-07-13.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-07-13 | ES | Futures | 2316.75 | 2323.76 | 2310.0 | 2317.02 | 1633489.0 |
| 2016-07-13 | NQ | Futures | 5388.88 | 5403.91 | 5373.27 | 5376.51 | 190027.0 |
| 2016-07-13 | YM | Futures | 19081.3 | 19119.9 | 19033.2 | 19102.1 | 124219.0 |
| 2016-07-13 | CL | Futures | 54.11 | 54.26 | 51.76 | 51.98 | 686245.0 |
| 2016-07-13 | GC | Futures | 1716.2 | 1732.0 | 1708.6 | 1728.6 | 204592.0 |
| 2016-07-13 | ZN | Futures | 127.954385 | 128.392017 | 127.939294 | 128.286381 | 1201572.0 |
| 2016-07-13 | A6 | Futures | 0.77355 | 0.77528 | 0.76917 | 0.77253 | 94091.0 |
| 2016-07-13 | AD | Futures | 0.78493 | 0.79122 | 0.78216 | 0.78953 | 93201.0 |
| 2016-07-13 | ALI | Futures | 2180.15 | 2180.15 | 2174.44 | 2180.15 | 11.0 |
| 2016-07-13 | B | Futures | 38.42 | 38.48 | 36.8 | 36.93 | 299796.0 |
| 2016-07-13 | B6 | Futures | 1.3976 | 1.4074 | 1.3857 | 1.3883 | 133727.0 |
| 2016-07-13 | BFX | Futures | 3901.4 | 3914.7 | 3880.6 | 3880.6 | 39.0 |
| 2016-07-13 | BR | Futures | 0.19904 | 0.19984 | 0.19904 | 0.19977 | 5.0 |
| 2016-07-13 | BZ | Futures | 38.21 | 38.34 | 36.66 | 36.79 | 29323.0 |
| 2016-07-13 | C | Futures | 2634.0 | 2655.0 | 2622.0 | 2652.0 | 8355.0 |
| 2016-07-13 | CB | Futures | 273.124 | 275.761 | 273.124 | 275.761 | 5.0 |
| 2016-07-13 | CC | Futures | 2288.0 | 2316.0 | 2284.0 | 2304.0 | 14989.0 |
| 2016-07-13 | CNH | Futures | 7.2668 | 7.2668 | 7.2592 | 7.2592 | 1.0 |
| 2016-07-13 | CSC | Futures | 3.572 | 3.619 | 3.572 | 3.61 | 21.0 |
| 2016-07-13 | CT | Futures | 80.99 | 85.12 | 80.99 | 83.12 | 156.0 |
| 2016-07-13 | DC | Futures | 28.6 | 29.21 | 28.53 | 28.73 | 133.0 |
| 2016-07-13 | DX | Futures | 89.811 | 89.844 | 89.374 | 89.479 | 12261.0 |
| 2016-07-13 | E1 | Futures | 1.27041 | 1.27917 | 1.26978 | 1.27817 | 18242.0 |
| 2016-07-13 | E6 | Futures | 1.29108 | 1.29783 | 1.2887 | 1.29638 | 128781.0 |
| 2016-07-13 | E7 | Futures | 1.2844 | 1.2909 | 1.2819 | 1.2895 | 3974.0 |
| 2016-07-13 | EBM | Futures | 195.17 | 197.57 | 194.57 | 194.57 | 18923.0 |
| 2016-07-13 | ED | Futures | 95.7714 | 95.7811 | 95.7666 | 95.7763 | 144300.0 |
| 2016-07-13 | ER | Futures | 98.323 | 98.332 | 98.323 | 98.328 | 44248.0 |
| 2016-07-13 | EW | Futures | 1632.7 | 1641.0 | 1625.6 | 1629.4 | 18822.0 |
| 2016-07-13 | FBON | Futures | 122.56 | 122.76 | 122.55 | 122.73 | 250.0 |
| 2016-07-13 | FBTP | Futures | 109.55 | 109.72 | 109.37 | 109.66 | 81284.0 |
| 2016-07-13 | FBTS | Futures | 101.293 | 101.302 | 101.257 | 101.284 | 19746.0 |
| 2016-07-13 | FCE | Futures | 3768.2 | 3803.1 | 3767.3 | 3783.0 | 119606.0 |
| 2016-07-13 | FDAX | Futures | 10566.4 | 10633.4 | 10521.7 | 10579.7 | 66410.0 |
| 2016-07-13 | FDXM | Futures | 10299.9 | 10364.2 | 10257.4 | 10312.3 | 21146.0 |
| 2016-07-13 | FESX | Futures | 2285.2 | 2303.2 | 2279.7 | 2293.0 | 1032793.0 |
| 2016-07-13 | FEU3 | Futures | 98.981 | 98.981 | 98.981 | 98.981 | 9.0 |
| 2016-07-13 | FGBL | Futures | 149.97 | 150.6 | 149.93 | 150.53 | 612640.0 |
| 2016-07-13 | FGBM | Futures | 129.01 | 129.13 | 129.0 | 129.1 | 367186.0 |
| 2016-07-13 | FGBS | Futures | 111.977 | 111.987 | 111.957 | 111.972 | 151500.0 |
| 2016-07-13 | FGBX | Futures | 187.19 | 189.51 | 186.58 | 189.1 | 33674.0 |
| 2016-07-13 | FMWO | Futures | 5640.7 | 5671.1 | 5640.7 | 5655.3 | 134.0 |
| 2016-07-13 | FOAT | Futures | 138.1 | 138.58 | 138.06 | 138.49 | 78743.0 |
| 2016-07-13 | FTDX | Futures | 1565.2 | 1567.2 | 1555.6 | 1567.2 | 32.0 |
| 2016-07-13 | FTI | Futures | 396.83 | 399.48 | 395.71 | 396.61 | 27121.0 |
| 2016-07-13 | FTUK | Futures | 5525.2 | 5561.9 | 5501.4 | 5539.8 | 124912.0 |
| 2016-07-13 | FVSA | Futures | 2274.28 | 2352.36 | 2274.28 | 2337.72 | 5118.0 |
| 2016-07-13 | FXXP | Futures | 270.9 | 272.5 | 269.3 | 271.0 | 22232.0 |
| 2016-07-13 | G | Futures | 114.76 | 115.37 | 114.71 | 115.29 | 163619.0 |
| 2016-07-13 | GF | Futures | 275.363 | 278.508 | 273.766 | 278.109 | 5238.0 |
> showing 50 of 109 rows — these rows as CSV