PREVIEW / futures_daily / 2019-10-10
file: by_date/futures_daily/2019/2019-10-10.parquet size: 10 KB rows: 119
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-10-10 | ES | Futures | 3161.64 | 3197.9 | 3119.69 | 3183.83 | 1577766.0 |
| 2019-10-10 | NQ | Futures | 8876.23 | 8987.44 | 8739.09 | 8943.07 | 535042.0 |
| 2019-10-10 | YM | Futures | 27632.6 | 27923.4 | 27276.7 | 27802.7 | 219328.0 |
| 2019-10-10 | CL | Futures | 54.1 | 55.41 | 52.75 | 54.98 | 613944.0 |
| 2019-10-10 | GC | Futures | 1863.6 | 1877.8 | 1845.0 | 1851.4 | 417877.0 |
| 2019-10-10 | ZN | Futures | 130.177452 | 130.564562 | 129.418716 | 129.527107 | 1907652.0 |
| 2019-10-10 | A6 | Futures | 0.69116 | 0.6964 | 0.68973 | 0.69517 | 106255.0 |
| 2019-10-10 | AD | Futures | 0.75577 | 0.7596 | 0.75517 | 0.75799 | 91934.0 |
| 2019-10-10 | ALI | Futures | 2117.27 | 2130.55 | 2116.66 | 2125.72 | 116.0 |
| 2019-10-10 | B | Futures | 45.98 | 47.21 | 45.79 | 46.82 | 262531.0 |
| 2019-10-10 | B6 | Futures | 1.2442 | 1.2707 | 1.244 | 1.2681 | 205464.0 |
| 2019-10-10 | BR | Futures | 0.19623 | 0.19671 | 0.19489 | 0.19538 | 132.0 |
| 2019-10-10 | BTC | Futures | 12376.3 | 12469.8 | 12146.2 | 12361.9 | 2716.0 |
| 2019-10-10 | BZ | Futures | 45.61 | 46.5 | 44.61 | 46.16 | 36561.0 |
| 2019-10-10 | C | Futures | 1683.0 | 1713.0 | 1680.0 | 1710.0 | 6870.0 |
| 2019-10-10 | CB | Futures | 247.541 | 249.282 | 247.541 | 249.253 | 36.0 |
| 2019-10-10 | CC | Futures | 1578.0 | 1616.0 | 1578.0 | 1614.0 | 15756.0 |
| 2019-10-10 | CNH | Futures | 7.1495 | 7.1504 | 7.0943 | 7.107 | 2117.0 |
| 2019-10-10 | CSC | Futures | 3.212 | 3.217 | 3.195 | 3.202 | 53.0 |
| 2019-10-10 | CT | Futures | 60.35 | 60.81 | 59.73 | 59.79 | 12571.0 |
| 2019-10-10 | DC | Futures | 26.87 | 26.94 | 26.64 | 26.73 | 364.0 |
| 2019-10-10 | DX | Futures | 95.449 | 95.488 | 95.034 | 95.112 | 18498.0 |
| 2019-10-10 | E1 | Futures | 1.16128 | 1.16611 | 1.15921 | 1.1599 | 30448.0 |
| 2019-10-10 | E6 | Futures | 1.19448 | 1.20125 | 1.19448 | 1.19827 | 201895.0 |
| 2019-10-10 | E7 | Futures | 1.1881 | 1.1949 | 1.1881 | 1.1921 | 3070.0 |
| 2019-10-10 | EBM | Futures | 195.64 | 195.91 | 193.45 | 193.72 | 30690.0 |
| 2019-10-10 | ED | Futures | 95.4006 | 95.4346 | 95.3618 | 95.3715 | 327474.0 |
| 2019-10-10 | ER | Futures | 98.46 | 98.46 | 98.44 | 98.45 | 106529.0 |
| 2019-10-10 | EW | Futures | 1970.1 | 1990.8 | 1944.2 | 1979.4 | 11441.0 |
| 2019-10-10 | FBON | Futures | 145.88 | 146.0 | 145.16 | 145.41 | 178.0 |
| 2019-10-10 | FBTP | Futures | 131.93 | 132.07 | 131.03 | 131.17 | 110295.0 |
| 2019-10-10 | FBTS | Futures | 108.5 | 108.529 | 108.365 | 108.394 | 43695.0 |
| 2019-10-10 | FCE | Futures | 4991.1 | 5052.7 | 4965.8 | 5040.9 | 93139.0 |
| 2019-10-10 | FDAX | Futures | 12708.3 | 12862.4 | 12661.9 | 12845.5 | 107678.0 |
| 2019-10-10 | FDIV | Futures | 145.49 | 146.93 | 145.44 | 146.93 | 146.0 |
| 2019-10-10 | FDXM | Futures | 12552.8 | 12695.4 | 12496.5 | 12677.7 | 48933.0 |
| 2019-10-10 | FESX | Futures | 3020.3 | 3060.6 | 3006.2 | 3056.2 | 989221.0 |
| 2019-10-10 | FGBL | Futures | 168.14 | 168.22 | 166.7 | 167.12 | 794076.0 |
| 2019-10-10 | FGBM | Futures | 135.08 | 135.11 | 134.6 | 134.75 | 511048.0 |
| 2019-10-10 | FGBS | Futures | 112.981 | 112.986 | 112.885 | 112.925 | 389371.0 |
| 2019-10-10 | FGBX | Futures | 224.54 | 224.77 | 220.07 | 221.28 | 48652.0 |
| 2019-10-10 | FMWO | Futures | 7123.1 | 7190.2 | 7102.6 | 7186.8 | 1204.0 |
| 2019-10-10 | FOAT | Futures | 154.82 | 154.89 | 153.65 | 154.0 | 136952.0 |
| 2019-10-10 | FTDX | Futures | 2664.7 | 2691.4 | 2664.7 | 2691.4 | 28.0 |
| 2019-10-10 | FTI | Futures | 536.48 | 540.72 | 532.42 | 540.47 | 15.0 |
| 2019-10-10 | FTUK | Futures | 6594.3 | 6662.4 | 6567.4 | 6648.0 | 110732.0 |
| 2019-10-10 | FVSA | Futures | 200.97 | 207.15 | 186.94 | 189.74 | 47081.0 |
| 2019-10-10 | FXXP | Futures | 343.4 | 345.9 | 340.9 | 345.6 | 50005.0 |
| 2019-10-10 | G | Futures | 123.26 | 123.41 | 121.87 | 122.45 | 230538.0 |
| 2019-10-10 | GF | Futures | 302.471 | 303.832 | 299.645 | 301.738 | 8258.0 |
> showing 50 of 119 rows — these rows as CSV