PREVIEW / futures_daily / 2019-02-05
file: by_date/futures_daily/2019/2019-02-05.parquet size: 10 KB rows: 117
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-02-05 | ES | Futures | 2944.32 | 2964.08 | 2940.8 | 2956.77 | 1225737.0 |
| 2019-02-05 | NQ | Futures | 8031.91 | 8143.35 | 8021.21 | 8113.54 | 369764.0 |
| 2019-02-05 | YM | Futures | 26548.6 | 26763.7 | 26518.0 | 26711.0 | 159440.0 |
| 2019-02-05 | CL | Futures | 57.05 | 57.42 | 55.61 | 55.81 | 609756.0 |
| 2019-02-05 | GC | Futures | 1646.0 | 1651.2 | 1643.5 | 1649.0 | 129013.0 |
| 2019-02-05 | ZN | Futures | 121.222503 | 121.471484 | 121.098013 | 121.378116 | 1036243.0 |
| 2019-02-05 | A6 | Futures | 0.74445 | 0.74888 | 0.74167 | 0.74527 | 89443.0 |
| 2019-02-05 | AD | Futures | 0.7725 | 0.77346 | 0.77043 | 0.77098 | 48633.0 |
| 2019-02-05 | B | Futures | 45.41 | 45.69 | 44.75 | 44.94 | 215360.0 |
| 2019-02-05 | B6 | Futures | 1.3413 | 1.3433 | 1.3299 | 1.3331 | 83928.0 |
| 2019-02-05 | BR | Futures | 0.21692 | 0.21755 | 0.21616 | 0.21712 | 1498.0 |
| 2019-02-05 | BTC | Futures | 4998.4 | 5035.3 | 4983.7 | 5013.2 | 1566.0 |
| 2019-02-05 | BZ | Futures | 45.04 | 45.21 | 44.28 | 44.47 | 27285.0 |
| 2019-02-05 | C | Futures | 1421.0 | 1466.0 | 1421.0 | 1463.0 | 23111.0 |
| 2019-02-05 | CB | Futures | 276.389 | 277.27 | 275.812 | 277.27 | 18.0 |
| 2019-02-05 | CC | Futures | 1517.0 | 1531.0 | 1505.0 | 1519.0 | 30925.0 |
| 2019-02-05 | CNH | Futures | 6.7865 | 6.7894 | 6.7615 | 6.7732 | 59.0 |
| 2019-02-05 | CSC | Futures | 2.689 | 2.691 | 2.68 | 2.682 | 84.0 |
| 2019-02-05 | CT | Futures | 79.28 | 80.33 | 79.14 | 79.96 | 16326.0 |
| 2019-02-05 | DC | Futures | 22.85 | 22.88 | 22.74 | 22.77 | 238.0 |
| 2019-02-05 | DX | Futures | 91.159 | 91.426 | 91.116 | 91.381 | 18450.0 |
| 2019-02-05 | E1 | Futures | 1.18254 | 1.18277 | 1.17783 | 1.17983 | 15839.0 |
| 2019-02-05 | E6 | Futures | 1.26784 | 1.26845 | 1.26403 | 1.26497 | 142948.0 |
| 2019-02-05 | E7 | Futures | 1.2617 | 1.2623 | 1.258 | 1.2589 | 3030.0 |
| 2019-02-05 | EBM | Futures | 210.25 | 210.51 | 209.23 | 210.0 | 17109.0 |
| 2019-02-05 | ED | Futures | 95.0476 | 95.0525 | 95.033 | 95.0428 | 276104.0 |
| 2019-02-05 | ER | Futures | 98.401 | 98.406 | 98.396 | 98.401 | 30871.0 |
| 2019-02-05 | EW | Futures | 1977.6 | 1988.8 | 1975.8 | 1986.9 | 12200.0 |
| 2019-02-05 | FBON | Futures | 131.72 | 131.78 | 131.55 | 131.63 | 514.0 |
| 2019-02-05 | FBTP | Futures | 111.91 | 112.13 | 111.3 | 111.49 | 108817.0 |
| 2019-02-05 | FBTS | Futures | 105.048 | 105.096 | 104.944 | 104.963 | 56069.0 |
| 2019-02-05 | FCE | Futures | 4491.2 | 4552.5 | 4475.1 | 4551.6 | 74892.0 |
| 2019-02-05 | FDAX | Futures | 11774.8 | 11964.0 | 11736.5 | 11934.0 | 103626.0 |
| 2019-02-05 | FDIV | Futures | 138.54 | 139.8 | 138.54 | 139.44 | 42.0 |
| 2019-02-05 | FDXM | Futures | 11728.3 | 11933.8 | 11708.4 | 11905.0 | 48207.0 |
| 2019-02-05 | FESX | Futures | 2709.8 | 2745.7 | 2699.6 | 2741.5 | 1076401.0 |
| 2019-02-05 | FEU3 | Futures | 99.001 | 99.001 | 99.001 | 99.001 | 297.0 |
| 2019-02-05 | FGBL | Futures | 157.26 | 157.38 | 156.82 | 157.35 | 623597.0 |
| 2019-02-05 | FGBM | Futures | 132.34 | 132.34 | 132.13 | 132.29 | 387158.0 |
| 2019-02-05 | FGBS | Futures | 112.678 | 112.688 | 112.653 | 112.673 | 337906.0 |
| 2019-02-05 | FGBX | Futures | 187.65 | 187.92 | 186.48 | 187.88 | 40158.0 |
| 2019-02-05 | FMWO | Futures | 6841.9 | 6893.2 | 6840.7 | 6883.9 | 2819.0 |
| 2019-02-05 | FOAT | Futures | 142.92 | 143.06 | 142.69 | 143.03 | 136485.0 |
| 2019-02-05 | FTDX | Futures | 2538.4 | 2597.0 | 2538.4 | 2591.5 | 303.0 |
| 2019-02-05 | FTI | Futures | 496.65 | 502.18 | 495.8 | 501.83 | 23514.0 |
| 2019-02-05 | FTUK | Futures | 6370.1 | 6488.9 | 6366.0 | 6476.2 | 121972.0 |
| 2019-02-05 | FVSA | Futures | 278.55 | 283.24 | 263.55 | 266.36 | 22065.0 |
| 2019-02-05 | FXXP | Futures | 315.4 | 319.7 | 314.9 | 319.1 | 64244.0 |
| 2019-02-05 | G | Futures | 116.71 | 117.17 | 116.59 | 117.11 | 268427.0 |
| 2019-02-05 | GF | Futures | 315.892 | 316.657 | 313.267 | 314.525 | 5963.0 |
> showing 50 of 117 rows — these rows as CSV