PREVIEW / futures_daily / 2014-09-15
file: by_date/futures_daily/2014/2014-09-15.parquet size: 9 KB rows: 105
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 |
|---|---|---|---|---|---|---|---|
| 2014-09-15 | ES | Futures | 2061.75 | 2067.24 | 2055.74 | 2064.1 | 1742226.0 |
| 2014-09-15 | NQ | Futures | 4695.59 | 4715.29 | 4648.07 | 4665.46 | 379764.0 |
| 2014-09-15 | YM | Futures | 17121.1 | 17214.4 | 17083.6 | 17189.1 | 152152.0 |
| 2014-09-15 | CL | Futures | 171.87 | 173.41 | 169.08 | 173.28 | 104815.0 |
| 2014-09-15 | GC | Futures | 1611.1 | 1625.4 | 1608.5 | 1620.0 | 100037.0 |
| 2014-09-15 | ZN | Futures | 116.254995 | 116.44536 | 116.137846 | 116.357499 | 890028.0 |
| 2014-09-15 | A6 | Futures | 0.87053 | 0.87384 | 0.86752 | 0.8716 | 105452.0 |
| 2014-09-15 | AD | Futures | 0.91428 | 0.91855 | 0.91326 | 0.91722 | 61161.0 |
| 2014-09-15 | ALI | Futures | 2997.13 | 2997.13 | 2997.13 | 2997.13 | 0.0 |
| 2014-09-15 | B | Futures | 102.09 | 102.79 | 101.35 | 102.25 | 193491.0 |
| 2014-09-15 | B6 | Futures | 1.7087 | 1.7093 | 1.7037 | 1.7042 | 61974.0 |
| 2014-09-15 | BFX | Futures | 3823.8 | 3844.4 | 3823.8 | 3841.0 | 27.0 |
| 2014-09-15 | BR | Futures | 0.22597 | 0.22678 | 0.22492 | 0.22578 | 1764.0 |
| 2014-09-15 | BZ | Futures | 102.6 | 103.51 | 102.07 | 102.97 | 14114.0 |
| 2014-09-15 | C | Futures | 2122.0 | 2133.0 | 2113.0 | 2130.0 | 5005.0 |
| 2014-09-15 | CB | Futures | 148.162 | 148.162 | 147.294 | 147.294 | 2.0 |
| 2014-09-15 | CC | Futures | 2248.0 | 2263.0 | 2240.0 | 2257.0 | 9935.0 |
| 2014-09-15 | CNH | Futures | 7.0911 | 7.1212 | 7.0842 | 7.1183 | 19.0 |
| 2014-09-15 | CT | Futures | 89.39 | 89.39 | 86.01 | 86.01 | 88.0 |
| 2014-09-15 | DC | Futures | 40.39 | 41.22 | 39.99 | 41.01 | 123.0 |
| 2014-09-15 | DX | Futures | 80.043 | 80.256 | 79.986 | 80.117 | 17219.0 |
| 2014-09-15 | E1 | Futures | 1.37136 | 1.37174 | 1.36548 | 1.36803 | 31673.0 |
| 2014-09-15 | E6 | Futures | 1.52753 | 1.52789 | 1.52059 | 1.52377 | 157102.0 |
| 2014-09-15 | E7 | Futures | 1.5157 | 1.5183 | 1.511 | 1.5142 | 3369.0 |
| 2014-09-15 | ED | Futures | 95.4183 | 95.4278 | 95.4183 | 95.423 | 121855.0 |
| 2014-09-15 | ER | Futures | 98.004 | 98.014 | 97.999 | 98.009 | 75486.0 |
| 2014-09-15 | EW | Futures | 1474.4 | 1478.7 | 1467.1 | 1471.7 | 35200.0 |
| 2014-09-15 | FBTP | Futures | 94.43 | 94.56 | 94.24 | 94.42 | 36805.0 |
| 2014-09-15 | FBTS | Futures | 98.668 | 98.703 | 98.65 | 98.668 | 11577.0 |
| 2014-09-15 | FCE | Futures | 3519.3 | 3530.4 | 3512.9 | 3520.1 | 34386.0 |
| 2014-09-15 | FDAX | Futures | 10572.6 | 10667.3 | 10557.7 | 10640.3 | 103222.0 |
| 2014-09-15 | FESX | Futures | 2324.5 | 2335.4 | 2320.2 | 2330.3 | 960967.0 |
| 2014-09-15 | FEU3 | Futures | 98.636 | 98.636 | 98.631 | 98.636 | 262.0 |
| 2014-09-15 | FGBL | Futures | 130.31 | 130.72 | 130.22 | 130.53 | 565029.0 |
| 2014-09-15 | FGBM | Futures | 122.51 | 122.66 | 122.47 | 122.61 | 306565.0 |
| 2014-09-15 | FGBS | Futures | 110.918 | 110.953 | 110.913 | 110.943 | 157252.0 |
| 2014-09-15 | FGBX | Futures | 138.5 | 139.54 | 138.5 | 139.0 | 19834.0 |
| 2014-09-15 | FMWO | Futures | 5751.2 | 5751.2 | 5741.2 | 5741.2 | 227.0 |
| 2014-09-15 | FOAT | Futures | 120.21 | 120.41 | 120.02 | 120.24 | 51843.0 |
| 2014-09-15 | FTDX | Futures | 1186.1 | 1186.1 | 1181.9 | 1181.9 | 168.0 |
| 2014-09-15 | FTI | Futures | 359.83 | 361.52 | 359.1 | 360.87 | 9926.0 |
| 2014-09-15 | FTUK | Futures | 5229.9 | 5252.3 | 5218.7 | 5236.8 | 83889.0 |
| 2014-09-15 | FVSA | Futures | 1416.78 | 1428.96 | 1408.66 | 1428.96 | 12653.0 |
| 2014-09-15 | FXXP | Futures | 259.5 | 260.8 | 259.5 | 260.2 | 34477.0 |
| 2014-09-15 | G | Futures | 96.05 | 96.16 | 95.88 | 95.96 | 134743.0 |
| 2014-09-15 | GF | Futures | 352.377 | 352.727 | 349.383 | 351.366 | 2518.0 |
| 2014-09-15 | GSCI | Futures | 980.16 | 988.07 | 980.16 | 987.31 | 707.0 |
| 2014-09-15 | HE | Futures | 128.149 | 129.025 | 126.819 | 128.24 | 13343.0 |
| 2014-09-15 | HG | Futures | 3.913 | 3.9251 | 3.8877 | 3.9137 | 40033.0 |
| 2014-09-15 | HH | Futures | 48.159 | 48.159 | 48.159 | 48.159 | 4215.0 |
> showing 50 of 105 rows — these rows as CSV