PREVIEW / futures_daily / 2019-01-16
file: by_date/futures_daily/2019/2019-01-16.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-01-16 | ES | Futures | 2821.17 | 2843.36 | 2817.65 | 2829.29 | 1330329.0 |
| 2019-01-16 | NQ | Futures | 7727.43 | 7800.07 | 7715.27 | 7717.87 | 443742.0 |
| 2019-01-16 | YM | Futures | 25294.4 | 25587.7 | 25271.2 | 25473.8 | 184061.0 |
| 2019-01-16 | CL | Futures | 54.38 | 54.92 | 53.61 | 54.71 | 280989.0 |
| 2019-01-16 | GC | Futures | 1624.9 | 1632.2 | 1622.4 | 1630.2 | 181387.0 |
| 2019-01-16 | ZN | Futures | 121.346994 | 121.440361 | 121.113574 | 121.222503 | 1180543.0 |
| 2019-01-16 | A6 | Futures | 0.74239 | 0.74362 | 0.73847 | 0.74023 | 82383.0 |
| 2019-01-16 | AD | Futures | 0.76405 | 0.76602 | 0.76319 | 0.76521 | 48829.0 |
| 2019-01-16 | B | Futures | 43.62 | 44.36 | 43.34 | 44.27 | 315592.0 |
| 2019-01-16 | B6 | Futures | 1.3245 | 1.3284 | 1.3209 | 1.3257 | 126336.0 |
| 2019-01-16 | BFX | Futures | 3983.4 | 4031.5 | 3983.4 | 4031.5 | 1.0 |
| 2019-01-16 | BR | Futures | 0.21373 | 0.21421 | 0.21353 | 0.21353 | 81.0 |
| 2019-01-16 | BTC | Futures | 5189.9 | 5328.8 | 5182.6 | 5204.5 | 4110.0 |
| 2019-01-16 | BZ | Futures | 43.41 | 43.98 | 42.98 | 43.9 | 32025.0 |
| 2019-01-16 | C | Futures | 1459.0 | 1488.0 | 1454.0 | 1477.0 | 9851.0 |
| 2019-01-16 | CB | Futures | 273.989 | 275.508 | 273.989 | 275.052 | 19.0 |
| 2019-01-16 | CC | Futures | 1580.0 | 1614.0 | 1572.0 | 1600.0 | 21298.0 |
| 2019-01-16 | CNH | Futures | 6.7864 | 6.7995 | 6.7743 | 6.7743 | 671.0 |
| 2019-01-16 | CSC | Futures | 2.765 | 2.777 | 2.754 | 2.756 | 105.0 |
| 2019-01-16 | CT | Futures | 78.76 | 80.13 | 78.66 | 79.81 | 14341.0 |
| 2019-01-16 | DC | Futures | 23.96 | 23.96 | 23.72 | 23.76 | 297.0 |
| 2019-01-16 | DX | Futures | 91.126 | 91.36 | 91.059 | 91.247 | 14449.0 |
| 2019-01-16 | E1 | Futures | 1.197 | 1.19782 | 1.19324 | 1.19371 | 14955.0 |
| 2019-01-16 | E6 | Futures | 1.26691 | 1.26878 | 1.26365 | 1.26586 | 150044.0 |
| 2019-01-16 | E7 | Futures | 1.2612 | 1.2626 | 1.2575 | 1.2597 | 3435.0 |
| 2019-01-16 | EBM | Futures | 209.23 | 209.48 | 208.46 | 208.71 | 18845.0 |
| 2019-01-16 | ED | Futures | 95.0232 | 95.0281 | 95.0135 | 95.0232 | 236555.0 |
| 2019-01-16 | ER | Futures | 98.401 | 98.406 | 98.396 | 98.401 | 69678.0 |
| 2019-01-16 | EW | Futures | 1876.2 | 1898.7 | 1873.6 | 1892.6 | 13884.0 |
| 2019-01-16 | FBON | Futures | 130.09 | 130.23 | 130.02 | 130.16 | 549.0 |
| 2019-01-16 | FBTP | Futures | 110.87 | 111.8 | 110.83 | 111.75 | 86953.0 |
| 2019-01-16 | FBTS | Futures | 104.991 | 105.237 | 104.954 | 105.228 | 61487.0 |
| 2019-01-16 | FCE | Futures | 4297.7 | 4312.5 | 4282.5 | 4306.2 | 105855.0 |
| 2019-01-16 | FDAX | Futures | 11441.7 | 11497.4 | 11407.0 | 11472.7 | 86249.0 |
| 2019-01-16 | FDIV | Futures | 134.14 | 134.14 | 133.79 | 133.79 | 3.0 |
| 2019-01-16 | FDXM | Futures | 11424.3 | 11470.4 | 11379.2 | 11444.7 | 37584.0 |
| 2019-01-16 | FESX | Futures | 2615.8 | 2627.0 | 2606.4 | 2617.6 | 932187.0 |
| 2019-01-16 | FGBL | Futures | 156.69 | 156.79 | 156.27 | 156.49 | 639450.0 |
| 2019-01-16 | FGBM | Futures | 132.39 | 132.46 | 132.25 | 132.29 | 353319.0 |
| 2019-01-16 | FGBS | Futures | 112.779 | 112.789 | 112.734 | 112.739 | 267763.0 |
| 2019-01-16 | FGBX | Futures | 185.69 | 185.79 | 184.12 | 185.04 | 45337.0 |
| 2019-01-16 | FMWO | Futures | 6608.8 | 6626.3 | 6586.7 | 6619.3 | 2805.0 |
| 2019-01-16 | FOAT | Futures | 142.39 | 142.48 | 142.14 | 142.33 | 126280.0 |
| 2019-01-16 | FTDX | Futures | 2502.6 | 2526.4 | 2484.7 | 2501.1 | 224.0 |
| 2019-01-16 | FTI | Futures | 471.12 | 472.12 | 468.05 | 470.85 | 26027.0 |
| 2019-01-16 | FTUK | Futures | 6209.8 | 6240.7 | 6177.4 | 6188.8 | 91838.0 |
| 2019-01-16 | FVSA | Futures | 337.64 | 339.51 | 320.76 | 326.38 | 33674.0 |
| 2019-01-16 | FXXP | Futures | 306.1 | 306.8 | 304.8 | 306.0 | 38361.0 |
| 2019-01-16 | G | Futures | 116.64 | 116.65 | 116.05 | 116.33 | 269398.0 |
| 2019-01-16 | GF | Futures | 316.548 | 316.766 | 312.83 | 316.438 | 7972.0 |
> showing 50 of 117 rows — these rows as CSV