PREVIEW / futures_daily / 2014-09-30
file: by_date/futures_daily/2014/2014-09-30.parquet size: 9 KB rows: 106
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-30 | ES | Futures | 2056.53 | 2066.45 | 2047.91 | 2053.13 | 1991628.0 |
| 2014-09-30 | NQ | Futures | 4675.02 | 4710.95 | 4664.01 | 4687.77 | 334467.0 |
| 2014-09-30 | YM | Futures | 17226.6 | 17310.8 | 17175.9 | 17211.4 | 161891.0 |
| 2014-09-30 | CL | Futures | 177.71 | 178.76 | 171.15 | 171.72 | 429251.0 |
| 2014-09-30 | GC | Futures | 1594.6 | 1601.1 | 1579.6 | 1589.2 | 182523.0 |
| 2014-09-30 | ZN | Futures | 117.001815 | 117.016458 | 116.679657 | 116.811449 | 1415141.0 |
| 2014-09-30 | A6 | Futures | 0.84235 | 0.84741 | 0.84012 | 0.84517 | 140091.0 |
| 2014-09-30 | AD | Futures | 0.90839 | 0.91062 | 0.90382 | 0.90493 | 76695.0 |
| 2014-09-30 | ALI | Futures | 2953.59 | 2953.59 | 2953.59 | 2953.59 | 10.0 |
| 2014-09-30 | B | Futures | 101.34 | 102.06 | 98.47 | 98.94 | 204075.0 |
| 2014-09-30 | B6 | Futures | 1.7061 | 1.7109 | 1.6981 | 1.7019 | 128361.0 |
| 2014-09-30 | BFX | Futures | 3872.8 | 3902.0 | 3872.8 | 3892.9 | 51.0 |
| 2014-09-30 | BR | Futures | 0.21655 | 0.21733 | 0.21574 | 0.21725 | 1447.0 |
| 2014-09-30 | BZ | Futures | 102.24 | 102.81 | 99.22 | 99.67 | 24351.0 |
| 2014-09-30 | C | Futures | 2261.0 | 2278.0 | 2241.0 | 2247.0 | 11464.0 |
| 2014-09-30 | CB | Futures | 151.071 | 151.071 | 146.832 | 146.832 | 16.0 |
| 2014-09-30 | CC | Futures | 2447.0 | 2456.0 | 2428.0 | 2436.0 | 9500.0 |
| 2014-09-30 | CNH | Futures | 7.1072 | 7.118 | 7.1026 | 7.118 | 6.0 |
| 2014-09-30 | CSC | Futures | 5.169 | 5.182 | 5.093 | 5.103 | 67.0 |
| 2014-09-30 | CT | Futures | 78.4 | 78.65 | 77.31 | 77.76 | 12222.0 |
| 2014-09-30 | DC | Futures | 41.32 | 41.47 | 40.89 | 40.91 | 354.0 |
| 2014-09-30 | DX | Futures | 81.391 | 81.955 | 81.277 | 81.682 | 35415.0 |
| 2014-09-30 | E1 | Futures | 1.34489 | 1.34681 | 1.33313 | 1.3399 | 54207.0 |
| 2014-09-30 | E6 | Futures | 1.49434 | 1.49611 | 1.48057 | 1.48728 | 327820.0 |
| 2014-09-30 | E7 | Futures | 1.4851 | 1.4865 | 1.4714 | 1.4779 | 4482.0 |
| 2014-09-30 | ED | Futures | 95.4326 | 95.4422 | 95.4278 | 95.4326 | 115426.0 |
| 2014-09-30 | ER | Futures | 98.009 | 98.014 | 98.004 | 98.009 | 30765.0 |
| 2014-09-30 | EW | Futures | 1435.5 | 1441.6 | 1418.5 | 1423.0 | 24964.0 |
| 2014-09-30 | FBTP | Futures | 94.98 | 95.51 | 94.96 | 95.32 | 82917.0 |
| 2014-09-30 | FBTS | Futures | 98.659 | 98.721 | 98.641 | 98.694 | 14573.0 |
| 2014-09-30 | FCE | Futures | 3477.4 | 3532.4 | 3475.5 | 3516.9 | 124329.0 |
| 2014-09-30 | FDAX | Futures | 10335.6 | 10406.2 | 10303.2 | 10396.4 | 128286.0 |
| 2014-09-30 | FESX | Futures | 2305.7 | 2338.3 | 2303.5 | 2334.6 | 1193495.0 |
| 2014-09-30 | FEU3 | Futures | 98.636 | 98.636 | 98.631 | 98.631 | 25.0 |
| 2014-09-30 | FGBL | Futures | 131.68 | 131.97 | 131.53 | 131.88 | 892519.0 |
| 2014-09-30 | FGBM | Futures | 122.85 | 123.02 | 122.84 | 122.96 | 436012.0 |
| 2014-09-30 | FGBS | Futures | 110.928 | 110.973 | 110.928 | 110.963 | 182606.0 |
| 2014-09-30 | FGBX | Futures | 142.05 | 142.23 | 141.37 | 142.03 | 33853.0 |
| 2014-09-30 | FMWO | Futures | 5659.8 | 5663.6 | 5626.0 | 5663.6 | 844.0 |
| 2014-09-30 | FOAT | Futures | 121.39 | 121.75 | 121.36 | 121.66 | 75096.0 |
| 2014-09-30 | FTDX | Futures | 1178.1 | 1182.8 | 1176.2 | 1181.9 | 120.0 |
| 2014-09-30 | FTI | Futures | 361.52 | 364.63 | 361.47 | 364.02 | 37538.0 |
| 2014-09-30 | FTUK | Futures | 5116.6 | 5128.6 | 5074.5 | 5107.3 | 125364.0 |
| 2014-09-30 | FVSA | Futures | 1477.68 | 1506.09 | 1457.38 | 1469.56 | 14769.0 |
| 2014-09-30 | FXXP | Futures | 258.9 | 260.2 | 258.3 | 260.0 | 11669.0 |
| 2014-09-30 | G | Futures | 96.83 | 97.02 | 96.62 | 96.95 | 204607.0 |
| 2014-09-30 | GF | Futures | 365.601 | 367.429 | 365.135 | 366.263 | 2669.0 |
| 2014-09-30 | GSCI | Futures | 987.23 | 988.66 | 964.59 | 965.85 | 301.0 |
| 2014-09-30 | HE | Futures | 127.592 | 129.139 | 125.842 | 127.221 | 14330.0 |
| 2014-09-30 | HG | Futures | 3.8598 | 3.8813 | 3.8128 | 3.8147 | 53924.0 |
> showing 50 of 106 rows — these rows as CSV