PREVIEW / futures_daily / 2019-05-07
file: by_date/futures_daily/2019/2019-05-07.parquet size: 10 KB rows: 118
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-07 | ES | Futures | 3145.2 | 3165.45 | 3092.0 | 3122.52 | 2813033.0 |
| 2019-05-07 | NQ | Futures | 8923.54 | 8991.81 | 8735.15 | 8842.02 | 838952.0 |
| 2019-05-07 | YM | Futures | 27676.7 | 27860.4 | 27181.6 | 27416.0 | 378147.0 |
| 2019-05-07 | CL | Futures | 63.83 | 64.16 | 62.28 | 63.04 | 842810.0 |
| 2019-05-07 | GC | Futures | 1596.1 | 1602.2 | 1592.0 | 1600.1 | 251087.0 |
| 2019-05-07 | ZN | Futures | 123.259157 | 123.352394 | 122.932828 | 123.336854 | 1816896.0 |
| 2019-05-07 | A6 | Futures | 0.72096 | 0.72735 | 0.72034 | 0.72261 | 114002.0 |
| 2019-05-07 | AD | Futures | 0.75216 | 0.75468 | 0.75019 | 0.75074 | 70093.0 |
| 2019-05-07 | B | Futures | 52.43 | 52.56 | 51.12 | 51.49 | 332066.0 |
| 2019-05-07 | B6 | Futures | 1.3447 | 1.348 | 1.3384 | 1.341 | 105778.0 |
| 2019-05-07 | BFX | Futures | 4210.3 | 4210.3 | 4186.8 | 4186.8 | 6.0 |
| 2019-05-07 | BR | Futures | 0.20192 | 0.20192 | 0.19972 | 0.20076 | 2277.0 |
| 2019-05-07 | BTC | Futures | 8815.0 | 9255.7 | 8791.8 | 9039.2 | 10086.0 |
| 2019-05-07 | BZ | Futures | 52.29 | 52.4 | 50.99 | 51.35 | 48729.0 |
| 2019-05-07 | C | Futures | 1690.0 | 1690.0 | 1661.0 | 1679.0 | 3119.0 |
| 2019-05-07 | CB | Futures | 277.347 | 277.347 | 276.809 | 276.929 | 14.0 |
| 2019-05-07 | CC | Futures | 1581.0 | 1585.0 | 1539.0 | 1549.0 | 22763.0 |
| 2019-05-07 | CNH | Futures | 6.7986 | 6.8108 | 6.7829 | 6.8102 | 1237.0 |
| 2019-05-07 | CSC | Futures | 3.015 | 3.029 | 3.015 | 3.015 | 39.0 |
| 2019-05-07 | CT | Futures | 77.22 | 78.21 | 76.57 | 76.6 | 20241.0 |
| 2019-05-07 | DC | Futures | 25.35 | 25.52 | 25.27 | 25.35 | 309.0 |
| 2019-05-07 | DX | Futures | 93.249 | 93.465 | 93.106 | 93.359 | 17155.0 |
| 2019-05-07 | E1 | Futures | 1.15046 | 1.15279 | 1.14544 | 1.14882 | 25017.0 |
| 2019-05-07 | E6 | Futures | 1.233 | 1.23541 | 1.2297 | 1.23141 | 176296.0 |
| 2019-05-07 | E7 | Futures | 1.2271 | 1.2293 | 1.2236 | 1.2253 | 6118.0 |
| 2019-05-07 | EBM | Futures | 196.91 | 198.64 | 196.05 | 198.35 | 11948.0 |
| 2019-05-07 | ED | Futures | 95.1697 | 95.1746 | 95.1648 | 95.1697 | 155529.0 |
| 2019-05-07 | ER | Futures | 98.416 | 98.416 | 98.411 | 98.411 | 16218.0 |
| 2019-05-07 | EW | Futures | 2094.8 | 2096.7 | 2045.1 | 2058.2 | 16654.0 |
| 2019-05-07 | FBON | Futures | 136.66 | 136.85 | 136.43 | 136.77 | 268.0 |
| 2019-05-07 | FBTP | Futures | 115.68 | 115.93 | 115.22 | 115.61 | 84713.0 |
| 2019-05-07 | FBTS | Futures | 106.065 | 106.074 | 105.827 | 105.989 | 54512.0 |
| 2019-05-07 | FCE | Futures | 4909.6 | 4928.1 | 4813.7 | 4841.7 | 102513.0 |
| 2019-05-07 | FDAX | Futures | 12928.0 | 12981.1 | 12672.2 | 12725.3 | 152071.0 |
| 2019-05-07 | FDIV | Futures | 148.69 | 148.69 | 146.14 | 146.14 | 82.0 |
| 2019-05-07 | FDXM | Futures | 12825.9 | 12868.6 | 12561.8 | 12615.1 | 64994.0 |
| 2019-05-07 | FESX | Futures | 2975.9 | 2992.5 | 2914.7 | 2930.4 | 1384685.0 |
| 2019-05-07 | FGBL | Futures | 159.82 | 160.39 | 159.48 | 160.29 | 825789.0 |
| 2019-05-07 | FGBM | Futures | 133.07 | 133.26 | 132.96 | 133.24 | 469796.0 |
| 2019-05-07 | FGBS | Futures | 112.784 | 112.804 | 112.764 | 112.794 | 209998.0 |
| 2019-05-07 | FGBX | Futures | 193.2 | 194.82 | 192.28 | 194.41 | 40497.0 |
| 2019-05-07 | FMWO | Futures | 7242.7 | 7270.5 | 7124.7 | 7173.3 | 1524.0 |
| 2019-05-07 | FOAT | Futures | 146.84 | 147.24 | 146.64 | 147.18 | 125734.0 |
| 2019-05-07 | FTDX | Futures | 2813.3 | 2838.4 | 2782.2 | 2789.6 | 222.0 |
| 2019-05-07 | FTI | Futures | 531.82 | 535.19 | 522.81 | 526.06 | 33070.0 |
| 2019-05-07 | FTUK | Futures | 6665.1 | 6719.2 | 6572.9 | 6608.7 | 139301.0 |
| 2019-05-07 | FVSA | Futures | 213.66 | 248.57 | 203.89 | 233.91 | 74891.0 |
| 2019-05-07 | FXXP | Futures | 341.6 | 344.1 | 336.6 | 338.0 | 83444.0 |
| 2019-05-07 | G | Futures | 117.24 | 117.73 | 117.2 | 117.62 | 180368.0 |
| 2019-05-07 | GF | Futures | 284.081 | 286.996 | 283.3 | 285.851 | 1140.0 |
> showing 50 of 118 rows — these rows as CSV