PREVIEW / futures_daily / 2017-05-03
file: by_date/futures_daily/2017/2017-05-03.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-05-03 | ES | Futures | 2589.13 | 2591.3 | 2579.9 | 2588.31 | 1076558.0 |
| 2017-05-03 | NQ | Futures | 6620.35 | 6632.13 | 6602.69 | 6611.23 | 206431.0 |
| 2017-05-03 | YM | Futures | 22006.6 | 22060.4 | 21952.8 | 22030.9 | 97914.0 |
| 2017-05-03 | CL | Futures | 50.21 | 50.32 | 49.35 | 49.89 | 691319.0 |
| 2017-05-03 | GC | Futures | 1608.5 | 1608.5 | 1581.1 | 1596.6 | 253653.0 |
| 2017-05-03 | ZN | Futures | 123.674642 | 123.720732 | 123.305923 | 123.444193 | 1169980.0 |
| 2017-05-03 | A6 | Futures | 0.7727 | 0.77393 | 0.761 | 0.76192 | 107226.0 |
| 2017-05-03 | AD | Futures | 0.74427 | 0.74652 | 0.74264 | 0.74437 | 76293.0 |
| 2017-05-03 | ALI | Futures | 2574.66 | 2574.66 | 2574.66 | 2574.66 | 0.0 |
| 2017-05-03 | B | Futures | 36.57 | 36.68 | 36.0 | 36.43 | 357189.0 |
| 2017-05-03 | B6 | Futures | 1.3581 | 1.3592 | 1.3502 | 1.3528 | 97699.0 |
| 2017-05-03 | BR | Futures | 0.22799 | 0.2289 | 0.22705 | 0.22832 | 1651.0 |
| 2017-05-03 | BZ | Futures | 36.35 | 36.4 | 35.75 | 36.16 | 34131.0 |
| 2017-05-03 | C | Futures | 1430.0 | 1430.0 | 1402.0 | 1410.0 | 5815.0 |
| 2017-05-03 | CB | Futures | 259.983 | 261.692 | 259.983 | 261.692 | 16.0 |
| 2017-05-03 | CC | Futures | 1365.0 | 1370.0 | 1355.0 | 1361.0 | 14633.0 |
| 2017-05-03 | CNH | Futures | 7.2159 | 7.2159 | 7.2135 | 7.2135 | 9.0 |
| 2017-05-03 | CSC | Futures | 3.498 | 3.498 | 3.464 | 3.482 | 85.0 |
| 2017-05-03 | CT | Futures | 87.9 | 87.98 | 87.08 | 87.24 | 10282.0 |
| 2017-05-03 | DC | Futures | 28.93 | 29.01 | 28.71 | 28.76 | 358.0 |
| 2017-05-03 | DX | Futures | 92.02 | 92.486 | 92.002 | 92.311 | 27166.0 |
| 2017-05-03 | E1 | Futures | 1.24947 | 1.25281 | 1.24515 | 1.24762 | 23330.0 |
| 2017-05-03 | E6 | Futures | 1.26181 | 1.26262 | 1.25628 | 1.25876 | 144240.0 |
| 2017-05-03 | E7 | Futures | 1.2553 | 1.2562 | 1.2498 | 1.2523 | 3463.0 |
| 2017-05-03 | EBM | Futures | 188.46 | 192.38 | 188.18 | 191.82 | 13103.0 |
| 2017-05-03 | ED | Futures | 95.5639 | 95.5736 | 95.5542 | 95.5542 | 259516.0 |
| 2017-05-03 | ER | Futures | 98.337 | 98.352 | 98.337 | 98.342 | 187499.0 |
| 2017-05-03 | EW | Futures | 1840.2 | 1840.6 | 1826.3 | 1833.5 | 12328.0 |
| 2017-05-03 | FBON | Futures | 122.04 | 122.38 | 121.97 | 122.25 | 423.0 |
| 2017-05-03 | FBTP | Futures | 105.4 | 105.87 | 105.4 | 105.74 | 77974.0 |
| 2017-05-03 | FBTS | Futures | 102.081 | 102.136 | 102.081 | 102.136 | 24836.0 |
| 2017-05-03 | FCE | Futures | 4686.2 | 4689.7 | 4665.7 | 4682.6 | 67198.0 |
| 2017-05-03 | FDAX | Futures | 13214.8 | 13247.5 | 13183.1 | 13227.0 | 60053.0 |
| 2017-05-03 | FDXM | Futures | 13104.5 | 13131.7 | 13067.9 | 13110.8 | 14673.0 |
| 2017-05-03 | FESX | Futures | 2878.1 | 2888.7 | 2871.6 | 2882.2 | 626893.0 |
| 2017-05-03 | FEU3 | Futures | 99.016 | 99.016 | 99.016 | 99.016 | 54.0 |
| 2017-05-03 | FGBL | Futures | 148.67 | 148.83 | 148.45 | 148.6 | 531350.0 |
| 2017-05-03 | FGBM | Futures | 129.31 | 129.4 | 129.22 | 129.31 | 403479.0 |
| 2017-05-03 | FGBS | Futures | 112.282 | 112.317 | 112.277 | 112.292 | 164775.0 |
| 2017-05-03 | FGBX | Futures | 168.65 | 169.35 | 168.37 | 168.63 | 32801.0 |
| 2017-05-03 | FMWO | Futures | 6327.8 | 6330.2 | 6312.1 | 6319.3 | 2577.0 |
| 2017-05-03 | FOAT | Futures | 134.29 | 134.56 | 134.23 | 134.37 | 111399.0 |
| 2017-05-03 | FTDX | Futures | 2083.2 | 2087.6 | 2068.5 | 2076.4 | 257.0 |
| 2017-05-03 | FTI | Futures | 477.49 | 478.69 | 476.39 | 477.68 | 14661.0 |
| 2017-05-03 | FTUK | Futures | 6161.1 | 6165.8 | 6133.3 | 6141.8 | 63226.0 |
| 2017-05-03 | FVSA | Futures | 572.66 | 579.82 | 558.35 | 560.13 | 35059.0 |
| 2017-05-03 | FXXP | Futures | 324.9 | 326.1 | 324.6 | 325.2 | 19012.0 |
| 2017-05-03 | G | Futures | 115.67 | 115.84 | 115.58 | 115.77 | 118144.0 |
| 2017-05-03 | GF | Futures | 344.089 | 353.082 | 340.939 | 351.249 | 3316.0 |
| 2017-05-03 | GSCI | Futures | 474.87 | 475.37 | 472.99 | 475.37 | 1190.0 |
> showing 50 of 110 rows — these rows as CSV