PREVIEW / futures_daily / 2016-03-24
file: by_date/futures_daily/2016/2016-03-24.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-03-24 | ES | Futures | 2177.5 | 2179.92 | 2160.59 | 2178.04 | 1524072.0 |
| 2016-03-24 | NQ | Futures | 5164.16 | 5171.21 | 5128.91 | 5166.8 | 196013.0 |
| 2016-03-24 | YM | Futures | 18115.6 | 18157.2 | 17986.7 | 18132.2 | 134496.0 |
| 2016-03-24 | CL | Futures | 48.23 | 48.28 | 46.53 | 47.9 | 495168.0 |
| 2016-03-24 | GC | Futures | 1568.5 | 1573.0 | 1556.3 | 1569.7 | 169701.0 |
| 2016-03-24 | ZN | Futures | 124.815897 | 125.012029 | 124.529241 | 124.770635 | 749240.0 |
| 2016-03-24 | A6 | Futures | 0.75988 | 0.76018 | 0.75401 | 0.75846 | 65192.0 |
| 2016-03-24 | AD | Futures | 0.77441 | 0.77451 | 0.76899 | 0.77145 | 51711.0 |
| 2016-03-24 | ALI | Futures | 2056.24 | 2056.24 | 2056.24 | 2056.24 | 0.0 |
| 2016-03-24 | B | Futures | 33.65 | 33.85 | 32.66 | 33.68 | 203276.0 |
| 2016-03-24 | B6 | Futures | 1.4868 | 1.4939 | 1.4804 | 1.4904 | 75145.0 |
| 2016-03-24 | BR | Futures | 0.17339 | 0.17365 | 0.17228 | 0.17329 | 1009.0 |
| 2016-03-24 | BZ | Futures | 33.25 | 33.5 | 32.33 | 33.34 | 24268.0 |
| 2016-03-24 | C | Futures | 2332.0 | 2339.0 | 2294.0 | 2323.0 | 5735.0 |
| 2016-03-24 | CB | Futures | 245.415 | 245.415 | 245.415 | 245.415 | 2.0 |
| 2016-03-24 | CC | Futures | 2165.0 | 2176.0 | 2143.0 | 2169.0 | 12213.0 |
| 2016-03-24 | CNH | Futures | 7.1169 | 7.1171 | 7.1124 | 7.1124 | 20.0 |
| 2016-03-24 | CSC | Futures | 3.589 | 3.615 | 3.582 | 3.611 | 41.0 |
| 2016-03-24 | CT | Futures | 66.91 | 66.97 | 65.84 | 66.29 | 13937.0 |
| 2016-03-24 | DC | Futures | 28.22 | 28.51 | 28.18 | 28.46 | 54.0 |
| 2016-03-24 | DX | Futures | 89.591 | 89.861 | 89.558 | 89.663 | 13120.0 |
| 2016-03-24 | E1 | Futures | 1.29265 | 1.29454 | 1.28976 | 1.29228 | 9509.0 |
| 2016-03-24 | E6 | Futures | 1.30712 | 1.30776 | 1.30263 | 1.30584 | 117045.0 |
| 2016-03-24 | E7 | Futures | 1.2999 | 1.3007 | 1.2956 | 1.2987 | 1575.0 |
| 2016-03-24 | EBM | Futures | 199.45 | 202.03 | 199.13 | 201.38 | 18900.0 |
| 2016-03-24 | ED | Futures | 95.6581 | 95.6581 | 95.6437 | 95.6485 | 136729.0 |
| 2016-03-24 | ER | Futures | 98.254 | 98.259 | 98.249 | 98.254 | 28010.0 |
| 2016-03-24 | EW | Futures | 1487.9 | 1491.5 | 1473.6 | 1489.7 | 13047.0 |
| 2016-03-24 | FBON | Futures | 118.32 | 118.38 | 118.27 | 118.34 | 27.0 |
| 2016-03-24 | FBTP | Futures | 107.51 | 107.56 | 107.17 | 107.33 | 64879.0 |
| 2016-03-24 | FBTS | Futures | 101.006 | 101.024 | 100.97 | 100.97 | 15395.0 |
| 2016-03-24 | FCE | Futures | 3663.8 | 3664.7 | 3600.9 | 3606.7 | 88668.0 |
| 2016-03-24 | FDAX | Futures | 10741.0 | 10767.3 | 10609.4 | 10640.5 | 91572.0 |
| 2016-03-24 | FDXM | Futures | 10343.7 | 10365.4 | 10215.5 | 10245.4 | 17795.0 |
| 2016-03-24 | FESX | Futures | 2300.2 | 2303.3 | 2266.7 | 2274.5 | 1103730.0 |
| 2016-03-24 | FEU3 | Futures | 98.907 | 98.912 | 98.907 | 98.912 | 100.0 |
| 2016-03-24 | FGBL | Futures | 145.75 | 146.09 | 145.63 | 145.8 | 434316.0 |
| 2016-03-24 | FGBM | Futures | 127.33 | 127.42 | 127.23 | 127.29 | 296358.0 |
| 2016-03-24 | FGBS | Futures | 111.623 | 111.638 | 111.598 | 111.613 | 176698.0 |
| 2016-03-24 | FGBX | Futures | 172.07 | 173.35 | 171.91 | 172.65 | 23690.0 |
| 2016-03-24 | FMWO | Futures | 5486.0 | 5486.0 | 5454.9 | 5473.6 | 128.0 |
| 2016-03-24 | FOAT | Futures | 133.28 | 133.59 | 133.19 | 133.35 | 49822.0 |
| 2016-03-24 | FTDX | Futures | 1529.0 | 1534.2 | 1520.9 | 1523.8 | 172.0 |
| 2016-03-24 | FTI | Futures | 390.29 | 391.18 | 386.35 | 387.81 | 28640.0 |
| 2016-03-24 | FTUK | Futures | 5041.6 | 5043.6 | 4975.9 | 4999.1 | 108935.0 |
| 2016-03-24 | FVSA | Futures | 2738.6 | 2893.2 | 2738.6 | 2860.07 | 14466.0 |
| 2016-03-24 | FXXP | Futures | 265.9 | 266.5 | 263.2 | 264.3 | 18995.0 |
| 2016-03-24 | G | Futures | 108.4 | 108.65 | 108.04 | 108.22 | 129414.0 |
| 2016-03-24 | GF | Futures | 304.888 | 307.686 | 303.465 | 305.919 | 3529.0 |
| 2016-03-24 | GSCI | Futures | 486.84 | 493.16 | 486.17 | 492.78 | 271.0 |
> showing 50 of 109 rows — these rows as CSV