PREVIEW / futures_daily / 2016-05-05
file: by_date/futures_daily/2016/2016-05-05.parquet size: 10 KB rows: 111
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-05 | ES | Futures | 2197.36 | 2211.86 | 2189.85 | 2194.68 | 1433289.0 |
| 2016-05-05 | NQ | Futures | 5062.22 | 5102.47 | 5043.72 | 5052.82 | 221674.0 |
| 2016-05-05 | YM | Futures | 18273.6 | 18384.9 | 18233.1 | 18272.6 | 130181.0 |
| 2016-05-05 | CL | Futures | 52.46 | 54.88 | 52.37 | 52.8 | 746159.0 |
| 2016-05-05 | GC | Futures | 1651.4 | 1660.7 | 1637.7 | 1639.9 | 174581.0 |
| 2016-05-05 | ZN | Futures | 126.007781 | 126.369872 | 125.766386 | 126.234088 | 1192171.0 |
| 2016-05-05 | A6 | Futures | 0.75381 | 0.75938 | 0.7535 | 0.75391 | 89794.0 |
| 2016-05-05 | AD | Futures | 0.79455 | 0.79977 | 0.79415 | 0.79496 | 75649.0 |
| 2016-05-05 | ALI | Futures | 2179.05 | 2179.05 | 2168.38 | 2168.38 | 5.0 |
| 2016-05-05 | B | Futures | 37.42 | 38.82 | 37.06 | 37.36 | 280794.0 |
| 2016-05-05 | B6 | Futures | 1.527 | 1.5301 | 1.521 | 1.5245 | 79399.0 |
| 2016-05-05 | BR | Futures | 0.18321 | 0.18523 | 0.18194 | 0.18243 | 820.0 |
| 2016-05-05 | BZ | Futures | 37.23 | 38.69 | 36.95 | 37.24 | 24432.0 |
| 2016-05-05 | C | Futures | 2418.0 | 2418.0 | 2398.0 | 2399.0 | 4041.0 |
| 2016-05-05 | CB | Futures | 253.006 | 254.866 | 252.976 | 252.976 | 14.0 |
| 2016-05-05 | CC | Futures | 2325.0 | 2330.0 | 2297.0 | 2310.0 | 12492.0 |
| 2016-05-05 | CNH | Futures | 7.0886 | 7.0929 | 7.0886 | 7.0929 | 3.0 |
| 2016-05-05 | CSC | Futures | 3.436 | 3.436 | 3.401 | 3.436 | 136.0 |
| 2016-05-05 | CT | Futures | 71.59 | 72.29 | 70.1 | 70.29 | 20133.0 |
| 2016-05-05 | DC | Futures | 26.75 | 26.87 | 26.44 | 26.87 | 391.0 |
| 2016-05-05 | DX | Futures | 86.929 | 87.507 | 86.864 | 87.432 | 18224.0 |
| 2016-05-05 | E1 | Futures | 1.31401 | 1.31502 | 1.29768 | 1.29869 | 21726.0 |
| 2016-05-05 | E6 | Futures | 1.341 | 1.34194 | 1.32928 | 1.3308 | 171211.0 |
| 2016-05-05 | E7 | Futures | 1.3338 | 1.3347 | 1.3222 | 1.3236 | 2748.0 |
| 2016-05-05 | EBM | Futures | 193.66 | 193.96 | 191.26 | 191.56 | 5802.0 |
| 2016-05-05 | ED | Futures | 95.7401 | 95.7449 | 95.7352 | 95.7401 | 196548.0 |
| 2016-05-05 | ER | Futures | 98.264 | 98.264 | 98.259 | 98.259 | 12384.0 |
| 2016-05-05 | EW | Futures | 1529.4 | 1538.5 | 1521.9 | 1526.2 | 12511.0 |
| 2016-05-05 | FBON | Futures | 117.77 | 118.04 | 117.6 | 117.89 | 865.0 |
| 2016-05-05 | FBTP | Futures | 105.98 | 106.03 | 105.65 | 105.87 | 90882.0 |
| 2016-05-05 | FBTS | Futures | 101.051 | 101.06 | 101.033 | 101.042 | 18647.0 |
| 2016-05-05 | FCE | Futures | 3650.4 | 3665.2 | 3626.6 | 3641.4 | 70629.0 |
| 2016-05-05 | FDAX | Futures | 10623.9 | 10665.8 | 10533.1 | 10558.3 | 85804.0 |
| 2016-05-05 | FDIV | Futures | 126.64 | 126.64 | 126.51 | 126.51 | 15.0 |
| 2016-05-05 | FDXM | Futures | 10219.6 | 10269.2 | 10144.1 | 10166.8 | 15767.0 |
| 2016-05-05 | FESX | Futures | 2267.4 | 2277.6 | 2251.1 | 2254.2 | 1029027.0 |
| 2016-05-05 | FEU3 | Futures | 98.917 | 98.917 | 98.917 | 98.917 | 6.0 |
| 2016-05-05 | FGBL | Futures | 145.78 | 146.56 | 145.55 | 146.24 | 546274.0 |
| 2016-05-05 | FGBM | Futures | 127.47 | 127.73 | 127.47 | 127.65 | 435114.0 |
| 2016-05-05 | FGBS | Futures | 111.638 | 111.678 | 111.633 | 111.663 | 148834.0 |
| 2016-05-05 | FGBX | Futures | 171.6 | 173.99 | 170.71 | 172.75 | 20893.0 |
| 2016-05-05 | FMWO | Futures | 5601.7 | 5612.9 | 5570.6 | 5570.6 | 1915.0 |
| 2016-05-05 | FOAT | Futures | 133.13 | 133.56 | 132.88 | 133.4 | 57172.0 |
| 2016-05-05 | FTDX | Futures | 1532.8 | 1532.8 | 1519.5 | 1523.3 | 123.0 |
| 2016-05-05 | FTI | Futures | 386.64 | 388.45 | 385.1 | 387.18 | 23816.0 |
| 2016-05-05 | FTUK | Futures | 5022.6 | 5046.9 | 5002.4 | 5008.5 | 87167.0 |
| 2016-05-05 | FVSA | Futures | 2791.34 | 2791.34 | 2707.39 | 2770.36 | 9109.0 |
| 2016-05-05 | FXXP | Futures | 264.7 | 266.3 | 263.9 | 264.2 | 16878.0 |
| 2016-05-05 | G | Futures | 107.81 | 108.44 | 107.74 | 108.24 | 209251.0 |
| 2016-05-05 | GF | Futures | 289.587 | 296.128 | 289.587 | 295.529 | 2689.0 |
> showing 50 of 111 rows — these rows as CSV