PREVIEW / futures_daily / 2016-10-25
file: by_date/futures_daily/2016/2016-10-25.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-10-25 | ES | Futures | 2319.75 | 2325.16 | 2309.48 | 2312.45 | 1198210.0 |
| 2016-10-25 | NQ | Futures | 5782.25 | 5797.87 | 5743.66 | 5758.39 | 184984.0 |
| 2016-10-25 | YM | Futures | 19045.8 | 19082.5 | 18971.2 | 19002.7 | 125524.0 |
| 2016-10-25 | CL | Futures | 55.1 | 55.58 | 53.76 | 54.52 | 553778.0 |
| 2016-10-25 | GC | Futures | 1623.3 | 1639.0 | 1619.7 | 1634.0 | 140027.0 |
| 2016-10-25 | ZN | Futures | 126.602877 | 126.77008 | 126.405274 | 126.633278 | 1041362.0 |
| 2016-10-25 | A6 | Futures | 0.77469 | 0.7801 | 0.77326 | 0.77897 | 78941.0 |
| 2016-10-25 | AD | Futures | 0.76787 | 0.77002 | 0.76633 | 0.76767 | 64997.0 |
| 2016-10-25 | ALI | Futures | 2230.77 | 2230.77 | 2222.13 | 2222.13 | 5.0 |
| 2016-10-25 | B | Futures | 39.83 | 40.11 | 38.92 | 39.34 | 215666.0 |
| 2016-10-25 | B6 | Futures | 1.2882 | 1.2902 | 1.2731 | 1.2845 | 167370.0 |
| 2016-10-25 | BR | Futures | 0.21726 | 0.21856 | 0.2165 | 0.21852 | 421.0 |
| 2016-10-25 | BZ | Futures | 39.6 | 39.91 | 38.74 | 39.15 | 15713.0 |
| 2016-10-25 | C | Futures | 2383.0 | 2418.0 | 2380.0 | 2414.0 | 8743.0 |
| 2016-10-25 | CB | Futures | 228.893 | 234.969 | 228.18 | 234.969 | 35.0 |
| 2016-10-25 | CC | Futures | 2008.0 | 2036.0 | 1991.0 | 2023.0 | 22081.0 |
| 2016-10-25 | CNH | Futures | 7.3123 | 7.3185 | 7.2985 | 7.2985 | 72.0 |
| 2016-10-25 | CSC | Futures | 3.682 | 3.693 | 3.682 | 3.688 | 13.0 |
| 2016-10-25 | CT | Futures | 77.46 | 77.46 | 76.27 | 76.73 | 14016.0 |
| 2016-10-25 | DC | Futures | 28.92 | 29.13 | 28.84 | 29.07 | 91.0 |
| 2016-10-25 | DX | Futures | 91.909 | 92.225 | 91.755 | 91.845 | 23462.0 |
| 2016-10-25 | E1 | Futures | 1.25652 | 1.25789 | 1.24942 | 1.2564 | 25957.0 |
| 2016-10-25 | E6 | Futures | 1.26333 | 1.26692 | 1.26066 | 1.26513 | 153415.0 |
| 2016-10-25 | E7 | Futures | 1.2564 | 1.26 | 1.2538 | 1.2583 | 2326.0 |
| 2016-10-25 | EBM | Futures | 190.06 | 192.11 | 189.47 | 191.53 | 15387.0 |
| 2016-10-25 | ED | Futures | 95.62 | 95.6249 | 95.6152 | 95.62 | 156294.0 |
| 2016-10-25 | ER | Futures | 98.279 | 98.283 | 98.274 | 98.279 | 42428.0 |
| 2016-10-25 | EW | Futures | 1629.0 | 1633.2 | 1614.8 | 1616.8 | 12207.0 |
| 2016-10-25 | FBON | Futures | 124.51 | 124.74 | 124.39 | 124.62 | 1464.0 |
| 2016-10-25 | FBTP | Futures | 108.42 | 108.72 | 108.39 | 108.55 | 80554.0 |
| 2016-10-25 | FBTS | Futures | 101.221 | 101.239 | 101.203 | 101.221 | 13642.0 |
| 2016-10-25 | FCE | Futures | 4067.8 | 4069.5 | 4029.9 | 4041.9 | 62530.0 |
| 2016-10-25 | FDAX | Futures | 11401.2 | 11440.3 | 11344.7 | 11353.1 | 72202.0 |
| 2016-10-25 | FDXM | Futures | 11373.4 | 11417.7 | 11319.7 | 11328.6 | 19375.0 |
| 2016-10-25 | FESX | Futures | 2479.8 | 2483.0 | 2460.6 | 2463.0 | 728510.0 |
| 2016-10-25 | FEU3 | Futures | 98.956 | 98.956 | 98.956 | 98.956 | 20.0 |
| 2016-10-25 | FGBL | Futures | 149.63 | 149.89 | 149.47 | 149.76 | 658472.0 |
| 2016-10-25 | FGBM | Futures | 128.8 | 128.86 | 128.7 | 128.8 | 357901.0 |
| 2016-10-25 | FGBS | Futures | 111.907 | 111.917 | 111.887 | 111.907 | 168321.0 |
| 2016-10-25 | FGBX | Futures | 181.43 | 182.06 | 180.7 | 181.67 | 48160.0 |
| 2016-10-25 | FMWO | Futures | 5706.2 | 5706.2 | 5679.6 | 5689.2 | 429.0 |
| 2016-10-25 | FOAT | Futures | 137.42 | 137.67 | 137.29 | 137.5 | 95182.0 |
| 2016-10-25 | FTDX | Futures | 1734.7 | 1739.1 | 1721.5 | 1723.0 | 144.0 |
| 2016-10-25 | FTI | Futures | 422.59 | 423.32 | 419.92 | 420.7 | 22383.0 |
| 2016-10-25 | FTUK | Futures | 5885.8 | 5941.9 | 5883.3 | 5895.1 | 107188.0 |
| 2016-10-25 | FVSA | Futures | 1292.39 | 1310.94 | 1276.93 | 1304.75 | 14588.0 |
| 2016-10-25 | FXXP | Futures | 284.2 | 284.6 | 281.8 | 282.1 | 21904.0 |
| 2016-10-25 | G | Futures | 113.23 | 113.29 | 112.78 | 113.21 | 238318.0 |
| 2016-10-25 | GF | Futures | 263.07 | 267.956 | 262.48 | 263.393 | 4508.0 |
| 2016-10-25 | GSCI | Futures | 520.02 | 520.02 | 515.79 | 515.79 | 16.0 |
> showing 50 of 109 rows — these rows as CSV