PREVIEW / futures_daily / 2016-09-13
file: by_date/futures_daily/2016/2016-09-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-09-13 | ES | Futures | 2328.08 | 2329.43 | 2287.86 | 2298.39 | 1201101.0 |
| 2016-09-13 | NQ | Futures | 5614.61 | 5616.38 | 5539.17 | 5572.77 | 142822.0 |
| 2016-09-13 | YM | Futures | 19134.0 | 19147.6 | 18846.2 | 18910.3 | 285892.0 |
| 2016-09-13 | CL | Futures | 51.45 | 51.48 | 50.02 | 50.15 | 319462.0 |
| 2016-09-13 | GC | Futures | 1708.6 | 1714.0 | 1692.0 | 1698.3 | 180759.0 |
| 2016-09-13 | ZN | Futures | 126.998084 | 127.241288 | 126.283672 | 126.450875 | 1440609.0 |
| 2016-09-13 | A6 | Futures | 0.7701 | 0.7704 | 0.75744 | 0.75867 | 36980.0 |
| 2016-09-13 | AD | Futures | 0.78574 | 0.78651 | 0.77699 | 0.77781 | 29240.0 |
| 2016-09-13 | ALI | Futures | 2033.9 | 2033.9 | 2033.9 | 2033.9 | 0.0 |
| 2016-09-13 | B | Futures | 37.87 | 37.91 | 36.92 | 37.03 | 280023.0 |
| 2016-09-13 | B6 | Futures | 1.406 | 1.4066 | 1.3883 | 1.3903 | 76521.0 |
| 2016-09-13 | BFX | Futures | 4190.2 | 4190.2 | 4156.2 | 4156.2 | 31.0 |
| 2016-09-13 | BR | Futures | 0.20503 | 0.20503 | 0.2014 | 0.20153 | 282.0 |
| 2016-09-13 | BZ | Futures | 37.68 | 37.74 | 36.79 | 36.87 | 21761.0 |
| 2016-09-13 | C | Futures | 2341.0 | 2371.0 | 2335.0 | 2368.0 | 32638.0 |
| 2016-09-13 | CB | Futures | 254.56 | 256.357 | 254.56 | 255.985 | 17.0 |
| 2016-09-13 | CC | Futures | 2055.0 | 2077.0 | 2032.0 | 2058.0 | 27425.0 |
| 2016-09-13 | CNH | Futures | 7.2336 | 7.2519 | 7.2336 | 7.2511 | 198.0 |
| 2016-09-13 | CSC | Futures | 3.845 | 3.87 | 3.845 | 3.87 | 7.0 |
| 2016-09-13 | CT | Futures | 76.18 | 76.21 | 75.3 | 76.12 | 32.0 |
| 2016-09-13 | DC | Futures | 30.6 | 30.97 | 30.51 | 30.81 | 71.0 |
| 2016-09-13 | DX | Futures | 88.432 | 88.958 | 88.409 | 88.935 | 8829.0 |
| 2016-09-13 | E1 | Futures | 1.28817 | 1.28991 | 1.27995 | 1.28082 | 10013.0 |
| 2016-09-13 | E6 | Futures | 1.30732 | 1.31034 | 1.30373 | 1.30431 | 101157.0 |
| 2016-09-13 | E7 | Futures | 1.3002 | 1.3033 | 1.2968 | 1.2973 | 926.0 |
| 2016-09-13 | EBM | Futures | 185.64 | 187.7 | 185.05 | 186.82 | 14908.0 |
| 2016-09-13 | ED | Futures | 95.6345 | 95.6442 | 95.6249 | 95.6297 | 366552.0 |
| 2016-09-13 | ER | Futures | 98.288 | 98.293 | 98.283 | 98.288 | 47614.0 |
| 2016-09-13 | EW | Futures | 1639.8 | 1639.8 | 1602.9 | 1610.8 | 45663.0 |
| 2016-09-13 | FBON | Futures | 123.66 | 123.85 | 123.21 | 123.72 | 578.0 |
| 2016-09-13 | FBTP | Futures | 109.29 | 109.51 | 108.63 | 109.18 | 126913.0 |
| 2016-09-13 | FBTS | Futures | 101.221 | 101.239 | 101.158 | 101.212 | 18808.0 |
| 2016-09-13 | FCE | Futures | 3969.3 | 3969.8 | 3880.4 | 3890.6 | 150089.0 |
| 2016-09-13 | FDAX | Futures | 11200.1 | 11201.1 | 11014.9 | 11053.7 | 169487.0 |
| 2016-09-13 | FDXM | Futures | 11089.8 | 11089.8 | 10909.5 | 10943.7 | 1429.0 |
| 2016-09-13 | FESX | Futures | 2419.8 | 2419.8 | 2361.3 | 2370.1 | 1634223.0 |
| 2016-09-13 | FEU3 | Futures | 98.966 | 98.966 | 98.966 | 98.966 | 8.0 |
| 2016-09-13 | FGBL | Futures | 149.47 | 149.68 | 148.42 | 149.09 | 757025.0 |
| 2016-09-13 | FGBM | Futures | 128.7 | 128.76 | 128.43 | 128.59 | 486497.0 |
| 2016-09-13 | FGBS | Futures | 111.862 | 111.882 | 111.827 | 111.842 | 211491.0 |
| 2016-09-13 | FGBX | Futures | 182.25 | 183.82 | 179.49 | 181.84 | 37948.0 |
| 2016-09-13 | FMWO | Futures | 5719.7 | 5728.2 | 5663.8 | 5665.0 | 3611.0 |
| 2016-09-13 | FOAT | Futures | 137.3 | 137.51 | 136.43 | 136.99 | 116416.0 |
| 2016-09-13 | FTDX | Futures | 1716.1 | 1720.0 | 1706.8 | 1706.8 | 2403.0 |
| 2016-09-13 | FTI | Futures | 413.11 | 413.11 | 404.35 | 405.64 | 28819.0 |
| 2016-09-13 | FTUK | Futures | 5666.7 | 5670.1 | 5576.8 | 5595.8 | 330192.0 |
| 2016-09-13 | FVSA | Futures | 1669.49 | 1766.02 | 1662.34 | 1737.42 | 11715.0 |
| 2016-09-13 | FXXP | Futures | 282.7 | 282.7 | 277.8 | 278.0 | 177601.0 |
| 2016-09-13 | G | Futures | 115.1 | 115.47 | 114.05 | 114.82 | 221124.0 |
| 2016-09-13 | GF | Futures | 272.208 | 272.826 | 267.36 | 269.319 | 5656.0 |
> showing 50 of 110 rows — these rows as CSV