PREVIEW / futures_daily / 2017-04-11
file: by_date/futures_daily/2017/2017-04-11.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-04-11 | ES | Futures | 2556.82 | 2558.45 | 2534.01 | 2553.29 | 1856700.0 |
| 2017-04-11 | NQ | Futures | 6391.57 | 6394.51 | 6310.6 | 6362.12 | 332142.0 |
| 2017-04-11 | YM | Futures | 21742.8 | 21760.7 | 21576.1 | 21729.1 | 191207.0 |
| 2017-04-11 | CL | Futures | 55.69 | 56.02 | 55.23 | 55.97 | 598003.0 |
| 2017-04-11 | GC | Futures | 1607.2 | 1633.6 | 1604.5 | 1629.5 | 292142.0 |
| 2017-04-11 | ZN | Futures | 122.78357 | 123.459556 | 122.78357 | 123.38274 | 1485530.0 |
| 2017-04-11 | A6 | Futures | 0.76931 | 0.77044 | 0.76634 | 0.76849 | 92733.0 |
| 2017-04-11 | AD | Futures | 0.76594 | 0.76691 | 0.76421 | 0.76569 | 50063.0 |
| 2017-04-11 | ALI | Futures | 2528.38 | 2528.38 | 2528.38 | 2528.38 | 0.0 |
| 2017-04-11 | B | Futures | 40.67 | 40.83 | 40.21 | 40.78 | 340419.0 |
| 2017-04-11 | B6 | Futures | 1.3039 | 1.3123 | 1.3026 | 1.3116 | 89744.0 |
| 2017-04-11 | BR | Futures | 0.22908 | 0.22908 | 0.22825 | 0.22861 | 287.0 |
| 2017-04-11 | BZ | Futures | 40.54 | 40.7 | 40.11 | 40.67 | 32054.0 |
| 2017-04-11 | C | Futures | 1636.0 | 1658.0 | 1617.0 | 1650.0 | 9159.0 |
| 2017-04-11 | CB | Futures | 256.962 | 257.847 | 256.565 | 257.847 | 47.0 |
| 2017-04-11 | CC | Futures | 1491.0 | 1526.0 | 1487.0 | 1520.0 | 30928.0 |
| 2017-04-11 | CNH | Futures | 7.2335 | 7.2335 | 7.2238 | 7.2238 | 23.0 |
| 2017-04-11 | CSC | Futures | 3.48 | 3.507 | 3.46 | 3.504 | 105.0 |
| 2017-04-11 | CT | Futures | 83.72 | 84.49 | 82.94 | 83.61 | 29314.0 |
| 2017-04-11 | DC | Futures | 28.43 | 28.63 | 28.15 | 28.6 | 218.0 |
| 2017-04-11 | DX | Futures | 94.005 | 94.103 | 93.642 | 93.746 | 24418.0 |
| 2017-04-11 | E1 | Futures | 1.23007 | 1.23366 | 1.22921 | 1.23156 | 17057.0 |
| 2017-04-11 | E6 | Futures | 1.2242 | 1.22841 | 1.22248 | 1.22582 | 138806.0 |
| 2017-04-11 | E7 | Futures | 1.2177 | 1.2221 | 1.2162 | 1.2196 | 2847.0 |
| 2017-04-11 | EBM | Futures | 182.3 | 183.7 | 181.74 | 181.74 | 27671.0 |
| 2017-04-11 | ED | Futures | 95.5494 | 95.5639 | 95.5494 | 95.5591 | 185051.0 |
| 2017-04-11 | ER | Futures | 98.328 | 98.328 | 98.323 | 98.323 | 45603.0 |
| 2017-04-11 | EW | Futures | 1816.5 | 1828.9 | 1805.6 | 1827.4 | 22732.0 |
| 2017-04-11 | FBON | Futures | 122.13 | 122.28 | 121.96 | 122.06 | 343.0 |
| 2017-04-11 | FBTP | Futures | 105.55 | 105.58 | 105.1 | 105.31 | 80746.0 |
| 2017-04-11 | FBTS | Futures | 101.864 | 101.864 | 101.764 | 101.791 | 35553.0 |
| 2017-04-11 | FCE | Futures | 4497.2 | 4513.1 | 4466.3 | 4497.2 | 107287.0 |
| 2017-04-11 | FDAX | Futures | 12880.2 | 12930.3 | 12742.4 | 12831.6 | 110016.0 |
| 2017-04-11 | FDXM | Futures | 12770.7 | 12815.7 | 12631.5 | 12718.9 | 31702.0 |
| 2017-04-11 | FESX | Futures | 2776.9 | 2789.2 | 2756.5 | 2774.5 | 1237315.0 |
| 2017-04-11 | FEU3 | Futures | 98.996 | 98.996 | 98.996 | 98.996 | 3.0 |
| 2017-04-11 | FGBL | Futures | 150.06 | 150.16 | 149.69 | 150.0 | 657527.0 |
| 2017-04-11 | FGBM | Futures | 130.15 | 130.21 | 130.03 | 130.17 | 321705.0 |
| 2017-04-11 | FGBS | Futures | 112.557 | 112.587 | 112.542 | 112.577 | 154951.0 |
| 2017-04-11 | FGBX | Futures | 173.36 | 173.66 | 172.02 | 173.34 | 37874.0 |
| 2017-04-11 | FMWO | Futures | 6185.6 | 6203.7 | 6168.8 | 6173.6 | 389.0 |
| 2017-04-11 | FOAT | Futures | 132.05 | 132.11 | 131.5 | 131.85 | 158943.0 |
| 2017-04-11 | FTDX | Futures | 2007.3 | 2007.7 | 1959.7 | 1979.8 | 278.0 |
| 2017-04-11 | FTI | Futures | 468.87 | 470.47 | 466.62 | 469.05 | 71.0 |
| 2017-04-11 | FTUK | Futures | 6236.4 | 6287.8 | 6221.0 | 6254.4 | 140715.0 |
| 2017-04-11 | FVSA | Futures | 704.33 | 740.38 | 701.56 | 714.04 | 35521.0 |
| 2017-04-11 | FXXP | Futures | 316.5 | 318.5 | 315.7 | 317.4 | 30927.0 |
| 2017-04-11 | G | Futures | 115.85 | 115.97 | 115.44 | 115.94 | 149380.0 |
| 2017-04-11 | GF | Futures | 310.121 | 316.079 | 309.377 | 314.647 | 7582.0 |
| 2017-04-11 | GSCI | Futures | 502.24 | 504.25 | 500.55 | 504.06 | 3960.0 |
> showing 50 of 109 rows — these rows as CSV