PREVIEW / futures_daily / 2020-03-03
file: by_date/futures_daily/2020/2020-03-03.parquet size: 10 KB rows: 122
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-03-03 | ES | Futures | 3323.2 | 3388.0 | 3210.88 | 3236.8 | 3754363.0 |
| 2020-03-03 | NQ | Futures | 10128.75 | 10326.04 | 9762.28 | 9844.29 | 1295648.0 |
| 2020-03-03 | YM | Futures | 27895.5 | 28417.5 | 26968.2 | 27179.3 | 607045.0 |
| 2020-03-03 | CL | Futures | 48.72 | 49.68 | 47.45 | 48.17 | 1011933.0 |
| 2020-03-03 | GC | Futures | 1933.7 | 2012.4 | 1933.6 | 2004.9 | 466533.0 |
| 2020-03-03 | ZN | Futures | 133.352436 | 135.737324 | 133.290491 | 134.792661 | 60328.0 |
| 2020-03-03 | A6 | Futures | 0.67098 | 0.68143 | 0.66759 | 0.67641 | 206137.0 |
| 2020-03-03 | AD | Futures | 0.75582 | 0.75668 | 0.75249 | 0.7534 | 130565.0 |
| 2020-03-03 | ALI | Futures | 2077.24 | 2077.24 | 2076.04 | 2076.94 | 30.0 |
| 2020-03-03 | B | Futures | 45.48 | 45.85 | 43.57 | 44.11 | 407554.0 |
| 2020-03-03 | B6 | Futures | 1.2946 | 1.3028 | 1.2941 | 1.2995 | 151289.0 |
| 2020-03-03 | BR | Futures | 0.18263 | 0.18291 | 0.1807 | 0.1809 | 200.0 |
| 2020-03-03 | BTC | Futures | 13126.8 | 13134.1 | 12761.7 | 12805.5 | 2956.0 |
| 2020-03-03 | BZ | Futures | 43.86 | 44.6 | 42.42 | 42.94 | 42862.0 |
| 2020-03-03 | C | Futures | 1826.0 | 1838.0 | 1805.0 | 1812.0 | 3237.0 |
| 2020-03-03 | CB | Futures | 219.663 | 219.663 | 218.046 | 219.663 | 14.0 |
| 2020-03-03 | CC | Futures | 1741.0 | 1746.0 | 1722.0 | 1737.0 | 20892.0 |
| 2020-03-03 | CNH | Futures | 6.914 | 6.9507 | 6.905 | 6.9126 | 993.0 |
| 2020-03-03 | CSC | Futures | 3.209 | 3.22 | 3.172 | 3.183 | 125.0 |
| 2020-03-03 | CT | Futures | 61.37 | 62.65 | 60.3 | 60.43 | 21426.0 |
| 2020-03-03 | DC | Futures | 26.45 | 26.56 | 26.15 | 26.23 | 172.0 |
| 2020-03-03 | DX | Futures | 94.652 | 94.783 | 94.026 | 94.266 | 51417.0 |
| 2020-03-03 | E1 | Futures | 1.19375 | 1.20129 | 1.19135 | 1.19443 | 77723.0 |
| 2020-03-03 | E6 | Futures | 1.20167 | 1.20884 | 1.19623 | 1.20512 | 374128.0 |
| 2020-03-03 | E7 | Futures | 1.1951 | 1.2024 | 1.1901 | 1.1989 | 11382.0 |
| 2020-03-03 | EBM | Futures | 206.05 | 207.42 | 205.5 | 205.5 | 5762.0 |
| 2020-03-03 | ED | Futures | 95.7691 | 96.0625 | 95.7473 | 96.0092 | 1399325.0 |
| 2020-03-03 | ER | Futures | 98.47 | 98.494 | 98.44 | 98.489 | 296509.0 |
| 2020-03-03 | ESG | Futures | 277.29 | 277.29 | 269.03 | 269.03 | 817.0 |
| 2020-03-03 | EW | Futures | 1964.7 | 2006.4 | 1911.3 | 1929.0 | 35166.0 |
| 2020-03-03 | FBON | Futures | 145.66 | 147.07 | 145.66 | 146.61 | 2786.0 |
| 2020-03-03 | FBTP | Futures | 131.01 | 132.35 | 130.63 | 132.04 | 411486.0 |
| 2020-03-03 | FBTS | Futures | 108.345 | 108.499 | 108.22 | 108.422 | 223322.0 |
| 2020-03-03 | FCE | Futures | 4857.9 | 4981.9 | 4779.7 | 4875.1 | 241333.0 |
| 2020-03-03 | FDAX | Futures | 12742.6 | 12974.7 | 12405.8 | 12609.9 | 215194.0 |
| 2020-03-03 | FDIV | Futures | 141.68 | 143.35 | 139.5 | 139.5 | 128.0 |
| 2020-03-03 | FDXM | Futures | 12602.0 | 12810.8 | 12251.1 | 12451.6 | 336938.0 |
| 2020-03-03 | FESX | Futures | 2978.9 | 3036.1 | 2907.5 | 2954.2 | 2888480.0 |
| 2020-03-03 | FEU3 | Futures | 99.169 | 99.208 | 99.169 | 99.198 | 250.0 |
| 2020-03-03 | FGBL | Futures | 169.45 | 170.26 | 168.9 | 169.77 | 1843311.0 |
| 2020-03-03 | FGBM | Futures | 135.31 | 135.63 | 135.13 | 135.43 | 1352572.0 |
| 2020-03-03 | FGBS | Futures | 113.107 | 113.127 | 112.996 | 113.081 | 1062544.0 |
| 2020-03-03 | FGBX | Futures | 229.94 | 232.73 | 227.58 | 230.38 | 276614.0 |
| 2020-03-03 | FMWO | Futures | 7356.4 | 7511.7 | 7197.6 | 7300.8 | 11159.0 |
| 2020-03-03 | FOAT | Futures | 155.91 | 156.66 | 155.56 | 156.42 | 628368.0 |
| 2020-03-03 | FTDX | Futures | 2921.8 | 3013.7 | 2921.8 | 2942.9 | 256.0 |
| 2020-03-03 | FTI | Futures | 525.64 | 539.03 | 517.24 | 527.84 | 88973.0 |
| 2020-03-03 | FTUK | Futures | 6324.7 | 6402.1 | 6176.9 | 6271.6 | 262173.0 |
| 2020-03-03 | FVSA | Futures | 196.45 | 221.26 | 182.62 | 206.62 | 95524.0 |
| 2020-03-03 | FXXP | Futures | 345.0 | 353.9 | 340.5 | 346.3 | 176594.0 |
> showing 50 of 122 rows — these rows as CSV