PREVIEW / futures_daily / 2016-08-01
file: by_date/futures_daily/2016/2016-08-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-08-01 | ES | Futures | 2347.25 | 2351.3 | 2331.86 | 2336.99 | 1659094.0 |
| 2016-08-01 | NQ | Futures | 5584.26 | 5611.08 | 5564.81 | 5592.51 | 199516.0 |
| 2016-08-01 | YM | Futures | 19228.5 | 19270.3 | 19092.7 | 19141.8 | 129503.0 |
| 2016-08-01 | CL | Futures | 46.87 | 47.47 | 45.14 | 45.41 | 533020.0 |
| 2016-08-01 | GC | Futures | 1741.3 | 1747.3 | 1736.2 | 1744.4 | 112655.0 |
| 2016-08-01 | ZN | Futures | 128.573106 | 128.573106 | 128.029839 | 128.2562 | 1025550.0 |
| 2016-08-01 | A6 | Futures | 0.77162 | 0.77365 | 0.7647 | 0.76846 | 71349.0 |
| 2016-08-01 | AD | Futures | 0.78493 | 0.78574 | 0.77971 | 0.78145 | 40005.0 |
| 2016-08-01 | ALI | Futures | 2131.15 | 2131.15 | 2131.15 | 2131.15 | 0.0 |
| 2016-08-01 | B | Futures | 34.07 | 34.66 | 33.09 | 33.31 | 234773.0 |
| 2016-08-01 | B6 | Futures | 1.3965 | 1.4002 | 1.3886 | 1.3916 | 60969.0 |
| 2016-08-01 | BFX | Futures | 3943.5 | 3943.5 | 3942.9 | 3942.9 | 4.0 |
| 2016-08-01 | BR | Futures | 0.20263 | 0.20296 | 0.20123 | 0.20163 | 1294.0 |
| 2016-08-01 | BZ | Futures | 34.0 | 34.47 | 32.93 | 33.14 | 21767.0 |
| 2016-08-01 | C | Futures | 2450.0 | 2521.0 | 2437.0 | 2509.0 | 17788.0 |
| 2016-08-01 | CB | Futures | 257.885 | 263.746 | 257.885 | 263.746 | 30.0 |
| 2016-08-01 | CC | Futures | 2069.0 | 2164.0 | 2066.0 | 2145.0 | 33639.0 |
| 2016-08-01 | CNH | Futures | 7.1896 | 7.2003 | 7.1896 | 7.1971 | 3.0 |
| 2016-08-01 | CSC | Futures | 3.779 | 3.815 | 3.779 | 3.796 | 22.0 |
| 2016-08-01 | CT | Futures | 84.01 | 84.86 | 83.8 | 84.02 | 72.0 |
| 2016-08-01 | DC | Futures | 30.2 | 30.45 | 30.2 | 30.42 | 105.0 |
| 2016-08-01 | DX | Futures | 88.811 | 89.072 | 88.783 | 88.985 | 11369.0 |
| 2016-08-01 | E1 | Futures | 1.29545 | 1.29908 | 1.29382 | 1.29746 | 16623.0 |
| 2016-08-01 | E6 | Futures | 1.30453 | 1.30459 | 1.30121 | 1.30284 | 99659.0 |
| 2016-08-01 | E7 | Futures | 1.2972 | 1.2976 | 1.2943 | 1.2959 | 1057.0 |
| 2016-08-01 | EBM | Futures | 199.68 | 202.69 | 198.48 | 200.88 | 8561.0 |
| 2016-08-01 | ED | Futures | 95.7087 | 95.7136 | 95.6894 | 95.6991 | 214295.0 |
| 2016-08-01 | ER | Futures | 98.308 | 98.313 | 98.308 | 98.313 | 22905.0 |
| 2016-08-01 | EW | Futures | 1656.3 | 1659.4 | 1642.4 | 1645.7 | 13292.0 |
| 2016-08-01 | FBON | Futures | 123.92 | 124.1 | 123.91 | 123.91 | 397.0 |
| 2016-08-01 | FBTP | Futures | 110.12 | 110.26 | 109.82 | 110.0 | 68001.0 |
| 2016-08-01 | FBTS | Futures | 101.275 | 101.302 | 101.275 | 101.284 | 19099.0 |
| 2016-08-01 | FCE | Futures | 3895.6 | 3895.6 | 3827.1 | 3848.1 | 51365.0 |
| 2016-08-01 | FDAX | Futures | 11103.2 | 11143.7 | 10929.8 | 10999.5 | 79025.0 |
| 2016-08-01 | FDXM | Futures | 10819.6 | 10860.0 | 10653.6 | 10721.5 | 20752.0 |
| 2016-08-01 | FESX | Futures | 2366.6 | 2372.9 | 2308.7 | 2323.6 | 817389.0 |
| 2016-08-01 | FGBL | Futures | 151.02 | 151.03 | 150.6 | 150.67 | 365278.0 |
| 2016-08-01 | FGBM | Futures | 128.98 | 129.0 | 128.85 | 128.88 | 288142.0 |
| 2016-08-01 | FGBS | Futures | 111.887 | 111.887 | 111.852 | 111.857 | 142654.0 |
| 2016-08-01 | FGBX | Futures | 192.22 | 192.24 | 190.83 | 191.16 | 22871.0 |
| 2016-08-01 | FMWO | Futures | 5762.3 | 5764.7 | 5731.9 | 5740.4 | 371.0 |
| 2016-08-01 | FOAT | Futures | 139.02 | 139.06 | 138.63 | 138.67 | 60120.0 |
| 2016-08-01 | FTDX | Futures | 1662.6 | 1674.6 | 1651.5 | 1660.2 | 174.0 |
| 2016-08-01 | FTI | Futures | 405.64 | 406.45 | 395.26 | 397.19 | 19116.0 |
| 2016-08-01 | FTUK | Futures | 5579.4 | 5603.6 | 5516.4 | 5546.4 | 100392.0 |
| 2016-08-01 | FVSA | Futures | 2122.98 | 2205.95 | 2098.58 | 2166.91 | 8648.0 |
| 2016-08-01 | FXXP | Futures | 278.8 | 279.3 | 272.4 | 274.2 | 24950.0 |
| 2016-08-01 | G | Futures | 115.81 | 115.85 | 115.35 | 115.42 | 140334.0 |
| 2016-08-01 | GF | Futures | 281.503 | 288.642 | 281.503 | 288.642 | 3363.0 |
| 2016-08-01 | GSCI | Futures | 483.17 | 483.17 | 476.56 | 476.92 | 64.0 |
> showing 50 of 108 rows — these rows as CSV