PREVIEW / futures_daily / 2021-07-06
file: by_date/futures_daily/2021/2021-07-06.parquet size: 10 KB rows: 124
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 |
|---|---|---|---|---|---|---|---|
| 2021-07-06 | ES | Futures | 4879.6 | 4887.47 | 4839.42 | 4871.74 | 1368133.0 |
| 2021-07-06 | NQ | Futures | 16964.1 | 17063.03 | 16872.96 | 17046.3 | 557682.0 |
| 2021-07-06 | YM | Futures | 37599.9 | 37685.5 | 37128.2 | 37365.6 | 183144.0 |
| 2021-07-06 | CL | Futures | 54.05 | 55.22 | 52.32 | 52.63 | 714044.0 |
| 2021-07-06 | GC | Futures | 2090.7 | 2123.7 | 2087.4 | 2098.6 | 276597.0 |
| 2021-07-06 | ZN | Futures | 134.357742 | 135.006126 | 134.183785 | 134.832169 | 1946423.0 |
| 2021-07-06 | A6 | Futures | 0.77198 | 0.77956 | 0.76741 | 0.76905 | 155800.0 |
| 2021-07-06 | AD | Futures | 0.82239 | 0.82407 | 0.81134 | 0.81352 | 128907.0 |
| 2021-07-06 | ALI | Futures | 2979.06 | 2979.06 | 2905.02 | 2935.15 | 555.0 |
| 2021-07-06 | B | Futures | 50.88 | 51.39 | 48.94 | 49.21 | 410703.0 |
| 2021-07-06 | B6 | Futures | 1.4054 | 1.4116 | 1.3987 | 1.4013 | 147632.0 |
| 2021-07-06 | BFX | Futures | 4251.1 | 4251.1 | 4243.9 | 4249.6 | 26.0 |
| 2021-07-06 | BR | Futures | 0.15731 | 0.15851 | 0.15246 | 0.15294 | 716.0 |
| 2021-07-06 | BTC | Futures | 51001.0 | 51221.9 | 47460.9 | 48401.1 | 6997.0 |
| 2021-07-06 | BZ | Futures | 49.11 | 50.23 | 47.84 | 48.1 | 58679.0 |
| 2021-07-06 | C | Futures | 1450.0 | 1456.0 | 1432.0 | 1436.0 | 1671.0 |
| 2021-07-06 | CB | Futures | 141.327 | 141.327 | 139.602 | 139.602 | 46.0 |
| 2021-07-06 | CC | Futures | 1533.0 | 1540.0 | 1500.0 | 1507.0 | 22688.0 |
| 2021-07-06 | CNH | Futures | 6.2781 | 6.2826 | 6.2589 | 6.2767 | 549.0 |
| 2021-07-06 | CSC | Futures | 2.487 | 2.492 | 2.472 | 2.473 | 154.0 |
| 2021-07-06 | CT | Futures | 82.05 | 82.77 | 79.83 | 81.26 | 85.0 |
| 2021-07-06 | DC | Futures | 22.51 | 22.58 | 22.32 | 22.33 | 226.0 |
| 2021-07-06 | DX | Futures | 89.172 | 89.559 | 88.921 | 89.451 | 24696.0 |
| 2021-07-06 | E1 | Futures | 1.22033 | 1.2237 | 1.21606 | 1.2164 | 36288.0 |
| 2021-07-06 | E6 | Futures | 1.26398 | 1.26701 | 1.25733 | 1.25935 | 267001.0 |
| 2021-07-06 | E7 | Futures | 1.2575 | 1.2606 | 1.2512 | 1.2531 | 7019.0 |
| 2021-07-06 | EBM | Futures | 293.85 | 294.59 | 288.7 | 291.64 | 25585.0 |
| 2021-07-06 | ED | Futures | 96.5297 | 96.5393 | 96.5297 | 96.5393 | 112747.0 |
| 2021-07-06 | ER | Futures | 98.465 | 98.465 | 98.46 | 98.46 | 18426.0 |
| 2021-07-06 | ESG | Futures | 403.23 | 403.95 | 400.67 | 403.02 | 1297.0 |
| 2021-07-06 | EW | Futures | 2901.5 | 2912.7 | 2848.3 | 2871.8 | 13151.0 |
| 2021-07-06 | FBON | Futures | 148.24 | 149.05 | 148.23 | 148.97 | 443.0 |
| 2021-07-06 | FBTP | Futures | 138.64 | 139.5 | 138.52 | 139.36 | 136364.0 |
| 2021-07-06 | FBTS | Futures | 110.234 | 110.273 | 110.214 | 110.253 | 59469.0 |
| 2021-07-06 | FCE | Futures | 6538.4 | 6538.4 | 6455.7 | 6480.1 | 50775.0 |
| 2021-07-06 | FDAX | Futures | 16758.4 | 16794.8 | 16547.4 | 16580.6 | 73203.0 |
| 2021-07-06 | FDIV | Futures | 187.45 | 187.7 | 185.64 | 185.83 | 65.0 |
| 2021-07-06 | FDXM | Futures | 16668.8 | 16712.5 | 16464.2 | 16498.3 | 54599.0 |
| 2021-07-06 | FDXS | Futures | 16582.0 | 16602.2 | 16362.8 | 16393.5 | 7005.0 |
| 2021-07-06 | FESX | Futures | 3866.0 | 3871.2 | 3815.2 | 3823.3 | 616719.0 |
| 2021-07-06 | FGBL | Futures | 167.31 | 168.21 | 167.09 | 168.16 | 753361.0 |
| 2021-07-06 | FGBM | Futures | 134.62 | 134.86 | 134.54 | 134.85 | 394987.0 |
| 2021-07-06 | FGBS | Futures | 112.569 | 112.609 | 112.564 | 112.604 | 191338.0 |
| 2021-07-06 | FGBX | Futures | 217.17 | 220.48 | 216.59 | 220.24 | 109026.0 |
| 2021-07-06 | FMWO | Futures | 10769.2 | 10769.2 | 10661.1 | 10685.8 | 2852.0 |
| 2021-07-06 | FOAT | Futures | 155.17 | 155.99 | 154.98 | 155.92 | 217459.0 |
| 2021-07-06 | FTDX | Futures | 3656.3 | 3689.1 | 3651.1 | 3683.5 | 44.0 |
| 2021-07-06 | FTI | Futures | 698.14 | 700.47 | 693.57 | 696.31 | 18944.0 |
| 2021-07-06 | FTUK | Futures | 6985.3 | 6993.7 | 6896.7 | 6914.9 | 85227.0 |
| 2021-07-06 | FVSA | Futures | 80.0 | 85.27 | 78.85 | 83.89 | 39753.0 |
> showing 50 of 124 rows — these rows as CSV