PREVIEW / futures_daily / 2019-05-16
file: by_date/futures_daily/2019/2019-05-16.parquet size: 10 KB rows: 121
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 |
|---|---|---|---|---|---|---|---|
| 2019-05-16 | ES | Futures | 3082.28 | 3126.03 | 3068.24 | 3109.28 | 1687728.0 |
| 2019-05-16 | NQ | Futures | 8669.48 | 8804.0 | 8611.0 | 8757.04 | 525588.0 |
| 2019-05-16 | YM | Futures | 27096.1 | 27397.0 | 26973.7 | 27304.1 | 232025.0 |
| 2019-05-16 | CL | Futures | 63.97 | 65.37 | 63.95 | 64.72 | 312352.0 |
| 2019-05-16 | GC | Futures | 1615.1 | 1617.1 | 1598.3 | 1600.8 | 282065.0 |
| 2019-05-16 | ZN | Futures | 124.005052 | 124.160447 | 123.632104 | 123.740881 | 1441988.0 |
| 2019-05-16 | A6 | Futures | 0.71477 | 0.71518 | 0.71034 | 0.71096 | 97415.0 |
| 2019-05-16 | AD | Futures | 0.75286 | 0.75499 | 0.7511 | 0.75155 | 71445.0 |
| 2019-05-16 | ALI | Futures | 2718.01 | 2718.01 | 2718.01 | 2718.01 | 0.0 |
| 2019-05-16 | B | Futures | 53.09 | 54.06 | 52.92 | 53.51 | 326435.0 |
| 2019-05-16 | B6 | Futures | 1.3177 | 1.3184 | 1.3119 | 1.3123 | 78998.0 |
| 2019-05-16 | BFX | Futures | 4057.8 | 4132.3 | 4057.8 | 4132.3 | 41.0 |
| 2019-05-16 | BR | Futures | 0.20036 | 0.20056 | 0.19712 | 0.1978 | 3944.0 |
| 2019-05-16 | BTC | Futures | 12658.0 | 13060.1 | 11946.6 | 12178.6 | 19966.0 |
| 2019-05-16 | BZ | Futures | 52.87 | 53.9 | 52.78 | 53.37 | 56835.0 |
| 2019-05-16 | C | Futures | 1648.0 | 1694.0 | 1641.0 | 1692.0 | 11516.0 |
| 2019-05-16 | CB | Futures | 282.431 | 284.405 | 282.431 | 284.106 | 26.0 |
| 2019-05-16 | CC | Futures | 1563.0 | 1602.0 | 1550.0 | 1597.0 | 22465.0 |
| 2019-05-16 | CNH | Futures | 6.9156 | 6.9438 | 6.9156 | 6.9414 | 647.0 |
| 2019-05-16 | CSC | Futures | 2.989 | 2.989 | 2.97 | 2.973 | 53.0 |
| 2019-05-16 | CT | Futures | 69.43 | 70.31 | 69.43 | 69.92 | 13732.0 |
| 2019-05-16 | DC | Futures | 25.0 | 25.04 | 24.81 | 24.86 | 277.0 |
| 2019-05-16 | DX | Futures | 93.316 | 93.662 | 93.23 | 93.626 | 12121.0 |
| 2019-05-16 | E1 | Futures | 1.16061 | 1.16166 | 1.15781 | 1.15839 | 17742.0 |
| 2019-05-16 | E6 | Futures | 1.23294 | 1.23492 | 1.22855 | 1.22899 | 139482.0 |
| 2019-05-16 | E7 | Futures | 1.2268 | 1.2287 | 1.2224 | 1.2229 | 2962.0 |
| 2019-05-16 | EBM | Futures | 198.35 | 200.37 | 198.06 | 200.08 | 16361.0 |
| 2019-05-16 | ED | Futures | 95.2039 | 95.2063 | 95.1941 | 95.1941 | 247537.0 |
| 2019-05-16 | ER | Futures | 98.421 | 98.426 | 98.421 | 98.421 | 27548.0 |
| 2019-05-16 | EW | Futures | 2018.6 | 2042.5 | 2008.8 | 2030.2 | 13378.0 |
| 2019-05-16 | FBON | Futures | 136.92 | 137.49 | 136.88 | 137.44 | 837.0 |
| 2019-05-16 | FBTP | Futures | 114.47 | 115.09 | 114.14 | 114.95 | 104309.0 |
| 2019-05-16 | FBTS | Futures | 105.398 | 105.589 | 105.303 | 105.532 | 64513.0 |
| 2019-05-16 | FCE | Futures | 4797.1 | 4891.6 | 4795.3 | 4887.5 | 74095.0 |
| 2019-05-16 | FDAX | Futures | 12718.0 | 12966.9 | 12623.8 | 12948.5 | 145300.0 |
| 2019-05-16 | FDIV | Futures | 147.9 | 148.23 | 147.9 | 147.99 | 61.0 |
| 2019-05-16 | FDXM | Futures | 12618.2 | 12854.0 | 12512.8 | 12836.3 | 66283.0 |
| 2019-05-16 | FESX | Futures | 2928.7 | 2982.0 | 2908.6 | 2976.8 | 1401704.0 |
| 2019-05-16 | FGBL | Futures | 161.24 | 161.44 | 160.97 | 161.13 | 793321.0 |
| 2019-05-16 | FGBM | Futures | 133.59 | 133.65 | 133.47 | 133.54 | 526315.0 |
| 2019-05-16 | FGBS | Futures | 112.9 | 112.91 | 112.87 | 112.885 | 347672.0 |
| 2019-05-16 | FGBX | Futures | 198.21 | 198.95 | 197.35 | 197.72 | 43373.0 |
| 2019-05-16 | FMWO | Futures | 7066.9 | 7176.8 | 7066.9 | 7171.0 | 2844.0 |
| 2019-05-16 | FOAT | Futures | 147.74 | 147.95 | 147.6 | 147.75 | 147609.0 |
| 2019-05-16 | FTDX | Futures | 2783.7 | 2840.4 | 2779.2 | 2837.4 | 166.0 |
| 2019-05-16 | FTI | Futures | 518.53 | 527.54 | 517.53 | 526.75 | 21016.0 |
| 2019-05-16 | FTUK | Futures | 6661.9 | 6739.8 | 6634.4 | 6728.8 | 102207.0 |
| 2019-05-16 | FVSA | Futures | 232.38 | 233.81 | 215.99 | 218.84 | 27346.0 |
| 2019-05-16 | FXXP | Futures | 335.0 | 341.1 | 334.9 | 340.5 | 65514.0 |
| 2019-05-16 | G | Futures | 118.78 | 118.99 | 118.5 | 118.6 | 151166.0 |
> showing 50 of 121 rows — these rows as CSV