PREVIEW / futures_daily / 2018-03-08
file: by_date/futures_daily/2018/2018-03-08.parquet size: 10 KB rows: 112
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-03-08 | ES | Futures | 2959.03 | 2978.59 | 2956.31 | 2977.23 | 1502808.0 |
| 2018-03-08 | NQ | Futures | 8107.78 | 8171.61 | 8096.95 | 8168.1 | 388688.0 |
| 2018-03-08 | YM | Futures | 26137.4 | 26318.8 | 26053.0 | 26251.3 | 230598.0 |
| 2018-03-08 | CL | Futures | 61.76 | 61.83 | 60.37 | 60.55 | 720510.0 |
| 2018-03-08 | GC | Futures | 1694.0 | 1698.6 | 1685.6 | 1688.3 | 252829.0 |
| 2018-03-08 | ZN | Futures | 119.105911 | 119.416082 | 119.059385 | 119.276505 | 1256132.0 |
| 2018-03-08 | A6 | Futures | 0.80419 | 0.80635 | 0.79946 | 0.8011 | 99319.0 |
| 2018-03-08 | AD | Futures | 0.78635 | 0.78909 | 0.78346 | 0.7864 | 92537.0 |
| 2018-03-08 | B | Futures | 46.56 | 46.59 | 45.78 | 45.91 | 294786.0 |
| 2018-03-08 | B6 | Futures | 1.4458 | 1.4471 | 1.4336 | 1.4354 | 129629.0 |
| 2018-03-08 | BTC | Futures | 13830.3 | 14010.6 | 12630.4 | 13039.6 | 2524.0 |
| 2018-03-08 | BZ | Futures | 46.02 | 46.02 | 45.22 | 45.35 | 44008.0 |
| 2018-03-08 | C | Futures | 1589.0 | 1656.0 | 1589.0 | 1653.0 | 4068.0 |
| 2018-03-08 | CB | Futures | 284.459 | 284.459 | 282.606 | 282.606 | 27.0 |
| 2018-03-08 | CC | Futures | 1787.0 | 1850.0 | 1781.0 | 1829.0 | 27773.0 |
| 2018-03-08 | CNH | Futures | 6.4597 | 6.4711 | 6.4526 | 6.4711 | 19.0 |
| 2018-03-08 | CSC | Futures | 3.304 | 3.314 | 3.291 | 3.314 | 26.0 |
| 2018-03-08 | CT | Futures | 95.7 | 97.99 | 95.36 | 97.84 | 22263.0 |
| 2018-03-08 | DC | Futures | 26.19 | 26.28 | 26.15 | 26.28 | 34.0 |
| 2018-03-08 | DX | Futures | 84.129 | 84.721 | 83.974 | 84.666 | 31827.0 |
| 2018-03-08 | E1 | Futures | 1.2876 | 1.28918 | 1.27583 | 1.27644 | 27064.0 |
| 2018-03-08 | E6 | Futures | 1.40751 | 1.41181 | 1.39487 | 1.39577 | 372406.0 |
| 2018-03-08 | E7 | Futures | 1.4006 | 1.4047 | 1.3879 | 1.3888 | 7821.0 |
| 2018-03-08 | EBM | Futures | 175.86 | 176.93 | 175.05 | 176.66 | 20060.0 |
| 2018-03-08 | ED | Futures | 95.0518 | 95.0542 | 95.0421 | 95.047 | 320258.0 |
| 2018-03-08 | ER | Futures | 98.337 | 98.342 | 98.337 | 98.342 | 46632.0 |
| 2018-03-08 | EW | Futures | 2036.5 | 2043.9 | 2020.8 | 2033.2 | 28979.0 |
| 2018-03-08 | FBON | Futures | 127.28 | 127.89 | 127.03 | 127.86 | 517.0 |
| 2018-03-08 | FBTP | Futures | 112.77 | 113.58 | 112.46 | 113.51 | 135053.0 |
| 2018-03-08 | FBTS | Futures | 103.843 | 103.917 | 103.788 | 103.88 | 72216.0 |
| 2018-03-08 | FCE | Futures | 4594.0 | 4650.1 | 4580.3 | 4640.8 | 68424.0 |
| 2018-03-08 | FDAX | Futures | 12709.1 | 12846.5 | 12628.1 | 12823.2 | 95146.0 |
| 2018-03-08 | FDIV | Futures | 142.7 | 142.78 | 142.7 | 142.78 | 20.0 |
| 2018-03-08 | FDXM | Futures | 12731.7 | 12868.8 | 12648.5 | 12844.9 | 31510.0 |
| 2018-03-08 | FESX | Futures | 2761.2 | 2793.9 | 2755.5 | 2789.8 | 1625613.0 |
| 2018-03-08 | FEU3 | Futures | 99.016 | 99.016 | 99.011 | 99.016 | 1212.0 |
| 2018-03-08 | FGBL | Futures | 147.48 | 148.08 | 147.01 | 147.94 | 814860.0 |
| 2018-03-08 | FGBM | Futures | 128.75 | 128.94 | 128.41 | 128.89 | 713209.0 |
| 2018-03-08 | FGBS | Futures | 112.387 | 112.432 | 112.326 | 112.427 | 469771.0 |
| 2018-03-08 | FGBX | Futures | 165.84 | 167.08 | 165.11 | 166.87 | 68078.0 |
| 2018-03-08 | FMWO | Futures | 6988.9 | 7018.0 | 6977.2 | 7009.9 | 1405.0 |
| 2018-03-08 | FOAT | Futures | 136.78 | 137.37 | 136.39 | 137.31 | 144636.0 |
| 2018-03-08 | FTDX | Futures | 2601.7 | 2655.1 | 2594.2 | 2650.1 | 288.0 |
| 2018-03-08 | FTI | Futures | 488.04 | 492.63 | 486.84 | 491.44 | 22794.0 |
| 2018-03-08 | FTUK | Futures | 6226.9 | 6302.0 | 6226.9 | 6293.3 | 158716.0 |
| 2018-03-08 | FVSA | Futures | 419.81 | 432.12 | 407.5 | 408.73 | 21212.0 |
| 2018-03-08 | FXXP | Futures | 317.8 | 321.3 | 317.3 | 321.0 | 56983.0 |
| 2018-03-08 | G | Futures | 112.85 | 113.21 | 112.52 | 113.06 | 170205.0 |
| 2018-03-08 | GF | Futures | 315.451 | 316.494 | 309.906 | 311.278 | 2910.0 |
| 2018-03-08 | GSCI | Futures | 499.33 | 499.33 | 497.85 | 498.53 | 2632.0 |
> showing 50 of 112 rows — these rows as CSV