PREVIEW / futures_daily / 2019-05-23
file: by_date/futures_daily/2019/2019-05-23.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-23 | ES | Futures | 3086.87 | 3087.68 | 3030.7 | 3045.55 | 2013518.0 |
| 2019-05-23 | NQ | Futures | 8561.75 | 8566.35 | 8374.22 | 8423.77 | 640165.0 |
| 2019-05-23 | YM | Futures | 27211.2 | 27211.2 | 26726.7 | 26877.6 | 300183.0 |
| 2019-05-23 | CL | Futures | 62.92 | 63.03 | 58.84 | 59.44 | 1108052.0 |
| 2019-05-23 | GC | Futures | 1584.8 | 1602.0 | 1583.3 | 1599.8 | 330160.0 |
| 2019-05-23 | ZN | Futures | 123.818578 | 124.533394 | 123.787499 | 124.517855 | 3130623.0 |
| 2019-05-23 | A6 | Futures | 0.70962 | 0.71168 | 0.70797 | 0.71096 | 91533.0 |
| 2019-05-23 | AD | Futures | 0.75297 | 0.75312 | 0.74912 | 0.75008 | 81792.0 |
| 2019-05-23 | ALI | Futures | 2718.01 | 2718.01 | 2718.01 | 2718.01 | 0.0 |
| 2019-05-23 | B | Futures | 52.21 | 52.3 | 49.39 | 49.93 | 434538.0 |
| 2019-05-23 | B6 | Futures | 1.2982 | 1.3007 | 1.2925 | 1.2977 | 114075.0 |
| 2019-05-23 | BFX | Futures | 4030.3 | 4030.3 | 4007.4 | 4023.8 | 33.0 |
| 2019-05-23 | BR | Futures | 0.19796 | 0.19868 | 0.19652 | 0.1976 | 2300.0 |
| 2019-05-23 | BTC | Futures | 11884.8 | 12209.5 | 11575.5 | 12078.1 | 10992.0 |
| 2019-05-23 | BZ | Futures | 52.09 | 52.12 | 49.24 | 49.79 | 80487.0 |
| 2019-05-23 | C | Futures | 1710.0 | 1730.0 | 1706.0 | 1721.0 | 5069.0 |
| 2019-05-23 | CB | Futures | 284.773 | 286.377 | 284.656 | 286.027 | 51.0 |
| 2019-05-23 | CC | Futures | 1626.0 | 1637.0 | 1610.0 | 1633.0 | 19399.0 |
| 2019-05-23 | CNH | Futures | 6.9498 | 6.9549 | 6.9383 | 6.9397 | 753.0 |
| 2019-05-23 | CSC | Futures | 2.975 | 2.994 | 2.975 | 2.985 | 42.0 |
| 2019-05-23 | CT | Futures | 69.87 | 71.41 | 69.62 | 70.64 | 14727.0 |
| 2019-05-23 | DC | Futures | 25.15 | 25.3 | 25.13 | 25.18 | 240.0 |
| 2019-05-23 | DX | Futures | 93.887 | 94.184 | 93.614 | 93.669 | 19345.0 |
| 2019-05-23 | E1 | Futures | 1.15886 | 1.16656 | 1.15781 | 1.16633 | 26800.0 |
| 2019-05-23 | E6 | Futures | 1.22636 | 1.23014 | 1.22114 | 1.22959 | 240487.0 |
| 2019-05-23 | E7 | Futures | 1.2204 | 1.224 | 1.2151 | 1.2235 | 5270.0 |
| 2019-05-23 | EBM | Futures | 201.81 | 204.11 | 201.23 | 202.09 | 14002.0 |
| 2019-05-23 | ED | Futures | 95.1795 | 95.199 | 95.1795 | 95.1965 | 340521.0 |
| 2019-05-23 | ER | Futures | 98.421 | 98.426 | 98.416 | 98.421 | 28435.0 |
| 2019-05-23 | EW | Futures | 2000.7 | 2000.7 | 1956.7 | 1967.5 | 14053.0 |
| 2019-05-23 | FBON | Futures | 138.01 | 138.11 | 137.9 | 138.02 | 539.0 |
| 2019-05-23 | FBTP | Futures | 115.39 | 115.46 | 115.11 | 115.34 | 74975.0 |
| 2019-05-23 | FBTS | Futures | 105.798 | 105.817 | 105.722 | 105.77 | 38646.0 |
| 2019-05-23 | FCE | Futures | 4808.9 | 4811.2 | 4739.4 | 4749.0 | 100123.0 |
| 2019-05-23 | FDAX | Futures | 12755.9 | 12761.7 | 12546.4 | 12584.3 | 142841.0 |
| 2019-05-23 | FDIV | Futures | 143.21 | 143.45 | 142.66 | 142.84 | 71.0 |
| 2019-05-23 | FDXM | Futures | 12656.8 | 12656.8 | 12437.7 | 12475.2 | 67736.0 |
| 2019-05-23 | FESX | Futures | 2935.7 | 2935.7 | 2886.7 | 2897.2 | 1327374.0 |
| 2019-05-23 | FGBL | Futures | 161.09 | 161.56 | 161.04 | 161.39 | 784549.0 |
| 2019-05-23 | FGBM | Futures | 133.54 | 133.66 | 133.52 | 133.6 | 413454.0 |
| 2019-05-23 | FGBS | Futures | 112.86 | 112.875 | 112.849 | 112.865 | 232791.0 |
| 2019-05-23 | FGBX | Futures | 196.7 | 198.39 | 196.47 | 197.49 | 38955.0 |
| 2019-05-23 | FMWO | Futures | 7069.2 | 7069.2 | 6983.6 | 7013.6 | 4699.0 |
| 2019-05-23 | FOAT | Futures | 147.66 | 147.95 | 147.58 | 147.83 | 128735.0 |
| 2019-05-23 | FTDX | Futures | 2851.8 | 2851.8 | 2799.4 | 2800.4 | 240.0 |
| 2019-05-23 | FTI | Futures | 517.96 | 518.05 | 510.27 | 512.45 | 33220.0 |
| 2019-05-23 | FTUK | Futures | 6709.6 | 6709.6 | 6601.4 | 6619.7 | 103479.0 |
| 2019-05-23 | FVSA | Futures | 222.4 | 235.23 | 220.98 | 230.96 | 36715.0 |
| 2019-05-23 | FXXP | Futures | 336.6 | 336.6 | 332.4 | 333.5 | 62120.0 |
| 2019-05-23 | G | Futures | 119.44 | 119.95 | 119.32 | 119.7 | 311944.0 |
> showing 50 of 121 rows — these rows as CSV