PREVIEW / futures_daily / 2014-10-08
file: by_date/futures_daily/2014/2014-10-08.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-10-08 | ES | Futures | 2012.13 | 2051.57 | 2003.52 | 2049.22 | 2521875.0 |
| 2014-10-08 | NQ | Futures | 4582.01 | 4684.29 | 4555.64 | 4671.25 | 466944.0 |
| 2014-10-08 | YM | Futures | 16864.4 | 17173.9 | 16822.8 | 17148.5 | 249765.0 |
| 2014-10-08 | CL | Futures | 166.58 | 166.95 | 163.56 | 164.47 | 373752.0 |
| 2014-10-08 | GC | Futures | 1586.8 | 1606.1 | 1580.7 | 1581.9 | 192007.0 |
| 2014-10-08 | ZN | Futures | 118.14401 | 118.671177 | 117.89507 | 118.436881 | 2289193.0 |
| 2014-10-08 | A6 | Futures | 0.85168 | 0.85596 | 0.84459 | 0.85421 | 161104.0 |
| 2014-10-08 | AD | Futures | 0.90839 | 0.91418 | 0.90463 | 0.91306 | 79768.0 |
| 2014-10-08 | ALI | Futures | 2926.78 | 2926.78 | 2926.78 | 2926.78 | 6.0 |
| 2014-10-08 | B | Futures | 95.84 | 95.84 | 94.46 | 95.28 | 269128.0 |
| 2014-10-08 | B6 | Futures | 1.6912 | 1.7 | 1.6842 | 1.6977 | 120625.0 |
| 2014-10-08 | BFX | Futures | 3748.3 | 3754.5 | 3738.1 | 3749.7 | 70.0 |
| 2014-10-08 | BR | Futures | 0.22263 | 0.22395 | 0.21898 | 0.22309 | 1752.0 |
| 2014-10-08 | BZ | Futures | 96.07 | 96.39 | 95.15 | 95.98 | 23580.0 |
| 2014-10-08 | C | Futures | 2120.0 | 2125.0 | 2106.0 | 2106.0 | 6433.0 |
| 2014-10-08 | CB | Futures | 141.051 | 141.051 | 140.28 | 140.473 | 7.0 |
| 2014-10-08 | CC | Futures | 2252.0 | 2269.0 | 2237.0 | 2243.0 | 9110.0 |
| 2014-10-08 | CNH | Futures | 7.0718 | 7.0718 | 7.0687 | 7.0695 | 7.0 |
| 2014-10-08 | CSC | Futures | 5.09 | 5.127 | 5.051 | 5.074 | 16.0 |
| 2014-10-08 | CT | Futures | 82.73 | 82.73 | 81.48 | 82.23 | 11256.0 |
| 2014-10-08 | DC | Futures | 40.97 | 41.11 | 40.59 | 40.93 | 90.0 |
| 2014-10-08 | DX | Futures | 81.405 | 81.666 | 80.963 | 81.074 | 51008.0 |
| 2014-10-08 | E1 | Futures | 1.33722 | 1.34514 | 1.33261 | 1.34335 | 47795.0 |
| 2014-10-08 | E6 | Futures | 1.49163 | 1.5014 | 1.48645 | 1.4994 | 331403.0 |
| 2014-10-08 | E7 | Futures | 1.4821 | 1.4918 | 1.4771 | 1.49 | 4048.0 |
| 2014-10-08 | ED | Futures | 95.4374 | 95.447 | 95.4374 | 95.4422 | 216427.0 |
| 2014-10-08 | ER | Futures | 98.009 | 98.009 | 98.004 | 98.004 | 16992.0 |
| 2014-10-08 | EW | Futures | 1392.0 | 1412.5 | 1379.8 | 1411.0 | 28687.0 |
| 2014-10-08 | FBTP | Futures | 95.23 | 95.51 | 94.91 | 95.34 | 86473.0 |
| 2014-10-08 | FBTS | Futures | 98.632 | 98.632 | 98.526 | 98.57 | 14514.0 |
| 2014-10-08 | FCE | Futures | 3327.3 | 3366.3 | 3306.5 | 3320.9 | 139533.0 |
| 2014-10-08 | FDAX | Futures | 9879.3 | 9998.2 | 9815.2 | 9874.4 | 164115.0 |
| 2014-10-08 | FESX | Futures | 2204.3 | 2236.9 | 2195.6 | 2207.2 | 1593850.0 |
| 2014-10-08 | FGBL | Futures | 132.3 | 132.52 | 132.1 | 132.32 | 766141.0 |
| 2014-10-08 | FGBM | Futures | 122.95 | 123.03 | 122.89 | 122.96 | 434700.0 |
| 2014-10-08 | FGBS | Futures | 110.933 | 110.943 | 110.923 | 110.933 | 139323.0 |
| 2014-10-08 | FGBX | Futures | 143.35 | 143.9 | 142.75 | 143.33 | 22064.0 |
| 2014-10-08 | FMWO | Futures | 5510.7 | 5510.7 | 5485.6 | 5498.1 | 730.0 |
| 2014-10-08 | FOAT | Futures | 121.78 | 121.99 | 121.78 | 121.87 | 73226.0 |
| 2014-10-08 | FTDX | Futures | 1124.2 | 1132.2 | 1114.3 | 1117.6 | 200.0 |
| 2014-10-08 | FTI | Futures | 348.47 | 352.71 | 347.57 | 348.73 | 44341.0 |
| 2014-10-08 | FTUK | Futures | 4967.8 | 5045.1 | 4967.0 | 5001.4 | 131973.0 |
| 2014-10-08 | FVSA | Futures | 1619.76 | 1652.24 | 1607.58 | 1627.88 | 12798.0 |
| 2014-10-08 | FXXP | Futures | 248.9 | 251.0 | 247.5 | 248.5 | 14358.0 |
| 2014-10-08 | G | Futures | 98.26 | 98.67 | 98.24 | 98.48 | 282432.0 |
| 2014-10-08 | GF | Futures | 376.336 | 378.008 | 374.547 | 376.997 | 1085.0 |
| 2014-10-08 | GSCI | Futures | 947.84 | 947.84 | 941.95 | 946.07 | 1641.0 |
| 2014-10-08 | HE | Futures | 126.818 | 129.207 | 126.38 | 128.096 | 12735.0 |
| 2014-10-08 | HG | Futures | 3.8464 | 3.8674 | 3.8002 | 3.8097 | 67264.0 |
| 2014-10-08 | HH | Futures | 47.113 | 47.342 | 46.436 | 46.605 | 1105.0 |
> showing 50 of 105 rows — these rows as CSV