PREVIEW / futures_daily / 2016-05-04
file: by_date/futures_daily/2016/2016-05-04.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-05-04 | ES | Futures | 2209.17 | 2212.13 | 2189.31 | 2197.9 | 1557981.0 |
| 2016-05-04 | NQ | Futures | 5094.24 | 5101.88 | 5043.42 | 5063.99 | 235256.0 |
| 2016-05-04 | YM | Futures | 18380.7 | 18403.6 | 18222.7 | 18279.9 | 162200.0 |
| 2016-05-04 | CL | Futures | 52.24 | 53.46 | 51.49 | 52.15 | 711125.0 |
| 2016-05-04 | GC | Futures | 1659.8 | 1665.0 | 1641.6 | 1642.6 | 212954.0 |
| 2016-05-04 | ZN | Futures | 125.826735 | 126.053042 | 125.675864 | 125.947432 | 1118669.0 |
| 2016-05-04 | A6 | Futures | 0.75593 | 0.75968 | 0.75249 | 0.75361 | 113082.0 |
| 2016-05-04 | AD | Futures | 0.80365 | 0.80529 | 0.79343 | 0.79486 | 109278.0 |
| 2016-05-04 | ALI | Futures | 2196.5 | 2196.5 | 2196.5 | 2196.5 | 0.0 |
| 2016-05-04 | B | Futures | 37.53 | 38.19 | 36.68 | 37.04 | 293821.0 |
| 2016-05-04 | B6 | Futures | 1.5307 | 1.5345 | 1.5228 | 1.5269 | 95738.0 |
| 2016-05-04 | BFX | Futures | 3933.1 | 3933.1 | 3885.0 | 3885.0 | 8.0 |
| 2016-05-04 | BR | Futures | 0.18097 | 0.18321 | 0.18035 | 0.1821 | 2149.0 |
| 2016-05-04 | BZ | Futures | 37.42 | 38.06 | 36.57 | 36.92 | 28903.0 |
| 2016-05-04 | C | Futures | 2423.0 | 2429.0 | 2388.0 | 2425.0 | 13020.0 |
| 2016-05-04 | CB | Futures | 250.293 | 253.006 | 250.293 | 253.006 | 21.0 |
| 2016-05-04 | CC | Futures | 2338.0 | 2340.0 | 2298.0 | 2331.0 | 19714.0 |
| 2016-05-04 | CNH | Futures | 7.0786 | 7.091 | 7.0786 | 7.091 | 15.0 |
| 2016-05-04 | CSC | Futures | 3.439 | 3.439 | 3.42 | 3.424 | 57.0 |
| 2016-05-04 | CT | Futures | 71.72 | 71.88 | 70.87 | 71.41 | 16306.0 |
| 2016-05-04 | DC | Futures | 26.75 | 26.81 | 26.54 | 26.67 | 494.0 |
| 2016-05-04 | DX | Futures | 86.663 | 87.041 | 86.551 | 86.88 | 30460.0 |
| 2016-05-04 | E1 | Futures | 1.31791 | 1.32005 | 1.31226 | 1.31628 | 17836.0 |
| 2016-05-04 | E6 | Futures | 1.34275 | 1.34625 | 1.33879 | 1.34287 | 195794.0 |
| 2016-05-04 | E7 | Futures | 1.3352 | 1.3389 | 1.3316 | 1.3356 | 4041.0 |
| 2016-05-04 | EBM | Futures | 193.99 | 194.31 | 193.02 | 193.66 | 5655.0 |
| 2016-05-04 | ED | Futures | 95.7352 | 95.7449 | 95.7304 | 95.7352 | 245048.0 |
| 2016-05-04 | ER | Futures | 98.264 | 98.264 | 98.259 | 98.264 | 42706.0 |
| 2016-05-04 | EW | Futures | 1537.7 | 1539.4 | 1522.5 | 1528.8 | 15205.0 |
| 2016-05-04 | FBON | Futures | 118.03 | 118.03 | 117.7 | 117.96 | 545.0 |
| 2016-05-04 | FBTP | Futures | 106.24 | 106.29 | 105.83 | 106.04 | 85508.0 |
| 2016-05-04 | FBTS | Futures | 101.078 | 101.087 | 101.033 | 101.051 | 30499.0 |
| 2016-05-04 | FCE | Futures | 3680.1 | 3690.7 | 3627.0 | 3635.1 | 92391.0 |
| 2016-05-04 | FDAX | Futures | 10693.7 | 10714.6 | 10545.4 | 10557.3 | 104770.0 |
| 2016-05-04 | FDIV | Futures | 127.99 | 128.31 | 126.51 | 126.51 | 97.0 |
| 2016-05-04 | FDXM | Futures | 10302.3 | 10317.9 | 10156.5 | 10164.8 | 22390.0 |
| 2016-05-04 | FESX | Futures | 2283.8 | 2289.3 | 2247.9 | 2250.3 | 1501299.0 |
| 2016-05-04 | FGBL | Futures | 145.7 | 145.87 | 145.49 | 145.77 | 736786.0 |
| 2016-05-04 | FGBM | Futures | 127.5 | 127.53 | 127.41 | 127.51 | 509967.0 |
| 2016-05-04 | FGBS | Futures | 111.638 | 111.653 | 111.623 | 111.643 | 178586.0 |
| 2016-05-04 | FGBX | Futures | 171.62 | 172.09 | 170.73 | 171.43 | 36157.0 |
| 2016-05-04 | FMWO | Futures | 5619.1 | 5619.1 | 5568.1 | 5568.1 | 76.0 |
| 2016-05-04 | FOAT | Futures | 133.11 | 133.19 | 132.87 | 133.14 | 130446.0 |
| 2016-05-04 | FTDX | Futures | 1530.0 | 1533.3 | 1512.3 | 1522.3 | 281.0 |
| 2016-05-04 | FTI | Futures | 388.58 | 390.25 | 384.25 | 385.15 | 31164.0 |
| 2016-05-04 | FTUK | Futures | 5080.8 | 5085.3 | 4996.2 | 5001.1 | 141817.0 |
| 2016-05-04 | FVSA | Futures | 2770.36 | 2833.32 | 2728.38 | 2828.07 | 14593.0 |
| 2016-05-04 | FXXP | Futures | 267.0 | 267.2 | 263.0 | 263.3 | 37442.0 |
| 2016-05-04 | G | Futures | 107.67 | 108.0 | 107.58 | 107.81 | 183342.0 |
| 2016-05-04 | GF | Futures | 284.793 | 290.286 | 283.944 | 289.487 | 2633.0 |
> showing 50 of 110 rows — these rows as CSV