PREVIEW / futures_daily / 2018-02-06
file: by_date/futures_daily/2018/2018-02-06.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-02-06 | ES | Futures | 2851.97 | 2934.3 | 2748.72 | 2928.32 | 4806868.0 |
| 2018-02-06 | NQ | Futures | 7581.05 | 7820.55 | 7331.88 | 7792.74 | 813419.0 |
| 2018-02-06 | YM | Futures | 25402.3 | 26249.2 | 24348.8 | 26154.3 | 655987.0 |
| 2018-02-06 | CL | Futures | 63.41 | 64.27 | 63.1 | 63.37 | 797814.0 |
| 2018-02-06 | GC | Futures | 1715.6 | 1723.5 | 1689.7 | 1698.2 | 473350.0 |
| 2018-02-06 | ZN | Futures | 120.401714 | 121.034189 | 119.630402 | 119.938927 | 3525275.0 |
| 2018-02-06 | A6 | Futures | 0.81057 | 0.81386 | 0.80584 | 0.81108 | 217610.0 |
| 2018-02-06 | AD | Futures | 0.81036 | 0.813 | 0.80813 | 0.81122 | 126650.0 |
| 2018-02-06 | B | Futures | 48.09 | 48.51 | 47.74 | 47.98 | 328847.0 |
| 2018-02-06 | B6 | Futures | 1.4551 | 1.4583 | 1.4412 | 1.4539 | 183699.0 |
| 2018-02-06 | BFX | Futures | 4668.9 | 4668.9 | 4640.9 | 4640.9 | 5.0 |
| 2018-02-06 | BR | Futures | 0.23226 | 0.23492 | 0.23093 | 0.23355 | 6244.0 |
| 2018-02-06 | BTC | Futures | 8913.4 | 10305.8 | 7768.4 | 9824.3 | 2234.0 |
| 2018-02-06 | BZ | Futures | 47.44 | 47.86 | 47.13 | 47.35 | 32169.0 |
| 2018-02-06 | C | Futures | 1334.0 | 1355.0 | 1321.0 | 1337.0 | 13050.0 |
| 2018-02-06 | CB | Futures | 265.619 | 268.059 | 264.383 | 265.001 | 60.0 |
| 2018-02-06 | CC | Futures | 1519.0 | 1530.0 | 1498.0 | 1515.0 | 35111.0 |
| 2018-02-06 | CNH | Futures | 6.4558 | 6.4558 | 6.4207 | 6.4207 | 110.0 |
| 2018-02-06 | CSC | Futures | 3.199 | 3.221 | 3.191 | 3.193 | 85.0 |
| 2018-02-06 | CT | Futures | 89.41 | 89.7 | 88.59 | 88.99 | 24696.0 |
| 2018-02-06 | DC | Futures | 25.44 | 25.59 | 25.28 | 25.33 | 375.0 |
| 2018-02-06 | DX | Futures | 84.017 | 84.444 | 83.801 | 84.004 | 40145.0 |
| 2018-02-06 | E1 | Futures | 1.30703 | 1.30824 | 1.29562 | 1.30096 | 38352.0 |
| 2018-02-06 | E6 | Futures | 1.40643 | 1.41329 | 1.39951 | 1.40847 | 370346.0 |
| 2018-02-06 | E7 | Futures | 1.3994 | 1.4061 | 1.3926 | 1.4014 | 5906.0 |
| 2018-02-06 | EBM | Futures | 170.19 | 171.27 | 169.38 | 171.0 | 14677.0 |
| 2018-02-06 | ED | Futures | 95.3019 | 95.3165 | 95.2776 | 95.2825 | 477368.0 |
| 2018-02-06 | ER | Futures | 98.332 | 98.342 | 98.332 | 98.332 | 133104.0 |
| 2018-02-06 | EW | Futures | 1956.4 | 1984.3 | 1867.4 | 1973.9 | 48606.0 |
| 2018-02-06 | FBON | Futures | 126.67 | 126.89 | 126.46 | 126.77 | 268.0 |
| 2018-02-06 | FBTP | Futures | 111.32 | 111.5 | 110.77 | 111.33 | 140122.0 |
| 2018-02-06 | FBTS | Futures | 103.65 | 103.695 | 103.631 | 103.668 | 45893.0 |
| 2018-02-06 | FCE | Futures | 4494.3 | 4707.8 | 4494.3 | 4600.8 | 280937.0 |
| 2018-02-06 | FDAX | Futures | 12525.4 | 13115.7 | 12522.8 | 12840.8 | 186848.0 |
| 2018-02-06 | FDIV | Futures | 143.4 | 143.4 | 142.86 | 142.86 | 15.0 |
| 2018-02-06 | FDXM | Futures | 12551.9 | 13140.1 | 12551.9 | 12862.6 | 113751.0 |
| 2018-02-06 | FESX | Futures | 2720.4 | 2836.4 | 2717.9 | 2770.2 | 3347546.0 |
| 2018-02-06 | FGBL | Futures | 147.32 | 147.58 | 146.88 | 147.23 | 1274063.0 |
| 2018-02-06 | FGBM | Futures | 128.5 | 128.65 | 128.38 | 128.51 | 832989.0 |
| 2018-02-06 | FGBS | Futures | 112.301 | 112.321 | 112.261 | 112.281 | 563695.0 |
| 2018-02-06 | FGBX | Futures | 165.64 | 166.17 | 164.79 | 165.62 | 80638.0 |
| 2018-02-06 | FMWO | Futures | 6772.9 | 6987.7 | 6746.1 | 6827.8 | 10397.0 |
| 2018-02-06 | FOAT | Futures | 136.34 | 136.52 | 135.87 | 136.18 | 158635.0 |
| 2018-02-06 | FTDX | Futures | 2453.6 | 2515.4 | 2406.2 | 2477.5 | 780.0 |
| 2018-02-06 | FTI | Futures | 484.14 | 498.54 | 482.88 | 487.39 | 106874.0 |
| 2018-02-06 | FTUK | Futures | 6095.0 | 6331.7 | 5993.2 | 6202.4 | 360719.0 |
| 2018-02-06 | FVSA | Futures | 464.56 | 494.67 | 333.8 | 425.85 | 169809.0 |
| 2018-02-06 | FXXP | Futures | 314.3 | 323.1 | 312.9 | 316.7 | 146562.0 |
| 2018-02-06 | G | Futures | 112.44 | 112.73 | 112.15 | 112.45 | 406429.0 |
| 2018-02-06 | GF | Futures | 325.387 | 329.505 | 324.838 | 326.595 | 4755.0 |
> showing 50 of 113 rows — these rows as CSV