PREVIEW / futures_daily / 2016-01-08
file: by_date/futures_daily/2016/2016-01-08.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-01-08 | ES | Futures | 2068.45 | 2098.62 | 2040.14 | 2041.74 | 2694404.0 |
| 2016-01-08 | NQ | Futures | 5038.58 | 5122.98 | 4989.05 | 4995.79 | 480513.0 |
| 2016-01-08 | YM | Futures | 17018.3 | 17246.0 | 16773.1 | 16800.0 | 301344.0 |
| 2016-01-08 | CL | Futures | 49.53 | 51.07 | 48.55 | 49.32 | 596496.0 |
| 2016-01-08 | GC | Futures | 1430.0 | 1435.6 | 1408.1 | 1415.9 | 193452.0 |
| 2016-01-08 | ZN | Futures | 122.393292 | 122.799414 | 121.851795 | 122.648999 | 1657147.0 |
| 2016-01-08 | A6 | Futures | 0.70099 | 0.70711 | 0.69428 | 0.69769 | 136190.0 |
| 2016-01-08 | AD | Futures | 0.72421 | 0.72728 | 0.72104 | 0.72329 | 67043.0 |
| 2016-01-08 | ALI | Futures | 2107.88 | 2107.88 | 2107.88 | 2107.88 | 0.0 |
| 2016-01-08 | B | Futures | 29.6 | 30.21 | 28.58 | 29.24 | 243815.0 |
| 2016-01-08 | B6 | Futures | 1.539 | 1.541 | 1.5262 | 1.5274 | 98018.0 |
| 2016-01-08 | BFX | Futures | 4335.3 | 4339.5 | 4245.4 | 4245.4 | 15.0 |
| 2016-01-08 | BR | Futures | 0.15403 | 0.15403 | 0.15337 | 0.15337 | 2.0 |
| 2016-01-08 | BZ | Futures | 29.2 | 29.9 | 28.3 | 28.93 | 24303.0 |
| 2016-01-08 | C | Futures | 2222.0 | 2271.0 | 2222.0 | 2268.0 | 17576.0 |
| 2016-01-08 | CB | Futures | 254.844 | 256.081 | 254.844 | 255.772 | 15.0 |
| 2016-01-08 | CC | Futures | 2201.0 | 2230.0 | 2193.0 | 2224.0 | 20972.0 |
| 2016-01-08 | CNH | Futures | 7.4147 | 7.4228 | 7.4147 | 7.4181 | 19.0 |
| 2016-01-08 | CSC | Futures | 3.694 | 3.755 | 3.694 | 3.753 | 54.0 |
| 2016-01-08 | CT | Futures | 72.06 | 72.51 | 71.82 | 71.92 | 18090.0 |
| 2016-01-08 | DC | Futures | 29.1 | 29.72 | 29.08 | 29.7 | 186.0 |
| 2016-01-08 | DX | Futures | 91.939 | 92.756 | 91.897 | 92.106 | 40217.0 |
| 2016-01-08 | E1 | Futures | 1.27372 | 1.27397 | 1.2587 | 1.27132 | 21451.0 |
| 2016-01-08 | E6 | Futures | 1.27935 | 1.2804 | 1.26426 | 1.27689 | 291114.0 |
| 2016-01-08 | E7 | Futures | 1.2723 | 1.273 | 1.2574 | 1.2697 | 7401.0 |
| 2016-01-08 | EBM | Futures | 241.19 | 242.6 | 240.83 | 242.25 | 15866.0 |
| 2016-01-08 | ED | Futures | 95.5976 | 95.5976 | 95.5639 | 95.5832 | 433298.0 |
| 2016-01-08 | ER | Futures | 98.234 | 98.239 | 98.234 | 98.239 | 22250.0 |
| 2016-01-08 | EW | Futures | 1391.7 | 1411.6 | 1373.6 | 1375.3 | 28147.0 |
| 2016-01-08 | FBON | Futures | 115.77 | 116.04 | 115.77 | 115.88 | 216.0 |
| 2016-01-08 | FBTP | Futures | 105.21 | 105.5 | 105.11 | 105.34 | 69965.0 |
| 2016-01-08 | FBTS | Futures | 100.828 | 100.917 | 100.828 | 100.873 | 17476.0 |
| 2016-01-08 | FCE | Futures | 3674.0 | 3710.4 | 3591.2 | 3623.4 | 128237.0 |
| 2016-01-08 | FDAX | Futures | 10815.0 | 10979.8 | 10543.3 | 10691.4 | 131186.0 |
| 2016-01-08 | FDXM | Futures | 10335.0 | 10496.7 | 10089.3 | 10224.1 | 31801.0 |
| 2016-01-08 | FESX | Futures | 2335.8 | 2363.2 | 2276.5 | 2303.1 | 1581057.0 |
| 2016-01-08 | FGBL | Futures | 140.41 | 140.89 | 140.2 | 140.72 | 549423.0 |
| 2016-01-08 | FGBM | Futures | 125.9 | 126.07 | 125.84 | 125.99 | 376207.0 |
| 2016-01-08 | FGBS | Futures | 111.518 | 111.543 | 111.503 | 111.528 | 211353.0 |
| 2016-01-08 | FGBX | Futures | 157.08 | 158.52 | 156.72 | 158.01 | 23713.0 |
| 2016-01-08 | FMWO | Futures | 5371.3 | 5371.3 | 5270.5 | 5281.7 | 2443.0 |
| 2016-01-08 | FOAT | Futures | 128.34 | 128.77 | 128.14 | 128.64 | 70803.0 |
| 2016-01-08 | FTDX | Futures | 1678.2 | 1688.8 | 1648.9 | 1658.0 | 539.0 |
| 2016-01-08 | FTI | Futures | 366.14 | 370.25 | 356.05 | 358.8 | 44389.0 |
| 2016-01-08 | FTUK | Futures | 4768.8 | 4861.3 | 4751.2 | 4790.0 | 145468.0 |
| 2016-01-08 | FVSA | Futures | 2611.5 | 2823.25 | 2522.1 | 2700.91 | 18633.0 |
| 2016-01-08 | FXXP | Futures | 270.8 | 274.1 | 265.4 | 267.7 | 35890.0 |
| 2016-01-08 | G | Futures | 105.3 | 105.73 | 105.09 | 105.56 | 181792.0 |
| 2016-01-08 | GF | Futures | 314.731 | 319.557 | 306.334 | 307.734 | 2983.0 |
| 2016-01-08 | GSCI | Futures | 462.32 | 464.99 | 459.11 | 462.24 | 1904.0 |
> showing 50 of 108 rows — these rows as CSV