PREVIEW / futures_daily / 2016-12-15
file: by_date/futures_daily/2016/2016-12-15.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-12-15 | ES | Futures | 2441.12 | 2458.47 | 2436.24 | 2448.44 | 1976782.0 |
| 2016-12-15 | NQ | Futures | 5811.42 | 5847.96 | 5796.69 | 5816.14 | 249163.0 |
| 2016-12-15 | YM | Futures | 20816.3 | 20955.4 | 20794.2 | 20858.4 | 202529.0 |
| 2016-12-15 | CL | Futures | 55.48 | 56.24 | 54.68 | 55.62 | 395078.0 |
| 2016-12-15 | GC | Futures | 1468.9 | 1471.7 | 1443.8 | 1450.9 | 281607.0 |
| 2016-12-15 | ZN | Futures | 120.330724 | 120.437698 | 119.765289 | 120.22375 | 2089103.0 |
| 2016-12-15 | A6 | Futures | 0.7563 | 0.75948 | 0.74985 | 0.75272 | 52922.0 |
| 2016-12-15 | AD | Futures | 0.7701 | 0.7705 | 0.76228 | 0.76662 | 64835.0 |
| 2016-12-15 | ALI | Futures | 2372.66 | 2372.66 | 2372.66 | 2372.66 | 0.0 |
| 2016-12-15 | B | Futures | 40.05 | 40.6 | 39.6 | 40.24 | 266152.0 |
| 2016-12-15 | B6 | Futures | 1.3185 | 1.3212 | 1.3011 | 1.3075 | 95428.0 |
| 2016-12-15 | BFX | Futures | 4243.2 | 4271.9 | 4243.2 | 4271.9 | 3.0 |
| 2016-12-15 | BR | Futures | 0.20623 | 0.20687 | 0.20367 | 0.20687 | 34.0 |
| 2016-12-15 | BZ | Futures | 39.73 | 40.3 | 39.3 | 39.95 | 34744.0 |
| 2016-12-15 | C | Futures | 1900.0 | 1912.0 | 1868.0 | 1890.0 | 10082.0 |
| 2016-12-15 | CB | Futures | 263.034 | 263.645 | 262.76 | 262.76 | 26.0 |
| 2016-12-15 | CC | Futures | 1751.0 | 1756.0 | 1692.0 | 1707.0 | 17493.0 |
| 2016-12-15 | CNH | Futures | 7.4505 | 7.4579 | 7.4304 | 7.4304 | 72.0 |
| 2016-12-15 | CSC | Futures | 4.163 | 4.163 | 4.078 | 4.082 | 60.0 |
| 2016-12-15 | CT | Futures | 81.93 | 82.45 | 81.68 | 82.33 | 10400.0 |
| 2016-12-15 | DC | Futures | 33.72 | 33.8 | 33.11 | 33.3 | 265.0 |
| 2016-12-15 | DX | Futures | 95.385 | 96.4 | 95.064 | 95.919 | 83048.0 |
| 2016-12-15 | E1 | Futures | 1.2214 | 1.22215 | 1.20517 | 1.21013 | 23510.0 |
| 2016-12-15 | E6 | Futures | 1.22114 | 1.22143 | 1.20272 | 1.20954 | 252467.0 |
| 2016-12-15 | E7 | Futures | 1.2145 | 1.2145 | 1.1967 | 1.2034 | 6003.0 |
| 2016-12-15 | EBM | Futures | 188.86 | 191.42 | 188.86 | 190.85 | 26268.0 |
| 2016-12-15 | ED | Futures | 95.5568 | 95.5617 | 95.5375 | 95.5617 | 566325.0 |
| 2016-12-15 | ER | Futures | 98.288 | 98.288 | 98.279 | 98.283 | 59190.0 |
| 2016-12-15 | EW | Futures | 1774.7 | 1790.2 | 1768.0 | 1778.6 | 18338.0 |
| 2016-12-15 | FBON | Futures | 121.73 | 122.14 | 121.61 | 121.92 | 330.0 |
| 2016-12-15 | FBTP | Futures | 106.59 | 106.94 | 106.17 | 106.58 | 100593.0 |
| 2016-12-15 | FBTS | Futures | 101.828 | 101.846 | 101.764 | 101.773 | 30202.0 |
| 2016-12-15 | FCE | Futures | 4193.5 | 4243.6 | 4189.1 | 4231.3 | 66576.0 |
| 2016-12-15 | FDAX | Futures | 11909.0 | 12045.8 | 11895.8 | 12026.8 | 123563.0 |
| 2016-12-15 | FDXM | Futures | 11845.7 | 11981.4 | 11832.1 | 11963.5 | 3695.0 |
| 2016-12-15 | FESX | Futures | 2564.7 | 2598.3 | 2560.7 | 2593.5 | 1131492.0 |
| 2016-12-15 | FEU3 | Futures | 98.956 | 98.956 | 98.952 | 98.952 | 20.0 |
| 2016-12-15 | FGBL | Futures | 145.92 | 146.13 | 145.37 | 145.72 | 765274.0 |
| 2016-12-15 | FGBM | Futures | 128.46 | 128.58 | 128.34 | 128.47 | 503657.0 |
| 2016-12-15 | FGBS | Futures | 112.117 | 112.167 | 112.092 | 112.152 | 254339.0 |
| 2016-12-15 | FGBX | Futures | 165.11 | 166.55 | 163.39 | 164.99 | 50598.0 |
| 2016-12-15 | FMWO | Futures | 5875.5 | 5893.7 | 5856.2 | 5886.4 | 857.0 |
| 2016-12-15 | FOAT | Futures | 132.51 | 133.02 | 131.76 | 132.58 | 107691.0 |
| 2016-12-15 | FTDX | Futures | 1713.6 | 1730.3 | 1711.7 | 1726.9 | 1541.0 |
| 2016-12-15 | FTI | Futures | 430.87 | 434.37 | 430.5 | 433.51 | 18996.0 |
| 2016-12-15 | FTUK | Futures | 5823.5 | 5892.2 | 5820.2 | 5881.2 | 122625.0 |
| 2016-12-15 | FVSA | Futures | 1120.87 | 1148.27 | 1118.13 | 1137.31 | 15462.0 |
| 2016-12-15 | FXXP | Futures | 294.0 | 297.3 | 293.7 | 296.5 | 48923.0 |
| 2016-12-15 | G | Futures | 109.79 | 109.85 | 109.15 | 109.52 | 236788.0 |
| 2016-12-15 | GF | Futures | 284.204 | 286.267 | 282.921 | 284.873 | 3422.0 |
> showing 50 of 109 rows — these rows as CSV