PREVIEW / futures_daily / 2019-06-11
file: by_date/futures_daily/2019/2019-06-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-06-11 | ES | Futures | 3121.98 | 3144.93 | 3110.09 | 3118.47 | 1397028.0 |
| 2019-06-11 | NQ | Futures | 8664.0 | 8757.62 | 8633.18 | 8662.56 | 461725.0 |
| 2019-06-11 | YM | Futures | 27395.2 | 27573.7 | 27314.3 | 27371.0 | 4541.0 |
| 2019-06-11 | CL | Futures | 54.84 | 55.46 | 54.3 | 54.67 | 642940.0 |
| 2019-06-11 | GC | Futures | 1657.6 | 1660.1 | 1647.4 | 1656.8 | 215146.0 |
| 2019-06-11 | ZN | Futures | 126.118354 | 126.227224 | 125.900614 | 126.211671 | 1277336.0 |
| 2019-06-11 | A6 | Futures | 0.71798 | 0.71849 | 0.71643 | 0.71777 | 33849.0 |
| 2019-06-11 | AD | Futures | 0.76101 | 0.76216 | 0.75889 | 0.7601 | 35689.0 |
| 2019-06-11 | ALI | Futures | 2718.01 | 2718.01 | 2718.01 | 2718.01 | 0.0 |
| 2019-06-11 | B | Futures | 46.37 | 46.8 | 46.16 | 46.37 | 302739.0 |
| 2019-06-11 | B6 | Futures | 1.3007 | 1.3053 | 1.2991 | 1.3043 | 46506.0 |
| 2019-06-11 | BR | Futures | 0.20451 | 0.20635 | 0.20451 | 0.20635 | 245.0 |
| 2019-06-11 | BTC | Futures | 12262.5 | 12423.8 | 11862.9 | 12170.3 | 2537.0 |
| 2019-06-11 | BZ | Futures | 45.83 | 46.2 | 45.57 | 45.77 | 41448.0 |
| 2019-06-11 | C | Futures | 1773.0 | 1796.0 | 1773.0 | 1782.0 | 8305.0 |
| 2019-06-11 | CB | Futures | 286.786 | 287.077 | 286.786 | 287.077 | 30.0 |
| 2019-06-11 | CC | Futures | 1667.0 | 1690.0 | 1659.0 | 1668.0 | 31831.0 |
| 2019-06-11 | CNH | Futures | 6.9538 | 6.9538 | 6.9366 | 6.938 | 807.0 |
| 2019-06-11 | CSC | Futures | 3.013 | 3.026 | 3.013 | 3.023 | 30.0 |
| 2019-06-11 | CT | Futures | 69.23 | 69.46 | 68.34 | 68.72 | 21366.0 |
| 2019-06-11 | DC | Futures | 25.41 | 25.52 | 25.41 | 25.52 | 134.0 |
| 2019-06-11 | DX | Futures | 92.617 | 92.762 | 92.521 | 92.56 | 9720.0 |
| 2019-06-11 | E1 | Futures | 1.18232 | 1.18255 | 1.17756 | 1.17953 | 14388.0 |
| 2019-06-11 | E6 | Futures | 1.24382 | 1.24638 | 1.24251 | 1.24578 | 173778.0 |
| 2019-06-11 | E7 | Futures | 1.2375 | 1.2399 | 1.236 | 1.2393 | 2547.0 |
| 2019-06-11 | EBM | Futures | 203.82 | 205.55 | 202.38 | 204.69 | 23350.0 |
| 2019-06-11 | ED | Futures | 95.299 | 95.3038 | 95.26 | 95.2746 | 428227.0 |
| 2019-06-11 | ER | Futures | 98.43 | 98.435 | 98.426 | 98.43 | 29156.0 |
| 2019-06-11 | EW | Futures | 2002.3 | 2013.3 | 1999.3 | 2003.8 | 157.0 |
| 2019-06-11 | FBON | Futures | 140.85 | 141.12 | 140.82 | 141.04 | 571.0 |
| 2019-06-11 | FBTP | Futures | 117.98 | 118.61 | 117.45 | 118.35 | 113340.0 |
| 2019-06-11 | FBTS | Futures | 106.325 | 106.382 | 106.152 | 106.287 | 68982.0 |
| 2019-06-11 | FCE | Futures | 4883.8 | 4927.4 | 4878.8 | 4906.5 | 94805.0 |
| 2019-06-11 | FDAX | Futures | 12708.5 | 12867.4 | 12708.5 | 12806.9 | 105233.0 |
| 2019-06-11 | FDXM | Futures | 12593.5 | 12695.5 | 12588.3 | 12637.2 | 175.0 |
| 2019-06-11 | FESX | Futures | 2942.7 | 2972.4 | 2942.7 | 2960.1 | 155869.0 |
| 2019-06-11 | FGBL | Futures | 162.7 | 163.0 | 162.58 | 162.94 | 540350.0 |
| 2019-06-11 | FGBM | Futures | 134.01 | 134.06 | 133.95 | 134.02 | 419396.0 |
| 2019-06-11 | FGBS | Futures | 112.915 | 112.93 | 112.9 | 112.915 | 205619.0 |
| 2019-06-11 | FGBX | Futures | 203.47 | 204.52 | 203.06 | 204.31 | 47748.0 |
| 2019-06-11 | FMWO | Futures | 7209.2 | 7242.7 | 7183.7 | 7206.9 | 1466.0 |
| 2019-06-11 | FOAT | Futures | 149.47 | 149.98 | 149.47 | 149.91 | 146214.0 |
| 2019-06-11 | FTDX | Futures | 2770.8 | 2784.1 | 2770.8 | 2784.1 | 1.0 |
| 2019-06-11 | FTI | Futures | 521.92 | 525.54 | 521.92 | 523.46 | 32.0 |
| 2019-06-11 | FTUK | Futures | 6750.2 | 6781.6 | 6744.2 | 6762.6 | 3539.0 |
| 2019-06-11 | FVSA | Futures | 216.7 | 220.26 | 211.0 | 215.27 | 23228.0 |
| 2019-06-11 | FXXP | Futures | 338.0 | 339.7 | 337.5 | 339.3 | 9495.0 |
| 2019-06-11 | G | Futures | 119.91 | 119.93 | 119.45 | 119.75 | 154498.0 |
| 2019-06-11 | GF | Futures | 274.392 | 276.502 | 270.173 | 271.056 | 5386.0 |
| 2019-06-11 | GSCI | Futures | 462.39 | 462.39 | 460.75 | 460.86 | 3408.0 |
> showing 50 of 114 rows — these rows as CSV