PREVIEW / futures_daily / 2021-06-30
file: by_date/futures_daily/2021/2021-06-30.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-06-30 | ES | Futures | 4816.37 | 4827.05 | 4798.95 | 4820.59 | 1100062.0 |
| 2021-06-30 | NQ | Futures | 16826.24 | 16842.1 | 16749.52 | 16784.99 | 384458.0 |
| 2021-06-30 | YM | Futures | 37067.5 | 37354.8 | 36873.4 | 37299.5 | 132388.0 |
| 2021-06-30 | CL | Futures | 52.7 | 53.18 | 52.24 | 52.7 | 383626.0 |
| 2021-06-30 | GC | Futures | 2060.8 | 2075.7 | 2050.6 | 2072.1 | 177887.0 |
| 2021-06-30 | ZN | Futures | 133.883315 | 134.167971 | 133.78843 | 134.104714 | 1715181.0 |
| 2021-06-30 | A6 | Futures | 0.7708 | 0.77213 | 0.76859 | 0.76895 | 70742.0 |
| 2021-06-30 | AD | Futures | 0.81773 | 0.82052 | 0.81601 | 0.81737 | 72112.0 |
| 2021-06-30 | ALI | Futures | 2960.41 | 2960.41 | 2908.18 | 2926.83 | 128.0 |
| 2021-06-30 | B | Futures | 49.25 | 49.75 | 48.81 | 49.27 | 296472.0 |
| 2021-06-30 | B6 | Futures | 1.4055 | 1.4088 | 1.4011 | 1.4017 | 88735.0 |
| 2021-06-30 | BFX | Futures | 4202.5 | 4224.0 | 4202.5 | 4215.3 | 13.0 |
| 2021-06-30 | BR | Futures | 0.16023 | 0.16027 | 0.15823 | 0.15951 | 395.0 |
| 2021-06-30 | BTC | Futures | 51592.3 | 51592.3 | 48465.2 | 49469.6 | 3880.0 |
| 2021-06-30 | BZ | Futures | 48.14 | 48.63 | 47.72 | 48.16 | 33596.0 |
| 2021-06-30 | C | Futures | 1447.0 | 1458.0 | 1435.0 | 1456.0 | 4171.0 |
| 2021-06-30 | CB | Futures | 142.41 | 142.41 | 142.009 | 142.009 | 10.0 |
| 2021-06-30 | CC | Futures | 1563.0 | 1571.0 | 1552.0 | 1567.0 | 12332.0 |
| 2021-06-30 | CNH | Futures | 6.2661 | 6.268 | 6.2599 | 6.268 | 223.0 |
| 2021-06-30 | CSC | Futures | 2.503 | 2.505 | 2.493 | 2.496 | 64.0 |
| 2021-06-30 | CT | Futures | 81.34 | 81.34 | 79.08 | 79.08 | 40.0 |
| 2021-06-30 | DC | Futures | 22.85 | 22.85 | 22.58 | 22.62 | 256.0 |
| 2021-06-30 | DX | Futures | 88.994 | 89.351 | 88.926 | 89.343 | 17120.0 |
| 2021-06-30 | E1 | Futures | 1.22145 | 1.22224 | 1.21471 | 1.21494 | 26265.0 |
| 2021-06-30 | E6 | Futures | 1.26759 | 1.26866 | 1.2618 | 1.26206 | 168822.0 |
| 2021-06-30 | E7 | Futures | 1.2612 | 1.2623 | 1.2555 | 1.2557 | 4506.0 |
| 2021-06-30 | EBM | Futures | 297.53 | 310.03 | 296.43 | 307.83 | 30486.0 |
| 2021-06-30 | ED | Futures | 96.5248 | 96.5297 | 96.52 | 96.5297 | 77003.0 |
| 2021-06-30 | ER | Futures | 98.46 | 98.465 | 98.46 | 98.46 | 31302.0 |
| 2021-06-30 | ESG | Futures | 397.02 | 398.37 | 397.02 | 398.21 | 215.0 |
| 2021-06-30 | EW | Futures | 2893.3 | 2896.9 | 2867.7 | 2891.8 | 10338.0 |
| 2021-06-30 | FBON | Futures | 147.56 | 148.24 | 147.51 | 148.13 | 551.0 |
| 2021-06-30 | FBTP | Futures | 137.68 | 138.49 | 137.63 | 138.4 | 141868.0 |
| 2021-06-30 | FBTS | Futures | 110.137 | 110.195 | 110.098 | 110.175 | 65592.0 |
| 2021-06-30 | FCE | Futures | 6534.9 | 6548.4 | 6444.3 | 6480.6 | 72488.0 |
| 2021-06-30 | FDAX | Futures | 16818.4 | 16824.8 | 16539.9 | 16634.1 | 80802.0 |
| 2021-06-30 | FDIV | Futures | 186.96 | 187.11 | 186.67 | 186.67 | 55.0 |
| 2021-06-30 | FDXM | Futures | 16729.6 | 16747.7 | 16458.9 | 16551.6 | 55233.0 |
| 2021-06-30 | FDXS | Futures | 16618.0 | 16628.6 | 16355.4 | 16446.5 | 6485.0 |
| 2021-06-30 | FESX | Futures | 3886.8 | 3888.2 | 3823.8 | 3844.6 | 1109802.0 |
| 2021-06-30 | FEU3 | Futures | 99.203 | 99.208 | 99.203 | 99.208 | 50.0 |
| 2021-06-30 | FGBL | Futures | 166.74 | 167.33 | 166.6 | 167.21 | 724062.0 |
| 2021-06-30 | FGBM | Futures | 134.45 | 134.65 | 134.44 | 134.62 | 355808.0 |
| 2021-06-30 | FGBS | Futures | 112.549 | 112.574 | 112.544 | 112.564 | 181362.0 |
| 2021-06-30 | FGBX | Futures | 215.69 | 217.62 | 215.22 | 217.19 | 80595.0 |
| 2021-06-30 | FMWO | Futures | 10668.2 | 10669.4 | 10607.1 | 10634.1 | 3934.0 |
| 2021-06-30 | FOAT | Futures | 154.67 | 155.2 | 154.5 | 155.08 | 181360.0 |
| 2021-06-30 | FTDX | Futures | 3708.1 | 3708.1 | 3649.1 | 3656.8 | 50.0 |
| 2021-06-30 | FTI | Futures | 698.19 | 700.24 | 691.57 | 694.41 | 23780.0 |
| 2021-06-30 | FTUK | Futures | 6914.9 | 6925.7 | 6832.2 | 6873.5 | 118230.0 |
> showing 50 of 124 rows — these rows as CSV