PREVIEW / futures_daily / 2020-02-18
file: by_date/futures_daily/2020/2020-02-18.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-02-18 | ES | Futures | 3652.88 | 3663.95 | 3623.72 | 3638.84 | 1735931.0 |
| 2020-02-18 | NQ | Futures | 11051.53 | 11111.75 | 10935.97 | 11052.68 | 668505.0 |
| 2020-02-18 | YM | Futures | 30859.2 | 30955.8 | 30561.0 | 30677.5 | 268667.0 |
| 2020-02-18 | CL | Futures | 53.59 | 53.76 | 52.23 | 53.39 | 723143.0 |
| 2020-02-18 | GC | Futures | 1932.6 | 1960.8 | 1928.6 | 1955.2 | 414235.0 |
| 2020-02-18 | ZN | Futures | 129.775103 | 130.224206 | 129.666699 | 130.03837 | 1883347.0 |
| 2020-02-18 | A6 | Futures | 0.68902 | 0.69066 | 0.68451 | 0.68584 | 125741.0 |
| 2020-02-18 | AD | Futures | 0.76045 | 0.76192 | 0.75884 | 0.76035 | 92174.0 |
| 2020-02-18 | ALI | Futures | 2086.57 | 2097.4 | 2079.05 | 2090.48 | 293.0 |
| 2020-02-18 | B | Futures | 47.53 | 47.93 | 46.66 | 47.86 | 249196.0 |
| 2020-02-18 | B6 | Futures | 1.3236 | 1.3249 | 1.3163 | 1.3193 | 140102.0 |
| 2020-02-18 | BFX | Futures | 4915.4 | 4920.0 | 4915.4 | 4920.0 | 1.0 |
| 2020-02-18 | BR | Futures | 0.18841 | 0.18853 | 0.18589 | 0.18606 | 6810.0 |
| 2020-02-18 | BTC | Futures | 14976.3 | 15554.0 | 14263.5 | 15381.4 | 20878.0 |
| 2020-02-18 | BZ | Futures | 46.82 | 47.22 | 45.97 | 47.16 | 47337.0 |
| 2020-02-18 | C | Futures | 1890.0 | 1900.0 | 1859.0 | 1875.0 | 2716.0 |
| 2020-02-18 | CB | Futures | 223.282 | 226.938 | 223.282 | 225.994 | 29.0 |
| 2020-02-18 | CC | Futures | 1898.0 | 1901.0 | 1851.0 | 1864.0 | 19871.0 |
| 2020-02-18 | CNH | Futures | 6.9543 | 6.9762 | 6.9422 | 6.9742 | 662.0 |
| 2020-02-18 | CSC | Futures | 3.318 | 3.318 | 3.286 | 3.316 | 98.0 |
| 2020-02-18 | CT | Futures | 64.62 | 65.55 | 64.52 | 64.56 | 10513.0 |
| 2020-02-18 | DC | Futures | 27.48 | 27.56 | 27.18 | 27.51 | 472.0 |
| 2020-02-18 | DX | Futures | 96.186 | 96.453 | 96.118 | 96.412 | 13756.0 |
| 2020-02-18 | E1 | Futures | 1.16542 | 1.16816 | 1.16302 | 1.16416 | 36627.0 |
| 2020-02-18 | E6 | Futures | 1.16962 | 1.17097 | 1.16375 | 1.16472 | 313856.0 |
| 2020-02-18 | E7 | Futures | 1.1632 | 1.1648 | 1.1577 | 1.1587 | 7018.0 |
| 2020-02-18 | EBM | Futures | 214.84 | 215.94 | 214.57 | 215.39 | 22032.0 |
| 2020-02-18 | ED | Futures | 95.3932 | 95.4005 | 95.3859 | 95.3981 | 327225.0 |
| 2020-02-18 | ER | Futures | 98.396 | 98.401 | 98.391 | 98.396 | 38073.0 |
| 2020-02-18 | ESG | Futures | 301.47 | 302.15 | 300.64 | 301.71 | 1056.0 |
| 2020-02-18 | EW | Futures | 2210.3 | 2216.4 | 2187.2 | 2200.4 | 13063.0 |
| 2020-02-18 | FBON | Futures | 145.97 | 146.17 | 145.58 | 145.71 | 625.0 |
| 2020-02-18 | FBTP | Futures | 132.97 | 133.21 | 132.58 | 132.6 | 78786.0 |
| 2020-02-18 | FBTS | Futures | 108.672 | 108.711 | 108.624 | 108.624 | 48072.0 |
| 2020-02-18 | FCE | Futures | 5473.4 | 5496.1 | 5457.6 | 5475.7 | 78494.0 |
| 2020-02-18 | FDAX | Futures | 14527.2 | 14541.5 | 14436.2 | 14445.8 | 111385.0 |
| 2020-02-18 | FDIV | Futures | 160.06 | 160.06 | 159.78 | 159.78 | 80.0 |
| 2020-02-18 | FDXM | Futures | 14352.1 | 14357.4 | 14255.0 | 14264.4 | 68224.0 |
| 2020-02-18 | FESX | Futures | 3380.5 | 3385.8 | 3364.7 | 3372.6 | 1106662.0 |
| 2020-02-18 | FGBL | Futures | 166.68 | 167.08 | 166.47 | 166.7 | 761810.0 |
| 2020-02-18 | FGBM | Futures | 134.33 | 134.44 | 134.24 | 134.31 | 459342.0 |
| 2020-02-18 | FGBS | Futures | 112.754 | 112.774 | 112.729 | 112.744 | 286546.0 |
| 2020-02-18 | FGBX | Futures | 218.19 | 219.82 | 217.48 | 218.36 | 68118.0 |
| 2020-02-18 | FMWO | Futures | 8079.9 | 8081.0 | 8039.1 | 8043.6 | 2375.0 |
| 2020-02-18 | FOAT | Futures | 154.67 | 154.79 | 154.22 | 154.4 | 186864.0 |
| 2020-02-18 | FTDX | Futures | 3249.9 | 3257.9 | 3234.8 | 3248.9 | 37.0 |
| 2020-02-18 | FTI | Futures | 600.21 | 601.46 | 597.0 | 599.61 | 13591.0 |
| 2020-02-18 | FTUK | Futures | 6895.5 | 6918.0 | 6850.5 | 6867.4 | 100720.0 |
| 2020-02-18 | FVSA | Futures | 112.67 | 114.7 | 112.26 | 114.29 | 50128.0 |
| 2020-02-18 | FXXP | Futures | 390.6 | 392.6 | 389.7 | 391.1 | 57011.0 |
> showing 50 of 120 rows — these rows as CSV