PREVIEW / futures_daily / 2015-10-02
file: by_date/futures_daily/2015/2015-10-02.parquet size: 9 KB rows: 107
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 |
|---|---|---|---|---|---|---|---|
| 2015-10-02 | ES | Futures | 2039.21 | 2067.67 | 2003.04 | 2066.87 | 2466082.0 |
| 2015-10-02 | NQ | Futures | 4896.94 | 4985.21 | 4807.2 | 4982.29 | 404892.0 |
| 2015-10-02 | YM | Futures | 16705.5 | 16905.7 | 16413.5 | 16897.4 | 287405.0 |
| 2015-10-02 | CL | Futures | 72.39 | 73.58 | 70.62 | 73.14 | 420740.0 |
| 2015-10-02 | GC | Futures | 1436.1 | 1472.8 | 1424.9 | 1467.2 | 190004.0 |
| 2015-10-02 | ZN | Futures | 123.377223 | 124.544689 | 123.182645 | 123.901086 | 1920484.0 |
| 2015-10-02 | A6 | Futures | 0.70063 | 0.70453 | 0.69773 | 0.70093 | 78707.0 |
| 2015-10-02 | AD | Futures | 0.7722 | 0.77885 | 0.7722 | 0.7764 | 55327.0 |
| 2015-10-02 | ALI | Futures | 2085.19 | 2085.19 | 2085.19 | 2085.19 | 0.0 |
| 2015-10-02 | B | Futures | 43.58 | 44.03 | 42.61 | 43.67 | 159034.0 |
| 2015-10-02 | B6 | Futures | 1.5929 | 1.604 | 1.5927 | 1.5991 | 80081.0 |
| 2015-10-02 | BFX | Futures | 4076.2 | 4076.2 | 3987.9 | 4030.2 | 3.0 |
| 2015-10-02 | BR | Futures | 0.15084 | 0.15309 | 0.14859 | 0.15269 | 940.0 |
| 2015-10-02 | BZ | Futures | 43.4 | 43.74 | 42.38 | 43.43 | 19759.0 |
| 2015-10-02 | C | Futures | 2273.0 | 2288.0 | 2258.0 | 2261.0 | 6983.0 |
| 2015-10-02 | CB | Futures | 190.426 | 190.426 | 188.433 | 189.417 | 11.0 |
| 2015-10-02 | CC | Futures | 2277.0 | 2289.0 | 2264.0 | 2269.0 | 18034.0 |
| 2015-10-02 | CNH | Futures | 7.1275 | 7.1275 | 7.1149 | 7.1149 | 4.0 |
| 2015-10-02 | CSC | Futures | 4.317 | 4.353 | 4.317 | 4.325 | 30.0 |
| 2015-10-02 | CT | Futures | 72.35 | 73.42 | 72.07 | 72.14 | 9578.0 |
| 2015-10-02 | DC | Futures | 34.92 | 35.21 | 34.81 | 34.83 | 54.0 |
| 2015-10-02 | DX | Futures | 90.014 | 90.262 | 89.13 | 89.754 | 50493.0 |
| 2015-10-02 | E1 | Futures | 1.30104 | 1.31842 | 1.29812 | 1.31017 | 23104.0 |
| 2015-10-02 | E6 | Futures | 1.31201 | 1.32735 | 1.30756 | 1.31681 | 295586.0 |
| 2015-10-02 | E7 | Futures | 1.305 | 1.32 | 1.3005 | 1.3095 | 6058.0 |
| 2015-10-02 | EBM | Futures | 257.59 | 258.32 | 255.03 | 256.86 | 16867.0 |
| 2015-10-02 | ED | Futures | 95.7063 | 95.764 | 95.6967 | 95.7448 | 491668.0 |
| 2015-10-02 | ER | Futures | 98.146 | 98.151 | 98.136 | 98.151 | 65194.0 |
| 2015-10-02 | EW | Futures | 1436.9 | 1458.5 | 1413.4 | 1457.8 | 24405.0 |
| 2015-10-02 | FBTP | Futures | 103.14 | 103.55 | 102.55 | 103.24 | 119708.0 |
| 2015-10-02 | FBTS | Futures | 100.347 | 100.436 | 100.302 | 100.418 | 22232.0 |
| 2015-10-02 | FCE | Futures | 3722.4 | 3771.6 | 3649.1 | 3712.4 | 129240.0 |
| 2015-10-02 | FDAX | Futures | 10551.1 | 10662.3 | 10341.8 | 10502.6 | 136731.0 |
| 2015-10-02 | FESX | Futures | 2314.3 | 2345.1 | 2267.9 | 2305.4 | 1411749.0 |
| 2015-10-02 | FEU3 | Futures | 98.789 | 98.794 | 98.789 | 98.794 | 1857.0 |
| 2015-10-02 | FGBL | Futures | 139.37 | 140.3 | 139.21 | 139.92 | 751889.0 |
| 2015-10-02 | FGBM | Futures | 125.4 | 125.59 | 125.33 | 125.5 | 469718.0 |
| 2015-10-02 | FGBS | Futures | 111.323 | 111.343 | 111.298 | 111.323 | 250329.0 |
| 2015-10-02 | FGBX | Futures | 159.18 | 162.03 | 158.67 | 161.12 | 36471.0 |
| 2015-10-02 | FMWO | Futures | 5309.6 | 5309.6 | 5244.1 | 5286.1 | 211.0 |
| 2015-10-02 | FOAT | Futures | 127.46 | 128.32 | 127.24 | 127.99 | 99082.0 |
| 2015-10-02 | FTDX | Futures | 1653.8 | 1663.3 | 1625.3 | 1644.8 | 218.0 |
| 2015-10-02 | FTI | Futures | 366.44 | 372.99 | 360.62 | 366.96 | 48077.0 |
| 2015-10-02 | FTUK | Futures | 4870.8 | 4989.0 | 4839.9 | 4904.2 | 136983.0 |
| 2015-10-02 | FVSA | Futures | 2616.87 | 2746.32 | 2579.88 | 2663.1 | 14091.0 |
| 2015-10-02 | FXXP | Futures | 271.3 | 273.9 | 266.7 | 270.5 | 16277.0 |
| 2015-10-02 | G | Futures | 105.34 | 106.37 | 105.11 | 105.89 | 208720.0 |
| 2015-10-02 | GF | Futures | 312.229 | 320.219 | 310.764 | 318.71 | 1996.0 |
| 2015-10-02 | GSCI | Futures | 578.8 | 586.39 | 576.43 | 586.22 | 215.0 |
| 2015-10-02 | HE | Futures | 96.955 | 98.974 | 96.543 | 97.777 | 13999.0 |
> showing 50 of 107 rows — these rows as CSV