PREVIEW / futures_daily / 2016-01-29
file: by_date/futures_daily/2016/2016-01-29.parquet size: 9 KB rows: 110
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-29 | ES | Futures | 2006.76 | 2064.71 | 2004.36 | 2061.5 | 2406399.0 |
| 2016-01-29 | NQ | Futures | 4847.49 | 5007.22 | 4840.46 | 4997.55 | 328862.0 |
| 2016-01-29 | YM | Futures | 16512.3 | 16945.9 | 16491.6 | 16925.2 | 217260.0 |
| 2016-01-29 | CL | Futures | 48.55 | 49.55 | 47.03 | 48.43 | 618110.0 |
| 2016-01-29 | GC | Futures | 1432.4 | 1437.7 | 1424.3 | 1434.5 | 133251.0 |
| 2016-01-29 | ZN | Futures | 124.243406 | 124.845069 | 124.153156 | 124.739777 | 1692523.0 |
| 2016-01-29 | A6 | Futures | 0.70851 | 0.71412 | 0.7058 | 0.7067 | 122407.0 |
| 2016-01-29 | AD | Futures | 0.72871 | 0.73198 | 0.72472 | 0.72973 | 95232.0 |
| 2016-01-29 | ALI | Futures | 2112.58 | 2112.58 | 2112.58 | 2112.58 | 0.0 |
| 2016-01-29 | B | Futures | 29.58 | 30.39 | 29.06 | 30.24 | 415849.0 |
| 2016-01-29 | B6 | Futures | 1.5109 | 1.5166 | 1.4888 | 1.4985 | 140213.0 |
| 2016-01-29 | BFX | Futures | 4144.4 | 4192.5 | 4144.4 | 4192.5 | 5.0 |
| 2016-01-29 | BR | Futures | 0.15215 | 0.15614 | 0.15215 | 0.15589 | 2974.0 |
| 2016-01-29 | BZ | Futures | 29.18 | 30.17 | 28.85 | 30.02 | 44460.0 |
| 2016-01-29 | C | Futures | 2111.0 | 2157.0 | 2111.0 | 2114.0 | 4922.0 |
| 2016-01-29 | CB | Futures | 277.697 | 281.408 | 277.697 | 277.697 | 36.0 |
| 2016-01-29 | CC | Futures | 2069.0 | 2087.0 | 2030.0 | 2036.0 | 17904.0 |
| 2016-01-29 | CNH | Futures | 7.2978 | 7.2978 | 7.2818 | 7.2819 | 11.0 |
| 2016-01-29 | CSC | Futures | 3.743 | 3.743 | 3.723 | 3.74 | 47.0 |
| 2016-01-29 | CT | Futures | 71.85 | 72.5 | 71.17 | 71.61 | 21729.0 |
| 2016-01-29 | DC | Futures | 29.78 | 29.83 | 29.57 | 29.74 | 146.0 |
| 2016-01-29 | DX | Futures | 92.182 | 93.303 | 92.107 | 93.09 | 53797.0 |
| 2016-01-29 | E1 | Futures | 1.24708 | 1.24784 | 1.23294 | 1.23395 | 37853.0 |
| 2016-01-29 | E6 | Futures | 1.28034 | 1.28157 | 1.26532 | 1.26736 | 277993.0 |
| 2016-01-29 | E7 | Futures | 1.2732 | 1.2744 | 1.2582 | 1.2603 | 6103.0 |
| 2016-01-29 | EBM | Futures | 232.71 | 233.42 | 230.95 | 231.3 | 16710.0 |
| 2016-01-29 | ED | Futures | 95.641 | 95.6698 | 95.641 | 95.6554 | 405667.0 |
| 2016-01-29 | ER | Futures | 98.274 | 98.308 | 98.274 | 98.298 | 144893.0 |
| 2016-01-29 | EW | Futures | 1339.5 | 1390.4 | 1338.0 | 1388.1 | 32510.0 |
| 2016-01-29 | FBON | Futures | 117.12 | 117.88 | 117.11 | 117.74 | 830.0 |
| 2016-01-29 | FBTP | Futures | 105.93 | 106.63 | 105.82 | 106.42 | 111853.0 |
| 2016-01-29 | FBTS | Futures | 100.926 | 101.015 | 100.926 | 100.998 | 31511.0 |
| 2016-01-29 | FCE | Futures | 3678.5 | 3720.5 | 3637.4 | 3704.6 | 115593.0 |
| 2016-01-29 | FDAX | Futures | 10622.5 | 10665.9 | 10459.8 | 10579.1 | 101371.0 |
| 2016-01-29 | FDXM | Futures | 10145.3 | 10197.1 | 10000.1 | 10115.2 | 18825.0 |
| 2016-01-29 | FESX | Futures | 2297.8 | 2324.4 | 2271.9 | 2302.3 | 1454878.0 |
| 2016-01-29 | FEU3 | Futures | 98.952 | 98.956 | 98.947 | 98.956 | 18.0 |
| 2016-01-29 | FGBL | Futures | 143.46 | 144.13 | 143.4 | 143.98 | 948957.0 |
| 2016-01-29 | FGBM | Futures | 126.92 | 127.16 | 126.92 | 127.11 | 555945.0 |
| 2016-01-29 | FGBS | Futures | 111.673 | 111.743 | 111.673 | 111.733 | 362753.0 |
| 2016-01-29 | FGBX | Futures | 166.27 | 167.87 | 165.75 | 167.05 | 47758.0 |
| 2016-01-29 | FMWO | Futures | 5198.2 | 5229.4 | 5198.2 | 5228.1 | 405.0 |
| 2016-01-29 | FOAT | Futures | 130.64 | 131.4 | 130.58 | 131.24 | 139717.0 |
| 2016-01-29 | FTDX | Futures | 1599.5 | 1613.9 | 1583.2 | 1612.9 | 729.0 |
| 2016-01-29 | FTI | Futures | 375.31 | 382.7 | 371.77 | 380.13 | 36174.0 |
| 2016-01-29 | FTUK | Futures | 4797.3 | 4956.0 | 4781.4 | 4899.7 | 175294.0 |
| 2016-01-29 | FVSA | Futures | 2813.08 | 2872.94 | 2743.26 | 2783.16 | 9698.0 |
| 2016-01-29 | FXXP | Futures | 266.2 | 269.8 | 263.9 | 267.5 | 27567.0 |
| 2016-01-29 | G | Futures | 106.65 | 107.24 | 106.59 | 107.1 | 254545.0 |
| 2016-01-29 | GF | Futures | 313.968 | 314.704 | 304.838 | 308.765 | 6305.0 |
> showing 50 of 110 rows — these rows as CSV