PREVIEW / futures_daily / 2016-01-07
file: by_date/futures_daily/2016/2016-01-07.parquet size: 9 KB rows: 110
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 |
|---|---|---|---|---|---|---|---|
| 2016-01-07 | ES | Futures | 2123.19 | 2126.66 | 2059.9 | 2064.71 | 2969295.0 |
| 2016-01-07 | NQ | Futures | 5217.06 | 5226.73 | 5020.99 | 5028.32 | 501315.0 |
| 2016-01-07 | YM | Futures | 17444.7 | 17468.5 | 16936.6 | 16990.4 | 311903.0 |
| 2016-01-07 | CL | Futures | 50.7 | 50.96 | 47.74 | 49.48 | 617409.0 |
| 2016-01-07 | GC | Futures | 1410.5 | 1431.4 | 1407.2 | 1428.7 | 217266.0 |
| 2016-01-07 | ZN | Futures | 122.107502 | 122.558749 | 121.942045 | 122.363209 | 1450669.0 |
| 2016-01-07 | A6 | Futures | 0.7054 | 0.70781 | 0.69719 | 0.69869 | 137811.0 |
| 2016-01-07 | AD | Futures | 0.72656 | 0.72779 | 0.72155 | 0.72595 | 87378.0 |
| 2016-01-07 | ALI | Futures | 2086.16 | 2086.16 | 2086.16 | 2086.16 | 0.0 |
| 2016-01-07 | B | Futures | 30.07 | 30.26 | 28.05 | 29.38 | 265450.0 |
| 2016-01-07 | B6 | Futures | 1.5395 | 1.5406 | 1.5292 | 1.5378 | 105462.0 |
| 2016-01-07 | BFX | Futures | 4267.9 | 4340.8 | 4267.9 | 4314.0 | 7.0 |
| 2016-01-07 | BR | Futures | 0.15227 | 0.15281 | 0.15227 | 0.15281 | 9.0 |
| 2016-01-07 | BZ | Futures | 29.77 | 29.93 | 27.77 | 29.07 | 23813.0 |
| 2016-01-07 | C | Futures | 2221.0 | 2221.0 | 2168.0 | 2218.0 | 24941.0 |
| 2016-01-07 | CB | Futures | 253.607 | 254.844 | 253.607 | 254.844 | 7.0 |
| 2016-01-07 | CC | Futures | 2176.0 | 2202.0 | 2137.0 | 2185.0 | 35446.0 |
| 2016-01-07 | CNH | Futures | 7.4257 | 7.4268 | 7.395 | 7.416 | 109.0 |
| 2016-01-07 | CSC | Futures | 3.696 | 3.711 | 3.679 | 3.699 | 111.0 |
| 2016-01-07 | CT | Futures | 72.52 | 72.85 | 71.7 | 71.96 | 28884.0 |
| 2016-01-07 | DC | Futures | 29.06 | 29.27 | 28.97 | 29.08 | 262.0 |
| 2016-01-07 | DX | Futures | 92.784 | 92.84 | 91.771 | 91.801 | 39144.0 |
| 2016-01-07 | E1 | Futures | 1.2563 | 1.27587 | 1.25529 | 1.27498 | 27455.0 |
| 2016-01-07 | E6 | Futures | 1.26239 | 1.28145 | 1.26146 | 1.28063 | 289122.0 |
| 2016-01-07 | E7 | Futures | 1.2547 | 1.2741 | 1.2544 | 1.2734 | 7144.0 |
| 2016-01-07 | EBM | Futures | 239.77 | 241.19 | 238.36 | 239.42 | 24075.0 |
| 2016-01-07 | ED | Futures | 95.588 | 95.6025 | 95.5784 | 95.5976 | 339094.0 |
| 2016-01-07 | ER | Futures | 98.234 | 98.249 | 98.234 | 98.239 | 66247.0 |
| 2016-01-07 | EW | Futures | 1433.9 | 1434.6 | 1390.5 | 1392.3 | 39301.0 |
| 2016-01-07 | FBON | Futures | 116.37 | 116.37 | 115.49 | 115.52 | 183.0 |
| 2016-01-07 | FBTP | Futures | 105.79 | 105.88 | 104.96 | 105.08 | 103483.0 |
| 2016-01-07 | FBTS | Futures | 100.917 | 100.944 | 100.819 | 100.837 | 30840.0 |
| 2016-01-07 | FCE | Futures | 3676.1 | 3700.0 | 3611.7 | 3682.0 | 148265.0 |
| 2016-01-07 | FDAX | Futures | 10829.1 | 10888.2 | 10638.2 | 10815.0 | 150864.0 |
| 2016-01-07 | FDIV | Futures | 126.78 | 128.59 | 126.78 | 128.59 | 3.0 |
| 2016-01-07 | FDXM | Futures | 10341.2 | 10410.7 | 10172.2 | 10341.2 | 25888.0 |
| 2016-01-07 | FESX | Futures | 2326.7 | 2352.5 | 2293.2 | 2338.1 | 1850172.0 |
| 2016-01-07 | FEU3 | Futures | 98.897 | 98.897 | 98.892 | 98.892 | 30.0 |
| 2016-01-07 | FGBL | Futures | 140.98 | 141.19 | 140.18 | 140.3 | 779519.0 |
| 2016-01-07 | FGBM | Futures | 126.04 | 126.15 | 125.84 | 125.87 | 531229.0 |
| 2016-01-07 | FGBS | Futures | 111.518 | 111.563 | 111.498 | 111.508 | 296475.0 |
| 2016-01-07 | FGBX | Futures | 158.93 | 158.93 | 156.45 | 156.92 | 45483.0 |
| 2016-01-07 | FMWO | Futures | 5343.9 | 5368.8 | 5289.1 | 5356.4 | 1735.0 |
| 2016-01-07 | FOAT | Futures | 128.73 | 129.02 | 128.04 | 128.2 | 165183.0 |
| 2016-01-07 | FTDX | Futures | 1661.9 | 1680.1 | 1636.5 | 1671.5 | 1626.0 |
| 2016-01-07 | FTI | Futures | 368.11 | 369.77 | 359.72 | 367.49 | 51932.0 |
| 2016-01-07 | FTUK | Futures | 4894.0 | 4905.8 | 4750.0 | 4807.9 | 201907.0 |
| 2016-01-07 | FVSA | Futures | 2545.63 | 2752.67 | 2531.51 | 2592.68 | 26668.0 |
| 2016-01-07 | FXXP | Futures | 271.7 | 272.7 | 267.2 | 271.0 | 56022.0 |
| 2016-01-07 | G | Futures | 105.54 | 105.85 | 105.05 | 105.22 | 230812.0 |
> showing 50 of 110 rows — these rows as CSV