PREVIEW / futures_daily / 2019-06-14
file: by_date/futures_daily/2019/2019-06-14.parquet size: 10 KB rows: 116
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-06-14 | ES | Futures | 3126.57 | 3132.23 | 3112.27 | 3123.6 | 1318938.0 |
| 2019-06-14 | NQ | Futures | 8667.75 | 8689.34 | 8609.32 | 8640.4 | 253169.0 |
| 2019-06-14 | YM | Futures | 27446.6 | 27491.8 | 27309.1 | 27435.1 | 128234.0 |
| 2019-06-14 | CL | Futures | 53.64 | 54.48 | 53.14 | 53.98 | 166399.0 |
| 2019-06-14 | GC | Futures | 1675.9 | 1695.4 | 1669.5 | 1673.4 | 358448.0 |
| 2019-06-14 | ZN | Futures | 126.724917 | 127.06708 | 126.569388 | 126.709364 | 1447655.0 |
| 2019-06-14 | A6 | Futures | 0.71324 | 0.71355 | 0.70769 | 0.7081 | 126356.0 |
| 2019-06-14 | AD | Futures | 0.75768 | 0.75783 | 0.75224 | 0.75259 | 87621.0 |
| 2019-06-14 | ALI | Futures | 2718.01 | 2718.01 | 2718.01 | 2718.01 | 0.0 |
| 2019-06-14 | B | Futures | 45.59 | 46.57 | 45.21 | 46.16 | 262307.0 |
| 2019-06-14 | B6 | Futures | 1.2993 | 1.2999 | 1.2894 | 1.2898 | 88990.0 |
| 2019-06-14 | BR | Futures | 0.20595 | 0.20595 | 0.20387 | 0.20387 | 2.0 |
| 2019-06-14 | BTC | Futures | 12854.1 | 13084.6 | 12623.6 | 12969.3 | 2084.0 |
| 2019-06-14 | BZ | Futures | 45.11 | 45.98 | 44.64 | 45.57 | 38166.0 |
| 2019-06-14 | C | Futures | 1786.0 | 1795.0 | 1775.0 | 1778.0 | 4876.0 |
| 2019-06-14 | CB | Futures | 286.552 | 287.165 | 285.619 | 285.619 | 14.0 |
| 2019-06-14 | CC | Futures | 1672.0 | 1685.0 | 1660.0 | 1663.0 | 16861.0 |
| 2019-06-14 | CNH | Futures | 6.9456 | 6.9535 | 6.9455 | 6.9457 | 790.0 |
| 2019-06-14 | CSC | Futures | 3.043 | 3.045 | 3.04 | 3.041 | 37.0 |
| 2019-06-14 | CT | Futures | 69.97 | 70.09 | 68.98 | 69.02 | 13798.0 |
| 2019-06-14 | DC | Futures | 25.66 | 25.67 | 25.55 | 25.6 | 41.0 |
| 2019-06-14 | DX | Futures | 92.94 | 93.474 | 92.853 | 93.455 | 35656.0 |
| 2019-06-14 | E1 | Futures | 1.17664 | 1.17803 | 1.16991 | 1.17037 | 26511.0 |
| 2019-06-14 | E6 | Futures | 1.23913 | 1.24054 | 1.231 | 1.23154 | 256303.0 |
| 2019-06-14 | E7 | Futures | 1.233 | 1.2341 | 1.2245 | 1.2252 | 5519.0 |
| 2019-06-14 | EBM | Futures | 205.84 | 208.72 | 205.55 | 208.14 | 13740.0 |
| 2019-06-14 | ED | Futures | 95.3671 | 95.3963 | 95.3379 | 95.3525 | 561467.0 |
| 2019-06-14 | ER | Futures | 98.435 | 98.455 | 98.435 | 98.45 | 126258.0 |
| 2019-06-14 | EW | Futures | 2012.6 | 2017.2 | 1997.4 | 1999.7 | 27433.0 |
| 2019-06-14 | FBON | Futures | 141.18 | 141.73 | 141.18 | 141.64 | 217.0 |
| 2019-06-14 | FBTP | Futures | 118.1 | 118.68 | 118.07 | 118.44 | 71961.0 |
| 2019-06-14 | FBTS | Futures | 106.325 | 106.469 | 106.239 | 106.382 | 68193.0 |
| 2019-06-14 | FCE | Futures | 4903.3 | 4904.7 | 4870.9 | 4893.3 | 8469.0 |
| 2019-06-14 | FDAX | Futures | 12781.7 | 12826.4 | 12681.7 | 12735.3 | 114045.0 |
| 2019-06-14 | FDXM | Futures | 12643.5 | 12647.6 | 12514.5 | 12567.0 | 312.0 |
| 2019-06-14 | FESX | Futures | 2947.0 | 2952.3 | 2925.2 | 2938.3 | 565130.0 |
| 2019-06-14 | FEU3 | Futures | 99.07 | 99.08 | 99.07 | 99.075 | 670.0 |
| 2019-06-14 | FGBL | Futures | 163.2 | 163.54 | 163.16 | 163.34 | 586933.0 |
| 2019-06-14 | FGBM | Futures | 134.06 | 134.2 | 134.05 | 134.09 | 359012.0 |
| 2019-06-14 | FGBS | Futures | 112.935 | 112.985 | 112.935 | 112.965 | 242712.0 |
| 2019-06-14 | FGBX | Futures | 205.86 | 207.45 | 205.69 | 206.95 | 53153.0 |
| 2019-06-14 | FMWO | Futures | 7176.8 | 7182.6 | 7145.5 | 7158.3 | 7912.0 |
| 2019-06-14 | FOAT | Futures | 150.03 | 150.28 | 149.98 | 150.12 | 108117.0 |
| 2019-06-14 | FTDX | Futures | 2778.7 | 2778.7 | 2744.7 | 2748.6 | 20.0 |
| 2019-06-14 | FTI | Futures | 522.29 | 522.29 | 517.07 | 519.87 | 1319.0 |
| 2019-06-14 | FTUK | Futures | 6736.8 | 6749.2 | 6692.9 | 6717.4 | 76833.0 |
| 2019-06-14 | FVSA | Futures | 211.81 | 215.27 | 209.04 | 212.51 | 35246.0 |
| 2019-06-14 | FXXP | Futures | 339.0 | 339.0 | 336.1 | 337.4 | 52543.0 |
| 2019-06-14 | G | Futures | 120.07 | 120.17 | 119.59 | 119.77 | 146090.0 |
| 2019-06-14 | GF | Futures | 266.445 | 268.113 | 264.237 | 265.954 | 4440.0 |
> showing 50 of 116 rows — these rows as CSV