PREVIEW / futures_daily / 2016-01-26
file: by_date/futures_daily/2016/2016-01-26.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 |
|---|---|---|---|---|---|---|---|
| 2016-01-26 | ES | Futures | 1999.28 | 2029.19 | 1977.39 | 2025.19 | 1780235.0 |
| 2016-01-26 | NQ | Futures | 4911.97 | 4974.98 | 4845.15 | 4955.05 | 327223.0 |
| 2016-01-26 | YM | Futures | 16360.2 | 16661.3 | 16184.3 | 16625.1 | 193761.0 |
| 2016-01-26 | CL | Futures | 42.94 | 46.69 | 42.14 | 45.3 | 642432.0 |
| 2016-01-26 | GC | Futures | 1425.5 | 1443.7 | 1423.3 | 1439.9 | 91028.0 |
| 2016-01-26 | ZN | Futures | 123.882408 | 124.258447 | 123.701909 | 124.00274 | 1088050.0 |
| 2016-01-26 | A6 | Futures | 0.69438 | 0.702 | 0.69167 | 0.70139 | 85416.0 |
| 2016-01-26 | AD | Futures | 0.71562 | 0.72799 | 0.71378 | 0.72605 | 99162.0 |
| 2016-01-26 | ALI | Futures | 2089.24 | 2089.24 | 2089.24 | 2089.24 | 0.0 |
| 2016-01-26 | B | Futures | 26.04 | 28.15 | 25.31 | 27.37 | 296405.0 |
| 2016-01-26 | B6 | Futures | 1.4985 | 1.5116 | 1.4912 | 1.5108 | 91937.0 |
| 2016-01-26 | BFX | Futures | 4128.7 | 4179.2 | 4128.7 | 4179.2 | 2.0 |
| 2016-01-26 | BR | Futures | 0.15152 | 0.15397 | 0.15152 | 0.15334 | 2378.0 |
| 2016-01-26 | BZ | Futures | 25.75 | 27.94 | 25.14 | 27.17 | 32104.0 |
| 2016-01-26 | C | Futures | 2151.0 | 2165.0 | 2130.0 | 2148.0 | 13328.0 |
| 2016-01-26 | CB | Futures | 278.749 | 282.027 | 278.749 | 282.027 | 5.0 |
| 2016-01-26 | CC | Futures | 2057.0 | 2102.0 | 2053.0 | 2086.0 | 23262.0 |
| 2016-01-26 | CNH | Futures | 7.3155 | 7.3159 | 7.2929 | 7.2975 | 19.0 |
| 2016-01-26 | CSC | Futures | 3.704 | 3.706 | 3.691 | 3.701 | 109.0 |
| 2016-01-26 | CT | Futures | 71.98 | 72.33 | 71.41 | 71.93 | 22324.0 |
| 2016-01-26 | DC | Futures | 29.36 | 29.4 | 29.27 | 29.27 | 159.0 |
| 2016-01-26 | DX | Futures | 92.84 | 92.952 | 92.541 | 92.605 | 19415.0 |
| 2016-01-26 | E1 | Futures | 1.24872 | 1.25011 | 1.24014 | 1.24304 | 17366.0 |
| 2016-01-26 | E6 | Futures | 1.27017 | 1.27303 | 1.26648 | 1.27046 | 156060.0 |
| 2016-01-26 | E7 | Futures | 1.2632 | 1.2659 | 1.2595 | 1.2633 | 4084.0 |
| 2016-01-26 | EBM | Futures | 234.83 | 238.36 | 234.12 | 238.01 | 22700.0 |
| 2016-01-26 | ED | Futures | 95.6169 | 95.6217 | 95.6073 | 95.6169 | 165495.0 |
| 2016-01-26 | ER | Futures | 98.288 | 98.298 | 98.288 | 98.288 | 40828.0 |
| 2016-01-26 | EW | Futures | 1327.0 | 1358.5 | 1314.6 | 1356.9 | 21353.0 |
| 2016-01-26 | FBON | Futures | 115.96 | 116.54 | 115.96 | 116.54 | 745.0 |
| 2016-01-26 | FBTP | Futures | 105.34 | 105.74 | 105.15 | 105.67 | 94653.0 |
| 2016-01-26 | FBTS | Futures | 100.908 | 100.935 | 100.891 | 100.917 | 24580.0 |
| 2016-01-26 | FCE | Futures | 3561.8 | 3671.4 | 3540.8 | 3653.3 | 109363.0 |
| 2016-01-26 | FDAX | Futures | 10400.7 | 10703.3 | 10369.8 | 10664.8 | 99758.0 |
| 2016-01-26 | FDXM | Futures | 9948.3 | 10235.5 | 9914.0 | 10196.1 | 21372.0 |
| 2016-01-26 | FESX | Futures | 2242.3 | 2311.5 | 2233.9 | 2303.1 | 1370055.0 |
| 2016-01-26 | FGBL | Futures | 142.55 | 142.81 | 142.39 | 142.64 | 658061.0 |
| 2016-01-26 | FGBM | Futures | 126.72 | 126.79 | 126.67 | 126.75 | 369840.0 |
| 2016-01-26 | FGBS | Futures | 111.663 | 111.678 | 111.653 | 111.673 | 159453.0 |
| 2016-01-26 | FGBX | Futures | 162.82 | 163.8 | 162.59 | 163.23 | 41330.0 |
| 2016-01-26 | FMWO | Futures | 5076.2 | 5180.8 | 5065.0 | 5180.8 | 487.0 |
| 2016-01-26 | FOAT | Futures | 129.97 | 130.22 | 129.86 | 130.14 | 99218.0 |
| 2016-01-26 | FTDX | Futures | 1598.5 | 1621.1 | 1588.0 | 1618.2 | 187.0 |
| 2016-01-26 | FTI | Futures | 363.05 | 374.03 | 361.15 | 371.9 | 37960.0 |
| 2016-01-26 | FTUK | Futures | 4724.7 | 4802.6 | 4662.7 | 4783.9 | 129823.0 |
| 2016-01-26 | FVSA | Futures | 2962.72 | 2997.63 | 2783.16 | 2808.1 | 5337.0 |
| 2016-01-26 | FXXP | Futures | 259.3 | 267.4 | 258.0 | 266.5 | 29015.0 |
| 2016-01-26 | G | Futures | 106.53 | 106.71 | 106.04 | 106.17 | 216891.0 |
| 2016-01-26 | GF | Futures | 308.863 | 314.164 | 308.323 | 312.692 | 3678.0 |
| 2016-01-26 | GSCI | Futures | 436.9 | 456.38 | 436.9 | 451.29 | 86.0 |
> showing 50 of 109 rows — these rows as CSV