PREVIEW / futures_daily / 2020-08-14
file: by_date/futures_daily/2020/2020-08-14.parquet size: 10 KB rows: 118
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-08-14 | ES | Futures | 3792.38 | 3805.05 | 3770.72 | 3783.66 | 1084771.0 |
| 2020-08-14 | NQ | Futures | 12976.53 | 13042.98 | 12878.46 | 12922.27 | 398616.0 |
| 2020-08-14 | YM | Futures | 29823.0 | 29912.0 | 29570.1 | 29784.4 | 150506.0 |
| 2020-08-14 | CL | Futures | 30.82 | 30.98 | 30.32 | 30.6 | 180371.0 |
| 2020-08-14 | GC | Futures | 2319.3 | 2326.6 | 2290.1 | 2302.7 | 241798.0 |
| 2020-08-14 | ZN | Futures | 137.660553 | 137.97025 | 137.660553 | 137.877341 | 1105774.0 |
| 2020-08-14 | A6 | Futures | 0.73541 | 0.73818 | 0.73376 | 0.73798 | 58441.0 |
| 2020-08-14 | AD | Futures | 0.76738 | 0.76865 | 0.76484 | 0.76576 | 49215.0 |
| 2020-08-14 | ALI | Futures | 2159.31 | 2161.74 | 2112.27 | 2115.31 | 151.0 |
| 2020-08-14 | B | Futures | 29.2 | 29.2 | 28.67 | 28.88 | 151463.0 |
| 2020-08-14 | B6 | Futures | 1.3269 | 1.3347 | 1.325 | 1.3295 | 69150.0 |
| 2020-08-14 | BR | Futures | 0.14706 | 0.14774 | 0.14556 | 0.14591 | 5649.0 |
| 2020-08-14 | BTC | Futures | 16095.3 | 16416.8 | 16061.1 | 16327.9 | 9980.0 |
| 2020-08-14 | BZ | Futures | 28.36 | 28.59 | 28.0 | 28.2 | 16681.0 |
| 2020-08-14 | C | Futures | 1550.0 | 1589.0 | 1535.0 | 1537.0 | 5647.0 |
| 2020-08-14 | CB | Futures | 172.76 | 176.531 | 172.76 | 175.889 | 36.0 |
| 2020-08-14 | CC | Futures | 1629.0 | 1660.0 | 1608.0 | 1612.0 | 28392.0 |
| 2020-08-14 | CNH | Futures | 6.8588 | 6.8618 | 6.849 | 6.8504 | 275.0 |
| 2020-08-14 | CSC | Futures | 3.484 | 3.57 | 3.478 | 3.55 | 127.0 |
| 2020-08-14 | CT | Futures | 63.5 | 63.5 | 63.0 | 63.0 | 10.0 |
| 2020-08-14 | DC | Futures | 28.52 | 29.25 | 28.12 | 28.79 | 674.0 |
| 2020-08-14 | DX | Futures | 90.068 | 90.228 | 89.827 | 89.914 | 15380.0 |
| 2020-08-14 | E1 | Futures | 1.24954 | 1.25079 | 1.24579 | 1.24988 | 15714.0 |
| 2020-08-14 | E6 | Futures | 1.26863 | 1.27233 | 1.26493 | 1.27099 | 153531.0 |
| 2020-08-14 | E7 | Futures | 1.2624 | 1.2659 | 1.2584 | 1.2646 | 5457.0 |
| 2020-08-14 | EBM | Futures | 213.47 | 218.56 | 212.57 | 216.46 | 16167.0 |
| 2020-08-14 | ED | Futures | 96.4233 | 96.4378 | 96.4185 | 96.4282 | 180772.0 |
| 2020-08-14 | ER | Futures | 98.396 | 98.401 | 98.391 | 98.396 | 41706.0 |
| 2020-08-14 | ESG | Futures | 306.46 | 306.7 | 305.55 | 306.33 | 11.0 |
| 2020-08-14 | EW | Futures | 2075.9 | 2083.0 | 2056.4 | 2071.4 | 10366.0 |
| 2020-08-14 | FBON | Futures | 145.9 | 146.41 | 145.9 | 146.34 | 319.0 |
| 2020-08-14 | FBTP | Futures | 132.54 | 133.15 | 132.44 | 133.06 | 61655.0 |
| 2020-08-14 | FBTS | Futures | 108.832 | 108.948 | 108.803 | 108.919 | 40301.0 |
| 2020-08-14 | FCE | Futures | 4905.5 | 4908.2 | 4788.0 | 4826.0 | 793.0 |
| 2020-08-14 | FDAX | Futures | 13811.0 | 13823.8 | 13583.1 | 13702.6 | 58474.0 |
| 2020-08-14 | FDIV | Futures | 149.15 | 149.15 | 148.58 | 148.96 | 100.0 |
| 2020-08-14 | FDXM | Futures | 13752.7 | 13773.9 | 13534.7 | 13653.2 | 37380.0 |
| 2020-08-14 | FESX | Futures | 3082.3 | 3086.0 | 3019.5 | 3050.9 | 725988.0 |
| 2020-08-14 | FGBL | Futures | 167.45 | 167.98 | 167.44 | 167.93 | 486775.0 |
| 2020-08-14 | FGBM | Futures | 134.4 | 134.56 | 134.4 | 134.55 | 353354.0 |
| 2020-08-14 | FGBS | Futures | 112.659 | 112.684 | 112.654 | 112.679 | 303925.0 |
| 2020-08-14 | FGBX | Futures | 223.51 | 226.21 | 223.22 | 225.55 | 40632.0 |
| 2020-08-14 | FMWO | Futures | 8390.5 | 8390.5 | 8315.8 | 8371.5 | 1212.0 |
| 2020-08-14 | FOAT | Futures | 154.79 | 155.77 | 154.78 | 155.68 | 145980.0 |
| 2020-08-14 | FTDX | Futures | 3160.4 | 3169.6 | 3138.5 | 3150.2 | 29.0 |
| 2020-08-14 | FTI | Futures | 531.05 | 531.08 | 518.54 | 521.92 | 374.0 |
| 2020-08-14 | FTUK | Futures | 5831.5 | 5852.8 | 5692.6 | 5746.9 | 95869.0 |
| 2020-08-14 | FVSA | Futures | 205.0 | 217.45 | 205.0 | 209.56 | 11125.0 |
| 2020-08-14 | FXXP | Futures | 343.9 | 344.1 | 336.6 | 339.4 | 38093.0 |
| 2020-08-14 | G | Futures | 126.39 | 126.51 | 126.25 | 126.39 | 143943.0 |
> showing 50 of 118 rows — these rows as CSV