PREVIEW / futures_daily / 2017-02-16
file: by_date/futures_daily/2017/2017-02-16.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 |
|---|---|---|---|---|---|---|---|
| 2017-02-16 | ES | Futures | 2547.91 | 2548.45 | 2533.27 | 2542.76 | 1737007.0 |
| 2017-02-16 | NQ | Futures | 6261.94 | 6266.66 | 6233.07 | 6247.21 | 209931.0 |
| 2017-02-16 | YM | Futures | 21715.8 | 21725.3 | 21630.5 | 21691.6 | 137885.0 |
| 2017-02-16 | CL | Futures | 56.81 | 57.36 | 56.36 | 57.03 | 453226.0 |
| 2017-02-16 | GC | Futures | 1576.8 | 1588.8 | 1575.5 | 1586.1 | 203786.0 |
| 2017-02-16 | ZN | Futures | 121.27821 | 121.797799 | 121.232364 | 121.721389 | 1367559.0 |
| 2017-02-16 | A6 | Futures | 0.78918 | 0.79174 | 0.78662 | 0.78754 | 85209.0 |
| 2017-02-16 | AD | Futures | 0.78113 | 0.78526 | 0.78097 | 0.78169 | 59385.0 |
| 2017-02-16 | ALI | Futures | 2565.28 | 2565.28 | 2565.28 | 2565.28 | 0.0 |
| 2017-02-16 | B | Futures | 41.1 | 41.47 | 40.65 | 41.04 | 310843.0 |
| 2017-02-16 | B6 | Futures | 1.3075 | 1.3142 | 1.3069 | 1.3113 | 91508.0 |
| 2017-02-16 | BFX | Futures | 4385.1 | 4389.3 | 4383.2 | 4383.2 | 25.0 |
| 2017-02-16 | BR | Futures | 0.2319 | 0.23467 | 0.22756 | 0.23019 | 1972.0 |
| 2017-02-16 | BZ | Futures | 40.84 | 41.26 | 40.45 | 40.83 | 32712.0 |
| 2017-02-16 | C | Futures | 1662.0 | 1703.0 | 1654.0 | 1701.0 | 4892.0 |
| 2017-02-16 | CB | Futures | 266.696 | 267.917 | 266.696 | 267.917 | 7.0 |
| 2017-02-16 | CC | Futures | 1519.0 | 1570.0 | 1516.0 | 1559.0 | 24295.0 |
| 2017-02-16 | CNH | Futures | 7.2415 | 7.2451 | 7.2388 | 7.2411 | 41.0 |
| 2017-02-16 | CSC | Futures | 3.9 | 3.9 | 3.875 | 3.884 | 69.0 |
| 2017-02-16 | CT | Futures | 86.99 | 87.11 | 86.11 | 86.17 | 20111.0 |
| 2017-02-16 | DC | Futures | 32.54 | 32.59 | 32.33 | 32.4 | 282.0 |
| 2017-02-16 | DX | Futures | 93.979 | 94.082 | 93.481 | 93.509 | 41895.0 |
| 2017-02-16 | E1 | Futures | 1.23368 | 1.2452 | 1.23343 | 1.24446 | 21144.0 |
| 2017-02-16 | E6 | Futures | 1.22478 | 1.2346 | 1.22449 | 1.2342 | 207182.0 |
| 2017-02-16 | E7 | Futures | 1.2185 | 1.2282 | 1.2183 | 1.2278 | 3109.0 |
| 2017-02-16 | EBM | Futures | 197.41 | 197.98 | 195.7 | 196.55 | 21046.0 |
| 2017-02-16 | ED | Futures | 95.5279 | 95.5472 | 95.5254 | 95.5423 | 312611.0 |
| 2017-02-16 | ER | Futures | 98.303 | 98.303 | 98.298 | 98.298 | 20430.0 |
| 2017-02-16 | EW | Futures | 1847.4 | 1849.3 | 1834.9 | 1844.1 | 11564.0 |
| 2017-02-16 | FBON | Futures | 120.2 | 121.13 | 120.13 | 121.0 | 1088.0 |
| 2017-02-16 | FBTP | Futures | 103.74 | 104.52 | 103.46 | 104.4 | 132391.0 |
| 2017-02-16 | FBTS | Futures | 101.602 | 101.674 | 101.539 | 101.629 | 54496.0 |
| 2017-02-16 | FCE | Futures | 4333.3 | 4337.7 | 4301.1 | 4309.5 | 73685.0 |
| 2017-02-16 | FDAX | Futures | 12436.3 | 12468.5 | 12375.6 | 12396.1 | 66825.0 |
| 2017-02-16 | FDXM | Futures | 12392.5 | 12417.7 | 12326.2 | 12346.2 | 25175.0 |
| 2017-02-16 | FESX | Futures | 2655.9 | 2661.5 | 2641.5 | 2646.3 | 929782.0 |
| 2017-02-16 | FGBL | Futures | 147.43 | 147.79 | 147.29 | 147.76 | 754372.0 |
| 2017-02-16 | FGBM | Futures | 129.28 | 129.31 | 129.12 | 129.26 | 574178.0 |
| 2017-02-16 | FGBS | Futures | 112.282 | 112.282 | 112.227 | 112.247 | 351821.0 |
| 2017-02-16 | FGBX | Futures | 164.75 | 166.63 | 164.53 | 166.33 | 52037.0 |
| 2017-02-16 | FMWO | Futures | 6138.5 | 6142.1 | 6127.7 | 6133.7 | 2132.0 |
| 2017-02-16 | FOAT | Futures | 130.57 | 131.77 | 130.24 | 131.02 | 192137.0 |
| 2017-02-16 | FTDX | Futures | 1862.7 | 1862.7 | 1849.4 | 1852.4 | 68.0 |
| 2017-02-16 | FTI | Futures | 450.52 | 450.8 | 447.8 | 448.84 | 20333.0 |
| 2017-02-16 | FTUK | Futures | 6150.0 | 6157.6 | 6122.9 | 6136.4 | 88827.0 |
| 2017-02-16 | FVSA | Futures | 713.56 | 734.49 | 703.1 | 732.4 | 15663.0 |
| 2017-02-16 | FXXP | Futures | 307.0 | 307.5 | 305.8 | 306.2 | 24476.0 |
| 2017-02-16 | G | Futures | 112.04 | 112.55 | 112.04 | 112.54 | 170723.0 |
| 2017-02-16 | GF | Futures | 282.402 | 284.169 | 279.952 | 282.288 | 2899.0 |
| 2017-02-16 | GSCI | Futures | 522.75 | 522.75 | 519.09 | 519.54 | 20.0 |
> showing 50 of 110 rows — these rows as CSV