PREVIEW / futures_daily / 2016-12-01
file: by_date/futures_daily/2016/2016-12-01.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-01 | ES | Futures | 2378.97 | 2382.76 | 2364.37 | 2370.86 | 2148721.0 |
| 2016-12-01 | NQ | Futures | 5679.42 | 5689.44 | 5565.99 | 5582.19 | 291375.0 |
| 2016-12-01 | YM | Futures | 20101.1 | 20166.2 | 20069.6 | 20157.8 | 186012.0 |
| 2016-12-01 | CL | Futures | 52.95 | 55.89 | 52.85 | 55.1 | 974805.0 |
| 2016-12-01 | GC | Futures | 1509.1 | 1513.3 | 1492.5 | 1501.7 | 230283.0 |
| 2016-12-01 | ZN | Futures | 121.693197 | 121.769198 | 120.963585 | 121.343591 | 92573.0 |
| 2016-12-01 | A6 | Futures | 0.75326 | 0.75693 | 0.75173 | 0.75612 | 96856.0 |
| 2016-12-01 | AD | Futures | 0.76295 | 0.77023 | 0.76239 | 0.76895 | 88122.0 |
| 2016-12-01 | ALI | Futures | 2372.98 | 2372.98 | 2370.1 | 2370.1 | 10.0 |
| 2016-12-01 | B | Futures | 38.53 | 40.62 | 38.38 | 40.19 | 460862.0 |
| 2016-12-01 | B6 | Futures | 1.318 | 1.3369 | 1.317 | 1.3249 | 175983.0 |
| 2016-12-01 | BR | Futures | 0.20267 | 0.20267 | 0.19965 | 0.19965 | 37.0 |
| 2016-12-01 | BZ | Futures | 38.05 | 40.32 | 38.03 | 39.89 | 71317.0 |
| 2016-12-01 | C | Futures | 2095.0 | 2099.0 | 2084.0 | 2092.0 | 8686.0 |
| 2016-12-01 | CB | Futures | 266.055 | 268.527 | 262.058 | 263.858 | 8.0 |
| 2016-12-01 | CC | Futures | 1813.0 | 1848.0 | 1813.0 | 1832.0 | 19698.0 |
| 2016-12-01 | CNH | Futures | 7.4308 | 7.4308 | 7.3967 | 7.3967 | 54.0 |
| 2016-12-01 | CSC | Futures | 3.891 | 3.944 | 3.891 | 3.944 | 119.0 |
| 2016-12-01 | CT | Futures | 82.31 | 82.86 | 81.27 | 81.45 | 18083.0 |
| 2016-12-01 | DC | Futures | 31.58 | 32.15 | 31.58 | 32.02 | 390.0 |
| 2016-12-01 | DX | Futures | 94.524 | 94.575 | 93.956 | 94.095 | 35284.0 |
| 2016-12-01 | E1 | Futures | 1.22587 | 1.2346 | 1.2255 | 1.2321 | 27851.0 |
| 2016-12-01 | E6 | Futures | 1.22879 | 1.2376 | 1.22768 | 1.23499 | 226919.0 |
| 2016-12-01 | E7 | Futures | 1.2222 | 1.2308 | 1.221 | 1.2283 | 4246.0 |
| 2016-12-01 | EBM | Futures | 190.06 | 190.06 | 188.29 | 188.58 | 7429.0 |
| 2016-12-01 | ED | Futures | 95.5862 | 95.5886 | 95.579 | 95.5886 | 287442.0 |
| 2016-12-01 | ER | Futures | 98.279 | 98.283 | 98.274 | 98.279 | 48373.0 |
| 2016-12-01 | EW | Futures | 1732.2 | 1741.3 | 1721.4 | 1726.1 | 16614.0 |
| 2016-12-01 | FBON | Futures | 120.32 | 120.41 | 119.54 | 119.75 | 1504.0 |
| 2016-12-01 | FBTP | Futures | 103.82 | 104.24 | 103.19 | 103.49 | 179779.0 |
| 2016-12-01 | FBTS | Futures | 100.745 | 100.772 | 100.655 | 100.718 | 44503.0 |
| 2016-12-01 | FCE | Futures | 4034.0 | 4045.1 | 4005.8 | 4024.8 | 103806.0 |
| 2016-12-01 | FDAX | Futures | 11212.1 | 11229.0 | 11072.0 | 11107.4 | 127197.0 |
| 2016-12-01 | FDXM | Futures | 11182.6 | 11203.7 | 11048.7 | 11083.5 | 27328.0 |
| 2016-12-01 | FESX | Futures | 2435.0 | 2443.0 | 2413.4 | 2422.2 | 1302476.0 |
| 2016-12-01 | FGBL | Futures | 146.79 | 146.97 | 145.67 | 146.32 | 1333037.0 |
| 2016-12-01 | FGBM | Futures | 128.61 | 128.66 | 128.27 | 128.53 | 872021.0 |
| 2016-12-01 | FGBS | Futures | 112.162 | 112.197 | 112.097 | 112.182 | 670924.0 |
| 2016-12-01 | FGBX | Futures | 171.45 | 171.75 | 167.7 | 169.57 | 93094.0 |
| 2016-12-01 | FMWO | Futures | 5731.6 | 5737.6 | 5717.1 | 5720.7 | 245.0 |
| 2016-12-01 | FOAT | Futures | 132.28 | 132.52 | 131.35 | 131.96 | 262343.0 |
| 2016-12-01 | FTDX | Futures | 1672.5 | 1674.0 | 1656.3 | 1656.3 | 256.0 |
| 2016-12-01 | FTI | Futures | 415.29 | 416.93 | 410.91 | 413.37 | 41390.0 |
| 2016-12-01 | FTUK | Futures | 5721.6 | 5731.7 | 5643.5 | 5696.3 | 160960.0 |
| 2016-12-01 | FVSA | Futures | 1335.32 | 1379.31 | 1313.33 | 1360.46 | 35792.0 |
| 2016-12-01 | FXXP | Futures | 281.8 | 282.6 | 279.4 | 280.6 | 34988.0 |
| 2016-12-01 | G | Futures | 110.12 | 110.21 | 109.15 | 109.67 | 234773.0 |
| 2016-12-01 | GF | Futures | 288.331 | 289.112 | 284.037 | 285.04 | 5398.0 |
| 2016-12-01 | GSCI | Futures | 523.33 | 527.55 | 521.97 | 525.1 | 1283.0 |
| 2016-12-01 | HE | Futures | 74.701 | 74.837 | 72.403 | 73.113 | 23780.0 |
> showing 50 of 108 rows — these rows as CSV