PREVIEW / futures_daily / 2016-01-19
file: by_date/futures_daily/2016/2016-01-19.parquet size: 9 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-01-19 | ES | Futures | 1997.15 | 2037.47 | 1982.73 | 2000.62 | 2796679.0 |
| 2016-01-19 | NQ | Futures | 4837.82 | 4942.16 | 4796.2 | 4858.63 | 475760.0 |
| 2016-01-19 | YM | Futures | 16427.5 | 16751.4 | 16343.6 | 16466.8 | 348986.0 |
| 2016-01-19 | CL | Futures | 43.46 | 45.17 | 42.28 | 42.6 | 743931.0 |
| 2016-01-19 | GC | Futures | 1404.9 | 1411.6 | 1395.6 | 1404.6 | 160106.0 |
| 2016-01-19 | ZN | Futures | 123.686867 | 123.792158 | 123.23562 | 123.596618 | 1569573.0 |
| 2016-01-19 | A6 | Futures | 0.68526 | 0.69528 | 0.68336 | 0.69027 | 198487.0 |
| 2016-01-19 | AD | Futures | 0.70233 | 0.70857 | 0.7009 | 0.70182 | 120534.0 |
| 2016-01-19 | ALI | Futures | 2077.41 | 2077.41 | 2077.41 | 2077.41 | 0.0 |
| 2016-01-19 | B | Futures | 24.73 | 26.06 | 24.65 | 24.78 | 419479.0 |
| 2016-01-19 | B6 | Futures | 1.5005 | 1.5089 | 1.4867 | 1.4917 | 179414.0 |
| 2016-01-19 | BFX | Futures | 4083.0 | 4096.8 | 4062.6 | 4067.4 | 9.0 |
| 2016-01-19 | BR | Futures | 0.15501 | 0.15501 | 0.15259 | 0.15365 | 94.0 |
| 2016-01-19 | BZ | Futures | 24.56 | 25.85 | 23.59 | 24.52 | 60326.0 |
| 2016-01-19 | C | Futures | 2226.0 | 2260.0 | 2226.0 | 2257.0 | 10088.0 |
| 2016-01-19 | CB | Futures | 290.994 | 290.994 | 278.006 | 278.006 | 98.0 |
| 2016-01-19 | CC | Futures | 2150.0 | 2178.0 | 2140.0 | 2163.0 | 23702.0 |
| 2016-01-19 | CNH | Futures | 7.3405 | 7.3407 | 7.3019 | 7.3019 | 71.0 |
| 2016-01-19 | CSC | Futures | 3.785 | 3.817 | 3.731 | 3.731 | 81.0 |
| 2016-01-19 | CT | Futures | 71.92 | 73.71 | 71.81 | 73.18 | 25848.0 |
| 2016-01-19 | DC | Futures | 30.23 | 30.32 | 29.48 | 29.48 | 247.0 |
| 2016-01-19 | DX | Futures | 92.719 | 92.85 | 92.406 | 92.514 | 24177.0 |
| 2016-01-19 | E1 | Futures | 1.26387 | 1.26488 | 1.25478 | 1.26248 | 22544.0 |
| 2016-01-19 | E6 | Futures | 1.27806 | 1.28087 | 1.27157 | 1.27917 | 225962.0 |
| 2016-01-19 | E7 | Futures | 1.2711 | 1.2737 | 1.2644 | 1.2721 | 6251.0 |
| 2016-01-19 | EBM | Futures | 234.48 | 235.89 | 233.42 | 233.77 | 23178.0 |
| 2016-01-19 | ED | Futures | 95.6217 | 95.6265 | 95.5928 | 95.5976 | 311371.0 |
| 2016-01-19 | ER | Futures | 98.225 | 98.234 | 98.225 | 98.229 | 60229.0 |
| 2016-01-19 | EW | Futures | 1334.3 | 1357.0 | 1318.0 | 1327.0 | 26601.0 |
| 2016-01-19 | FBON | Futures | 115.46 | 115.95 | 115.46 | 115.84 | 368.0 |
| 2016-01-19 | FBTP | Futures | 104.99 | 105.23 | 104.91 | 105.13 | 69957.0 |
| 2016-01-19 | FBTS | Futures | 100.837 | 100.855 | 100.811 | 100.855 | 19167.0 |
| 2016-01-19 | FCE | Futures | 3555.5 | 3611.8 | 3526.9 | 3580.7 | 120926.0 |
| 2016-01-19 | FDAX | Futures | 10499.4 | 10583.5 | 10329.2 | 10469.6 | 116721.0 |
| 2016-01-19 | FDIV | Futures | 125.95 | 125.95 | 125.72 | 125.72 | 3.0 |
| 2016-01-19 | FDXM | Futures | 10018.8 | 10118.3 | 9877.8 | 10010.5 | 25906.0 |
| 2016-01-19 | FESX | Futures | 2260.5 | 2284.1 | 2227.1 | 2260.5 | 1523288.0 |
| 2016-01-19 | FEU3 | Futures | 98.887 | 98.887 | 98.887 | 98.887 | 20.0 |
| 2016-01-19 | FGBL | Futures | 141.16 | 141.36 | 140.91 | 141.17 | 575906.0 |
| 2016-01-19 | FGBM | Futures | 126.15 | 126.26 | 126.12 | 126.21 | 354390.0 |
| 2016-01-19 | FGBS | Futures | 111.533 | 111.553 | 111.523 | 111.543 | 144029.0 |
| 2016-01-19 | FGBX | Futures | 159.49 | 160.06 | 158.85 | 159.53 | 30865.0 |
| 2016-01-19 | FMWO | Futures | 5179.5 | 5189.5 | 5131.0 | 5148.4 | 635.0 |
| 2016-01-19 | FOAT | Futures | 128.64 | 128.88 | 128.54 | 128.76 | 86126.0 |
| 2016-01-19 | FTDX | Futures | 1537.6 | 1581.7 | 1537.6 | 1578.4 | 766.0 |
| 2016-01-19 | FTI | Futures | 358.09 | 363.09 | 354.2 | 359.24 | 36401.0 |
| 2016-01-19 | FTUK | Futures | 4685.2 | 4781.0 | 4680.7 | 4743.5 | 125764.0 |
| 2016-01-19 | FVSA | Futures | 2823.06 | 3012.59 | 2823.06 | 2912.84 | 23175.0 |
| 2016-01-19 | FXXP | Futures | 261.0 | 263.6 | 257.2 | 260.7 | 37915.0 |
| 2016-01-19 | G | Futures | 106.0 | 106.26 | 105.65 | 106.1 | 200542.0 |
> showing 50 of 111 rows — these rows as CSV