PREVIEW / futures_daily / 2018-07-30
file: by_date/futures_daily/2018/2018-07-30.parquet size: 10 KB rows: 113
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 |
|---|---|---|---|---|---|---|---|
| 2018-07-30 | ES | Futures | 3058.45 | 3064.7 | 3039.17 | 3044.6 | 1169457.0 |
| 2018-07-30 | NQ | Futures | 8502.92 | 8521.87 | 8355.73 | 8395.08 | 497537.0 |
| 2018-07-30 | YM | Futures | 26787.0 | 26842.8 | 26620.5 | 26642.6 | 152238.0 |
| 2018-07-30 | CL | Futures | 71.4 | 72.87 | 71.18 | 72.56 | 463011.0 |
| 2018-07-30 | GC | Futures | 1560.3 | 1564.1 | 1556.1 | 1560.8 | 183752.0 |
| 2018-07-30 | ZN | Futures | 118.826361 | 118.826361 | 118.593277 | 118.717589 | 1053711.0 |
| 2018-07-30 | A6 | Futures | 0.76151 | 0.76254 | 0.75977 | 0.76223 | 56112.0 |
| 2018-07-30 | AD | Futures | 0.77619 | 0.78009 | 0.77503 | 0.77842 | 57077.0 |
| 2018-07-30 | B | Futures | 54.63 | 55.25 | 54.41 | 55.07 | 203108.0 |
| 2018-07-30 | B6 | Futures | 1.3548 | 1.3597 | 1.3539 | 1.3578 | 67045.0 |
| 2018-07-30 | BR | Futures | 0.20342 | 0.20677 | 0.20304 | 0.20353 | 2271.0 |
| 2018-07-30 | BTC | Futures | 11596.2 | 11774.3 | 11176.0 | 11539.3 | 8136.0 |
| 2018-07-30 | BZ | Futures | 54.44 | 55.16 | 54.33 | 55.0 | 21184.0 |
| 2018-07-30 | C | Futures | 1563.0 | 1586.0 | 1563.0 | 1569.0 | 8933.0 |
| 2018-07-30 | CB | Futures | 273.332 | 273.452 | 271.743 | 272.582 | 20.0 |
| 2018-07-30 | CC | Futures | 1593.0 | 1634.0 | 1593.0 | 1605.0 | 16904.0 |
| 2018-07-30 | CNH | Futures | 6.9003 | 6.9181 | 6.8995 | 6.9009 | 35.0 |
| 2018-07-30 | CSC | Futures | 3.248 | 3.25 | 3.208 | 3.226 | 72.0 |
| 2018-07-30 | CT | Futures | 99.95 | 101.67 | 99.28 | 100.93 | 77.0 |
| 2018-07-30 | DC | Futures | 26.08 | 26.18 | 25.8 | 26.03 | 138.0 |
| 2018-07-30 | DX | Futures | 89.487 | 89.553 | 89.065 | 89.133 | 12396.0 |
| 2018-07-30 | E1 | Futures | 1.20672 | 1.2146 | 1.20492 | 1.21448 | 25415.0 |
| 2018-07-30 | E6 | Futures | 1.30827 | 1.31531 | 1.30721 | 1.3142 | 183956.0 |
| 2018-07-30 | E7 | Futures | 1.3016 | 1.3086 | 1.3006 | 1.3075 | 2231.0 |
| 2018-07-30 | EBM | Futures | 210.02 | 212.64 | 209.24 | 211.85 | 16286.0 |
| 2018-07-30 | ED | Futures | 95.0156 | 95.0156 | 95.0059 | 95.0059 | 93642.0 |
| 2018-07-30 | ER | Futures | 98.367 | 98.367 | 98.362 | 98.367 | 49084.0 |
| 2018-07-30 | EW | Futures | 2090.3 | 2101.3 | 2082.3 | 2083.8 | 15626.0 |
| 2018-07-30 | FBON | Futures | 129.27 | 129.37 | 128.8 | 128.81 | 196.0 |
| 2018-07-30 | FBTP | Futures | 107.71 | 107.71 | 107.15 | 107.27 | 81801.0 |
| 2018-07-30 | FBTS | Futures | 102.633 | 102.661 | 102.531 | 102.577 | 35141.0 |
| 2018-07-30 | FCE | Futures | 4915.9 | 4940.1 | 4906.9 | 4924.4 | 38895.0 |
| 2018-07-30 | FDAX | Futures | 13364.1 | 13423.7 | 13336.4 | 13381.3 | 58334.0 |
| 2018-07-30 | FDXM | Futures | 13188.7 | 13252.7 | 13166.0 | 13210.4 | 25575.0 |
| 2018-07-30 | FESX | Futures | 2924.0 | 2938.2 | 2921.5 | 2931.6 | 583478.0 |
| 2018-07-30 | FEU3 | Futures | 99.011 | 99.016 | 99.011 | 99.016 | 198.0 |
| 2018-07-30 | FGBL | Futures | 152.77 | 152.93 | 152.02 | 152.11 | 631434.0 |
| 2018-07-30 | FGBM | Futures | 130.9 | 130.96 | 130.62 | 130.67 | 368839.0 |
| 2018-07-30 | FGBS | Futures | 112.638 | 112.648 | 112.598 | 112.603 | 274359.0 |
| 2018-07-30 | FGBX | Futures | 176.63 | 177.02 | 174.71 | 174.95 | 36693.0 |
| 2018-07-30 | FMWO | Futures | 7164.9 | 7181.2 | 7145.1 | 7167.3 | 1815.0 |
| 2018-07-30 | FOAT | Futures | 140.67 | 140.81 | 140.03 | 140.1 | 118413.0 |
| 2018-07-30 | FTDX | Futures | 2875.0 | 2886.3 | 2845.6 | 2853.9 | 424.0 |
| 2018-07-30 | FTI | Futures | 525.96 | 528.55 | 525.55 | 526.79 | 20794.0 |
| 2018-07-30 | FTUK | Futures | 6784.0 | 6822.8 | 6762.6 | 6809.4 | 60153.0 |
| 2018-07-30 | FVSA | Futures | 264.65 | 269.42 | 257.96 | 264.65 | 15785.0 |
| 2018-07-30 | FXXP | Futures | 336.5 | 337.9 | 336.1 | 337.2 | 31072.0 |
| 2018-07-30 | G | Futures | 115.67 | 115.67 | 114.84 | 114.91 | 261677.0 |
| 2018-07-30 | GF | Futures | 315.138 | 316.691 | 312.963 | 313.843 | 4426.0 |
| 2018-07-30 | GSCI | Futures | 529.0 | 529.17 | 527.98 | 528.27 | 7.0 |
> showing 50 of 113 rows — these rows as CSV