PREVIEW / futures_daily / 2016-05-19
file: by_date/futures_daily/2016/2016-05-19.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-05-19 | ES | Futures | 2194.14 | 2195.48 | 2171.06 | 2189.04 | 2055973.0 |
| 2016-05-19 | NQ | Futures | 5096.89 | 5100.41 | 5029.91 | 5072.8 | 272694.0 |
| 2016-05-19 | YM | Futures | 18186.3 | 18197.7 | 17984.6 | 18107.3 | 189903.0 |
| 2016-05-19 | CL | Futures | 56.8 | 57.18 | 55.4 | 57.05 | 620753.0 |
| 2016-05-19 | GC | Futures | 1622.9 | 1627.0 | 1604.2 | 1617.3 | 270061.0 |
| 2016-05-19 | ZN | Futures | 125.087465 | 125.313772 | 124.861158 | 125.208162 | 1641077.0 |
| 2016-05-19 | A6 | Futures | 0.73043 | 0.73235 | 0.72557 | 0.73023 | 116003.0 |
| 2016-05-19 | AD | Futures | 0.78474 | 0.78586 | 0.77727 | 0.78075 | 82754.0 |
| 2016-05-19 | ALI | Futures | 2086.58 | 2086.58 | 2082.4 | 2082.4 | 3.0 |
| 2016-05-19 | B | Futures | 40.4 | 40.57 | 39.33 | 40.52 | 302095.0 |
| 2016-05-19 | B6 | Futures | 1.5376 | 1.5442 | 1.5335 | 1.5392 | 97890.0 |
| 2016-05-19 | BFX | Futures | 3949.0 | 3949.0 | 3920.8 | 3920.8 | 8.0 |
| 2016-05-19 | BR | Futures | 0.18282 | 0.18282 | 0.17944 | 0.18123 | 2359.0 |
| 2016-05-19 | BZ | Futures | 40.17 | 40.43 | 39.21 | 40.38 | 33279.0 |
| 2016-05-19 | C | Futures | 2243.0 | 2249.0 | 2215.0 | 2217.0 | 12835.0 |
| 2016-05-19 | CB | Futures | 254.561 | 254.866 | 254.561 | 254.866 | 4.0 |
| 2016-05-19 | CC | Futures | 2137.0 | 2151.0 | 2110.0 | 2116.0 | 20096.0 |
| 2016-05-19 | CNH | Futures | 7.1431 | 7.1457 | 7.1353 | 7.1397 | 14.0 |
| 2016-05-19 | CSC | Futures | 3.257 | 3.262 | 3.243 | 3.246 | 107.0 |
| 2016-05-19 | CT | Futures | 70.64 | 70.7 | 68.93 | 69.47 | 18892.0 |
| 2016-05-19 | DC | Futures | 25.63 | 25.63 | 25.3 | 25.41 | 248.0 |
| 2016-05-19 | DX | Futures | 88.747 | 89.045 | 88.686 | 88.844 | 22694.0 |
| 2016-05-19 | E1 | Futures | 1.27268 | 1.27506 | 1.2674 | 1.26991 | 23340.0 |
| 2016-05-19 | E6 | Futures | 1.30922 | 1.31051 | 1.30467 | 1.30712 | 165548.0 |
| 2016-05-19 | E7 | Futures | 1.3022 | 1.3035 | 1.2976 | 1.3 | 3106.0 |
| 2016-05-19 | EBM | Futures | 196.07 | 196.37 | 193.06 | 194.27 | 17097.0 |
| 2016-05-19 | ED | Futures | 95.6871 | 95.6919 | 95.6678 | 95.6822 | 489039.0 |
| 2016-05-19 | ER | Futures | 98.259 | 98.264 | 98.259 | 98.259 | 23252.0 |
| 2016-05-19 | EW | Futures | 1514.5 | 1517.0 | 1497.6 | 1512.1 | 20276.0 |
| 2016-05-19 | FBON | Futures | 117.82 | 118.14 | 117.72 | 118.07 | 384.0 |
| 2016-05-19 | FBTP | Futures | 106.03 | 106.24 | 105.88 | 106.1 | 108988.0 |
| 2016-05-19 | FBTS | Futures | 101.078 | 101.087 | 101.069 | 101.078 | 18387.0 |
| 2016-05-19 | FCE | Futures | 3653.3 | 3672.2 | 3636.9 | 3644.6 | 93600.0 |
| 2016-05-19 | FDAX | Futures | 10612.0 | 10642.1 | 10490.7 | 10521.3 | 121018.0 |
| 2016-05-19 | FDXM | Futures | 10231.0 | 10246.5 | 10102.7 | 10129.6 | 22242.0 |
| 2016-05-19 | FESX | Futures | 2271.3 | 2281.5 | 2254.2 | 2258.9 | 1626191.0 |
| 2016-05-19 | FEU3 | Futures | 98.912 | 98.912 | 98.912 | 98.912 | 11.0 |
| 2016-05-19 | FGBL | Futures | 145.98 | 146.42 | 145.84 | 146.34 | 743616.0 |
| 2016-05-19 | FGBM | Futures | 127.55 | 127.65 | 127.52 | 127.62 | 629886.0 |
| 2016-05-19 | FGBS | Futures | 111.648 | 111.658 | 111.643 | 111.648 | 223082.0 |
| 2016-05-19 | FGBX | Futures | 171.76 | 173.12 | 171.19 | 172.9 | 35035.0 |
| 2016-05-19 | FMWO | Futures | 5537.0 | 5551.9 | 5515.9 | 5517.1 | 96.0 |
| 2016-05-19 | FOAT | Futures | 133.51 | 134.03 | 133.38 | 133.93 | 97187.0 |
| 2016-05-19 | FTDX | Futures | 1575.2 | 1577.6 | 1562.3 | 1571.4 | 233.0 |
| 2016-05-19 | FTI | Futures | 386.42 | 387.59 | 382.83 | 383.86 | 19803.0 |
| 2016-05-19 | FTUK | Futures | 5044.0 | 5051.9 | 4978.8 | 4988.3 | 147118.0 |
| 2016-05-19 | FVSA | Futures | 2573.85 | 2597.12 | 2518.0 | 2583.16 | 9221.0 |
| 2016-05-19 | FXXP | Futures | 268.8 | 269.5 | 266.6 | 267.0 | 25480.0 |
| 2016-05-19 | G | Futures | 108.29 | 108.67 | 108.15 | 108.63 | 206489.0 |
| 2016-05-19 | GF | Futures | 296.08 | 297.328 | 290.589 | 295.731 | 4764.0 |
> showing 50 of 110 rows — these rows as CSV