PREVIEW / futures_daily / 2020-06-02
file: by_date/futures_daily/2020/2020-06-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-06-02 | ES | Futures | 3377.82 | 3406.87 | 3358.18 | 3404.66 | 1458830.0 |
| 2020-06-02 | NQ | Futures | 10994.36 | 11086.07 | 10896.62 | 11060.57 | 389908.0 |
| 2020-06-02 | YM | Futures | 27165.0 | 27444.6 | 26986.8 | 27424.3 | 174040.0 |
| 2020-06-02 | CL | Futures | 25.78 | 26.87 | 25.58 | 26.69 | 343483.0 |
| 2020-06-02 | GC | Futures | 2101.4 | 2109.5 | 2074.7 | 2081.9 | 175351.0 |
| 2020-06-02 | ZN | Futures | 137.639453 | 137.732067 | 137.43879 | 137.500532 | 23513.0 |
| 2020-06-02 | A6 | Futures | 0.6987 | 0.70877 | 0.69614 | 0.70774 | 101962.0 |
| 2020-06-02 | AD | Futures | 0.74664 | 0.75155 | 0.74593 | 0.74973 | 76146.0 |
| 2020-06-02 | ALI | Futures | 1837.94 | 1865.86 | 1823.97 | 1865.86 | 168.0 |
| 2020-06-02 | B | Futures | 25.1 | 26.02 | 25.04 | 25.9 | 205218.0 |
| 2020-06-02 | B6 | Futures | 1.268 | 1.2767 | 1.2667 | 1.2731 | 109335.0 |
| 2020-06-02 | BR | Futures | 0.14825 | 0.15122 | 0.14825 | 0.15122 | 51.0 |
| 2020-06-02 | BTC | Futures | 13553.6 | 14694.1 | 12983.4 | 13324.1 | 14048.0 |
| 2020-06-02 | BZ | Futures | 24.6 | 25.44 | 24.51 | 25.3 | 27662.0 |
| 2020-06-02 | C | Futures | 1878.0 | 1878.0 | 1809.0 | 1816.0 | 8077.0 |
| 2020-06-02 | CB | Futures | 203.118 | 203.278 | 203.118 | 203.278 | 9.0 |
| 2020-06-02 | CC | Futures | 1632.0 | 1635.0 | 1565.0 | 1570.0 | 24633.0 |
| 2020-06-02 | CNH | Futures | 7.0671 | 7.0697 | 7.0419 | 7.0439 | 559.0 |
| 2020-06-02 | CSC | Futures | 3.457 | 3.457 | 3.428 | 3.457 | 42.0 |
| 2020-06-02 | CT | Futures | 58.78 | 59.61 | 58.49 | 58.85 | 20390.0 |
| 2020-06-02 | DC | Futures | 28.53 | 28.86 | 28.45 | 28.76 | 136.0 |
| 2020-06-02 | DX | Futures | 94.628 | 94.667 | 94.203 | 94.434 | 15324.0 |
| 2020-06-02 | E1 | Futures | 1.18533 | 1.19 | 1.18203 | 1.18397 | 26331.0 |
| 2020-06-02 | E6 | Futures | 1.1967 | 1.20369 | 1.19487 | 1.201 | 189688.0 |
| 2020-06-02 | E7 | Futures | 1.1907 | 1.1973 | 1.1887 | 1.1948 | 7110.0 |
| 2020-06-02 | EBM | Futures | 223.35 | 224.24 | 220.05 | 220.65 | 16874.0 |
| 2020-06-02 | ED | Futures | 96.3944 | 96.3968 | 96.3895 | 96.3944 | 89928.0 |
| 2020-06-02 | ER | Futures | 98.308 | 98.318 | 98.308 | 98.313 | 49393.0 |
| 2020-06-02 | ESG | Futures | 275.53 | 277.59 | 275.19 | 277.59 | 325.0 |
| 2020-06-02 | EW | Futures | 1892.9 | 1912.3 | 1874.9 | 1906.5 | 9099.0 |
| 2020-06-02 | FBON | Futures | 143.48 | 143.72 | 143.41 | 143.46 | 614.0 |
| 2020-06-02 | FBTP | Futures | 127.15 | 127.58 | 126.69 | 126.9 | 200613.0 |
| 2020-06-02 | FBTS | Futures | 107.778 | 107.922 | 107.749 | 107.816 | 127694.0 |
| 2020-06-02 | FCE | Futures | 4656.8 | 4735.5 | 4640.8 | 4712.6 | 71717.0 |
| 2020-06-02 | FDAX | Futures | 12596.5 | 12778.4 | 12531.0 | 12686.4 | 84692.0 |
| 2020-06-02 | FDIV | Futures | 135.98 | 136.3 | 135.98 | 136.3 | 200.0 |
| 2020-06-02 | FDXM | Futures | 12648.2 | 12840.6 | 12591.9 | 12747.0 | 62710.0 |
| 2020-06-02 | FESX | Futures | 2855.4 | 2905.8 | 2847.1 | 2886.6 | 1502449.0 |
| 2020-06-02 | FGBL | Futures | 167.11 | 167.34 | 166.87 | 167.05 | 1109518.0 |
| 2020-06-02 | FGBM | Futures | 134.4 | 134.49 | 134.27 | 134.34 | 818419.0 |
| 2020-06-02 | FGBS | Futures | 112.759 | 112.775 | 112.709 | 112.714 | 762441.0 |
| 2020-06-02 | FGBX | Futures | 221.75 | 222.54 | 221.03 | 222.03 | 146596.0 |
| 2020-06-02 | FMWO | Futures | 7528.0 | 7611.5 | 7526.8 | 7564.5 | 3701.0 |
| 2020-06-02 | FOAT | Futures | 153.03 | 153.37 | 153.0 | 153.13 | 259894.0 |
| 2020-06-02 | FTDX | Futures | 3295.4 | 3295.4 | 3239.3 | 3239.3 | 75.0 |
| 2020-06-02 | FTI | Futures | 505.75 | 511.1 | 503.98 | 508.41 | 25492.0 |
| 2020-06-02 | FTUK | Futures | 5813.4 | 5883.7 | 5802.6 | 5865.3 | 81362.0 |
| 2020-06-02 | FVSA | Futures | 261.49 | 261.49 | 249.73 | 259.23 | 18692.0 |
| 2020-06-02 | FXXP | Futures | 331.3 | 334.2 | 330.1 | 332.4 | 88994.0 |
| 2020-06-02 | G | Futures | 126.73 | 126.88 | 126.46 | 126.58 | 217334.0 |
> showing 50 of 120 rows — these rows as CSV