PREVIEW / futures_daily / 2018-06-14
file: by_date/futures_daily/2018/2018-06-14.parquet size: 10 KB rows: 114
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 |
|---|---|---|---|---|---|---|---|
| 2018-06-14 | ES | Futures | 3016.91 | 3034.56 | 3010.93 | 3028.58 | 1275141.0 |
| 2018-06-14 | NQ | Futures | 8432.09 | 8535.57 | 8400.62 | 8524.2 | 335148.0 |
| 2018-06-14 | YM | Futures | 26560.4 | 26714.3 | 26499.3 | 26563.6 | 178514.0 |
| 2018-06-14 | CL | Futures | 67.35 | 67.9 | 67.04 | 67.55 | 294351.0 |
| 2018-06-14 | GC | Futures | 1663.6 | 1676.3 | 1661.0 | 1670.3 | 347193.0 |
| 2018-06-14 | ZN | Futures | 118.608816 | 118.919595 | 118.531121 | 118.779744 | 1604785.0 |
| 2018-06-14 | A6 | Futures | 0.77972 | 0.78034 | 0.76912 | 0.77015 | 69962.0 |
| 2018-06-14 | AD | Futures | 0.78161 | 0.78359 | 0.77396 | 0.77447 | 79027.0 |
| 2018-06-14 | B | Futures | 56.06 | 56.33 | 55.48 | 55.61 | 279214.0 |
| 2018-06-14 | B6 | Futures | 1.3861 | 1.3933 | 1.3733 | 1.3761 | 112191.0 |
| 2018-06-14 | BR | Futures | 0.20338 | 0.2038 | 0.19706 | 0.19942 | 49.0 |
| 2018-06-14 | BTC | Futures | 8917.6 | 9528.7 | 8882.1 | 9429.2 | 4461.0 |
| 2018-06-14 | BZ | Futures | 55.53 | 55.79 | 54.96 | 55.09 | 24181.0 |
| 2018-06-14 | C | Futures | 1486.0 | 1539.0 | 1484.0 | 1535.0 | 5078.0 |
| 2018-06-14 | CB | Futures | 289.853 | 290.153 | 289.103 | 289.313 | 45.0 |
| 2018-06-14 | CC | Futures | 1717.0 | 1759.0 | 1714.0 | 1744.0 | 20588.0 |
| 2018-06-14 | CNH | Futures | 6.4762 | 6.5065 | 6.4762 | 6.5041 | 103.0 |
| 2018-06-14 | CSC | Futures | 3.45 | 3.452 | 3.421 | 3.437 | 181.0 |
| 2018-06-14 | CT | Futures | 106.46 | 107.42 | 105.27 | 106.18 | 13682.0 |
| 2018-06-14 | DC | Futures | 27.91 | 27.96 | 27.58 | 27.74 | 168.0 |
| 2018-06-14 | DX | Futures | 88.213 | 89.601 | 87.91 | 89.431 | 57029.0 |
| 2018-06-14 | E1 | Futures | 1.22225 | 1.22572 | 1.20767 | 1.20875 | 40851.0 |
| 2018-06-14 | E6 | Futures | 1.32818 | 1.33528 | 1.30206 | 1.30542 | 323920.0 |
| 2018-06-14 | E7 | Futures | 1.3215 | 1.3285 | 1.2955 | 1.2988 | 7428.0 |
| 2018-06-14 | EBM | Futures | 187.27 | 189.88 | 186.48 | 188.57 | 27060.0 |
| 2018-06-14 | ED | Futures | 94.9474 | 94.9572 | 94.9426 | 94.9523 | 283915.0 |
| 2018-06-14 | ER | Futures | 98.352 | 98.362 | 98.347 | 98.357 | 103136.0 |
| 2018-06-14 | EW | Futures | 2113.8 | 2121.9 | 2107.3 | 2119.6 | 13376.0 |
| 2018-06-14 | FBON | Futures | 128.04 | 128.82 | 127.86 | 128.68 | 494.0 |
| 2018-06-14 | FBTP | Futures | 106.15 | 106.99 | 105.21 | 106.7 | 88708.0 |
| 2018-06-14 | FBTS | Futures | 102.021 | 102.485 | 101.706 | 102.392 | 46705.0 |
| 2018-06-14 | FCE | Futures | 4882.0 | 4987.1 | 4853.6 | 4962.8 | 78738.0 |
| 2018-06-14 | FDAX | Futures | 13340.8 | 13703.5 | 13298.2 | 13644.3 | 129367.0 |
| 2018-06-14 | FDIV | Futures | 154.83 | 155.81 | 154.83 | 155.81 | 8.0 |
| 2018-06-14 | FDXM | Futures | 13237.2 | 13588.1 | 13193.9 | 13533.4 | 4325.0 |
| 2018-06-14 | FESX | Futures | 2891.5 | 2954.1 | 2878.9 | 2943.3 | 1188282.0 |
| 2018-06-14 | FGBL | Futures | 150.76 | 151.56 | 150.25 | 151.43 | 954338.0 |
| 2018-06-14 | FGBM | Futures | 130.15 | 130.64 | 129.84 | 130.52 | 662678.0 |
| 2018-06-14 | FGBS | Futures | 112.598 | 112.693 | 112.547 | 112.683 | 535585.0 |
| 2018-06-14 | FGBX | Futures | 172.23 | 173.13 | 171.55 | 172.79 | 87447.0 |
| 2018-06-14 | FMWO | Futures | 7099.8 | 7134.8 | 7099.8 | 7133.6 | 988.0 |
| 2018-06-14 | FOAT | Futures | 138.66 | 139.78 | 138.36 | 139.68 | 210398.0 |
| 2018-06-14 | FTDX | Futures | 2839.2 | 2886.8 | 2830.9 | 2882.8 | 3434.0 |
| 2018-06-14 | FTI | Futures | 518.61 | 525.21 | 514.13 | 523.78 | 21506.0 |
| 2018-06-14 | FTUK | Futures | 6808.9 | 6886.5 | 6739.9 | 6879.8 | 150059.0 |
| 2018-06-14 | FVSA | Futures | 285.73 | 290.59 | 255.6 | 258.52 | 52090.0 |
| 2018-06-14 | FXXP | Futures | 332.7 | 339.3 | 331.7 | 338.9 | 44996.0 |
| 2018-06-14 | G | Futures | 114.44 | 115.04 | 114.31 | 114.89 | 218675.0 |
| 2018-06-14 | GF | Futures | 301.103 | 301.828 | 296.752 | 297.633 | 6344.0 |
| 2018-06-14 | GSCI | Futures | 536.18 | 536.18 | 531.24 | 532.25 | 239.0 |
> showing 50 of 114 rows — these rows as CSV