PREVIEW / futures_daily / 2018-05-02
file: by_date/futures_daily/2018/2018-05-02.parquet size: 10 KB rows: 113
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 |
|---|---|---|---|---|---|---|---|
| 2018-05-02 | ES | Futures | 2887.77 | 2891.03 | 2853.79 | 2857.32 | 1427995.0 |
| 2018-05-02 | NQ | Futures | 7860.05 | 7876.43 | 7754.41 | 7764.07 | 382532.0 |
| 2018-05-02 | YM | Futures | 25378.5 | 25424.9 | 25067.8 | 25097.3 | 211176.0 |
| 2018-05-02 | CL | Futures | 67.74 | 68.39 | 67.17 | 68.18 | 789367.0 |
| 2018-05-02 | GC | Futures | 1665.3 | 1678.7 | 1665.2 | 1666.8 | 370242.0 |
| 2018-05-02 | ZN | Futures | 118.56311 | 118.67167 | 118.361499 | 118.625145 | 1318968.0 |
| 2018-05-02 | A6 | Futures | 0.76985 | 0.77509 | 0.76872 | 0.77221 | 146337.0 |
| 2018-05-02 | AD | Futures | 0.78834 | 0.79097 | 0.78571 | 0.78783 | 90938.0 |
| 2018-05-02 | B | Futures | 53.7 | 53.96 | 53.04 | 53.76 | 347055.0 |
| 2018-05-02 | B6 | Futures | 1.4125 | 1.4182 | 1.4066 | 1.4117 | 136463.0 |
| 2018-05-02 | BR | Futures | 0.21439 | 0.21599 | 0.21355 | 0.21443 | 3988.0 |
| 2018-05-02 | BTC | Futures | 12736.8 | 12933.4 | 12617.5 | 12849.2 | 2093.0 |
| 2018-05-02 | BZ | Futures | 53.1 | 53.4 | 52.49 | 53.21 | 34769.0 |
| 2018-05-02 | C | Futures | 1765.0 | 1787.0 | 1749.0 | 1756.0 | 1695.0 |
| 2018-05-02 | CB | Futures | 301.446 | 301.446 | 296.288 | 298.358 | 41.0 |
| 2018-05-02 | CC | Futures | 2114.0 | 2117.0 | 2046.0 | 2051.0 | 19472.0 |
| 2018-05-02 | CNH | Futures | 6.4498 | 6.4701 | 6.4498 | 6.4662 | 220.0 |
| 2018-05-02 | CSC | Futures | 3.478 | 3.486 | 3.467 | 3.475 | 24.0 |
| 2018-05-02 | CT | Futures | 96.11 | 96.74 | 95.64 | 96.26 | 15193.0 |
| 2018-05-02 | DC | Futures | 28.1 | 28.19 | 28.0 | 28.07 | 145.0 |
| 2018-05-02 | DX | Futures | 87.046 | 87.395 | 86.806 | 87.088 | 38903.0 |
| 2018-05-02 | E1 | Futures | 1.21285 | 1.2167 | 1.20875 | 1.21249 | 38235.0 |
| 2018-05-02 | E6 | Futures | 1.35562 | 1.35984 | 1.3492 | 1.35466 | 314725.0 |
| 2018-05-02 | E7 | Futures | 1.3483 | 1.3526 | 1.3418 | 1.3474 | 4692.0 |
| 2018-05-02 | EBM | Futures | 182.03 | 183.91 | 182.03 | 183.65 | 14507.0 |
| 2018-05-02 | ED | Futures | 94.9452 | 94.95 | 94.9306 | 94.9354 | 283798.0 |
| 2018-05-02 | ER | Futures | 98.342 | 98.347 | 98.342 | 98.347 | 26694.0 |
| 2018-05-02 | EW | Futures | 1992.3 | 2003.0 | 1978.9 | 1986.5 | 13829.0 |
| 2018-05-02 | FBON | Futures | 129.42 | 129.66 | 129.23 | 129.35 | 144.0 |
| 2018-05-02 | FBTP | Futures | 115.55 | 116.1 | 115.51 | 115.84 | 97264.0 |
| 2018-05-02 | FBTS | Futures | 104.241 | 104.287 | 104.232 | 104.278 | 33682.0 |
| 2018-05-02 | FCE | Futures | 4879.3 | 4903.8 | 4873.9 | 4895.3 | 77628.0 |
| 2018-05-02 | FDAX | Futures | 13112.2 | 13345.5 | 13094.6 | 13322.1 | 111657.0 |
| 2018-05-02 | FDIV | Futures | 154.65 | 154.74 | 154.65 | 154.74 | 4.0 |
| 2018-05-02 | FDXM | Futures | 12992.4 | 13227.2 | 12981.1 | 13203.5 | 35408.0 |
| 2018-05-02 | FESX | Futures | 2895.6 | 2915.6 | 2892.2 | 2913.1 | 982488.0 |
| 2018-05-02 | FEU3 | Futures | 99.021 | 99.026 | 99.021 | 99.026 | 396.0 |
| 2018-05-02 | FGBL | Futures | 149.32 | 149.34 | 149.1 | 149.24 | 942130.0 |
| 2018-05-02 | FGBM | Futures | 129.57 | 129.58 | 129.46 | 129.51 | 382348.0 |
| 2018-05-02 | FGBS | Futures | 112.527 | 112.527 | 112.492 | 112.507 | 313911.0 |
| 2018-05-02 | FGBX | Futures | 169.06 | 169.09 | 168.34 | 168.86 | 48187.0 |
| 2018-05-02 | FMWO | Futures | 6911.8 | 6938.6 | 6877.9 | 6923.4 | 2155.0 |
| 2018-05-02 | FOAT | Futures | 138.53 | 138.54 | 138.31 | 138.46 | 86493.0 |
| 2018-05-02 | FTDX | Futures | 2602.3 | 2668.1 | 2598.9 | 2661.2 | 252.0 |
| 2018-05-02 | FTI | Futures | 510.53 | 512.47 | 509.1 | 510.72 | 25061.0 |
| 2018-05-02 | FTUK | Futures | 6620.1 | 6649.3 | 6601.5 | 6632.9 | 129824.0 |
| 2018-05-02 | FVSA | Futures | 332.94 | 339.83 | 328.35 | 334.09 | 20026.0 |
| 2018-05-02 | FXXP | Futures | 329.8 | 331.9 | 329.3 | 331.7 | 58588.0 |
| 2018-05-02 | G | Futures | 113.81 | 113.84 | 113.36 | 113.46 | 233547.0 |
| 2018-05-02 | GF | Futures | 297.622 | 299.021 | 295.47 | 298.321 | 1920.0 |
> showing 50 of 113 rows — these rows as CSV