PREVIEW / futures_daily / 2016-12-13
file: by_date/futures_daily/2016/2016-12-13.parquet size: 9 KB rows: 108
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-12-13 | ES | Futures | 2440.08 | 2464.15 | 2437.11 | 2458.74 | 1053815.0 |
| 2016-12-13 | NQ | Futures | 5736.0 | 5847.96 | 5729.51 | 5819.38 | 131855.0 |
| 2016-12-13 | YM | Futures | 20782.6 | 20960.6 | 20764.7 | 20916.4 | 152246.0 |
| 2016-12-13 | CL | Futures | 56.66 | 57.63 | 56.49 | 57.17 | 638396.0 |
| 2016-12-13 | GC | Futures | 1495.5 | 1498.7 | 1484.9 | 1488.4 | 142850.0 |
| 2016-12-13 | ZN | Futures | 121.324056 | 121.583851 | 121.110108 | 121.2018 | 1251420.0 |
| 2016-12-13 | A6 | Futures | 0.76603 | 0.769 | 0.76399 | 0.76614 | 20628.0 |
| 2016-12-13 | AD | Futures | 0.77908 | 0.78062 | 0.77837 | 0.77949 | 26185.0 |
| 2016-12-13 | ALI | Futures | 2371.7 | 2371.7 | 2369.45 | 2369.45 | 1.0 |
| 2016-12-13 | B | Futures | 41.5 | 42.05 | 41.07 | 41.51 | 283432.0 |
| 2016-12-13 | B6 | Futures | 1.3336 | 1.3382 | 1.3304 | 1.3313 | 53004.0 |
| 2016-12-13 | BR | Futures | 0.2096 | 0.2096 | 0.2095 | 0.2095 | 7.0 |
| 2016-12-13 | BZ | Futures | 40.95 | 41.73 | 40.78 | 41.21 | 38210.0 |
| 2016-12-13 | C | Futures | 1867.0 | 1885.0 | 1839.0 | 1883.0 | 17181.0 |
| 2016-12-13 | CB | Futures | 261.387 | 261.387 | 261.387 | 261.387 | 2.0 |
| 2016-12-13 | CC | Futures | 1731.0 | 1750.0 | 1705.0 | 1743.0 | 19598.0 |
| 2016-12-13 | CNH | Futures | 7.4157 | 7.4386 | 7.4099 | 7.4099 | 192.0 |
| 2016-12-13 | CSC | Futures | 4.23 | 4.259 | 4.147 | 4.147 | 98.0 |
| 2016-12-13 | CT | Futures | 82.19 | 83.2 | 81.78 | 82.76 | 18701.0 |
| 2016-12-13 | DC | Futures | 33.88 | 34.6 | 33.51 | 33.65 | 520.0 |
| 2016-12-13 | DX | Futures | 93.923 | 94.124 | 93.742 | 94.032 | 18445.0 |
| 2016-12-13 | E1 | Futures | 1.23083 | 1.2343 | 1.22872 | 1.23083 | 7057.0 |
| 2016-12-13 | E6 | Futures | 1.23477 | 1.23778 | 1.2305 | 1.23235 | 110845.0 |
| 2016-12-13 | E7 | Futures | 1.229 | 1.2313 | 1.2242 | 1.226 | 1053.0 |
| 2016-12-13 | EBM | Futures | 187.44 | 189.14 | 186.87 | 188.86 | 17394.0 |
| 2016-12-13 | ED | Futures | 95.5858 | 95.5906 | 95.5713 | 95.581 | 301324.0 |
| 2016-12-13 | ER | Futures | 98.283 | 98.288 | 98.279 | 98.283 | 33095.0 |
| 2016-12-13 | EW | Futures | 1789.5 | 1800.6 | 1784.5 | 1794.7 | 40604.0 |
| 2016-12-13 | FBON | Futures | 121.71 | 122.37 | 121.53 | 122.16 | 55.0 |
| 2016-12-13 | FBTP | Futures | 105.58 | 106.46 | 105.52 | 106.33 | 105843.0 |
| 2016-12-13 | FBTS | Futures | 101.62 | 101.746 | 101.593 | 101.728 | 38180.0 |
| 2016-12-13 | FCE | Futures | 4175.4 | 4224.2 | 4168.4 | 4217.6 | 132897.0 |
| 2016-12-13 | FDAX | Futures | 11811.2 | 11950.2 | 11808.1 | 11935.9 | 156419.0 |
| 2016-12-13 | FDXM | Futures | 11749.0 | 11884.6 | 11745.9 | 11873.1 | 5330.0 |
| 2016-12-13 | FESX | Futures | 2539.9 | 2584.7 | 2539.9 | 2581.5 | 1631289.0 |
| 2016-12-13 | FGBL | Futures | 145.53 | 146.05 | 145.27 | 145.84 | 637777.0 |
| 2016-12-13 | FGBM | Futures | 128.35 | 128.52 | 128.25 | 128.46 | 413658.0 |
| 2016-12-13 | FGBS | Futures | 112.092 | 112.117 | 112.077 | 112.102 | 193037.0 |
| 2016-12-13 | FGBX | Futures | 163.35 | 165.38 | 162.62 | 164.65 | 49815.0 |
| 2016-12-13 | FMWO | Futures | 5899.7 | 5937.2 | 5899.7 | 5937.2 | 1249.0 |
| 2016-12-13 | FOAT | Futures | 131.89 | 132.55 | 131.78 | 132.38 | 91999.0 |
| 2016-12-13 | FTDX | Futures | 1717.6 | 1718.5 | 1708.7 | 1718.5 | 902.0 |
| 2016-12-13 | FTI | Futures | 427.23 | 431.73 | 427.23 | 430.73 | 27409.0 |
| 2016-12-13 | FTUK | Futures | 5777.8 | 5865.5 | 5772.7 | 5863.4 | 354162.0 |
| 2016-12-13 | FVSA | Futures | 1126.35 | 1129.09 | 1107.16 | 1115.39 | 9463.0 |
| 2016-12-13 | FXXP | Futures | 291.5 | 295.7 | 291.1 | 295.3 | 118028.0 |
| 2016-12-13 | G | Futures | 109.9 | 110.4 | 109.78 | 110.18 | 175661.0 |
| 2016-12-13 | GF | Futures | 287.773 | 289.558 | 286.992 | 287.717 | 6403.0 |
| 2016-12-13 | GSCI | Futures | 529.46 | 529.46 | 524.89 | 525.62 | 2194.0 |
| 2016-12-13 | HE | Futures | 84.065 | 84.369 | 82.679 | 83.49 | 15024.0 |
> showing 50 of 108 rows — these rows as CSV