PREVIEW / futures_daily / 2018-01-08
file: by_date/futures_daily/2018/2018-01-08.parquet size: 9 KB rows: 109
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-01-08 | ES | Futures | 2979.95 | 2987.29 | 2974.24 | 2985.38 | 903544.0 |
| 2018-01-08 | NQ | Futures | 7809.13 | 7836.07 | 7792.15 | 7832.85 | 198494.0 |
| 2018-01-08 | YM | Futures | 26652.0 | 26743.8 | 26586.6 | 26628.8 | 108698.0 |
| 2018-01-08 | CL | Futures | 61.6 | 61.96 | 61.33 | 61.72 | 616474.0 |
| 2018-01-08 | GC | Futures | 1675.8 | 1677.3 | 1668.0 | 1674.0 | 246086.0 |
| 2018-01-08 | ZN | Futures | 121.913484 | 122.05232 | 121.836353 | 121.913484 | 739863.0 |
| 2018-01-08 | A6 | Futures | 0.80913 | 0.80964 | 0.80491 | 0.80645 | 92155.0 |
| 2018-01-08 | AD | Futures | 0.81879 | 0.82082 | 0.8161 | 0.81798 | 61571.0 |
| 2018-01-08 | B | Futures | 48.55 | 48.68 | 48.29 | 48.53 | 210348.0 |
| 2018-01-08 | B6 | Futures | 1.4146 | 1.4161 | 1.4096 | 1.414 | 75060.0 |
| 2018-01-08 | BR | Futures | 0.23298 | 0.23374 | 0.23275 | 0.23344 | 11.0 |
| 2018-01-08 | BTC | Futures | 21035.7 | 21074.1 | 17763.4 | 19089.0 | 958.0 |
| 2018-01-08 | BZ | Futures | 47.9 | 48.02 | 47.64 | 47.87 | 17704.0 |
| 2018-01-08 | C | Futures | 1244.0 | 1257.0 | 1231.0 | 1254.0 | 9539.0 |
| 2018-01-08 | CB | Futures | 276.46 | 276.46 | 272.228 | 273.031 | 71.0 |
| 2018-01-08 | CC | Futures | 1406.0 | 1430.0 | 1395.0 | 1428.0 | 21988.0 |
| 2018-01-08 | CNH | Futures | 6.6242 | 6.6542 | 6.6242 | 6.6489 | 13.0 |
| 2018-01-08 | CSC | Futures | 3.161 | 3.161 | 3.129 | 3.135 | 92.0 |
| 2018-01-08 | CT | Futures | 91.22 | 92.02 | 91.02 | 91.26 | 16891.0 |
| 2018-01-08 | DC | Futures | 24.91 | 24.91 | 24.57 | 24.63 | 149.0 |
| 2018-01-08 | DX | Futures | 86.177 | 86.524 | 86.031 | 86.491 | 15958.0 |
| 2018-01-08 | E1 | Futures | 1.25046 | 1.25143 | 1.24657 | 1.24742 | 19659.0 |
| 2018-01-08 | E6 | Futures | 1.36959 | 1.37197 | 1.36097 | 1.36182 | 198647.0 |
| 2018-01-08 | E7 | Futures | 1.3626 | 1.365 | 1.3541 | 1.355 | 3849.0 |
| 2018-01-08 | EBM | Futures | 172.62 | 174.24 | 172.35 | 173.7 | 13991.0 |
| 2018-01-08 | ED | Futures | 95.3602 | 95.3699 | 95.3602 | 95.365 | 125368.0 |
| 2018-01-08 | ER | Futures | 98.337 | 98.342 | 98.332 | 98.337 | 65796.0 |
| 2018-01-08 | EW | Futures | 2055.7 | 2066.6 | 2046.7 | 2064.9 | 12588.0 |
| 2018-01-08 | FBON | Futures | 126.21 | 126.62 | 126.06 | 126.55 | 148.0 |
| 2018-01-08 | FBTP | Futures | 111.23 | 111.52 | 110.89 | 111.37 | 60960.0 |
| 2018-01-08 | FBTS | Futures | 103.567 | 103.613 | 103.522 | 103.613 | 36071.0 |
| 2018-01-08 | FCE | Futures | 4899.1 | 4917.8 | 4896.8 | 4907.6 | 62007.0 |
| 2018-01-08 | FDAX | Futures | 13867.9 | 13911.0 | 13827.4 | 13868.4 | 67674.0 |
| 2018-01-08 | FDXM | Futures | 13893.5 | 13934.0 | 13849.9 | 13892.0 | 20824.0 |
| 2018-01-08 | FESX | Futures | 2944.2 | 2951.5 | 2937.7 | 2945.8 | 793246.0 |
| 2018-01-08 | FGBL | Futures | 149.81 | 150.18 | 149.57 | 149.95 | 454684.0 |
| 2018-01-08 | FGBM | Futures | 129.42 | 129.58 | 129.36 | 129.49 | 368132.0 |
| 2018-01-08 | FGBS | Futures | 112.347 | 112.392 | 112.342 | 112.377 | 299219.0 |
| 2018-01-08 | FGBX | Futures | 168.52 | 169.2 | 167.86 | 168.78 | 28235.0 |
| 2018-01-08 | FMWO | Futures | 7119.6 | 7125.4 | 7110.2 | 7118.4 | 2733.0 |
| 2018-01-08 | FOAT | Futures | 138.13 | 138.51 | 137.91 | 138.3 | 65710.0 |
| 2018-01-08 | FTDX | Futures | 2643.1 | 2663.0 | 2623.2 | 2663.0 | 278.0 |
| 2018-01-08 | FTI | Futures | 517.46 | 519.59 | 517.37 | 519.08 | 17928.0 |
| 2018-01-08 | FTUK | Futures | 6704.4 | 6704.4 | 6667.7 | 6672.9 | 69281.0 |
| 2018-01-08 | FVSA | Futures | 248.63 | 256.0 | 246.52 | 250.73 | 29093.0 |
| 2018-01-08 | FXXP | Futures | 338.2 | 339.0 | 337.7 | 338.2 | 32197.0 |
| 2018-01-08 | G | Futures | 114.82 | 115.23 | 114.73 | 115.09 | 137078.0 |
| 2018-01-08 | GF | Futures | 316.085 | 317.977 | 314.355 | 316.625 | 1996.0 |
| 2018-01-08 | GSCI | Futures | 517.48 | 517.48 | 515.27 | 516.32 | 2404.0 |
| 2018-01-08 | HE | Futures | 95.611 | 97.912 | 95.611 | 97.345 | 30818.0 |
> showing 50 of 109 rows — these rows as CSV