PREVIEW / futures_daily / 2016-01-06
file: by_date/futures_daily/2016/2016-01-06.parquet size: 9 KB rows: 109
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-01-06 | ES | Futures | 2147.76 | 2150.43 | 2104.76 | 2121.32 | 2237518.0 |
| 2016-01-06 | NQ | Futures | 5254.28 | 5260.73 | 5141.74 | 5212.96 | 346779.0 |
| 2016-01-06 | YM | Futures | 17668.2 | 17691.0 | 17305.0 | 17424.0 | 232499.0 |
| 2016-01-06 | CL | Futures | 53.81 | 54.12 | 50.23 | 50.52 | 563811.0 |
| 2016-01-06 | GC | Futures | 1388.7 | 1412.1 | 1385.6 | 1408.2 | 191801.0 |
| 2016-01-06 | ZN | Futures | 121.596088 | 122.18271 | 121.520881 | 122.122544 | 1164824.0 |
| 2016-01-06 | A6 | Futures | 0.71502 | 0.71622 | 0.7039 | 0.7051 | 110149.0 |
| 2016-01-06 | AD | Futures | 0.73126 | 0.73188 | 0.72431 | 0.72492 | 70968.0 |
| 2016-01-06 | ALI | Futures | 2085.19 | 2085.19 | 2085.19 | 2085.19 | 0.0 |
| 2016-01-06 | B | Futures | 31.94 | 32.01 | 29.75 | 29.84 | 257591.0 |
| 2016-01-06 | B6 | Futures | 1.5444 | 1.5448 | 1.5364 | 1.5391 | 72463.0 |
| 2016-01-06 | BFX | Futures | 4392.4 | 4392.4 | 4390.6 | 4390.6 | 1.0 |
| 2016-01-06 | BR | Futures | 0.15309 | 0.15365 | 0.15255 | 0.15365 | 77.0 |
| 2016-01-06 | BZ | Futures | 31.66 | 31.66 | 29.44 | 29.53 | 28342.0 |
| 2016-01-06 | C | Futures | 2268.0 | 2274.0 | 2222.0 | 2226.0 | 19005.0 |
| 2016-01-06 | CB | Futures | 255.185 | 255.525 | 255.185 | 255.525 | 7.0 |
| 2016-01-06 | CC | Futures | 2236.0 | 2250.0 | 2190.0 | 2198.0 | 28951.0 |
| 2016-01-06 | CNH | Futures | 7.3548 | 7.4468 | 7.3544 | 7.4124 | 74.0 |
| 2016-01-06 | CSC | Futures | 3.714 | 3.714 | 3.679 | 3.679 | 54.0 |
| 2016-01-06 | CT | Futures | 73.34 | 73.42 | 72.46 | 72.63 | 24275.0 |
| 2016-01-06 | DC | Futures | 29.29 | 29.33 | 28.97 | 29.03 | 136.0 |
| 2016-01-06 | DX | Futures | 92.962 | 93.181 | 92.663 | 92.729 | 29733.0 |
| 2016-01-06 | E1 | Futures | 1.25541 | 1.2587 | 1.24948 | 1.25794 | 14258.0 |
| 2016-01-06 | E6 | Futures | 1.25935 | 1.26496 | 1.25491 | 1.26356 | 190337.0 |
| 2016-01-06 | E7 | Futures | 1.2519 | 1.2579 | 1.248 | 1.2565 | 5097.0 |
| 2016-01-06 | EBM | Futures | 241.19 | 242.95 | 239.42 | 242.25 | 23903.0 |
| 2016-01-06 | ED | Futures | 95.5736 | 95.588 | 95.5639 | 95.5832 | 281207.0 |
| 2016-01-06 | ER | Futures | 98.229 | 98.239 | 98.225 | 98.234 | 34374.0 |
| 2016-01-06 | EW | Futures | 1452.9 | 1453.2 | 1423.2 | 1433.3 | 25383.0 |
| 2016-01-06 | FBON | Futures | 116.17 | 116.58 | 116.17 | 116.2 | 209.0 |
| 2016-01-06 | FBTP | Futures | 105.56 | 105.99 | 105.56 | 105.71 | 70256.0 |
| 2016-01-06 | FBTS | Futures | 100.9 | 100.935 | 100.882 | 100.9 | 13336.0 |
| 2016-01-06 | FCE | Futures | 3776.1 | 3790.7 | 3706.7 | 3745.5 | 100899.0 |
| 2016-01-06 | FDAX | Futures | 11104.0 | 11155.5 | 10945.1 | 11081.2 | 111783.0 |
| 2016-01-06 | FDXM | Futures | 10626.3 | 10664.7 | 10464.6 | 10595.2 | 19513.0 |
| 2016-01-06 | FESX | Futures | 2395.1 | 2406.5 | 2354.0 | 2380.7 | 1238863.0 |
| 2016-01-06 | FEU3 | Futures | 98.887 | 98.892 | 98.887 | 98.892 | 20.0 |
| 2016-01-06 | FGBL | Futures | 140.32 | 140.95 | 140.29 | 140.75 | 504837.0 |
| 2016-01-06 | FGBM | Futures | 125.85 | 126.03 | 125.84 | 125.96 | 414725.0 |
| 2016-01-06 | FGBS | Futures | 111.498 | 111.523 | 111.488 | 111.513 | 296179.0 |
| 2016-01-06 | FGBX | Futures | 157.31 | 159.0 | 157.31 | 158.11 | 25948.0 |
| 2016-01-06 | FMWO | Futures | 5401.2 | 5452.3 | 5401.2 | 5448.5 | 636.0 |
| 2016-01-06 | FOAT | Futures | 128.32 | 128.87 | 128.32 | 128.66 | 84454.0 |
| 2016-01-06 | FTDX | Futures | 1722.8 | 1730.5 | 1700.8 | 1716.1 | 74.0 |
| 2016-01-06 | FTI | Futures | 377.41 | 378.98 | 370.64 | 374.53 | 41208.0 |
| 2016-01-06 | FTUK | Futures | 4970.6 | 4975.9 | 4861.3 | 4903.8 | 130474.0 |
| 2016-01-06 | FVSA | Futures | 2390.35 | 2484.46 | 2371.53 | 2399.76 | 18482.0 |
| 2016-01-06 | FXXP | Futures | 279.5 | 281.0 | 274.9 | 277.6 | 32053.0 |
| 2016-01-06 | G | Futures | 104.77 | 105.34 | 104.73 | 105.3 | 177920.0 |
| 2016-01-06 | GF | Futures | 322.308 | 326.168 | 320.425 | 324.913 | 1543.0 |
> showing 50 of 109 rows — these rows as CSV