PREVIEW / futures_daily / 2017-05-30
file: by_date/futures_daily/2017/2017-05-30.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 |
|---|---|---|---|---|---|---|---|
| 2017-05-30 | ES | Futures | 2621.71 | 2624.97 | 2614.92 | 2618.18 | 1040285.0 |
| 2017-05-30 | NQ | Futures | 6822.93 | 6835.3 | 6805.56 | 6821.76 | 197717.0 |
| 2017-05-30 | YM | Futures | 22232.4 | 22254.6 | 22156.4 | 22174.4 | 101700.0 |
| 2017-05-30 | CL | Futures | 51.72 | 52.08 | 50.79 | 51.44 | 663486.0 |
| 2017-05-30 | GC | Futures | 1622.8 | 1625.6 | 1610.8 | 1615.8 | 286212.0 |
| 2017-05-30 | ZN | Futures | 124.058725 | 124.381355 | 123.935819 | 124.319901 | 1822122.0 |
| 2017-05-30 | A6 | Futures | 0.76367 | 0.76654 | 0.7611 | 0.76613 | 92207.0 |
| 2017-05-30 | AD | Futures | 0.75824 | 0.75972 | 0.75529 | 0.75758 | 51683.0 |
| 2017-05-30 | ALI | Futures | 2523.01 | 2523.01 | 2523.01 | 2523.01 | 0.0 |
| 2017-05-30 | B | Futures | 37.41 | 37.48 | 36.71 | 37.16 | 370004.0 |
| 2017-05-30 | B6 | Futures | 1.344 | 1.3519 | 1.342 | 1.3487 | 131518.0 |
| 2017-05-30 | BR | Futures | 0.22222 | 0.22297 | 0.22222 | 0.22297 | 696.0 |
| 2017-05-30 | BZ | Futures | 37.3 | 37.5 | 36.56 | 37.0 | 36278.0 |
| 2017-05-30 | C | Futures | 1517.0 | 1603.0 | 1499.0 | 1601.0 | 22940.0 |
| 2017-05-30 | CB | Futures | 299.241 | 301.065 | 296.808 | 296.808 | 13.0 |
| 2017-05-30 | CC | Futures | 1469.0 | 1560.0 | 1468.0 | 1557.0 | 35761.0 |
| 2017-05-30 | CNH | Futures | 7.1311 | 7.136 | 7.1235 | 7.1263 | 81.0 |
| 2017-05-30 | CSC | Futures | 3.633 | 3.633 | 3.612 | 3.612 | 64.0 |
| 2017-05-30 | CT | Futures | 85.39 | 86.02 | 85.17 | 85.56 | 12043.0 |
| 2017-05-30 | DC | Futures | 30.26 | 30.61 | 30.26 | 30.28 | 90.0 |
| 2017-05-30 | DX | Futures | 90.944 | 91.024 | 90.506 | 90.569 | 27990.0 |
| 2017-05-30 | E1 | Futures | 1.26912 | 1.27122 | 1.26133 | 1.26961 | 37596.0 |
| 2017-05-30 | E6 | Futures | 1.28848 | 1.29199 | 1.28088 | 1.28998 | 257785.0 |
| 2017-05-30 | E7 | Futures | 1.2822 | 1.2853 | 1.2743 | 1.2834 | 5911.0 |
| 2017-05-30 | EBM | Futures | 187.34 | 187.62 | 185.11 | 185.39 | 9025.0 |
| 2017-05-30 | ED | Futures | 95.5905 | 95.6002 | 95.5905 | 95.593 | 253724.0 |
| 2017-05-30 | ER | Futures | 98.337 | 98.337 | 98.332 | 98.337 | 24838.0 |
| 2017-05-30 | EW | Futures | 1834.2 | 1836.6 | 1823.1 | 1828.6 | 13708.0 |
| 2017-05-30 | FBON | Futures | 124.2 | 124.2 | 123.28 | 123.7 | 1079.0 |
| 2017-05-30 | FBTP | Futures | 106.9 | 107.0 | 106.49 | 106.8 | 159729.0 |
| 2017-05-30 | FBTS | Futures | 102.525 | 102.525 | 102.426 | 102.471 | 66986.0 |
| 2017-05-30 | FCE | Futures | 4751.5 | 4751.5 | 4712.9 | 4743.9 | 72472.0 |
| 2017-05-30 | FDAX | Futures | 13312.5 | 13352.1 | 13262.3 | 13289.8 | 73402.0 |
| 2017-05-30 | FDXM | Futures | 13195.5 | 13235.3 | 13145.3 | 13173.0 | 24505.0 |
| 2017-05-30 | FESX | Futures | 2901.8 | 2904.3 | 2884.7 | 2895.3 | 826176.0 |
| 2017-05-30 | FGBL | Futures | 149.15 | 149.28 | 148.94 | 149.19 | 781453.0 |
| 2017-05-30 | FGBM | Futures | 129.76 | 129.81 | 129.59 | 129.7 | 608805.0 |
| 2017-05-30 | FGBS | Futures | 112.367 | 112.372 | 112.307 | 112.332 | 243161.0 |
| 2017-05-30 | FGBX | Futures | 168.39 | 168.77 | 167.75 | 168.17 | 39313.0 |
| 2017-05-30 | FMWO | Futures | 6415.7 | 6432.6 | 6415.7 | 6430.2 | 1023.0 |
| 2017-05-30 | FOAT | Futures | 135.53 | 135.65 | 135.34 | 135.6 | 105736.0 |
| 2017-05-30 | FTDX | Futures | 2237.6 | 2243.5 | 2225.4 | 2239.6 | 106.0 |
| 2017-05-30 | FTI | Futures | 482.95 | 483.27 | 480.15 | 481.67 | 25302.0 |
| 2017-05-30 | FTUK | Futures | 6450.4 | 6450.4 | 6401.6 | 6425.5 | 100403.0 |
| 2017-05-30 | FVSA | Futures | 516.36 | 521.44 | 506.2 | 518.05 | 18252.0 |
| 2017-05-30 | FXXP | Futures | 329.2 | 329.4 | 327.6 | 328.6 | 37014.0 |
| 2017-05-30 | G | Futures | 116.75 | 116.79 | 116.25 | 116.48 | 158564.0 |
| 2017-05-30 | GF | Futures | 322.143 | 329.827 | 318.796 | 329.113 | 6282.0 |
| 2017-05-30 | GSCI | Futures | 470.57 | 471.99 | 469.84 | 471.44 | 67.0 |
| 2017-05-30 | HE | Futures | 88.34 | 88.395 | 86.988 | 87.096 | 6174.0 |
> showing 50 of 109 rows — these rows as CSV