PREVIEW / futures_daily / 2016-05-03
file: by_date/futures_daily/2016/2016-05-03.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-05-03 | ES | Futures | 2228.5 | 2229.31 | 2198.97 | 2208.64 | 1827577.0 |
| 2016-05-03 | NQ | Futures | 5137.13 | 5140.07 | 5075.44 | 5093.07 | 270601.0 |
| 2016-05-03 | YM | Futures | 18513.8 | 18522.1 | 18284.0 | 18375.5 | 165942.0 |
| 2016-05-03 | CL | Futures | 53.51 | 54.02 | 51.61 | 52.0 | 625551.0 |
| 2016-05-03 | GC | Futures | 1667.1 | 1680.6 | 1655.0 | 1665.0 | 214985.0 |
| 2016-05-03 | ZN | Futures | 125.177988 | 125.977606 | 125.177988 | 125.811648 | 1321886.0 |
| 2016-05-03 | A6 | Futures | 0.77435 | 0.78012 | 0.75573 | 0.75644 | 171784.0 |
| 2016-05-03 | AD | Futures | 0.81572 | 0.82052 | 0.80304 | 0.80355 | 96602.0 |
| 2016-05-03 | ALI | Futures | 2202.31 | 2202.31 | 2202.31 | 2202.31 | 0.0 |
| 2016-05-03 | B | Futures | 38.02 | 38.51 | 37.04 | 37.33 | 276403.0 |
| 2016-05-03 | B6 | Futures | 1.5448 | 1.5554 | 1.5301 | 1.5313 | 125142.0 |
| 2016-05-03 | BFX | Futures | 3930.2 | 3950.8 | 3930.2 | 3939.2 | 13.0 |
| 2016-05-03 | BR | Futures | 0.18386 | 0.18386 | 0.18041 | 0.18083 | 1184.0 |
| 2016-05-03 | BZ | Futures | 37.98 | 38.38 | 36.92 | 37.2 | 23630.0 |
| 2016-05-03 | C | Futures | 2437.0 | 2437.0 | 2414.0 | 2426.0 | 9093.0 |
| 2016-05-03 | CB | Futures | 253.951 | 253.951 | 248.769 | 249.378 | 64.0 |
| 2016-05-03 | CC | Futures | 2368.0 | 2370.0 | 2333.0 | 2344.0 | 18047.0 |
| 2016-05-03 | CNH | Futures | 7.044 | 7.0709 | 7.044 | 7.0709 | 2.0 |
| 2016-05-03 | CSC | Futures | 3.441 | 3.448 | 3.415 | 3.427 | 244.0 |
| 2016-05-03 | CT | Futures | 73.3 | 73.54 | 70.71 | 71.73 | 27262.0 |
| 2016-05-03 | DC | Futures | 26.75 | 26.81 | 26.48 | 26.69 | 548.0 |
| 2016-05-03 | DX | Futures | 86.351 | 86.733 | 85.661 | 86.641 | 31396.0 |
| 2016-05-03 | E1 | Futures | 1.31791 | 1.33274 | 1.31741 | 1.31929 | 31176.0 |
| 2016-05-03 | E6 | Futures | 1.34613 | 1.3564 | 1.34223 | 1.34357 | 230491.0 |
| 2016-05-03 | E7 | Futures | 1.3389 | 1.3491 | 1.3348 | 1.3363 | 3554.0 |
| 2016-05-03 | EBM | Futures | 195.27 | 196.88 | 193.02 | 193.34 | 20749.0 |
| 2016-05-03 | ED | Futures | 95.7304 | 95.7401 | 95.7304 | 95.7401 | 190414.0 |
| 2016-05-03 | ER | Futures | 98.259 | 98.264 | 98.259 | 98.259 | 20392.0 |
| 2016-05-03 | EW | Futures | 1556.4 | 1556.4 | 1524.7 | 1534.8 | 17088.0 |
| 2016-05-03 | FBON | Futures | 117.6 | 118.14 | 117.6 | 118.03 | 421.0 |
| 2016-05-03 | FBTP | Futures | 106.14 | 106.3 | 106.04 | 106.17 | 89609.0 |
| 2016-05-03 | FBTS | Futures | 101.069 | 101.096 | 101.06 | 101.069 | 18461.0 |
| 2016-05-03 | FCE | Futures | 3739.2 | 3740.9 | 3666.9 | 3674.2 | 102724.0 |
| 2016-05-03 | FDAX | Futures | 10887.0 | 10896.7 | 10666.8 | 10695.3 | 118079.0 |
| 2016-05-03 | FDIV | Futures | 128.26 | 128.26 | 127.8 | 127.99 | 12.0 |
| 2016-05-03 | FDXM | Futures | 10485.4 | 10491.6 | 10269.2 | 10298.2 | 25176.0 |
| 2016-05-03 | FESX | Futures | 2328.3 | 2331.4 | 2279.1 | 2285.4 | 1570011.0 |
| 2016-05-03 | FEU3 | Futures | 98.917 | 98.917 | 98.912 | 98.917 | 59.0 |
| 2016-05-03 | FGBL | Futures | 144.92 | 145.9 | 144.81 | 145.82 | 830401.0 |
| 2016-05-03 | FGBM | Futures | 127.24 | 127.53 | 127.2 | 127.5 | 566046.0 |
| 2016-05-03 | FGBS | Futures | 111.598 | 111.648 | 111.588 | 111.638 | 249692.0 |
| 2016-05-03 | FGBX | Futures | 169.47 | 172.09 | 169.06 | 171.8 | 44412.0 |
| 2016-05-03 | FMWO | Futures | 5653.9 | 5657.6 | 5611.6 | 5611.6 | 1065.0 |
| 2016-05-03 | FOAT | Futures | 132.52 | 133.3 | 132.34 | 133.21 | 96591.0 |
| 2016-05-03 | FTDX | Futures | 1557.6 | 1557.6 | 1532.3 | 1540.0 | 104.0 |
| 2016-05-03 | FTI | Futures | 396.08 | 396.53 | 387.0 | 389.12 | 37387.0 |
| 2016-05-03 | FTUK | Futures | 5155.4 | 5161.6 | 5046.1 | 5073.7 | 150604.0 |
| 2016-05-03 | FVSA | Futures | 2591.96 | 2759.86 | 2591.96 | 2749.37 | 25485.0 |
| 2016-05-03 | FXXP | Futures | 271.3 | 271.6 | 266.1 | 266.7 | 28798.0 |
| 2016-05-03 | G | Futures | 107.17 | 107.92 | 107.14 | 107.81 | 182931.0 |
> showing 50 of 111 rows — these rows as CSV