PREVIEW / futures_daily / 2016-12-08
file: by_date/futures_daily/2016/2016-12-08.parquet size: 10 KB rows: 111
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-12-08 | ES | Futures | 2418.99 | 2435.21 | 2414.66 | 2431.16 | 2109978.0 |
| 2016-12-08 | NQ | Futures | 5709.48 | 5738.94 | 5699.46 | 5731.28 | 225777.0 |
| 2016-12-08 | YM | Futures | 20499.0 | 20649.2 | 20469.6 | 20603.0 | 192372.0 |
| 2016-12-08 | CL | Futures | 53.82 | 55.01 | 53.53 | 54.86 | 780062.0 |
| 2016-12-08 | GC | Futures | 1510.3 | 1516.3 | 1503.7 | 1505.6 | 147750.0 |
| 2016-12-08 | ZN | Futures | 122.134004 | 122.134004 | 121.476876 | 121.797799 | 1379057.0 |
| 2016-12-08 | A6 | Futures | 0.76316 | 0.76601 | 0.75785 | 0.76101 | 105448.0 |
| 2016-12-08 | AD | Futures | 0.77427 | 0.77704 | 0.77315 | 0.77663 | 66835.0 |
| 2016-12-08 | ALI | Futures | 2339.94 | 2360.15 | 2339.94 | 2347.32 | 25.0 |
| 2016-12-08 | B | Futures | 39.6 | 40.27 | 39.34 | 40.15 | 334183.0 |
| 2016-12-08 | B6 | Futures | 1.3299 | 1.3379 | 1.3212 | 1.3255 | 135041.0 |
| 2016-12-08 | BFX | Futures | 4213.4 | 4248.6 | 4213.4 | 4246.8 | 5.0 |
| 2016-12-08 | BR | Futures | 0.20487 | 0.20548 | 0.20249 | 0.20548 | 91.0 |
| 2016-12-08 | BZ | Futures | 39.23 | 39.97 | 39.07 | 39.85 | 44044.0 |
| 2016-12-08 | C | Futures | 1937.0 | 1939.0 | 1888.0 | 1891.0 | 4430.0 |
| 2016-12-08 | CB | Futures | 257.542 | 257.542 | 254.49 | 254.826 | 44.0 |
| 2016-12-08 | CC | Futures | 1781.0 | 1787.0 | 1707.0 | 1730.0 | 20873.0 |
| 2016-12-08 | CNH | Futures | 7.4093 | 7.4263 | 7.4038 | 7.4258 | 265.0 |
| 2016-12-08 | CSC | Futures | 3.983 | 3.983 | 3.946 | 3.979 | 64.0 |
| 2016-12-08 | CT | Futures | 81.62 | 82.65 | 81.45 | 82.04 | 15883.0 |
| 2016-12-08 | DC | Futures | 32.08 | 32.21 | 31.85 | 32.02 | 129.0 |
| 2016-12-08 | DX | Futures | 93.295 | 94.259 | 92.597 | 94.119 | 75792.0 |
| 2016-12-08 | E1 | Futures | 1.23833 | 1.24406 | 1.2245 | 1.22637 | 42350.0 |
| 2016-12-08 | E6 | Futures | 1.24757 | 1.26101 | 1.2289 | 1.23076 | 356309.0 |
| 2016-12-08 | E7 | Futures | 1.2408 | 1.2542 | 1.2222 | 1.2241 | 8599.0 |
| 2016-12-08 | EBM | Futures | 187.15 | 188.86 | 187.15 | 187.44 | 22572.0 |
| 2016-12-08 | ED | Futures | 95.5862 | 95.5935 | 95.5862 | 95.5911 | 276077.0 |
| 2016-12-08 | ER | Futures | 98.279 | 98.288 | 98.279 | 98.288 | 64810.0 |
| 2016-12-08 | EW | Futures | 1782.3 | 1807.9 | 1781.9 | 1804.7 | 44059.0 |
| 2016-12-08 | FBON | Futures | 121.74 | 121.78 | 120.57 | 120.87 | 395.0 |
| 2016-12-08 | FBTP | Futures | 105.88 | 105.91 | 104.56 | 104.82 | 158689.0 |
| 2016-12-08 | FBTS | Futures | 101.196 | 101.403 | 101.079 | 101.286 | 38218.0 |
| 2016-12-08 | FCE | Futures | 4169.1 | 4198.3 | 4136.0 | 4180.6 | 149792.0 |
| 2016-12-08 | FDAX | Futures | 11651.7 | 11841.9 | 11603.1 | 11819.2 | 124092.0 |
| 2016-12-08 | FDXM | Futures | 11626.5 | 11815.3 | 11580.1 | 11793.6 | 34691.0 |
| 2016-12-08 | FESX | Futures | 2526.3 | 2560.7 | 2512.7 | 2553.5 | 2343282.0 |
| 2016-12-08 | FEU3 | Futures | 98.961 | 98.966 | 98.961 | 98.966 | 260.0 |
| 2016-12-08 | FGBL | Futures | 145.76 | 145.9 | 144.21 | 145.31 | 1267397.0 |
| 2016-12-08 | FGBM | Futures | 127.96 | 128.55 | 127.38 | 128.26 | 900769.0 |
| 2016-12-08 | FGBS | Futures | 111.907 | 112.117 | 111.807 | 112.067 | 946590.0 |
| 2016-12-08 | FGBX | Futures | 168.21 | 168.61 | 162.73 | 165.01 | 93183.0 |
| 2016-12-08 | FMWO | Futures | 5858.6 | 5867.1 | 5851.3 | 5864.6 | 2754.0 |
| 2016-12-08 | FOAT | Futures | 132.6 | 132.69 | 131.35 | 131.95 | 159332.0 |
| 2016-12-08 | FTDX | Futures | 1694.0 | 1704.8 | 1681.8 | 1699.9 | 204.0 |
| 2016-12-08 | FTI | Futures | 422.99 | 426.73 | 420.76 | 425.31 | 44712.0 |
| 2016-12-08 | FTUK | Futures | 5840.2 | 5866.8 | 5817.0 | 5849.5 | 161999.0 |
| 2016-12-08 | FVSA | Futures | 1124.81 | 1156.23 | 1087.11 | 1099.68 | 38858.0 |
| 2016-12-08 | FXXP | Futures | 288.6 | 291.5 | 286.3 | 290.8 | 74899.0 |
| 2016-12-08 | G | Futures | 110.92 | 110.93 | 110.22 | 110.69 | 186555.0 |
| 2016-12-08 | GF | Futures | 282.419 | 284.985 | 277.902 | 282.419 | 5464.0 |
> showing 50 of 111 rows — these rows as CSV