PREVIEW / futures_daily / 2019-02-21
file: by_date/futures_daily/2019/2019-02-21.parquet size: 10 KB rows: 117
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-21 | ES | Futures | 3017.4 | 3029.31 | 2992.77 | 3003.6 | 1426061.0 |
| 2019-02-21 | NQ | Futures | 8186.19 | 8235.97 | 8110.06 | 8144.22 | 432866.0 |
| 2019-02-21 | YM | Futures | 27386.1 | 27510.5 | 27163.5 | 27247.9 | 207240.0 |
| 2019-02-21 | CL | Futures | 59.17 | 59.55 | 58.55 | 58.88 | 546202.0 |
| 2019-02-21 | GC | Futures | 1677.1 | 1680.4 | 1654.1 | 1659.7 | 285810.0 |
| 2019-02-21 | ZN | Futures | 121.720465 | 121.751587 | 121.30031 | 121.409239 | 2635431.0 |
| 2019-02-21 | A6 | Futures | 0.73837 | 0.7428 | 0.72848 | 0.72972 | 168659.0 |
| 2019-02-21 | AD | Futures | 0.76886 | 0.76962 | 0.76542 | 0.76602 | 73029.0 |
| 2019-02-21 | B | Futures | 48.61 | 48.8 | 48.35 | 48.63 | 245862.0 |
| 2019-02-21 | B6 | Futures | 1.3414 | 1.3462 | 1.339 | 1.3403 | 120288.0 |
| 2019-02-21 | BFX | Futures | 4121.3 | 4121.3 | 4112.1 | 4112.1 | 53.0 |
| 2019-02-21 | BR | Futures | 0.21309 | 0.21444 | 0.21133 | 0.21249 | 3462.0 |
| 2019-02-21 | BTC | Futures | 5779.9 | 5875.7 | 5684.1 | 5743.0 | 5427.0 |
| 2019-02-21 | BZ | Futures | 48.17 | 48.3 | 47.85 | 48.12 | 27113.0 |
| 2019-02-21 | C | Futures | 1544.0 | 1554.0 | 1512.0 | 1540.0 | 4134.0 |
| 2019-02-21 | CB | Futures | 274.985 | 275.194 | 274.686 | 275.134 | 12.0 |
| 2019-02-21 | CC | Futures | 1565.0 | 1581.0 | 1513.0 | 1536.0 | 29599.0 |
| 2019-02-21 | CNH | Futures | 6.7265 | 6.7396 | 6.6997 | 6.7375 | 1589.0 |
| 2019-02-21 | CSC | Futures | 2.756 | 2.784 | 2.741 | 2.778 | 57.0 |
| 2019-02-21 | CT | Futures | 76.66 | 78.76 | 76.31 | 78.64 | 5409.0 |
| 2019-02-21 | DC | Futures | 23.23 | 23.67 | 23.23 | 23.6 | 268.0 |
| 2019-02-21 | DX | Futures | 91.894 | 92.07 | 91.755 | 91.997 | 18036.0 |
| 2019-02-21 | E1 | Futures | 1.17725 | 1.17878 | 1.17548 | 1.17666 | 17429.0 |
| 2019-02-21 | E6 | Futures | 1.25558 | 1.25829 | 1.25304 | 1.25492 | 198651.0 |
| 2019-02-21 | E7 | Futures | 1.2497 | 1.2521 | 1.247 | 1.2488 | 4602.0 |
| 2019-02-21 | EBM | Futures | 198.43 | 201.52 | 198.17 | 200.49 | 27558.0 |
| 2019-02-21 | ED | Futures | 95.1038 | 95.1038 | 95.0965 | 95.1013 | 186210.0 |
| 2019-02-21 | ER | Futures | 98.406 | 98.411 | 98.401 | 98.406 | 125871.0 |
| 2019-02-21 | EW | Futures | 2051.8 | 2060.4 | 2035.4 | 2043.4 | 16142.0 |
| 2019-02-21 | FBON | Futures | 132.24 | 132.49 | 132.07 | 132.24 | 623.0 |
| 2019-02-21 | FBTP | Futures | 111.18 | 111.91 | 110.98 | 111.57 | 108895.0 |
| 2019-02-21 | FBTS | Futures | 104.954 | 105.152 | 104.878 | 105.058 | 62317.0 |
| 2019-02-21 | FCE | Futures | 4640.2 | 4651.7 | 4619.2 | 4633.5 | 68832.0 |
| 2019-02-21 | FDAX | Futures | 11983.4 | 12065.4 | 11964.5 | 12002.3 | 101994.0 |
| 2019-02-21 | FDIV | Futures | 141.23 | 141.23 | 140.96 | 140.96 | 35.0 |
| 2019-02-21 | FDXM | Futures | 11973.6 | 12034.4 | 11935.9 | 11973.1 | 46555.0 |
| 2019-02-21 | FESX | Futures | 2784.2 | 2797.0 | 2779.1 | 2786.8 | 894461.0 |
| 2019-02-21 | FGBL | Futures | 158.4 | 158.47 | 157.69 | 157.9 | 986011.0 |
| 2019-02-21 | FGBM | Futures | 132.58 | 132.58 | 132.29 | 132.36 | 569762.0 |
| 2019-02-21 | FGBS | Futures | 112.673 | 112.678 | 112.618 | 112.648 | 444631.0 |
| 2019-02-21 | FGBX | Futures | 189.78 | 190.01 | 188.28 | 188.77 | 53650.0 |
| 2019-02-21 | FMWO | Futures | 7009.7 | 7010.9 | 6968.9 | 6972.4 | 1773.0 |
| 2019-02-21 | FOAT | Futures | 143.61 | 143.67 | 143.3 | 143.43 | 182249.0 |
| 2019-02-21 | FTDX | Futures | 2604.0 | 2604.0 | 2576.6 | 2583.6 | 165.0 |
| 2019-02-21 | FTI | Futures | 508.0 | 509.03 | 506.07 | 507.49 | 23660.0 |
| 2019-02-21 | FTUK | Futures | 6549.1 | 6570.5 | 6480.3 | 6498.5 | 112946.0 |
| 2019-02-21 | FVSA | Futures | 270.01 | 274.37 | 268.26 | 270.88 | 17751.0 |
| 2019-02-21 | FXXP | Futures | 326.2 | 326.5 | 323.7 | 324.4 | 60472.0 |
| 2019-02-21 | G | Futures | 117.46 | 117.51 | 117.12 | 117.29 | 436543.0 |
| 2019-02-21 | GF | Futures | 313.814 | 315.29 | 312.065 | 313.213 | 5872.0 |
> showing 50 of 117 rows — these rows as CSV