PREVIEW / futures_daily / 2016-03-18
file: by_date/futures_daily/2016/2016-03-18.parquet size: 10 KB rows: 111
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-03-18 | ES | Futures | 2180.99 | 2193.34 | 2176.43 | 2187.7 | 1775664.0 |
| 2016-03-18 | NQ | Futures | 5164.74 | 5182.66 | 5141.54 | 5163.86 | 240454.0 |
| 2016-03-18 | YM | Futures | 18081.3 | 18218.5 | 18051.1 | 18187.3 | 128256.0 |
| 2016-03-18 | CL | Futures | 50.53 | 51.58 | 49.79 | 49.94 | 671720.0 |
| 2016-03-18 | GC | Futures | 1616.0 | 1628.9 | 1604.1 | 1611.7 | 158071.0 |
| 2016-03-18 | ZN | Futures | 124.665025 | 125.012029 | 124.649938 | 124.951681 | 950622.0 |
| 2016-03-18 | A6 | Futures | 0.77031 | 0.77435 | 0.76565 | 0.76616 | 70439.0 |
| 2016-03-18 | AD | Futures | 0.7877 | 0.79118 | 0.78402 | 0.78474 | 58528.0 |
| 2016-03-18 | ALI | Futures | 2085.0 | 2085.0 | 2085.0 | 2085.0 | 15.0 |
| 2016-03-18 | B | Futures | 34.46 | 35.43 | 34.2 | 34.31 | 286653.0 |
| 2016-03-18 | B6 | Futures | 1.5251 | 1.5288 | 1.5179 | 1.5247 | 64954.0 |
| 2016-03-18 | BFX | Futures | 3994.5 | 4004.4 | 3994.5 | 4004.4 | 8.0 |
| 2016-03-18 | BR | Futures | 0.1754 | 0.17833 | 0.1754 | 0.17774 | 464.0 |
| 2016-03-18 | BZ | Futures | 34.11 | 35.07 | 33.67 | 33.96 | 36422.0 |
| 2016-03-18 | C | Futures | 2384.0 | 2400.0 | 2374.0 | 2380.0 | 6995.0 |
| 2016-03-18 | CB | Futures | 248.769 | 248.769 | 247.549 | 248.067 | 26.0 |
| 2016-03-18 | CC | Futures | 2281.0 | 2305.0 | 2273.0 | 2283.0 | 12405.0 |
| 2016-03-18 | CNH | Futures | 7.0472 | 7.0592 | 7.0339 | 7.0404 | 20.0 |
| 2016-03-18 | CSC | Futures | 3.52 | 3.575 | 3.52 | 3.568 | 19.0 |
| 2016-03-18 | CT | Futures | 67.03 | 67.24 | 65.26 | 65.65 | 16258.0 |
| 2016-03-18 | DC | Futures | 27.7 | 28.22 | 27.68 | 28.11 | 182.0 |
| 2016-03-18 | DX | Futures | 88.383 | 88.752 | 88.202 | 88.682 | 20394.0 |
| 2016-03-18 | E1 | Futures | 1.30421 | 1.30597 | 1.29781 | 1.30032 | 17819.0 |
| 2016-03-18 | E6 | Futures | 1.32298 | 1.32543 | 1.31599 | 1.31739 | 153487.0 |
| 2016-03-18 | E7 | Futures | 1.3158 | 1.3182 | 1.3088 | 1.3102 | 2906.0 |
| 2016-03-18 | EBM | Futures | 197.52 | 197.52 | 195.59 | 195.59 | 18951.0 |
| 2016-03-18 | ED | Futures | 95.6678 | 95.6822 | 95.663 | 95.6678 | 216334.0 |
| 2016-03-18 | ER | Futures | 98.254 | 98.264 | 98.249 | 98.254 | 67924.0 |
| 2016-03-18 | EW | Futures | 1498.7 | 1511.8 | 1494.5 | 1505.5 | 17606.0 |
| 2016-03-18 | FBON | Futures | 118.55 | 118.68 | 118.26 | 118.33 | 117.0 |
| 2016-03-18 | FBTP | Futures | 107.5 | 107.82 | 107.47 | 107.49 | 72483.0 |
| 2016-03-18 | FBTS | Futures | 100.997 | 101.024 | 100.979 | 101.006 | 16852.0 |
| 2016-03-18 | FCE | Futures | 3685.9 | 3719.7 | 3672.2 | 3709.2 | 91652.0 |
| 2016-03-18 | FDAX | Futures | 10640.0 | 10737.7 | 10586.3 | 10734.0 | 98453.0 |
| 2016-03-18 | FDIV | Futures | 133.91 | 133.91 | 126.97 | 128.31 | 68.0 |
| 2016-03-18 | FDXM | Futures | 10247.5 | 10339.6 | 10193.7 | 10335.4 | 19484.0 |
| 2016-03-18 | FESX | Futures | 2307.2 | 2331.4 | 2294.0 | 2325.9 | 1287093.0 |
| 2016-03-18 | FEU3 | Futures | 98.912 | 98.912 | 98.907 | 98.907 | 5.0 |
| 2016-03-18 | FGBL | Futures | 145.33 | 145.62 | 145.19 | 145.29 | 463333.0 |
| 2016-03-18 | FGBM | Futures | 127.17 | 127.28 | 127.15 | 127.18 | 411115.0 |
| 2016-03-18 | FGBS | Futures | 111.603 | 111.623 | 111.593 | 111.608 | 161210.0 |
| 2016-03-18 | FGBX | Futures | 170.69 | 171.87 | 170.57 | 170.86 | 27099.0 |
| 2016-03-18 | FMWO | Futures | 5561.9 | 5575.6 | 5558.1 | 5573.1 | 97.0 |
| 2016-03-18 | FOAT | Futures | 132.93 | 133.34 | 132.84 | 132.94 | 56623.0 |
| 2016-03-18 | FTDX | Futures | 1523.8 | 1537.6 | 1523.8 | 1536.6 | 2173.0 |
| 2016-03-18 | FTI | Futures | 393.09 | 395.26 | 391.23 | 393.71 | 34724.0 |
| 2016-03-18 | FTUK | Futures | 5072.5 | 5097.3 | 5042.0 | 5062.6 | 135013.0 |
| 2016-03-18 | FVSA | Futures | 2766.21 | 2799.34 | 2622.65 | 2628.17 | 18663.0 |
| 2016-03-18 | FXXP | Futures | 268.4 | 269.9 | 267.2 | 269.2 | 28615.0 |
| 2016-03-18 | G | Futures | 108.33 | 108.45 | 108.1 | 108.18 | 120849.0 |
> showing 50 of 111 rows — these rows as CSV