PREVIEW / futures_daily / 2016-07-11
file: by_date/futures_daily/2016/2016-07-11.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-07-11 | ES | Futures | 2289.21 | 2307.03 | 2288.94 | 2300.01 | 1467322.0 |
| 2016-07-11 | NQ | Futures | 5327.29 | 5379.16 | 5322.87 | 5362.66 | 182422.0 |
| 2016-07-11 | YM | Futures | 18847.3 | 19007.1 | 18835.8 | 18954.9 | 133935.0 |
| 2016-07-11 | CL | Futures | 52.35 | 53.17 | 51.6 | 51.99 | 533657.0 |
| 2016-07-11 | GC | Futures | 1761.1 | 1770.9 | 1739.1 | 1745.3 | 230696.0 |
| 2016-07-11 | ZN | Futures | 129.28237 | 129.312552 | 128.588196 | 128.603287 | 932748.0 |
| 2016-07-11 | A6 | Futures | 0.76765 | 0.76887 | 0.76337 | 0.7647 | 74308.0 |
| 2016-07-11 | AD | Futures | 0.78441 | 0.78539 | 0.77884 | 0.77935 | 70964.0 |
| 2016-07-11 | ALI | Futures | 2148.42 | 2151.59 | 2148.42 | 2151.59 | 6.0 |
| 2016-07-11 | B | Futures | 37.12 | 37.6 | 36.64 | 36.92 | 229276.0 |
| 2016-07-11 | B6 | Futures | 1.3656 | 1.3735 | 1.3557 | 1.372 | 126264.0 |
| 2016-07-11 | BR | Futures | 0.19704 | 0.19914 | 0.19704 | 0.19824 | 22.0 |
| 2016-07-11 | BZ | Futures | 37.01 | 37.47 | 36.52 | 36.79 | 20339.0 |
| 2016-07-11 | C | Futures | 2663.0 | 2681.0 | 2652.0 | 2659.0 | 11763.0 |
| 2016-07-11 | CB | Futures | 278.311 | 278.311 | 275.498 | 275.527 | 6.0 |
| 2016-07-11 | CC | Futures | 2273.0 | 2296.0 | 2268.0 | 2274.0 | 14509.0 |
| 2016-07-11 | CNH | Futures | 7.2698 | 7.2755 | 7.2698 | 7.2755 | 4.0 |
| 2016-07-11 | CSC | Futures | 3.57 | 3.57 | 3.551 | 3.559 | 8.0 |
| 2016-07-11 | CT | Futures | 75.18 | 77.2 | 75.18 | 77.19 | 71.0 |
| 2016-07-11 | DC | Futures | 28.83 | 28.92 | 28.47 | 28.58 | 82.0 |
| 2016-07-11 | DX | Futures | 89.611 | 90.034 | 89.551 | 89.834 | 11606.0 |
| 2016-07-11 | E1 | Futures | 1.27892 | 1.2803 | 1.27504 | 1.2788 | 13013.0 |
| 2016-07-11 | E6 | Futures | 1.28986 | 1.29265 | 1.28561 | 1.2905 | 98509.0 |
| 2016-07-11 | E7 | Futures | 1.2761 | 1.2856 | 1.2761 | 1.2836 | 1480.0 |
| 2016-07-11 | EBM | Futures | 192.46 | 195.17 | 192.16 | 193.66 | 19024.0 |
| 2016-07-11 | ED | Futures | 95.8052 | 95.8052 | 95.7859 | 95.7907 | 147011.0 |
| 2016-07-11 | ER | Futures | 98.332 | 98.337 | 98.328 | 98.328 | 16363.0 |
| 2016-07-11 | EW | Futures | 1607.4 | 1621.3 | 1606.0 | 1617.0 | 13643.0 |
| 2016-07-11 | FBON | Futures | 122.79 | 122.79 | 122.54 | 122.57 | 29.0 |
| 2016-07-11 | FBTP | Futures | 109.87 | 109.87 | 109.52 | 109.59 | 54971.0 |
| 2016-07-11 | FBTS | Futures | 101.293 | 101.311 | 101.275 | 101.284 | 14924.0 |
| 2016-07-11 | FCE | Futures | 3675.3 | 3722.3 | 3664.8 | 3715.8 | 132987.0 |
| 2016-07-11 | FDAX | Futures | 10334.9 | 10464.7 | 10296.1 | 10452.5 | 93715.0 |
| 2016-07-11 | FDXM | Futures | 10072.7 | 10201.4 | 10036.4 | 10188.4 | 25043.0 |
| 2016-07-11 | FESX | Futures | 2235.1 | 2258.6 | 2221.0 | 2253.9 | 1128974.0 |
| 2016-07-11 | FEU3 | Futures | 98.986 | 98.986 | 98.981 | 98.981 | 12.0 |
| 2016-07-11 | FGBL | Futures | 151.03 | 151.21 | 150.66 | 150.79 | 412674.0 |
| 2016-07-11 | FGBM | Futures | 129.24 | 129.33 | 129.18 | 129.22 | 303633.0 |
| 2016-07-11 | FGBS | Futures | 112.017 | 112.037 | 112.002 | 112.012 | 178248.0 |
| 2016-07-11 | FGBX | Futures | 191.18 | 192.26 | 190.11 | 190.56 | 23612.0 |
| 2016-07-11 | FMWO | Futures | 5582.3 | 5612.7 | 5572.6 | 5609.0 | 692.0 |
| 2016-07-11 | FOAT | Futures | 138.99 | 139.07 | 138.65 | 138.71 | 78091.0 |
| 2016-07-11 | FTDX | Futures | 1562.3 | 1579.7 | 1559.9 | 1574.9 | 306.0 |
| 2016-07-11 | FTI | Futures | 390.35 | 393.5 | 388.29 | 393.19 | 6710.0 |
| 2016-07-11 | FTUK | Futures | 5466.8 | 5542.7 | 5455.9 | 5531.4 | 126410.0 |
| 2016-07-11 | FVSA | Futures | 2497.95 | 2508.06 | 2361.42 | 2381.64 | 14979.0 |
| 2016-07-11 | FXXP | Futures | 265.7 | 268.4 | 263.9 | 268.2 | 29838.0 |
| 2016-07-11 | G | Futures | 115.4 | 115.67 | 115.08 | 115.19 | 133425.0 |
| 2016-07-11 | GF | Futures | 285.197 | 286.096 | 277.46 | 278.458 | 5913.0 |
| 2016-07-11 | GSCI | Futures | 518.47 | 518.47 | 512.3 | 512.3 | 1721.0 |
> showing 50 of 108 rows — these rows as CSV