PREVIEW / futures_daily / 2016-08-08
file: by_date/futures_daily/2016/2016-08-08.parquet size: 9 KB rows: 110
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-08 | ES | Futures | 2349.41 | 2356.96 | 2346.44 | 2348.87 | 970557.0 |
| 2016-08-08 | NQ | Futures | 5639.95 | 5658.81 | 5618.15 | 5633.47 | 132186.0 |
| 2016-08-08 | YM | Futures | 19279.7 | 19331.9 | 19256.7 | 19281.8 | 84638.0 |
| 2016-08-08 | CL | Futures | 47.59 | 49.18 | 47.39 | 48.76 | 562530.0 |
| 2016-08-08 | GC | Futures | 1720.8 | 1724.2 | 1713.2 | 1720.9 | 137539.0 |
| 2016-08-08 | ZN | Futures | 127.531844 | 127.682752 | 127.290393 | 127.531844 | 978792.0 |
| 2016-08-08 | A6 | Futures | 0.77304 | 0.77975 | 0.77202 | 0.77772 | 60560.0 |
| 2016-08-08 | AD | Futures | 0.77623 | 0.77925 | 0.77587 | 0.77735 | 50281.0 |
| 2016-08-08 | ALI | Futures | 2140.7 | 2148.34 | 2140.06 | 2140.06 | 12.0 |
| 2016-08-08 | B | Futures | 35.05 | 36.13 | 34.97 | 35.88 | 221513.0 |
| 2016-08-08 | B6 | Futures | 1.3793 | 1.3815 | 1.3743 | 1.3754 | 47943.0 |
| 2016-08-08 | BFX | Futures | 3992.5 | 3994.2 | 3992.5 | 3994.2 | 1.0 |
| 2016-08-08 | BR | Futures | 0.20872 | 0.20909 | 0.20712 | 0.20842 | 2958.0 |
| 2016-08-08 | BZ | Futures | 34.91 | 35.95 | 34.79 | 35.7 | 19192.0 |
| 2016-08-08 | C | Futures | 2571.0 | 2584.0 | 2557.0 | 2560.0 | 9037.0 |
| 2016-08-08 | CB | Futures | 273.241 | 273.417 | 272.538 | 273.417 | 36.0 |
| 2016-08-08 | CC | Futures | 2199.0 | 2220.0 | 2194.0 | 2200.0 | 25467.0 |
| 2016-08-08 | CNH | Futures | 7.2212 | 7.2212 | 7.2194 | 7.2194 | 1.0 |
| 2016-08-08 | CSC | Futures | 3.868 | 3.898 | 3.866 | 3.872 | 74.0 |
| 2016-08-08 | CT | Futures | 87.24 | 87.34 | 86.08 | 86.16 | 28.0 |
| 2016-08-08 | DC | Futures | 30.94 | 31.21 | 30.85 | 31.01 | 245.0 |
| 2016-08-08 | DX | Futures | 89.462 | 89.676 | 89.369 | 89.602 | 6382.0 |
| 2016-08-08 | E1 | Futures | 1.28043 | 1.28193 | 1.27504 | 1.27642 | 9881.0 |
| 2016-08-08 | E6 | Futures | 1.29265 | 1.29498 | 1.29114 | 1.29231 | 70983.0 |
| 2016-08-08 | E7 | Futures | 1.2853 | 1.288 | 1.2843 | 1.2855 | 1019.0 |
| 2016-08-08 | EBM | Futures | 201.78 | 202.08 | 198.78 | 199.08 | 7353.0 |
| 2016-08-08 | ED | Futures | 95.6267 | 95.6316 | 95.6123 | 95.6171 | 274322.0 |
| 2016-08-08 | ER | Futures | 98.308 | 98.313 | 98.308 | 98.308 | 16339.0 |
| 2016-08-08 | EW | Futures | 1650.1 | 1659.6 | 1650.1 | 1654.1 | 11463.0 |
| 2016-08-08 | FBON | Futures | 124.26 | 124.26 | 124.19 | 124.19 | 1.0 |
| 2016-08-08 | FBTP | Futures | 110.25 | 110.56 | 110.14 | 110.44 | 57484.0 |
| 2016-08-08 | FBTS | Futures | 101.329 | 101.338 | 101.311 | 101.329 | 20323.0 |
| 2016-08-08 | FCE | Futures | 3862.0 | 3877.3 | 3845.9 | 3854.2 | 51710.0 |
| 2016-08-08 | FDAX | Futures | 11096.3 | 11151.1 | 11063.3 | 11102.7 | 61894.0 |
| 2016-08-08 | FDXM | Futures | 10813.3 | 10866.2 | 10784.3 | 10822.2 | 15929.0 |
| 2016-08-08 | FESX | Futures | 2338.4 | 2348.6 | 2329.8 | 2336.9 | 644343.0 |
| 2016-08-08 | FEU3 | Futures | 98.966 | 98.966 | 98.966 | 98.966 | 19.0 |
| 2016-08-08 | FGBL | Futures | 150.25 | 150.48 | 150.05 | 150.36 | 393233.0 |
| 2016-08-08 | FGBM | Futures | 128.84 | 128.94 | 128.78 | 128.91 | 274742.0 |
| 2016-08-08 | FGBS | Futures | 111.862 | 111.887 | 111.847 | 111.877 | 145111.0 |
| 2016-08-08 | FGBX | Futures | 188.14 | 188.53 | 187.03 | 187.95 | 18390.0 |
| 2016-08-08 | FMWO | Futures | 5741.6 | 5751.3 | 5741.6 | 5747.7 | 217.0 |
| 2016-08-08 | FOAT | Futures | 138.24 | 138.47 | 138.03 | 138.35 | 59365.0 |
| 2016-08-08 | FTDX | Futures | 1651.0 | 1652.0 | 1638.5 | 1642.3 | 61.0 |
| 2016-08-08 | FTI | Futures | 402.72 | 403.58 | 401.37 | 402.41 | 17076.0 |
| 2016-08-08 | FTUK | Futures | 5629.9 | 5659.5 | 5618.2 | 5642.8 | 73008.0 |
| 2016-08-08 | FVSA | Futures | 2025.37 | 2025.37 | 1937.53 | 1961.93 | 12196.0 |
| 2016-08-08 | FXXP | Futures | 276.8 | 277.1 | 275.2 | 275.8 | 12933.0 |
| 2016-08-08 | G | Futures | 115.95 | 116.71 | 115.9 | 116.6 | 182447.0 |
| 2016-08-08 | GF | Futures | 299.325 | 301.222 | 296.729 | 297.777 | 2570.0 |
> showing 50 of 110 rows — these rows as CSV