PREVIEW / futures_daily / 2016-02-09
file: by_date/futures_daily/2016/2016-02-09.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-02-09 | ES | Futures | 1975.79 | 1990.74 | 1950.15 | 1974.18 | 2792208.0 |
| 2016-02-09 | NQ | Futures | 4640.58 | 4693.92 | 4569.07 | 4623.87 | 499993.0 |
| 2016-02-09 | YM | Futures | 16520.6 | 16631.3 | 16321.9 | 16514.4 | 296252.0 |
| 2016-02-09 | CL | Futures | 43.46 | 44.09 | 39.96 | 40.25 | 738219.0 |
| 2016-02-09 | GC | Futures | 1528.4 | 1541.0 | 1523.8 | 1540.1 | 190796.0 |
| 2016-02-09 | ZN | Futures | 126.28906 | 126.830556 | 126.123602 | 126.409392 | 1993045.0 |
| 2016-02-09 | A6 | Futures | 0.70861 | 0.70991 | 0.69759 | 0.7057 | 117296.0 |
| 2016-02-09 | AD | Futures | 0.73382 | 0.74159 | 0.73239 | 0.73597 | 70180.0 |
| 2016-02-09 | ALI | Futures | 2069.41 | 2069.41 | 2038.07 | 2038.07 | 25.0 |
| 2016-02-09 | B | Futures | 27.87 | 28.2 | 25.45 | 25.48 | 305766.0 |
| 2016-02-09 | B6 | Futures | 1.5185 | 1.5274 | 1.5129 | 1.5209 | 89928.0 |
| 2016-02-09 | BFX | Futures | 3840.1 | 3842.5 | 3761.9 | 3810.0 | 14.0 |
| 2016-02-09 | BR | Futures | 0.15784 | 0.15906 | 0.15677 | 0.15758 | 404.0 |
| 2016-02-09 | BZ | Futures | 27.59 | 27.98 | 25.26 | 25.29 | 28881.0 |
| 2016-02-09 | C | Futures | 2164.0 | 2168.0 | 2110.0 | 2144.0 | 6045.0 |
| 2016-02-09 | CB | Futures | 269.626 | 269.626 | 266.874 | 267.802 | 40.0 |
| 2016-02-09 | CC | Futures | 2094.0 | 2103.0 | 2048.0 | 2094.0 | 28479.0 |
| 2016-02-09 | CNH | Futures | 7.2567 | 7.26 | 7.2439 | 7.2439 | 5.0 |
| 2016-02-09 | CSC | Futures | 3.745 | 3.765 | 3.745 | 3.765 | 43.0 |
| 2016-02-09 | CT | Futures | 69.78 | 69.99 | 68.23 | 68.69 | 29396.0 |
| 2016-02-09 | DC | Futures | 29.7 | 29.93 | 29.66 | 29.91 | 152.0 |
| 2016-02-09 | DX | Futures | 90.318 | 90.472 | 89.375 | 89.766 | 41043.0 |
| 2016-02-09 | E1 | Futures | 1.28028 | 1.30402 | 1.28003 | 1.30011 | 44413.0 |
| 2016-02-09 | E6 | Futures | 1.31063 | 1.327 | 1.30636 | 1.32086 | 277498.0 |
| 2016-02-09 | E7 | Futures | 1.303 | 1.3195 | 1.299 | 1.3134 | 5531.0 |
| 2016-02-09 | EBM | Futures | 216.11 | 216.47 | 212.94 | 213.29 | 21481.0 |
| 2016-02-09 | ED | Futures | 95.6169 | 95.6361 | 95.5928 | 95.6265 | 328519.0 |
| 2016-02-09 | ER | Futures | 98.249 | 98.278 | 98.239 | 98.259 | 172451.0 |
| 2016-02-09 | EW | Futures | 1324.8 | 1331.0 | 1306.9 | 1319.1 | 28148.0 |
| 2016-02-09 | FBON | Futures | 114.49 | 115.76 | 114.49 | 115.54 | 505.0 |
| 2016-02-09 | FBTP | Futures | 103.82 | 104.48 | 103.5 | 104.08 | 209790.0 |
| 2016-02-09 | FBTS | Futures | 100.73 | 100.846 | 100.606 | 100.739 | 55571.0 |
| 2016-02-09 | FCE | Futures | 3405.6 | 3437.1 | 3317.0 | 3356.9 | 171697.0 |
| 2016-02-09 | FDAX | Futures | 9678.6 | 9800.0 | 9507.2 | 9657.9 | 174519.0 |
| 2016-02-09 | FDXM | Futures | 9258.8 | 9370.8 | 9089.8 | 9234.9 | 42404.0 |
| 2016-02-09 | FESX | Futures | 2106.9 | 2135.8 | 2059.0 | 2086.4 | 2534608.0 |
| 2016-02-09 | FEU3 | Futures | 98.917 | 98.917 | 98.917 | 98.917 | 4.0 |
| 2016-02-09 | FGBL | Futures | 145.55 | 145.63 | 144.64 | 145.1 | 1028962.0 |
| 2016-02-09 | FGBM | Futures | 127.42 | 127.45 | 127.24 | 127.42 | 618067.0 |
| 2016-02-09 | FGBS | Futures | 111.793 | 111.807 | 111.758 | 111.807 | 363886.0 |
| 2016-02-09 | FGBX | Futures | 172.45 | 173.46 | 169.95 | 171.14 | 66657.0 |
| 2016-02-09 | FMWO | Futures | 5050.0 | 5050.0 | 4989.0 | 5025.1 | 2142.0 |
| 2016-02-09 | FOAT | Futures | 131.8 | 131.85 | 131.05 | 131.39 | 149312.0 |
| 2016-02-09 | FTDX | Futures | 1424.8 | 1447.4 | 1405.1 | 1432.0 | 1161.0 |
| 2016-02-09 | FTI | Futures | 352.29 | 356.37 | 342.87 | 346.41 | 54889.0 |
| 2016-02-09 | FTUK | Futures | 4607.7 | 4639.9 | 4520.8 | 4564.0 | 187851.0 |
| 2016-02-09 | FVSA | Futures | 3162.23 | 3416.6 | 3157.24 | 3247.02 | 23315.0 |
| 2016-02-09 | FXXP | Futures | 245.5 | 248.1 | 239.9 | 242.9 | 67434.0 |
| 2016-02-09 | G | Futures | 108.35 | 108.7 | 108.1 | 108.45 | 276208.0 |
| 2016-02-09 | GF | Futures | 291.633 | 296.689 | 290.602 | 292.566 | 7943.0 |
> showing 50 of 110 rows — these rows as CSV