PREVIEW / futures_daily / 2016-04-13
file: by_date/futures_daily/2016/2016-04-13.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-04-13 | ES | Futures | 2206.76 | 2230.11 | 2205.42 | 2229.04 | 1637033.0 |
| 2016-04-13 | NQ | Futures | 5274.61 | 5350.69 | 5271.96 | 5343.64 | 228380.0 |
| 2016-04-13 | YM | Futures | 18338.1 | 18539.8 | 18329.8 | 18536.7 | 154946.0 |
| 2016-04-13 | CL | Futures | 51.19 | 52.05 | 50.72 | 51.24 | 341985.0 |
| 2016-04-13 | GC | Futures | 1620.4 | 1622.4 | 1600.1 | 1609.0 | 155992.0 |
| 2016-04-13 | ZN | Futures | 126.037955 | 126.219001 | 125.871996 | 126.128478 | 1073434.0 |
| 2016-04-13 | A6 | Futures | 0.77537 | 0.77881 | 0.77061 | 0.77294 | 85348.0 |
| 2016-04-13 | AD | Futures | 0.80089 | 0.80243 | 0.79701 | 0.79813 | 84424.0 |
| 2016-04-13 | ALI | Futures | 2100.19 | 2116.35 | 2100.19 | 2113.77 | 31.0 |
| 2016-04-13 | B | Futures | 37.01 | 37.43 | 36.44 | 36.79 | 348587.0 |
| 2016-04-13 | B6 | Futures | 1.5022 | 1.5037 | 1.4946 | 1.4967 | 77928.0 |
| 2016-04-13 | BFX | Futures | 3937.3 | 3957.8 | 3921.4 | 3957.8 | 61.0 |
| 2016-04-13 | BR | Futures | 0.18249 | 0.1851 | 0.18028 | 0.18415 | 70.0 |
| 2016-04-13 | BZ | Futures | 36.45 | 37.04 | 36.08 | 36.42 | 37539.0 |
| 2016-04-13 | C | Futures | 2269.0 | 2292.0 | 2243.0 | 2284.0 | 4572.0 |
| 2016-04-13 | CB | Futures | 260.963 | 260.963 | 258.616 | 260.963 | 34.0 |
| 2016-04-13 | CC | Futures | 2136.0 | 2166.0 | 2132.0 | 2161.0 | 22116.0 |
| 2016-04-13 | CNH | Futures | 7.0554 | 7.0694 | 7.0554 | 7.0694 | 17.0 |
| 2016-04-13 | CSC | Futures | 3.644 | 3.644 | 3.639 | 3.639 | 10.0 |
| 2016-04-13 | CT | Futures | 70.76 | 71.63 | 70.41 | 70.78 | 27336.0 |
| 2016-04-13 | DC | Futures | 29.06 | 29.06 | 28.65 | 28.73 | 156.0 |
| 2016-04-13 | DX | Futures | 87.68 | 88.416 | 87.638 | 88.348 | 26029.0 |
| 2016-04-13 | E1 | Futures | 1.31816 | 1.31904 | 1.30233 | 1.30271 | 22357.0 |
| 2016-04-13 | E6 | Futures | 1.3301 | 1.33086 | 1.31645 | 1.31826 | 198197.0 |
| 2016-04-13 | E7 | Futures | 1.3228 | 1.3235 | 1.3095 | 1.3112 | 3938.0 |
| 2016-04-13 | EBM | Futures | 197.85 | 200.1 | 197.52 | 199.78 | 39569.0 |
| 2016-04-13 | ED | Futures | 95.716 | 95.7256 | 95.7112 | 95.716 | 187587.0 |
| 2016-04-13 | ER | Futures | 98.259 | 98.269 | 98.259 | 98.259 | 121413.0 |
| 2016-04-13 | EW | Futures | 1519.2 | 1545.5 | 1519.2 | 1545.1 | 16982.0 |
| 2016-04-13 | FBON | Futures | 118.34 | 118.95 | 118.25 | 118.95 | 234.0 |
| 2016-04-13 | FBTP | Futures | 106.63 | 107.42 | 106.57 | 107.25 | 95043.0 |
| 2016-04-13 | FBTS | Futures | 100.97 | 101.006 | 100.97 | 100.988 | 30135.0 |
| 2016-04-13 | FCE | Futures | 3656.7 | 3756.6 | 3655.0 | 3752.4 | 132951.0 |
| 2016-04-13 | FDAX | Futures | 10616.3 | 10820.4 | 10616.3 | 10775.9 | 115363.0 |
| 2016-04-13 | FDXM | Futures | 10221.7 | 10419.2 | 10221.7 | 10376.8 | 20552.0 |
| 2016-04-13 | FESX | Futures | 2259.6 | 2317.4 | 2259.6 | 2307.2 | 1734481.0 |
| 2016-04-13 | FEU3 | Futures | 98.922 | 98.922 | 98.917 | 98.917 | 62.0 |
| 2016-04-13 | FGBL | Futures | 146.01 | 146.65 | 145.93 | 146.45 | 649921.0 |
| 2016-04-13 | FGBM | Futures | 127.6 | 127.74 | 127.59 | 127.7 | 379147.0 |
| 2016-04-13 | FGBS | Futures | 111.683 | 111.713 | 111.683 | 111.698 | 140405.0 |
| 2016-04-13 | FGBX | Futures | 172.48 | 174.57 | 172.13 | 174.05 | 41535.0 |
| 2016-04-13 | FMWO | Futures | 5634.0 | 5652.7 | 5627.8 | 5646.4 | 1550.0 |
| 2016-04-13 | FOAT | Futures | 133.48 | 134.29 | 133.44 | 134.07 | 86994.0 |
| 2016-04-13 | FTDX | Futures | 1578.0 | 1589.0 | 1573.8 | 1584.2 | 205.0 |
| 2016-04-13 | FTI | Futures | 393.78 | 401.0 | 393.78 | 400.28 | 33004.0 |
| 2016-04-13 | FTUK | Futures | 5129.0 | 5218.6 | 5121.2 | 5200.4 | 149048.0 |
| 2016-04-13 | FVSA | Futures | 2675.91 | 2686.41 | 2597.21 | 2607.7 | 18733.0 |
| 2016-04-13 | FXXP | Futures | 267.7 | 271.6 | 267.6 | 270.8 | 38469.0 |
| 2016-04-13 | G | Futures | 108.33 | 108.63 | 108.23 | 108.49 | 182233.0 |
| 2016-04-13 | GF | Futures | 302.221 | 303.369 | 298.276 | 299.474 | 5658.0 |
> showing 50 of 110 rows — these rows as CSV