PREVIEW / futures_daily / 2016-09-15
file: by_date/futures_daily/2016/2016-09-15.parquet size: 9 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-09-15 | ES | Futures | 2287.58 | 2319.48 | 2279.73 | 2312.45 | 2301296.0 |
| 2016-09-15 | NQ | Futures | 5573.36 | 5684.73 | 5558.33 | 5673.24 | 343596.0 |
| 2016-09-15 | YM | Futures | 18831.5 | 19077.3 | 18776.9 | 19021.6 | 219404.0 |
| 2016-09-15 | CL | Futures | 48.82 | 49.58 | 48.37 | 49.09 | 392520.0 |
| 2016-09-15 | GC | Futures | 1701.0 | 1709.6 | 1683.4 | 1691.0 | 211228.0 |
| 2016-09-15 | ZN | Futures | 126.80048 | 127.286888 | 126.572477 | 126.906882 | 1392491.0 |
| 2016-09-15 | A6 | Futures | 0.76091 | 0.76581 | 0.75805 | 0.7651 | 57582.0 |
| 2016-09-15 | AD | Futures | 0.77673 | 0.78052 | 0.77437 | 0.77904 | 53865.0 |
| 2016-09-15 | ALI | Futures | 2071.36 | 2071.36 | 2071.36 | 2071.36 | 0.0 |
| 2016-09-15 | B | Futures | 36.21 | 36.95 | 35.91 | 36.63 | 320720.0 |
| 2016-09-15 | B6 | Futures | 1.3961 | 1.4002 | 1.3897 | 1.396 | 71752.0 |
| 2016-09-15 | BFX | Futures | 4171.1 | 4175.3 | 4149.1 | 4175.3 | 6.0 |
| 2016-09-15 | BR | Futures | 0.2004 | 0.20325 | 0.2004 | 0.20325 | 18.0 |
| 2016-09-15 | BZ | Futures | 36.13 | 36.8 | 35.77 | 36.48 | 28412.0 |
| 2016-09-15 | C | Futures | 2386.0 | 2402.0 | 2379.0 | 2400.0 | 13726.0 |
| 2016-09-15 | CB | Futures | 251.739 | 251.739 | 250.778 | 250.902 | 12.0 |
| 2016-09-15 | CC | Futures | 2079.0 | 2099.0 | 2072.0 | 2095.0 | 14844.0 |
| 2016-09-15 | CNH | Futures | 7.2348 | 7.2348 | 7.2157 | 7.2157 | 38.0 |
| 2016-09-15 | CSC | Futures | 3.891 | 3.891 | 3.891 | 3.891 | 1.0 |
| 2016-09-15 | CT | Futures | 76.6 | 77.46 | 76.55 | 77.46 | 8.0 |
| 2016-09-15 | DC | Futures | 30.78 | 30.95 | 30.7 | 30.83 | 20.0 |
| 2016-09-15 | DX | Futures | 88.684 | 88.87 | 88.419 | 88.617 | 20312.0 |
| 2016-09-15 | E1 | Futures | 1.28668 | 1.29216 | 1.28182 | 1.28867 | 16706.0 |
| 2016-09-15 | E6 | Futures | 1.30912 | 1.31474 | 1.30541 | 1.30819 | 153541.0 |
| 2016-09-15 | E7 | Futures | 1.3017 | 1.3069 | 1.2984 | 1.3011 | 3064.0 |
| 2016-09-15 | EBM | Futures | 187.7 | 190.06 | 186.52 | 186.82 | 17337.0 |
| 2016-09-15 | ED | Futures | 95.6586 | 95.6779 | 95.6538 | 95.6683 | 366681.0 |
| 2016-09-15 | ER | Futures | 98.288 | 98.293 | 98.283 | 98.288 | 78775.0 |
| 2016-09-15 | EW | Futures | 1604.4 | 1625.8 | 1597.9 | 1623.5 | 18263.0 |
| 2016-09-15 | FBON | Futures | 123.53 | 123.91 | 123.41 | 123.67 | 1105.0 |
| 2016-09-15 | FBTP | Futures | 108.94 | 109.03 | 108.55 | 108.71 | 98625.0 |
| 2016-09-15 | FBTS | Futures | 101.203 | 101.212 | 101.176 | 101.194 | 23551.0 |
| 2016-09-15 | FCE | Futures | 3867.1 | 3892.9 | 3848.0 | 3877.3 | 73122.0 |
| 2016-09-15 | FDAX | Futures | 11008.5 | 11147.9 | 10997.9 | 11114.4 | 131431.0 |
| 2016-09-15 | FDIV | Futures | 139.09 | 139.62 | 139.09 | 139.62 | 9.0 |
| 2016-09-15 | FDXM | Futures | 10907.4 | 11036.0 | 10888.4 | 11002.8 | 3692.0 |
| 2016-09-15 | FESX | Futures | 2355.7 | 2378.1 | 2346.9 | 2370.9 | 1084649.0 |
| 2016-09-15 | FEU3 | Futures | 98.966 | 98.971 | 98.966 | 98.966 | 252.0 |
| 2016-09-15 | FGBL | Futures | 149.23 | 149.54 | 148.86 | 149.26 | 699458.0 |
| 2016-09-15 | FGBM | Futures | 128.73 | 128.8 | 128.62 | 128.74 | 458468.0 |
| 2016-09-15 | FGBS | Futures | 111.887 | 111.902 | 111.872 | 111.892 | 236621.0 |
| 2016-09-15 | FGBX | Futures | 181.53 | 182.23 | 179.88 | 180.8 | 34147.0 |
| 2016-09-15 | FMWO | Futures | 5668.6 | 5706.3 | 5655.3 | 5706.3 | 2376.0 |
| 2016-09-15 | FOAT | Futures | 137.13 | 137.4 | 136.82 | 137.13 | 116077.0 |
| 2016-09-15 | FTDX | Futures | 1716.6 | 1734.2 | 1703.8 | 1726.9 | 846.0 |
| 2016-09-15 | FTI | Futures | 403.12 | 407.33 | 403.12 | 406.23 | 14188.0 |
| 2016-09-15 | FTUK | Futures | 5607.6 | 5663.8 | 5571.8 | 5651.5 | 108793.0 |
| 2016-09-15 | FVSA | Futures | 1740.99 | 1748.14 | 1662.34 | 1669.49 | 12523.0 |
| 2016-09-15 | FXXP | Futures | 277.8 | 280.5 | 277.3 | 279.8 | 72862.0 |
| 2016-09-15 | G | Futures | 114.8 | 115.05 | 114.22 | 114.8 | 217797.0 |
> showing 50 of 111 rows — these rows as CSV