PREVIEW / futures_daily / 2017-03-15
file: by_date/futures_daily/2017/2017-03-15.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 |
|---|---|---|---|---|---|---|---|
| 2017-03-15 | ES | Futures | 2566.86 | 2593.2 | 2566.32 | 2585.33 | 1775343.0 |
| 2017-03-15 | NQ | Futures | 6344.16 | 6397.16 | 6336.51 | 6382.74 | 248409.0 |
| 2017-03-15 | YM | Futures | 21968.6 | 22085.7 | 21952.8 | 22050.9 | 165569.0 |
| 2017-03-15 | CL | Futures | 51.59 | 51.96 | 51.13 | 51.75 | 388673.0 |
| 2017-03-15 | GC | Futures | 1531.3 | 1561.1 | 1528.9 | 1533.9 | 264336.0 |
| 2017-03-15 | ZN | Futures | 120.770977 | 121.738865 | 120.755614 | 121.662049 | 1563846.0 |
| 2017-03-15 | A6 | Futures | 0.77445 | 0.79108 | 0.77424 | 0.788 | 122086.0 |
| 2017-03-15 | AD | Futures | 0.75733 | 0.76803 | 0.75727 | 0.76604 | 95219.0 |
| 2017-03-15 | ALI | Futures | 2505.66 | 2505.66 | 2505.66 | 2505.66 | 0.0 |
| 2017-03-15 | B | Futures | 37.61 | 38.08 | 37.5 | 37.83 | 327902.0 |
| 2017-03-15 | B6 | Futures | 1.2775 | 1.2937 | 1.2766 | 1.2917 | 123936.0 |
| 2017-03-15 | BFX | Futures | 4540.7 | 4545.0 | 4540.7 | 4545.0 | 36.0 |
| 2017-03-15 | BR | Futures | 0.22332 | 0.22908 | 0.22332 | 0.22868 | 9.0 |
| 2017-03-15 | BZ | Futures | 37.65 | 37.83 | 37.33 | 37.66 | 36290.0 |
| 2017-03-15 | C | Futures | 1756.0 | 1772.0 | 1741.0 | 1746.0 | 10115.0 |
| 2017-03-15 | CB | Futures | 269.748 | 269.748 | 267.306 | 267.306 | 37.0 |
| 2017-03-15 | CC | Futures | 1578.0 | 1587.0 | 1555.0 | 1564.0 | 16914.0 |
| 2017-03-15 | CNH | Futures | 7.2555 | 7.2555 | 7.1977 | 7.1993 | 60.0 |
| 2017-03-15 | CSC | Futures | 3.663 | 3.663 | 3.609 | 3.618 | 79.0 |
| 2017-03-15 | CT | Futures | 86.19 | 87.23 | 86.02 | 87.03 | 11527.0 |
| 2017-03-15 | DC | Futures | 29.92 | 30.11 | 29.44 | 29.55 | 311.0 |
| 2017-03-15 | DX | Futures | 94.629 | 94.648 | 93.465 | 93.702 | 47714.0 |
| 2017-03-15 | E1 | Futures | 1.23057 | 1.24478 | 1.2302 | 1.24206 | 30432.0 |
| 2017-03-15 | E6 | Futures | 1.2276 | 1.24292 | 1.2272 | 1.2386 | 229234.0 |
| 2017-03-15 | E7 | Futures | 1.2213 | 1.2365 | 1.2209 | 1.2323 | 4121.0 |
| 2017-03-15 | EBM | Futures | 192.38 | 193.5 | 192.1 | 193.22 | 18500.0 |
| 2017-03-15 | ED | Futures | 95.4962 | 95.53 | 95.4816 | 95.5204 | 452738.0 |
| 2017-03-15 | ER | Futures | 98.313 | 98.318 | 98.303 | 98.313 | 70982.0 |
| 2017-03-15 | EW | Futures | 1816.3 | 1842.1 | 1815.3 | 1838.3 | 29203.0 |
| 2017-03-15 | FBON | Futures | 119.31 | 120.05 | 119.31 | 119.99 | 743.0 |
| 2017-03-15 | FBTP | Futures | 102.82 | 103.54 | 102.8 | 103.46 | 78671.0 |
| 2017-03-15 | FBTS | Futures | 101.51 | 101.637 | 101.465 | 101.601 | 30674.0 |
| 2017-03-15 | FCE | Futures | 4382.1 | 4404.1 | 4368.4 | 4385.1 | 175761.0 |
| 2017-03-15 | FDAX | Futures | 12667.4 | 12735.0 | 12642.6 | 12688.6 | 130278.0 |
| 2017-03-15 | FDXM | Futures | 12587.5 | 12656.6 | 12567.7 | 12611.6 | 3607.0 |
| 2017-03-15 | FESX | Futures | 2717.3 | 2734.5 | 2710.0 | 2719.0 | 1195762.0 |
| 2017-03-15 | FEU3 | Futures | 98.986 | 98.991 | 98.986 | 98.991 | 95.0 |
| 2017-03-15 | FGBL | Futures | 146.63 | 147.46 | 146.51 | 147.13 | 678122.0 |
| 2017-03-15 | FGBM | Futures | 128.94 | 129.28 | 128.9 | 129.11 | 445769.0 |
| 2017-03-15 | FGBS | Futures | 112.392 | 112.452 | 112.367 | 112.422 | 242759.0 |
| 2017-03-15 | FGBX | Futures | 165.09 | 166.99 | 164.71 | 166.09 | 52996.0 |
| 2017-03-15 | FMWO | Futures | 6185.6 | 6235.0 | 6184.3 | 6194.0 | 7852.0 |
| 2017-03-15 | FOAT | Futures | 130.0 | 130.79 | 129.87 | 130.73 | 108414.0 |
| 2017-03-15 | FTDX | Futures | 1934.7 | 1943.0 | 1934.7 | 1941.6 | 2472.0 |
| 2017-03-15 | FTI | Futures | 462.88 | 465.97 | 462.75 | 463.66 | 33751.0 |
| 2017-03-15 | FTUK | Futures | 6234.7 | 6260.4 | 6225.7 | 6239.0 | 234290.0 |
| 2017-03-15 | FVSA | Futures | 676.6 | 684.92 | 672.44 | 683.54 | 13233.0 |
| 2017-03-15 | FXXP | Futures | 310.2 | 311.6 | 309.6 | 310.6 | 107281.0 |
| 2017-03-15 | G | Futures | 113.86 | 114.23 | 113.82 | 114.08 | 169514.0 |
| 2017-03-15 | GF | Futures | 293.931 | 297.563 | 293.47 | 296.814 | 4419.0 |
> showing 50 of 109 rows — these rows as CSV