PREVIEW / futures_daily / 2016-01-25
file: by_date/futures_daily/2016/2016-01-25.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-25 | ES | Futures | 2028.93 | 2034.0 | 1994.74 | 1997.68 | 1640401.0 |
| 2016-01-25 | NQ | Futures | 4979.38 | 4994.03 | 4899.37 | 4908.16 | 287599.0 |
| 2016-01-25 | YM | Futures | 16565.1 | 16597.2 | 16339.5 | 16361.2 | 179722.0 |
| 2016-01-25 | CL | Futures | 46.17 | 47.16 | 42.75 | 43.71 | 606892.0 |
| 2016-01-25 | GC | Futures | 1415.8 | 1430.5 | 1415.6 | 1425.5 | 176358.0 |
| 2016-01-25 | ZN | Futures | 123.52141 | 123.897449 | 123.431161 | 123.747034 | 864678.0 |
| 2016-01-25 | A6 | Futures | 0.70019 | 0.703 | 0.69478 | 0.69668 | 70405.0 |
| 2016-01-25 | AD | Futures | 0.72308 | 0.7238 | 0.71531 | 0.71848 | 73736.0 |
| 2016-01-25 | ALI | Futures | 2067.49 | 2067.49 | 2067.49 | 2067.49 | 0.0 |
| 2016-01-25 | B | Futures | 27.73 | 28.15 | 25.92 | 26.31 | 284431.0 |
| 2016-01-25 | B6 | Futures | 1.5013 | 1.5056 | 1.4965 | 1.5 | 69567.0 |
| 2016-01-25 | BFX | Futures | 4135.3 | 4146.2 | 4132.3 | 4132.3 | 2.0 |
| 2016-01-25 | BR | Futures | 0.15123 | 0.15199 | 0.15057 | 0.15177 | 2291.0 |
| 2016-01-25 | BZ | Futures | 27.44 | 27.92 | 25.73 | 26.11 | 30307.0 |
| 2016-01-25 | C | Futures | 2193.0 | 2201.0 | 2150.0 | 2157.0 | 8258.0 |
| 2016-01-25 | CB | Futures | 278.316 | 278.749 | 275.842 | 277.079 | 21.0 |
| 2016-01-25 | CC | Futures | 2099.0 | 2121.0 | 2073.0 | 2078.0 | 17383.0 |
| 2016-01-25 | CNH | Futures | 7.2984 | 7.299 | 7.2928 | 7.2928 | 12.0 |
| 2016-01-25 | CSC | Futures | 3.694 | 3.694 | 3.691 | 3.691 | 5.0 |
| 2016-01-25 | CT | Futures | 73.06 | 73.2 | 71.93 | 72.16 | 17007.0 |
| 2016-01-25 | DC | Futures | 29.38 | 29.4 | 29.27 | 29.27 | 164.0 |
| 2016-01-25 | DX | Futures | 93.078 | 93.097 | 92.742 | 92.86 | 16694.0 |
| 2016-01-25 | E1 | Futures | 1.24443 | 1.24923 | 1.24367 | 1.24569 | 15971.0 |
| 2016-01-25 | E6 | Futures | 1.26374 | 1.27104 | 1.26309 | 1.26859 | 107098.0 |
| 2016-01-25 | E7 | Futures | 1.2564 | 1.2638 | 1.256 | 1.2615 | 2810.0 |
| 2016-01-25 | EBM | Futures | 231.65 | 236.24 | 231.65 | 235.89 | 28510.0 |
| 2016-01-25 | ED | Futures | 95.6169 | 95.6217 | 95.6121 | 95.6121 | 109315.0 |
| 2016-01-25 | ER | Futures | 98.283 | 98.293 | 98.278 | 98.288 | 54357.0 |
| 2016-01-25 | EW | Futures | 1354.6 | 1355.9 | 1325.0 | 1326.8 | 18748.0 |
| 2016-01-25 | FBON | Futures | 115.8 | 115.89 | 115.46 | 115.81 | 401.0 |
| 2016-01-25 | FBTP | Futures | 105.17 | 105.36 | 104.93 | 105.13 | 60541.0 |
| 2016-01-25 | FBTS | Futures | 100.9 | 100.926 | 100.873 | 100.882 | 14639.0 |
| 2016-01-25 | FCE | Futures | 3660.9 | 3663.0 | 3584.9 | 3613.9 | 93056.0 |
| 2016-01-25 | FDAX | Futures | 10670.2 | 10678.9 | 10485.9 | 10557.4 | 92628.0 |
| 2016-01-25 | FDXM | Futures | 10204.4 | 10204.4 | 10019.8 | 10092.4 | 23536.0 |
| 2016-01-25 | FESX | Futures | 2313.0 | 2313.0 | 2259.0 | 2278.8 | 1179141.0 |
| 2016-01-25 | FGBL | Futures | 142.06 | 142.39 | 142.02 | 142.28 | 438486.0 |
| 2016-01-25 | FGBM | Futures | 126.59 | 126.7 | 126.59 | 126.64 | 279380.0 |
| 2016-01-25 | FGBS | Futures | 111.653 | 111.663 | 111.643 | 111.648 | 120787.0 |
| 2016-01-25 | FGBX | Futures | 161.28 | 162.43 | 161.01 | 162.12 | 24079.0 |
| 2016-01-25 | FMWO | Futures | 5169.6 | 5169.6 | 5155.9 | 5155.9 | 300.0 |
| 2016-01-25 | FOAT | Futures | 129.53 | 129.86 | 129.52 | 129.74 | 72891.0 |
| 2016-01-25 | FTDX | Futures | 1608.6 | 1624.5 | 1601.4 | 1618.7 | 353.0 |
| 2016-01-25 | FTI | Futures | 372.3 | 372.43 | 365.66 | 368.36 | 30474.0 |
| 2016-01-25 | FTUK | Futures | 4800.2 | 4814.4 | 4714.1 | 4748.0 | 108927.0 |
| 2016-01-25 | FVSA | Futures | 2823.06 | 2897.88 | 2798.12 | 2828.05 | 16810.0 |
| 2016-01-25 | FXXP | Futures | 266.8 | 267.0 | 261.6 | 263.6 | 34192.0 |
| 2016-01-25 | G | Futures | 106.06 | 106.33 | 106.03 | 106.24 | 152713.0 |
| 2016-01-25 | GF | Futures | 308.863 | 311.808 | 308.028 | 309.796 | 4279.0 |
| 2016-01-25 | GSCI | Futures | 457.55 | 457.55 | 439.25 | 442.61 | 188.0 |
> showing 50 of 109 rows — these rows as CSV