PREVIEW / futures_daily / 2017-07-04
file: by_date/futures_daily/2017/2017-07-04.parquet size: 6 KB rows: 34
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 |
|---|---|---|---|---|---|---|---|
| 2017-07-04 | B | Futures | 35.09 | 35.28 | 34.85 | 35.08 | 129566.0 |
| 2017-07-04 | C | Futures | 1566.0 | 1574.0 | 1536.0 | 1553.0 | 6705.0 |
| 2017-07-04 | DX | Futures | 89.539 | 89.721 | 89.46 | 89.613 | 7549.0 |
| 2017-07-04 | EBM | Futures | 200.14 | 200.7 | 199.03 | 200.14 | 7858.0 |
| 2017-07-04 | ER | Futures | 98.337 | 98.337 | 98.332 | 98.332 | 25369.0 |
| 2017-07-04 | FBON | Futures | 124.03 | 124.2 | 123.85 | 123.89 | 215.0 |
| 2017-07-04 | FBTP | Futures | 107.68 | 108.04 | 107.59 | 107.87 | 52886.0 |
| 2017-07-04 | FBTS | Futures | 102.717 | 102.781 | 102.717 | 102.754 | 25841.0 |
| 2017-07-04 | FCE | Futures | 4656.8 | 4684.3 | 4653.2 | 4663.1 | 45291.0 |
| 2017-07-04 | FDAX | Futures | 13089.3 | 13137.2 | 13063.5 | 13113.5 | 46905.0 |
| 2017-07-04 | FDXM | Futures | 13009.3 | 13055.3 | 12983.1 | 13032.8 | 11766.0 |
| 2017-07-04 | FESX | Futures | 2830.0 | 2845.5 | 2825.1 | 2839.8 | 377355.0 |
| 2017-07-04 | FEU3 | Futures | 99.011 | 99.011 | 99.011 | 99.011 | 8.0 |
| 2017-07-04 | FGBL | Futures | 147.09 | 147.35 | 146.99 | 147.03 | 417805.0 |
| 2017-07-04 | FGBM | Futures | 128.59 | 128.74 | 128.56 | 128.6 | 202476.0 |
| 2017-07-04 | FGBS | Futures | 112.091 | 112.121 | 112.081 | 112.106 | 166949.0 |
| 2017-07-04 | FGBX | Futures | 164.52 | 164.93 | 163.6 | 163.82 | 42844.0 |
| 2017-07-04 | FMWO | Futures | 6418.6 | 6418.6 | 6411.4 | 6415.0 | 397.0 |
| 2017-07-04 | FOAT | Futures | 134.76 | 134.99 | 134.7 | 134.75 | 63329.0 |
| 2017-07-04 | FTDX | Futures | 2191.5 | 2213.6 | 2185.0 | 2206.6 | 310.0 |
| 2017-07-04 | FTI | Futures | 471.55 | 473.91 | 470.68 | 472.01 | 14633.0 |
| 2017-07-04 | FTUK | Futures | 6307.4 | 6326.0 | 6285.8 | 6316.1 | 60878.0 |
| 2017-07-04 | FVSA | Futures | 492.81 | 492.81 | 480.22 | 483.37 | 13890.0 |
| 2017-07-04 | FXXP | Futures | 324.2 | 325.5 | 323.6 | 325.0 | 16382.0 |
| 2017-07-04 | G | Futures | 114.06 | 114.18 | 113.88 | 114.07 | 109284.0 |
| 2017-07-04 | JB | Futures | 137.48 | 137.49 | 137.42 | 137.46 | 1079.0 |
| 2017-07-04 | L | Futures | 99.405 | 99.425 | 99.405 | 99.415 | 46114.0 |
| 2017-07-04 | MFC | Futures | 4627.7 | 4651.9 | 4627.7 | 4634.4 | 17.0 |
| 2017-07-04 | MFS | Futures | 1960.4 | 1960.4 | 1949.0 | 1958.5 | 13976.0 |
| 2017-07-04 | MME | Futures | 1026.7 | 1027.7 | 1017.8 | 1027.7 | 12996.0 |
| 2017-07-04 | RM | Futures | 1852.0 | 1866.8 | 1852.0 | 1864.2 | 2924.0 |
| 2017-07-04 | RS | Futures | 523.3 | 526.0 | 518.3 | 523.0 | 14143.0 |
| 2017-07-04 | RTY | Futures | 1556.8 | 1558.8 | 1543.0 | 1556.3 | 15666.0 |
| 2017-07-04 | ZTWA | Futures | 585.3 | 587.9 | 585.3 | 587.9 | 835.0 |
> showing 34 of 34 rows — these rows as CSV