PREVIEW / futures_daily / 2020-01-08
file: by_date/futures_daily/2020/2020-01-08.parquet size: 10 KB rows: 119
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-01-08 | ES | Futures | 3490.33 | 3529.21 | 3435.52 | 3521.11 | 2279138.0 |
| 2020-01-08 | NQ | Futures | 10141.37 | 10291.34 | 9953.83 | 10259.51 | 723085.0 |
| 2020-01-08 | YM | Futures | 29932.9 | 30280.6 | 29494.0 | 30214.4 | 337249.0 |
| 2020-01-08 | CL | Futures | 64.42 | 67.3 | 60.64 | 61.11 | 1205710.0 |
| 2020-01-08 | GC | Futures | 1942.4 | 1984.8 | 1911.1 | 1919.5 | 813406.0 |
| 2020-01-08 | ZN | Futures | 128.102584 | 129.031761 | 127.591536 | 127.622509 | 2993268.0 |
| 2020-01-08 | A6 | Futures | 0.70532 | 0.70696 | 0.70317 | 0.70563 | 141112.0 |
| 2020-01-08 | AD | Futures | 0.77491 | 0.77663 | 0.77255 | 0.77355 | 80341.0 |
| 2020-01-08 | ALI | Futures | 2208.82 | 2208.82 | 2181.08 | 2189.52 | 418.0 |
| 2020-01-08 | B | Futures | 58.23 | 58.66 | 53.09 | 53.5 | 560891.0 |
| 2020-01-08 | B6 | Futures | 1.3327 | 1.338 | 1.3289 | 1.331 | 87537.0 |
| 2020-01-08 | BR | Futures | 0.19863 | 0.20013 | 0.19851 | 0.20013 | 334.0 |
| 2020-01-08 | BTC | Futures | 12377.1 | 13028.9 | 11998.1 | 12293.7 | 16332.0 |
| 2020-01-08 | BZ | Futures | 55.19 | 58.03 | 52.35 | 52.75 | 85232.0 |
| 2020-01-08 | C | Futures | 1735.0 | 1737.0 | 1721.0 | 1723.0 | 5585.0 |
| 2020-01-08 | CB | Futures | 241.735 | 241.735 | 238.757 | 238.757 | 151.0 |
| 2020-01-08 | CC | Futures | 1655.0 | 1658.0 | 1633.0 | 1636.0 | 13837.0 |
| 2020-01-08 | CNH | Futures | 6.9165 | 6.935 | 6.9071 | 6.9097 | 643.0 |
| 2020-01-08 | CSC | Futures | 3.381 | 3.381 | 3.35 | 3.364 | 30.0 |
| 2020-01-08 | CT | Futures | 66.29 | 66.62 | 65.68 | 66.54 | 18796.0 |
| 2020-01-08 | DC | Futures | 28.24 | 28.24 | 27.94 | 28.04 | 137.0 |
| 2020-01-08 | DX | Futures | 93.721 | 94.186 | 93.687 | 94.144 | 13725.0 |
| 2020-01-08 | E1 | Futures | 1.18232 | 1.18735 | 1.17821 | 1.17856 | 36540.0 |
| 2020-01-08 | E6 | Futures | 1.20636 | 1.20824 | 1.20103 | 1.20205 | 208215.0 |
| 2020-01-08 | E7 | Futures | 1.1998 | 1.202 | 1.1948 | 1.1958 | 3360.0 |
| 2020-01-08 | EBM | Futures | 207.7 | 209.07 | 207.42 | 208.8 | 18876.0 |
| 2020-01-08 | ED | Futures | 95.3326 | 95.3811 | 95.318 | 95.3229 | 398417.0 |
| 2020-01-08 | ER | Futures | 98.382 | 98.382 | 98.377 | 98.377 | 58383.0 |
| 2020-01-08 | EW | Futures | 2154.2 | 2170.4 | 2120.6 | 2161.9 | 17616.0 |
| 2020-01-08 | FBON | Futures | 143.65 | 143.73 | 143.21 | 143.41 | 183.0 |
| 2020-01-08 | FBTP | Futures | 128.47 | 128.47 | 127.62 | 127.94 | 70175.0 |
| 2020-01-08 | FBTS | Futures | 108.259 | 108.259 | 108.105 | 108.143 | 32374.0 |
| 2020-01-08 | FCE | Futures | 5416.8 | 5489.7 | 5405.5 | 5459.8 | 76827.0 |
| 2020-01-08 | FDAX | Futures | 13749.9 | 14170.3 | 13710.2 | 14080.9 | 141352.0 |
| 2020-01-08 | FDIV | Futures | 159.82 | 159.82 | 159.17 | 159.82 | 50.0 |
| 2020-01-08 | FDXM | Futures | 13664.0 | 13991.9 | 13538.7 | 13904.2 | 76045.0 |
| 2020-01-08 | FESX | Futures | 3260.7 | 3331.2 | 3246.6 | 3312.7 | 974550.0 |
| 2020-01-08 | FGBL | Futures | 164.76 | 165.45 | 163.58 | 164.08 | 825735.0 |
| 2020-01-08 | FGBM | Futures | 133.88 | 134.11 | 133.51 | 133.66 | 484794.0 |
| 2020-01-08 | FGBS | Futures | 112.699 | 112.749 | 112.649 | 112.674 | 312303.0 |
| 2020-01-08 | FGBX | Futures | 212.48 | 214.32 | 209.09 | 210.45 | 61482.0 |
| 2020-01-08 | FMWO | Futures | 7847.4 | 7917.7 | 7837.2 | 7895.0 | 3281.0 |
| 2020-01-08 | FOAT | Futures | 152.16 | 152.19 | 151.4 | 151.73 | 164930.0 |
| 2020-01-08 | FTDX | Futures | 3027.8 | 3054.9 | 3019.7 | 3052.9 | 36.0 |
| 2020-01-08 | FTI | Futures | 580.16 | 587.63 | 579.92 | 584.59 | 32244.0 |
| 2020-01-08 | FTUK | Futures | 6986.5 | 7078.9 | 6967.3 | 7041.4 | 99148.0 |
| 2020-01-08 | FVSA | Futures | 134.88 | 135.35 | 122.7 | 125.98 | 37590.0 |
| 2020-01-08 | FXXP | Futures | 377.1 | 381.9 | 376.7 | 380.0 | 50122.0 |
| 2020-01-08 | G | Futures | 120.24 | 120.24 | 119.64 | 120.0 | 181225.0 |
| 2020-01-08 | GF | Futures | 307.336 | 309.864 | 306.599 | 309.285 | 1748.0 |
> showing 50 of 119 rows — these rows as CSV