PREVIEW / futures_daily / 2020-07-30
file: by_date/futures_daily/2020/2020-07-30.parquet size: 10 KB rows: 121
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 |
|---|---|---|---|---|---|---|---|
| 2020-07-30 | ES | Futures | 3665.76 | 3679.54 | 3596.25 | 3656.75 | 2000721.0 |
| 2020-07-30 | NQ | Futures | 12418.84 | 12647.78 | 12189.91 | 12527.94 | 521157.0 |
| 2020-07-30 | YM | Futures | 28350.5 | 28375.2 | 27736.4 | 28097.6 | 214147.0 |
| 2020-07-30 | CL | Futures | 30.15 | 30.2 | 28.25 | 29.13 | 487325.0 |
| 2020-07-30 | GC | Futures | 2346.0 | 2347.0 | 2305.7 | 2322.8 | 271380.0 |
| 2020-07-30 | ZN | Futures | 138.527706 | 138.806433 | 138.496736 | 138.759979 | 717957.0 |
| 2020-07-30 | A6 | Futures | 0.73983 | 0.74055 | 0.73273 | 0.73849 | 104272.0 |
| 2020-07-30 | AD | Futures | 0.76149 | 0.76149 | 0.75424 | 0.75525 | 78514.0 |
| 2020-07-30 | ALI | Futures | 2106.5 | 2109.24 | 2095.88 | 2097.4 | 228.0 |
| 2020-07-30 | B | Futures | 28.38 | 28.51 | 26.9 | 27.88 | 328238.0 |
| 2020-07-30 | B6 | Futures | 1.3204 | 1.3308 | 1.3147 | 1.3293 | 119266.0 |
| 2020-07-30 | BR | Futures | 0.15316 | 0.15384 | 0.15142 | 0.15372 | 4972.0 |
| 2020-07-30 | BTC | Futures | 15767.0 | 15842.2 | 15083.0 | 15554.9 | 3917.0 |
| 2020-07-30 | BZ | Futures | 27.8 | 27.82 | 26.26 | 27.23 | 34977.0 |
| 2020-07-30 | C | Futures | 1466.0 | 1487.0 | 1450.0 | 1453.0 | 6525.0 |
| 2020-07-30 | CB | Futures | 180.811 | 181.881 | 179.955 | 181.613 | 13.0 |
| 2020-07-30 | CC | Futures | 1528.0 | 1570.0 | 1528.0 | 1537.0 | 20244.0 |
| 2020-07-30 | CNH | Futures | 6.9126 | 6.9293 | 6.9087 | 6.9167 | 239.0 |
| 2020-07-30 | CSC | Futures | 3.993 | 4.016 | 3.819 | 3.917 | 126.0 |
| 2020-07-30 | CT | Futures | 61.75 | 63.53 | 61.22 | 63.53 | 14.0 |
| 2020-07-30 | DC | Futures | 32.46 | 32.99 | 31.14 | 32.0 | 708.0 |
| 2020-07-30 | DX | Futures | 90.126 | 90.45 | 89.725 | 89.84 | 26945.0 |
| 2020-07-30 | E1 | Futures | 1.24636 | 1.25124 | 1.24261 | 1.25011 | 29905.0 |
| 2020-07-30 | E6 | Futures | 1.26675 | 1.27255 | 1.25999 | 1.27126 | 239405.0 |
| 2020-07-30 | E7 | Futures | 1.2601 | 1.2662 | 1.2537 | 1.2649 | 8750.0 |
| 2020-07-30 | EBM | Futures | 216.46 | 220.95 | 215.86 | 219.15 | 23177.0 |
| 2020-07-30 | ED | Futures | 96.4378 | 96.4523 | 96.4378 | 96.4523 | 179058.0 |
| 2020-07-30 | ER | Futures | 98.377 | 98.386 | 98.372 | 98.382 | 73424.0 |
| 2020-07-30 | ESG | Futures | 291.43 | 293.72 | 289.86 | 293.62 | 30.0 |
| 2020-07-30 | EW | Futures | 2005.1 | 2007.7 | 1961.8 | 1992.3 | 15384.0 |
| 2020-07-30 | FBON | Futures | 146.76 | 146.96 | 146.6 | 146.88 | 87.0 |
| 2020-07-30 | FBTP | Futures | 133.02 | 133.6 | 132.98 | 133.32 | 97139.0 |
| 2020-07-30 | FBTS | Futures | 108.89 | 108.9 | 108.841 | 108.861 | 44862.0 |
| 2020-07-30 | FCE | Futures | 4798.7 | 4806.4 | 4636.3 | 4686.5 | 93307.0 |
| 2020-07-30 | FDAX | Futures | 13660.7 | 13670.2 | 13003.6 | 13105.6 | 126874.0 |
| 2020-07-30 | FDIV | Futures | 144.55 | 144.69 | 140.38 | 140.52 | 256.0 |
| 2020-07-30 | FDXM | Futures | 13614.0 | 13619.3 | 12957.7 | 13058.3 | 82717.0 |
| 2020-07-30 | FESX | Futures | 3055.5 | 3055.5 | 2924.4 | 2947.5 | 1353897.0 |
| 2020-07-30 | FEU3 | Futures | 99.129 | 99.134 | 99.129 | 99.134 | 100.0 |
| 2020-07-30 | FGBL | Futures | 169.12 | 169.88 | 169.04 | 169.78 | 531747.0 |
| 2020-07-30 | FGBM | Futures | 134.94 | 135.24 | 134.94 | 135.19 | 379802.0 |
| 2020-07-30 | FGBS | Futures | 112.764 | 112.835 | 112.759 | 112.83 | 413879.0 |
| 2020-07-30 | FGBX | Futures | 230.11 | 233.22 | 229.94 | 232.83 | 43305.0 |
| 2020-07-30 | FMWO | Futures | 8085.9 | 8098.9 | 7981.6 | 8033.8 | 1117.0 |
| 2020-07-30 | FOAT | Futures | 156.41 | 156.92 | 156.39 | 156.85 | 115272.0 |
| 2020-07-30 | FTDX | Futures | 3095.6 | 3095.6 | 3019.9 | 3045.5 | 57.0 |
| 2020-07-30 | FTI | Futures | 526.94 | 527.22 | 506.05 | 511.34 | 33370.0 |
| 2020-07-30 | FTUK | Futures | 5779.5 | 5789.4 | 5562.1 | 5616.0 | 115878.0 |
| 2020-07-30 | FVSA | Futures | 231.2 | 260.16 | 231.2 | 249.3 | 43973.0 |
| 2020-07-30 | FXXP | Futures | 339.3 | 339.3 | 328.0 | 330.6 | 74798.0 |
> showing 50 of 121 rows — these rows as CSV