PREVIEW / futures_daily / 2016-04-19
file: by_date/futures_daily/2016/2016-04-19.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-04-19 | ES | Futures | 2238.97 | 2253.2 | 2238.43 | 2248.1 | 1565161.0 |
| 2016-04-19 | NQ | Futures | 5340.99 | 5386.82 | 5295.46 | 5318.96 | 256892.0 |
| 2016-04-19 | YM | Futures | 18591.8 | 18734.3 | 18587.7 | 18675.0 | 146276.0 |
| 2016-04-19 | CL | Futures | 49.37 | 51.08 | 48.7 | 50.59 | 711459.0 |
| 2016-04-19 | GC | Futures | 1590.4 | 1622.1 | 1584.1 | 1616.7 | 217385.0 |
| 2016-04-19 | ZN | Futures | 126.007781 | 126.007781 | 125.721125 | 125.871996 | 1017239.0 |
| 2016-04-19 | A6 | Futures | 0.78255 | 0.79024 | 0.78215 | 0.78943 | 90049.0 |
| 2016-04-19 | AD | Futures | 0.79936 | 0.80948 | 0.79916 | 0.80887 | 83210.0 |
| 2016-04-19 | ALI | Futures | 2157.07 | 2157.07 | 2157.07 | 2157.07 | 0.0 |
| 2016-04-19 | B | Futures | 35.93 | 37.06 | 35.48 | 36.67 | 355947.0 |
| 2016-04-19 | B6 | Futures | 1.5032 | 1.5186 | 1.5028 | 1.5169 | 102185.0 |
| 2016-04-19 | BR | Futures | 0.18022 | 0.18171 | 0.17973 | 0.18171 | 61.0 |
| 2016-04-19 | BZ | Futures | 35.55 | 36.69 | 35.12 | 36.3 | 43258.0 |
| 2016-04-19 | C | Futures | 2339.0 | 2348.0 | 2325.0 | 2343.0 | 2890.0 |
| 2016-04-19 | CB | Futures | 259.896 | 259.896 | 259.896 | 259.896 | 2.0 |
| 2016-04-19 | CC | Futures | 2235.0 | 2257.0 | 2232.0 | 2252.0 | 16673.0 |
| 2016-04-19 | CNH | Futures | 7.0635 | 7.0635 | 7.0447 | 7.0447 | 8.0 |
| 2016-04-19 | CSC | Futures | 3.635 | 3.651 | 3.635 | 3.646 | 29.0 |
| 2016-04-19 | CT | Futures | 71.39 | 72.48 | 70.63 | 72.0 | 6310.0 |
| 2016-04-19 | DC | Futures | 28.92 | 29.02 | 28.75 | 28.96 | 129.0 |
| 2016-04-19 | DX | Futures | 88.104 | 88.127 | 87.535 | 87.588 | 17526.0 |
| 2016-04-19 | E1 | Futures | 1.30597 | 1.31389 | 1.30497 | 1.31112 | 17318.0 |
| 2016-04-19 | E6 | Futures | 1.3217 | 1.32992 | 1.32036 | 1.3287 | 146173.0 |
| 2016-04-19 | E7 | Futures | 1.3142 | 1.3226 | 1.3132 | 1.3215 | 2316.0 |
| 2016-04-19 | EBM | Futures | 194.31 | 198.17 | 193.66 | 195.59 | 39636.0 |
| 2016-04-19 | ED | Futures | 95.7208 | 95.7256 | 95.7112 | 95.716 | 163790.0 |
| 2016-04-19 | ER | Futures | 98.254 | 98.259 | 98.254 | 98.259 | 17618.0 |
| 2016-04-19 | EW | Futures | 1549.3 | 1564.1 | 1549.3 | 1558.0 | 14944.0 |
| 2016-04-19 | FBON | Futures | 118.38 | 118.51 | 118.27 | 118.31 | 249.0 |
| 2016-04-19 | FBTP | Futures | 106.53 | 106.73 | 106.43 | 106.56 | 108650.0 |
| 2016-04-19 | FBTS | Futures | 100.997 | 101.024 | 100.988 | 100.997 | 15969.0 |
| 2016-04-19 | FCE | Futures | 3782.1 | 3832.3 | 3777.0 | 3822.9 | 94874.0 |
| 2016-04-19 | FDAX | Futures | 10973.0 | 11180.3 | 10937.0 | 11151.8 | 127194.0 |
| 2016-04-19 | FDXM | Futures | 10560.9 | 10764.7 | 10532.0 | 10737.8 | 19861.0 |
| 2016-04-19 | FESX | Futures | 2347.0 | 2379.0 | 2343.1 | 2372.7 | 1365821.0 |
| 2016-04-19 | FEU3 | Futures | 98.912 | 98.912 | 98.912 | 98.912 | 137.0 |
| 2016-04-19 | FGBL | Futures | 146.15 | 146.33 | 145.87 | 146.0 | 657960.0 |
| 2016-04-19 | FGBM | Futures | 127.61 | 127.67 | 127.55 | 127.61 | 368865.0 |
| 2016-04-19 | FGBS | Futures | 111.668 | 111.678 | 111.663 | 111.668 | 108848.0 |
| 2016-04-19 | FGBX | Futures | 173.35 | 173.58 | 172.28 | 172.5 | 37851.0 |
| 2016-04-19 | FMWO | Futures | 5741.0 | 5759.6 | 5741.0 | 5750.9 | 182.0 |
| 2016-04-19 | FTDX | Futures | 1580.4 | 1601.4 | 1577.6 | 1596.6 | 221.0 |
| 2016-04-19 | FTI | Futures | 402.81 | 406.74 | 402.13 | 406.28 | 30476.0 |
| 2016-04-19 | FTUK | Futures | 5200.4 | 5256.9 | 5192.6 | 5246.2 | 117800.0 |
| 2016-04-19 | FVSA | Futures | 2466.04 | 2466.04 | 2376.84 | 2376.84 | 24923.0 |
| 2016-04-19 | FXXP | Futures | 273.8 | 276.9 | 273.6 | 276.6 | 41274.0 |
| 2016-04-19 | G | Futures | 108.2 | 108.2 | 107.78 | 107.84 | 174294.0 |
| 2016-04-19 | GF | Futures | 290.835 | 295.23 | 288.638 | 291.185 | 4578.0 |
| 2016-04-19 | GSCI | Futures | 497.86 | 504.54 | 497.86 | 503.66 | 181.0 |
| 2016-04-19 | HE | Futures | 96.354 | 98.409 | 96.322 | 97.863 | 403.0 |
> showing 50 of 108 rows — these rows as CSV