PREVIEW / futures_daily / 2019-01-11
file: by_date/futures_daily/2019/2019-01-11.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 |
|---|---|---|---|---|---|---|---|
| 2019-01-11 | ES | Futures | 2808.45 | 2812.51 | 2790.04 | 2809.53 | 1213026.0 |
| 2019-01-11 | NQ | Futures | 7667.22 | 7678.8 | 7608.76 | 7655.93 | 364787.0 |
| 2019-01-11 | YM | Futures | 25270.2 | 25308.2 | 25066.6 | 25261.8 | 173649.0 |
| 2019-01-11 | CL | Futures | 54.83 | 55.91 | 53.68 | 54.11 | 812339.0 |
| 2019-01-11 | GC | Futures | 1622.4 | 1632.6 | 1621.6 | 1624.8 | 210644.0 |
| 2019-01-11 | ZN | Futures | 121.129135 | 121.611536 | 121.113574 | 121.455923 | 1209547.0 |
| 2019-01-11 | A6 | Futures | 0.74084 | 0.7461 | 0.74064 | 0.74321 | 108751.0 |
| 2019-01-11 | AD | Futures | 0.76587 | 0.76906 | 0.76354 | 0.76405 | 64210.0 |
| 2019-01-11 | B | Futures | 44.18 | 45.11 | 43.37 | 43.66 | 292786.0 |
| 2019-01-11 | B6 | Futures | 1.3128 | 1.3253 | 1.309 | 1.3232 | 133715.0 |
| 2019-01-11 | BR | Futures | 0.21472 | 0.21472 | 0.21425 | 0.21425 | 38.0 |
| 2019-01-11 | BTC | Futures | 5263.0 | 5387.3 | 5204.5 | 5314.2 | 4216.0 |
| 2019-01-11 | BZ | Futures | 43.85 | 44.72 | 43.01 | 43.3 | 31369.0 |
| 2019-01-11 | C | Futures | 1497.0 | 1511.0 | 1484.0 | 1487.0 | 6397.0 |
| 2019-01-11 | CB | Futures | 272.987 | 273.686 | 272.957 | 273.382 | 19.0 |
| 2019-01-11 | CC | Futures | 1634.0 | 1651.0 | 1619.0 | 1623.0 | 15930.0 |
| 2019-01-11 | CNH | Futures | 6.8077 | 6.8114 | 6.7537 | 6.7748 | 1275.0 |
| 2019-01-11 | CSC | Futures | 2.791 | 2.803 | 2.791 | 2.803 | 33.0 |
| 2019-01-11 | CT | Futures | 79.3 | 79.79 | 78.8 | 78.96 | 12850.0 |
| 2019-01-11 | DC | Futures | 24.02 | 24.15 | 23.96 | 24.15 | 219.0 |
| 2019-01-11 | DX | Futures | 90.668 | 90.949 | 90.392 | 90.855 | 21025.0 |
| 2019-01-11 | E1 | Futures | 1.20205 | 1.20523 | 1.20006 | 1.20147 | 27156.0 |
| 2019-01-11 | E6 | Futures | 1.27718 | 1.28204 | 1.27282 | 1.27365 | 187965.0 |
| 2019-01-11 | E7 | Futures | 1.2712 | 1.2757 | 1.2665 | 1.2674 | 4369.0 |
| 2019-01-11 | EBM | Futures | 209.74 | 211.28 | 209.48 | 210.51 | 13178.0 |
| 2019-01-11 | ED | Futures | 95.0037 | 95.0135 | 94.9988 | 95.0037 | 253421.0 |
| 2019-01-11 | ER | Futures | 98.401 | 98.401 | 98.396 | 98.396 | 22515.0 |
| 2019-01-11 | EW | Futures | 1874.1 | 1882.2 | 1863.6 | 1878.8 | 10657.0 |
| 2019-01-11 | FBON | Futures | 129.44 | 129.79 | 129.38 | 129.52 | 227.0 |
| 2019-01-11 | FBTP | Futures | 110.55 | 111.19 | 110.4 | 110.86 | 86855.0 |
| 2019-01-11 | FBTS | Futures | 104.755 | 104.878 | 104.67 | 104.831 | 58363.0 |
| 2019-01-11 | FCE | Futures | 4271.5 | 4279.5 | 4225.3 | 4244.0 | 75834.0 |
| 2019-01-11 | FDAX | Futures | 11496.3 | 11515.8 | 11372.3 | 11433.3 | 82875.0 |
| 2019-01-11 | FDIV | Futures | 133.52 | 133.88 | 133.34 | 133.88 | 41.0 |
| 2019-01-11 | FDXM | Futures | 11469.4 | 11486.2 | 11344.6 | 11405.4 | 34794.0 |
| 2019-01-11 | FESX | Futures | 2623.5 | 2628.7 | 2601.3 | 2610.7 | 846007.0 |
| 2019-01-11 | FGBL | Futures | 156.17 | 156.54 | 156.08 | 156.32 | 563194.0 |
| 2019-01-11 | FGBM | Futures | 132.16 | 132.26 | 132.12 | 132.14 | 315717.0 |
| 2019-01-11 | FGBS | Futures | 112.729 | 112.739 | 112.703 | 112.708 | 219020.0 |
| 2019-01-11 | FGBX | Futures | 184.67 | 185.69 | 184.53 | 185.16 | 31266.0 |
| 2019-01-11 | FMWO | Futures | 6577.4 | 6589.0 | 6540.1 | 6556.4 | 1714.0 |
| 2019-01-11 | FOAT | Futures | 141.91 | 142.18 | 141.79 | 141.98 | 128523.0 |
| 2019-01-11 | FTDX | Futures | 2522.5 | 2522.5 | 2473.8 | 2497.6 | 83.0 |
| 2019-01-11 | FTI | Futures | 469.94 | 472.02 | 467.91 | 469.68 | 549.0 |
| 2019-01-11 | FTUK | Futures | 6277.2 | 6322.7 | 6228.4 | 6240.3 | 92480.0 |
| 2019-01-11 | FVSA | Futures | 380.85 | 386.95 | 359.53 | 367.65 | 25357.0 |
| 2019-01-11 | FXXP | Futures | 305.3 | 306.0 | 303.9 | 305.0 | 33369.0 |
| 2019-01-11 | G | Futures | 116.8 | 117.1 | 116.4 | 116.52 | 228474.0 |
| 2019-01-11 | GF | Futures | 317.696 | 318.407 | 315.728 | 316.876 | 3599.0 |
| 2019-01-11 | GSCI | Futures | 461.02 | 461.02 | 461.02 | 461.02 | 3037.0 |
> showing 50 of 114 rows — these rows as CSV