PREVIEW / futures_daily / 2018-07-13
file: by_date/futures_daily/2018/2018-07-13.parquet size: 10 KB rows: 115
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-07-13 | ES | Futures | 3039.44 | 3048.95 | 3033.74 | 3044.6 | 952307.0 |
| 2018-07-13 | NQ | Futures | 8606.69 | 8644.29 | 8589.2 | 8619.51 | 279818.0 |
| 2018-07-13 | YM | Futures | 26240.1 | 26371.8 | 26204.3 | 26346.5 | 140813.0 |
| 2018-07-13 | CL | Futures | 71.29 | 72.59 | 70.74 | 71.93 | 530277.0 |
| 2018-07-13 | GC | Futures | 1592.9 | 1593.9 | 1578.2 | 1584.6 | 257313.0 |
| 2018-07-13 | ZN | Futures | 119.556692 | 119.72762 | 119.463458 | 119.696543 | 822694.0 |
| 2018-07-13 | A6 | Futures | 0.76172 | 0.76336 | 0.75771 | 0.76234 | 75454.0 |
| 2018-07-13 | AD | Futures | 0.77042 | 0.77092 | 0.76758 | 0.77037 | 49872.0 |
| 2018-07-13 | B | Futures | 54.84 | 56.01 | 54.01 | 55.57 | 302426.0 |
| 2018-07-13 | B6 | Futures | 1.366 | 1.3696 | 1.3554 | 1.3684 | 133454.0 |
| 2018-07-13 | BFX | Futures | 4391.9 | 4412.7 | 4391.9 | 4412.7 | 1.0 |
| 2018-07-13 | BR | Futures | 0.19652 | 0.19652 | 0.19618 | 0.19618 | 1.0 |
| 2018-07-13 | BTC | Futures | 8775.5 | 9032.0 | 8633.1 | 8782.7 | 3558.0 |
| 2018-07-13 | BZ | Futures | 54.53 | 55.7 | 53.73 | 55.27 | 27308.0 |
| 2018-07-13 | C | Futures | 1722.0 | 1750.0 | 1722.0 | 1749.0 | 11445.0 |
| 2018-07-13 | CB | Futures | 271.533 | 272.283 | 271.533 | 272.283 | 3.0 |
| 2018-07-13 | CC | Futures | 1776.0 | 1805.0 | 1758.0 | 1801.0 | 16821.0 |
| 2018-07-13 | CNH | Futures | 6.7506 | 6.794 | 6.7506 | 6.7893 | 11.0 |
| 2018-07-13 | CSC | Futures | 3.238 | 3.238 | 3.194 | 3.212 | 144.0 |
| 2018-07-13 | CT | Futures | 100.7 | 100.86 | 98.76 | 99.75 | 54.0 |
| 2018-07-13 | DC | Futures | 25.63 | 25.63 | 25.21 | 25.43 | 273.0 |
| 2018-07-13 | DX | Futures | 89.634 | 89.975 | 89.435 | 89.501 | 17519.0 |
| 2018-07-13 | E1 | Futures | 1.19847 | 1.19955 | 1.19309 | 1.19871 | 29647.0 |
| 2018-07-13 | E6 | Futures | 1.31106 | 1.31313 | 1.30475 | 1.31196 | 197721.0 |
| 2018-07-13 | E7 | Futures | 1.3043 | 1.3064 | 1.2982 | 1.3053 | 3057.0 |
| 2018-07-13 | EBM | Futures | 191.71 | 193.02 | 189.88 | 191.97 | 20829.0 |
| 2018-07-13 | ED | Futures | 94.9815 | 94.9913 | 94.9767 | 94.9864 | 143734.0 |
| 2018-07-13 | ER | Futures | 98.367 | 98.367 | 98.362 | 98.367 | 27511.0 |
| 2018-07-13 | EW | Futures | 2116.5 | 2128.2 | 2112.8 | 2116.8 | 10730.0 |
| 2018-07-13 | FBON | Futures | 129.35 | 129.72 | 129.35 | 129.66 | 373.0 |
| 2018-07-13 | FBTP | Futures | 108.44 | 109.2 | 108.29 | 108.99 | 49461.0 |
| 2018-07-13 | FBTS | Futures | 102.726 | 102.837 | 102.577 | 102.744 | 20596.0 |
| 2018-07-13 | FCE | Futures | 4862.1 | 4875.1 | 4859.0 | 4868.8 | 1453.0 |
| 2018-07-13 | FDAX | Futures | 13092.8 | 13142.5 | 13049.9 | 13101.2 | 70401.0 |
| 2018-07-13 | FDXM | Futures | 12926.6 | 12974.1 | 12883.2 | 12933.8 | 22990.0 |
| 2018-07-13 | FESX | Futures | 2879.8 | 2889.0 | 2873.1 | 2879.8 | 684877.0 |
| 2018-07-13 | FEU3 | Futures | 99.011 | 99.016 | 99.011 | 99.016 | 80.0 |
| 2018-07-13 | FGBL | Futures | 153.29 | 153.8 | 153.27 | 153.57 | 453226.0 |
| 2018-07-13 | FGBM | Futures | 131.16 | 131.38 | 131.15 | 131.27 | 289147.0 |
| 2018-07-13 | FGBS | Futures | 112.708 | 112.734 | 112.703 | 112.713 | 219279.0 |
| 2018-07-13 | FGBX | Futures | 178.16 | 179.2 | 178.0 | 178.4 | 31969.0 |
| 2018-07-13 | FMWO | Futures | 7109.0 | 7117.2 | 7088.1 | 7116.0 | 2680.0 |
| 2018-07-13 | FOAT | Futures | 141.36 | 141.77 | 141.34 | 141.63 | 69801.0 |
| 2018-07-13 | FTDX | Futures | 2771.0 | 2780.4 | 2756.3 | 2763.7 | 103.0 |
| 2018-07-13 | FTI | Futures | 512.89 | 514.83 | 512.89 | 514.32 | 596.0 |
| 2018-07-13 | FTUK | Futures | 6787.6 | 6821.4 | 6768.0 | 6775.5 | 64844.0 |
| 2018-07-13 | FVSA | Futures | 276.11 | 280.89 | 271.33 | 272.29 | 19610.0 |
| 2018-07-13 | FXXP | Futures | 332.1 | 333.1 | 331.4 | 332.0 | 34782.0 |
| 2018-07-13 | G | Futures | 115.59 | 115.86 | 115.52 | 115.59 | 152219.0 |
| 2018-07-13 | GF | Futures | 313.014 | 313.843 | 310.839 | 312.237 | 5092.0 |
> showing 50 of 115 rows — these rows as CSV