PREVIEW / futures_daily / 2016-01-27
file: by_date/futures_daily/2016/2016-01-27.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-01-27 | ES | Futures | 2013.7 | 2040.14 | 1991.54 | 2002.76 | 2113363.0 |
| 2016-01-27 | NQ | Futures | 4918.12 | 4945.67 | 4808.81 | 4838.11 | 408523.0 |
| 2016-01-27 | YM | Futures | 16555.8 | 16713.1 | 16338.5 | 16402.6 | 261837.0 |
| 2016-01-27 | CL | Futures | 44.01 | 47.31 | 43.42 | 46.53 | 738551.0 |
| 2016-01-27 | GC | Futures | 1439.4 | 1450.3 | 1432.9 | 1434.4 | 128986.0 |
| 2016-01-27 | ZN | Futures | 123.972657 | 124.123073 | 123.52141 | 124.047865 | 1150788.0 |
| 2016-01-27 | A6 | Futures | 0.69939 | 0.70801 | 0.69909 | 0.7029 | 117849.0 |
| 2016-01-27 | AD | Futures | 0.72431 | 0.72891 | 0.72227 | 0.72411 | 97973.0 |
| 2016-01-27 | ALI | Futures | 2119.62 | 2119.62 | 2119.62 | 2119.62 | 0.0 |
| 2016-01-27 | B | Futures | 26.91 | 28.83 | 26.55 | 28.51 | 339911.0 |
| 2016-01-27 | B6 | Futures | 1.5096 | 1.5105 | 1.4973 | 1.4993 | 98972.0 |
| 2016-01-27 | BFX | Futures | 4172.6 | 4172.6 | 4162.4 | 4162.4 | 1.0 |
| 2016-01-27 | BR | Futures | 0.15403 | 0.15441 | 0.15152 | 0.15306 | 6764.0 |
| 2016-01-27 | BZ | Futures | 26.75 | 28.62 | 26.36 | 28.3 | 35654.0 |
| 2016-01-27 | C | Futures | 2148.0 | 2158.0 | 2100.0 | 2110.0 | 9038.0 |
| 2016-01-27 | CB | Futures | 282.027 | 285.799 | 282.027 | 285.799 | 9.0 |
| 2016-01-27 | CC | Futures | 2086.0 | 2092.0 | 2022.0 | 2038.0 | 16704.0 |
| 2016-01-27 | CNH | Futures | 7.305 | 7.305 | 7.3006 | 7.304 | 2.0 |
| 2016-01-27 | CSC | Futures | 3.706 | 3.733 | 3.706 | 3.728 | 16.0 |
| 2016-01-27 | CT | Futures | 71.86 | 72.0 | 71.1 | 71.29 | 17516.0 |
| 2016-01-27 | DC | Futures | 29.53 | 29.76 | 29.44 | 29.68 | 125.0 |
| 2016-01-27 | DX | Futures | 92.602 | 92.695 | 92.242 | 92.438 | 30069.0 |
| 2016-01-27 | E1 | Futures | 1.24291 | 1.24847 | 1.24115 | 1.24708 | 24663.0 |
| 2016-01-27 | E6 | Futures | 1.27216 | 1.27806 | 1.27023 | 1.2766 | 192258.0 |
| 2016-01-27 | E7 | Futures | 1.2652 | 1.2708 | 1.2633 | 1.2695 | 4615.0 |
| 2016-01-27 | EBM | Futures | 237.3 | 237.66 | 233.06 | 234.12 | 25253.0 |
| 2016-01-27 | ED | Futures | 95.6217 | 95.6313 | 95.5976 | 95.6265 | 463778.0 |
| 2016-01-27 | ER | Futures | 98.293 | 98.293 | 98.274 | 98.274 | 156596.0 |
| 2016-01-27 | EW | Futures | 1347.4 | 1366.4 | 1336.4 | 1341.0 | 22163.0 |
| 2016-01-27 | FBON | Futures | 116.63 | 117.04 | 116.51 | 116.78 | 384.0 |
| 2016-01-27 | FBTP | Futures | 105.65 | 106.02 | 105.48 | 105.75 | 97817.0 |
| 2016-01-27 | FBTS | Futures | 100.926 | 100.944 | 100.9 | 100.935 | 17982.0 |
| 2016-01-27 | FCE | Futures | 3653.3 | 3692.8 | 3609.2 | 3673.1 | 100852.0 |
| 2016-01-27 | FDAX | Futures | 10645.8 | 10760.8 | 10530.3 | 10688.6 | 102500.0 |
| 2016-01-27 | FDXM | Futures | 10187.8 | 10289.4 | 10068.5 | 10220.9 | 22759.0 |
| 2016-01-27 | FESX | Futures | 2301.6 | 2324.4 | 2270.4 | 2306.9 | 1237312.0 |
| 2016-01-27 | FEU3 | Futures | 98.952 | 98.952 | 98.932 | 98.932 | 8.0 |
| 2016-01-27 | FGBL | Futures | 142.72 | 143.01 | 142.44 | 142.67 | 631774.0 |
| 2016-01-27 | FGBM | Futures | 126.76 | 126.82 | 126.63 | 126.71 | 396597.0 |
| 2016-01-27 | FGBS | Futures | 111.673 | 111.688 | 111.633 | 111.653 | 231215.0 |
| 2016-01-27 | FGBX | Futures | 163.43 | 164.65 | 162.96 | 163.6 | 34844.0 |
| 2016-01-27 | FMWO | Futures | 5172.1 | 5197.0 | 5172.1 | 5197.0 | 990.0 |
| 2016-01-27 | FOAT | Futures | 130.21 | 130.42 | 129.86 | 130.11 | 101853.0 |
| 2016-01-27 | FTDX | Futures | 1624.0 | 1628.3 | 1606.2 | 1623.0 | 155.0 |
| 2016-01-27 | FTI | Futures | 372.43 | 376.06 | 367.43 | 374.03 | 31228.0 |
| 2016-01-27 | FTUK | Futures | 4779.0 | 4873.2 | 4744.7 | 4823.4 | 132426.0 |
| 2016-01-27 | FVSA | Futures | 2852.99 | 2887.9 | 2728.29 | 2788.15 | 8267.0 |
| 2016-01-27 | FXXP | Futures | 266.0 | 269.7 | 262.7 | 266.3 | 27107.0 |
| 2016-01-27 | G | Futures | 106.33 | 106.37 | 105.94 | 106.11 | 188585.0 |
| 2016-01-27 | GF | Futures | 312.643 | 315.539 | 310.483 | 314.017 | 4904.0 |
> showing 50 of 110 rows — these rows as CSV