PREVIEW / futures_daily / 2016-02-02
file: by_date/futures_daily/2016/2016-02-02.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-02 | ES | Futures | 2059.9 | 2060.7 | 2017.71 | 2026.79 | 2102411.0 |
| 2016-02-02 | NQ | Futures | 5025.1 | 5025.68 | 4889.4 | 4914.31 | 314726.0 |
| 2016-02-02 | YM | Futures | 16884.8 | 16894.2 | 16577.5 | 16651.0 | 205812.0 |
| 2016-02-02 | CL | Futures | 45.19 | 45.42 | 42.6 | 43.04 | 602564.0 |
| 2016-02-02 | GC | Futures | 1450.0 | 1453.9 | 1442.5 | 1448.4 | 117734.0 |
| 2016-02-02 | ZN | Futures | 124.453988 | 125.356482 | 124.438946 | 125.236149 | 1420462.0 |
| 2016-02-02 | A6 | Futures | 0.71081 | 0.71382 | 0.7035 | 0.7049 | 92000.0 |
| 2016-02-02 | AD | Futures | 0.7328 | 0.73341 | 0.72615 | 0.72901 | 72088.0 |
| 2016-02-02 | ALI | Futures | 2094.03 | 2094.03 | 2094.03 | 2094.03 | 0.0 |
| 2016-02-02 | B | Futures | 28.72 | 28.72 | 27.08 | 27.5 | 346885.0 |
| 2016-02-02 | B6 | Futures | 1.5174 | 1.5201 | 1.5074 | 1.5166 | 97386.0 |
| 2016-02-02 | BFX | Futures | 4146.2 | 4146.2 | 4130.5 | 4130.5 | 1.0 |
| 2016-02-02 | BR | Futures | 0.15645 | 0.15702 | 0.15529 | 0.15614 | 2319.0 |
| 2016-02-02 | BZ | Futures | 28.56 | 28.62 | 26.89 | 27.29 | 37956.0 |
| 2016-02-02 | C | Futures | 2175.0 | 2178.0 | 2089.0 | 2094.0 | 9566.0 |
| 2016-02-02 | CB | Futures | 270.801 | 270.801 | 268.42 | 270.77 | 75.0 |
| 2016-02-02 | CC | Futures | 2103.0 | 2107.0 | 2030.0 | 2036.0 | 26656.0 |
| 2016-02-02 | CNH | Futures | 7.3098 | 7.3196 | 7.3094 | 7.3196 | 22.0 |
| 2016-02-02 | CSC | Futures | 3.728 | 3.767 | 3.728 | 3.743 | 34.0 |
| 2016-02-02 | CT | Futures | 72.17 | 73.21 | 72.03 | 72.98 | 25284.0 |
| 2016-02-02 | DC | Futures | 29.68 | 29.87 | 29.59 | 29.74 | 227.0 |
| 2016-02-02 | DX | Futures | 92.513 | 92.579 | 92.284 | 92.381 | 19634.0 |
| 2016-02-02 | E1 | Futures | 1.23951 | 1.24317 | 1.23332 | 1.23963 | 22263.0 |
| 2016-02-02 | E6 | Futures | 1.27432 | 1.28052 | 1.27414 | 1.27771 | 152546.0 |
| 2016-02-02 | E7 | Futures | 1.2674 | 1.2734 | 1.2674 | 1.2705 | 2708.0 |
| 2016-02-02 | EBM | Futures | 228.12 | 228.47 | 225.65 | 226.0 | 21572.0 |
| 2016-02-02 | ED | Futures | 95.6458 | 95.6602 | 95.641 | 95.6602 | 278034.0 |
| 2016-02-02 | ER | Futures | 98.288 | 98.293 | 98.283 | 98.283 | 77932.0 |
| 2016-02-02 | EW | Futures | 1383.4 | 1384.5 | 1352.9 | 1359.0 | 24625.0 |
| 2016-02-02 | FBON | Futures | 117.42 | 117.51 | 117.01 | 117.17 | 225.0 |
| 2016-02-02 | FBTP | Futures | 106.28 | 106.28 | 105.72 | 105.85 | 170270.0 |
| 2016-02-02 | FBTS | Futures | 101.006 | 101.006 | 100.962 | 100.962 | 23717.0 |
| 2016-02-02 | FCE | Futures | 3678.9 | 3680.2 | 3561.8 | 3597.1 | 110633.0 |
| 2016-02-02 | FDAX | Futures | 10556.3 | 10556.3 | 10278.2 | 10369.3 | 119545.0 |
| 2016-02-02 | FDXM | Futures | 10089.3 | 10091.3 | 9828.0 | 9915.1 | 23341.0 |
| 2016-02-02 | FESX | Futures | 2291.7 | 2292.5 | 2218.7 | 2241.5 | 1508260.0 |
| 2016-02-02 | FEU3 | Futures | 98.952 | 98.952 | 98.947 | 98.947 | 16.0 |
| 2016-02-02 | FGBL | Futures | 143.91 | 144.34 | 143.81 | 144.07 | 715645.0 |
| 2016-02-02 | FGBM | Futures | 127.06 | 127.18 | 127.02 | 127.1 | 450131.0 |
| 2016-02-02 | FGBS | Futures | 111.708 | 111.733 | 111.693 | 111.718 | 212218.0 |
| 2016-02-02 | FGBX | Futures | 167.21 | 168.04 | 166.51 | 167.01 | 44105.0 |
| 2016-02-02 | FMWO | Futures | 5272.9 | 5272.9 | 5193.2 | 5205.7 | 67.0 |
| 2016-02-02 | FOAT | Futures | 131.15 | 131.38 | 131.01 | 131.17 | 88207.0 |
| 2016-02-02 | FTDX | Futures | 1624.9 | 1626.9 | 1601.4 | 1605.7 | 545.0 |
| 2016-02-02 | FTI | Futures | 378.36 | 378.36 | 367.56 | 370.75 | 39739.0 |
| 2016-02-02 | FTUK | Futures | 4878.1 | 4891.9 | 4742.3 | 4781.8 | 147867.0 |
| 2016-02-02 | FVSA | Futures | 2788.15 | 2942.77 | 2758.22 | 2882.91 | 8335.0 |
| 2016-02-02 | FXXP | Futures | 267.1 | 267.2 | 260.3 | 262.4 | 25182.0 |
| 2016-02-02 | G | Futures | 106.76 | 107.41 | 106.72 | 107.26 | 195808.0 |
| 2016-02-02 | GF | Futures | 310.139 | 313.183 | 308.765 | 309.943 | 2982.0 |
> showing 50 of 110 rows — these rows as CSV