PREVIEW / futures_daily / 2017-02-10
file: by_date/futures_daily/2017/2017-02-10.parquet size: 9 KB rows: 109
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 |
|---|---|---|---|---|---|---|---|
| 2017-02-10 | ES | Futures | 2498.04 | 2510.5 | 2496.68 | 2507.25 | 1177521.0 |
| 2017-02-10 | NQ | Futures | 6142.02 | 6167.07 | 6140.25 | 6160.29 | 147032.0 |
| 2017-02-10 | YM | Futures | 21206.0 | 21327.2 | 21199.7 | 21300.8 | 99922.0 |
| 2017-02-10 | CL | Futures | 56.88 | 57.93 | 56.61 | 57.64 | 596449.0 |
| 2017-02-10 | GC | Futures | 1570.8 | 1582.7 | 1561.8 | 1578.8 | 240052.0 |
| 2017-02-10 | ZN | Futures | 122.17985 | 122.17985 | 121.889491 | 122.042312 | 1166254.0 |
| 2017-02-10 | A6 | Futures | 0.78017 | 0.78693 | 0.77955 | 0.78539 | 76120.0 |
| 2017-02-10 | AD | Futures | 0.7775 | 0.78215 | 0.77643 | 0.78051 | 58256.0 |
| 2017-02-10 | ALI | Futures | 2517.5 | 2529.7 | 2517.5 | 2529.7 | 73.0 |
| 2017-02-10 | B | Futures | 41.05 | 41.94 | 40.99 | 41.81 | 284708.0 |
| 2017-02-10 | B6 | Futures | 1.3114 | 1.3141 | 1.3054 | 1.31 | 93293.0 |
| 2017-02-10 | BFX | Futures | 4346.3 | 4349.3 | 4346.3 | 4349.3 | 8.0 |
| 2017-02-10 | BR | Futures | 0.22681 | 0.22792 | 0.22678 | 0.22752 | 1136.0 |
| 2017-02-10 | BZ | Futures | 40.86 | 41.72 | 40.78 | 41.6 | 30763.0 |
| 2017-02-10 | C | Futures | 1684.0 | 1685.0 | 1655.0 | 1657.0 | 8308.0 |
| 2017-02-10 | CB | Futures | 265.506 | 265.506 | 262.607 | 263.034 | 66.0 |
| 2017-02-10 | CC | Futures | 1523.0 | 1525.0 | 1490.0 | 1498.0 | 28123.0 |
| 2017-02-10 | CNH | Futures | 7.2615 | 7.2757 | 7.2615 | 7.2622 | 33.0 |
| 2017-02-10 | CSC | Futures | 3.914 | 3.914 | 3.889 | 3.889 | 44.0 |
| 2017-02-10 | CT | Futures | 86.83 | 87.57 | 86.79 | 87.1 | 34544.0 |
| 2017-02-10 | DC | Futures | 32.5 | 32.82 | 32.25 | 32.36 | 223.0 |
| 2017-02-10 | DX | Futures | 93.747 | 94.054 | 93.63 | 93.845 | 34597.0 |
| 2017-02-10 | E1 | Futures | 1.23925 | 1.24 | 1.23355 | 1.2369 | 18248.0 |
| 2017-02-10 | E6 | Futures | 1.23183 | 1.2335 | 1.22652 | 1.22929 | 176378.0 |
| 2017-02-10 | E7 | Futures | 1.2255 | 1.2272 | 1.2201 | 1.223 | 3214.0 |
| 2017-02-10 | EBM | Futures | 196.27 | 196.84 | 195.41 | 195.7 | 19876.0 |
| 2017-02-10 | ED | Futures | 95.5713 | 95.5762 | 95.5617 | 95.5665 | 176867.0 |
| 2017-02-10 | ER | Futures | 98.298 | 98.303 | 98.298 | 98.298 | 32989.0 |
| 2017-02-10 | EW | Futures | 1821.1 | 1833.8 | 1820.1 | 1829.8 | 11475.0 |
| 2017-02-10 | FBON | Futures | 120.42 | 120.48 | 119.92 | 120.0 | 1193.0 |
| 2017-02-10 | FBTP | Futures | 104.11 | 104.22 | 103.37 | 103.51 | 114560.0 |
| 2017-02-10 | FBTS | Futures | 101.602 | 101.611 | 101.485 | 101.521 | 38067.0 |
| 2017-02-10 | FCE | Futures | 4263.8 | 4270.4 | 4240.9 | 4252.3 | 81688.0 |
| 2017-02-10 | FDAX | Futures | 12324.4 | 12369.2 | 12286.9 | 12308.5 | 71598.0 |
| 2017-02-10 | FDXM | Futures | 12278.9 | 12319.9 | 12236.9 | 12258.9 | 21477.0 |
| 2017-02-10 | FESX | Futures | 2628.7 | 2633.5 | 2609.5 | 2615.9 | 912885.0 |
| 2017-02-10 | FEU3 | Futures | 98.966 | 98.966 | 98.966 | 98.966 | 2.0 |
| 2017-02-10 | FGBL | Futures | 147.87 | 148.06 | 147.69 | 147.82 | 638457.0 |
| 2017-02-10 | FGBM | Futures | 129.28 | 129.39 | 129.24 | 129.33 | 441622.0 |
| 2017-02-10 | FGBS | Futures | 112.232 | 112.287 | 112.227 | 112.267 | 220091.0 |
| 2017-02-10 | FGBX | Futures | 167.74 | 167.95 | 166.77 | 166.95 | 40805.0 |
| 2017-02-10 | FMWO | Futures | 6054.1 | 6074.6 | 6038.4 | 6063.7 | 1210.0 |
| 2017-02-10 | FOAT | Futures | 130.97 | 131.12 | 130.26 | 130.51 | 115807.0 |
| 2017-02-10 | FTDX | Futures | 1831.8 | 1837.7 | 1829.8 | 1837.7 | 161.0 |
| 2017-02-10 | FTI | Futures | 444.75 | 445.25 | 442.3 | 443.57 | 852.0 |
| 2017-02-10 | FTUK | Futures | 6080.0 | 6113.1 | 6079.6 | 6095.3 | 111476.0 |
| 2017-02-10 | FVSA | Futures | 750.79 | 750.79 | 727.11 | 736.58 | 22447.0 |
| 2017-02-10 | FXXP | Futures | 304.2 | 304.7 | 302.9 | 303.7 | 38510.0 |
| 2017-02-10 | G | Futures | 112.21 | 112.56 | 112.19 | 112.29 | 154119.0 |
| 2017-02-10 | GF | Futures | 282.174 | 284.34 | 277.045 | 278.299 | 6144.0 |
> showing 50 of 109 rows — these rows as CSV