PREVIEW / futures_daily / 2019-02-12
file: by_date/futures_daily/2019/2019-02-12.parquet size: 10 KB rows: 116
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 |
|---|---|---|---|---|---|---|---|
| 2019-02-12 | ES | Futures | 2930.79 | 2975.18 | 2929.16 | 2971.66 | 1307152.0 |
| 2019-02-12 | NQ | Futures | 7998.34 | 8137.27 | 7991.97 | 8125.69 | 363950.0 |
| 2019-02-12 | YM | Futures | 26381.9 | 26832.3 | 26371.4 | 26797.5 | 172650.0 |
| 2019-02-12 | CL | Futures | 54.56 | 56.24 | 54.45 | 55.27 | 245522.0 |
| 2019-02-12 | GC | Futures | 1639.5 | 1647.9 | 1637.5 | 1642.5 | 146448.0 |
| 2019-02-12 | ZN | Futures | 121.689342 | 121.704903 | 121.393677 | 121.455923 | 1143327.0 |
| 2019-02-12 | A6 | Futures | 0.72766 | 0.73219 | 0.72714 | 0.73178 | 85048.0 |
| 2019-02-12 | AD | Futures | 0.76147 | 0.76567 | 0.76101 | 0.76516 | 49316.0 |
| 2019-02-12 | B | Futures | 44.65 | 45.92 | 44.65 | 45.26 | 278798.0 |
| 2019-02-12 | B6 | Futures | 1.3225 | 1.3277 | 1.3199 | 1.3266 | 85516.0 |
| 2019-02-12 | BR | Futures | 0.21177 | 0.21516 | 0.21177 | 0.21476 | 2151.0 |
| 2019-02-12 | BTC | Futures | 5300.7 | 5344.9 | 5234.3 | 5315.4 | 3944.0 |
| 2019-02-12 | BZ | Futures | 44.19 | 45.43 | 44.15 | 44.78 | 36801.0 |
| 2019-02-12 | C | Futures | 1506.0 | 1515.0 | 1493.0 | 1496.0 | 5694.0 |
| 2019-02-12 | CB | Futures | 277.938 | 277.938 | 275.174 | 275.174 | 26.0 |
| 2019-02-12 | CC | Futures | 1527.0 | 1546.0 | 1521.0 | 1532.0 | 27897.0 |
| 2019-02-12 | CNH | Futures | 6.8068 | 6.8166 | 6.7818 | 6.7824 | 1546.0 |
| 2019-02-12 | CSC | Futures | 2.782 | 2.829 | 2.777 | 2.816 | 208.0 |
| 2019-02-12 | CT | Futures | 76.93 | 77.27 | 75.95 | 76.01 | 22365.0 |
| 2019-02-12 | DC | Futures | 23.47 | 23.92 | 23.47 | 23.81 | 411.0 |
| 2019-02-12 | DX | Futures | 92.385 | 92.509 | 91.979 | 92.035 | 18517.0 |
| 2019-02-12 | E1 | Futures | 1.17478 | 1.1749 | 1.16866 | 1.17207 | 20529.0 |
| 2019-02-12 | E6 | Futures | 1.24945 | 1.25652 | 1.2474 | 1.25564 | 190032.0 |
| 2019-02-12 | E7 | Futures | 1.2435 | 1.2504 | 1.2414 | 1.2495 | 3681.0 |
| 2019-02-12 | EBM | Futures | 207.68 | 208.2 | 206.14 | 207.17 | 22105.0 |
| 2019-02-12 | ED | Futures | 95.0721 | 95.0769 | 95.0623 | 95.0672 | 113112.0 |
| 2019-02-12 | ER | Futures | 98.401 | 98.406 | 98.401 | 98.401 | 37137.0 |
| 2019-02-12 | EW | Futures | 1984.7 | 2010.2 | 1983.6 | 2006.7 | 12485.0 |
| 2019-02-12 | FBON | Futures | 131.76 | 132.01 | 131.67 | 131.81 | 514.0 |
| 2019-02-12 | FBTP | Futures | 110.66 | 111.27 | 110.56 | 111.21 | 81515.0 |
| 2019-02-12 | FBTS | Futures | 104.622 | 104.859 | 104.594 | 104.84 | 52001.0 |
| 2019-02-12 | FCE | Futures | 4491.2 | 4524.2 | 4491.2 | 4508.1 | 143994.0 |
| 2019-02-12 | FDAX | Futures | 11572.5 | 11730.2 | 11569.9 | 11703.4 | 88024.0 |
| 2019-02-12 | FDIV | Futures | 137.11 | 137.46 | 137.11 | 137.46 | 5.0 |
| 2019-02-12 | FDXM | Futures | 11551.2 | 11701.1 | 11543.8 | 11674.9 | 35224.0 |
| 2019-02-12 | FESX | Futures | 2701.3 | 2732.9 | 2700.4 | 2727.8 | 832001.0 |
| 2019-02-12 | FEU3 | Futures | 99.001 | 99.001 | 99.001 | 99.001 | 500.0 |
| 2019-02-12 | FGBL | Futures | 158.08 | 158.08 | 157.68 | 157.85 | 634420.0 |
| 2019-02-12 | FGBM | Futures | 132.57 | 132.57 | 132.44 | 132.48 | 429801.0 |
| 2019-02-12 | FGBS | Futures | 112.683 | 112.693 | 112.658 | 112.678 | 206987.0 |
| 2019-02-12 | FGBX | Futures | 188.97 | 189.07 | 187.94 | 188.36 | 44003.0 |
| 2019-02-12 | FMWO | Futures | 6836.1 | 6878.0 | 6832.6 | 6868.7 | 2733.0 |
| 2019-02-12 | FOAT | Futures | 143.12 | 143.35 | 143.0 | 143.14 | 190835.0 |
| 2019-02-12 | FTDX | Futures | 2529.9 | 2543.3 | 2515.0 | 2523.4 | 192.0 |
| 2019-02-12 | FTI | Futures | 499.36 | 501.47 | 499.31 | 500.15 | 53589.0 |
| 2019-02-12 | FTUK | Futures | 6436.1 | 6472.1 | 6427.9 | 6443.9 | 77989.0 |
| 2019-02-12 | FVSA | Futures | 281.36 | 281.36 | 273.5 | 277.0 | 35379.0 |
| 2019-02-12 | FXXP | Futures | 317.1 | 318.3 | 317.1 | 317.6 | 24289.0 |
| 2019-02-12 | G | Futures | 117.42 | 117.68 | 117.41 | 117.53 | 141538.0 |
| 2019-02-12 | GF | Futures | 316.712 | 316.876 | 315.126 | 315.782 | 6308.0 |
> showing 50 of 116 rows — these rows as CSV