PREVIEW / futures_daily / 2020-09-02
file: by_date/futures_daily/2020/2020-09-02.parquet size: 10 KB rows: 120
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-09-02 | ES | Futures | 3972.2 | 4037.48 | 3969.1 | 4028.76 | 1853078.0 |
| 2020-09-02 | NQ | Futures | 14305.46 | 14467.66 | 14127.59 | 14405.28 | 725395.0 |
| 2020-09-02 | YM | Futures | 30690.0 | 31241.9 | 30662.2 | 31175.5 | 213540.0 |
| 2020-09-02 | CL | Futures | 31.11 | 31.25 | 29.82 | 30.02 | 421771.0 |
| 2020-09-02 | GC | Futures | 2334.6 | 2338.9 | 2289.9 | 2296.7 | 332591.0 |
| 2020-09-02 | ZN | Futures | 138.341887 | 138.512221 | 138.202523 | 138.450281 | 29458.0 |
| 2020-09-02 | A6 | Futures | 0.75886 | 0.75948 | 0.75104 | 0.75269 | 89326.0 |
| 2020-09-02 | AD | Futures | 0.77712 | 0.7786 | 0.77509 | 0.77662 | 66216.0 |
| 2020-09-02 | ALI | Futures | 2166.82 | 2169.5 | 2134.36 | 2137.64 | 298.0 |
| 2020-09-02 | B | Futures | 29.21 | 29.35 | 28.18 | 28.32 | 260137.0 |
| 2020-09-02 | B6 | Futures | 1.3597 | 1.3609 | 1.3489 | 1.3528 | 114957.0 |
| 2020-09-02 | BTC | Futures | 16384.4 | 16438.4 | 15074.7 | 15473.0 | 17210.0 |
| 2020-09-02 | BZ | Futures | 28.59 | 28.71 | 27.56 | 27.71 | 31416.0 |
| 2020-09-02 | C | Futures | 1598.0 | 1624.0 | 1592.0 | 1622.0 | 3070.0 |
| 2020-09-02 | CB | Futures | 171.77 | 172.787 | 171.77 | 172.507 | 16.0 |
| 2020-09-02 | CC | Futures | 1748.0 | 1773.0 | 1733.0 | 1761.0 | 15290.0 |
| 2020-09-02 | CNH | Futures | 6.7394 | 6.7407 | 6.7248 | 6.736 | 879.0 |
| 2020-09-02 | CSC | Futures | 3.304 | 3.386 | 3.304 | 3.373 | 41.0 |
| 2020-09-02 | CT | Futures | 65.49 | 65.49 | 64.88 | 64.91 | 26.0 |
| 2020-09-02 | DC | Futures | 26.8 | 27.51 | 26.71 | 27.39 | 173.0 |
| 2020-09-02 | DX | Futures | 89.122 | 89.711 | 89.093 | 89.671 | 24027.0 |
| 2020-09-02 | E1 | Futures | 1.2492 | 1.24977 | 1.24352 | 1.24466 | 30146.0 |
| 2020-09-02 | E6 | Futures | 1.27882 | 1.28027 | 1.26879 | 1.26917 | 241988.0 |
| 2020-09-02 | E7 | Futures | 1.2724 | 1.2739 | 1.2625 | 1.2628 | 9787.0 |
| 2020-09-02 | EBM | Futures | 227.24 | 230.53 | 226.94 | 230.53 | 4278.0 |
| 2020-09-02 | ED | Futures | 96.4378 | 96.4403 | 96.4354 | 96.4354 | 113603.0 |
| 2020-09-02 | ER | Futures | 98.401 | 98.406 | 98.396 | 98.401 | 100386.0 |
| 2020-09-02 | ESG | Futures | 323.87 | 327.44 | 323.87 | 327.29 | 48.0 |
| 2020-09-02 | EW | Futures | 2065.3 | 2095.2 | 2058.4 | 2091.0 | 15393.0 |
| 2020-09-02 | FBON | Futures | 146.09 | 146.77 | 146.09 | 146.69 | 1531.0 |
| 2020-09-02 | FBTP | Futures | 132.9 | 133.57 | 132.9 | 133.51 | 216585.0 |
| 2020-09-02 | FBTS | Futures | 109.035 | 109.055 | 109.006 | 109.026 | 129157.0 |
| 2020-09-02 | FCE | Futures | 4825.5 | 4934.5 | 4822.6 | 4895.1 | 77618.0 |
| 2020-09-02 | FDAX | Futures | 13836.0 | 14185.5 | 13816.9 | 14045.3 | 106337.0 |
| 2020-09-02 | FDIV | Futures | 151.47 | 152.18 | 151.47 | 151.71 | 412.0 |
| 2020-09-02 | FDXM | Futures | 13783.4 | 14135.9 | 13766.5 | 13994.6 | 67595.0 |
| 2020-09-02 | FESX | Futures | 3034.3 | 3106.3 | 3028.7 | 3073.0 | 1025636.0 |
| 2020-09-02 | FGBL | Futures | 168.28 | 168.94 | 168.16 | 168.8 | 1138890.0 |
| 2020-09-02 | FGBM | Futures | 134.8 | 135.01 | 134.76 | 134.96 | 916009.0 |
| 2020-09-02 | FGBS | Futures | 112.729 | 112.78 | 112.724 | 112.764 | 1086068.0 |
| 2020-09-02 | FGBX | Futures | 225.51 | 227.84 | 224.75 | 227.36 | 123039.0 |
| 2020-09-02 | FMWO | Futures | 8710.4 | 8795.8 | 8685.6 | 8701.0 | 4310.0 |
| 2020-09-02 | FOAT | Futures | 155.85 | 156.6 | 155.85 | 156.52 | 405195.0 |
| 2020-09-02 | FTDX | Futures | 3163.5 | 3253.4 | 3163.5 | 3238.6 | 26.0 |
| 2020-09-02 | FTI | Futures | 517.8 | 527.91 | 516.49 | 522.91 | 33693.0 |
| 2020-09-02 | FTUK | Futures | 5558.3 | 5645.8 | 5554.1 | 5610.8 | 119041.0 |
| 2020-09-02 | FVSA | Futures | 217.86 | 221.18 | 209.15 | 219.52 | 29202.0 |
| 2020-09-02 | FXXP | Futures | 339.2 | 345.3 | 338.6 | 342.2 | 98358.0 |
| 2020-09-02 | G | Futures | 126.19 | 126.76 | 126.11 | 126.65 | 248154.0 |
| 2020-09-02 | GF | Futures | 267.295 | 267.58 | 261.727 | 264.011 | 1525.0 |
> showing 50 of 120 rows — these rows as CSV