PREVIEW / futures_daily / 2016-02-23
file: by_date/futures_daily/2016/2016-02-23.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-02-23 | ES | Futures | 2065.78 | 2070.05 | 2044.15 | 2046.55 | 1600879.0 |
| 2016-02-23 | NQ | Futures | 4932.19 | 4943.04 | 4870.35 | 4875.92 | 227805.0 |
| 2016-02-23 | YM | Futures | 17099.0 | 17150.8 | 16941.8 | 16966.6 | 129459.0 |
| 2016-02-23 | CL | Futures | 41.89 | 42.13 | 39.23 | 40.04 | 539379.0 |
| 2016-02-23 | GC | Futures | 1553.3 | 1579.2 | 1551.7 | 1570.9 | 184483.0 |
| 2016-02-23 | ZN | Futures | 125.973187 | 126.274018 | 125.491856 | 126.048394 | 2434982.0 |
| 2016-02-23 | A6 | Futures | 0.72354 | 0.72674 | 0.72083 | 0.72244 | 77182.0 |
| 2016-02-23 | AD | Futures | 0.74578 | 0.7466 | 0.73975 | 0.74323 | 51532.0 |
| 2016-02-23 | ALI | Futures | 2091.8 | 2091.8 | 2091.8 | 2091.8 | 0.0 |
| 2016-02-23 | B | Futures | 29.02 | 29.5 | 27.65 | 27.96 | 348078.0 |
| 2016-02-23 | B6 | Futures | 1.4889 | 1.4895 | 1.4738 | 1.4749 | 94868.0 |
| 2016-02-23 | BFX | Futures | 3944.1 | 3965.2 | 3916.6 | 3916.6 | 5.0 |
| 2016-02-23 | BR | Futures | 0.15875 | 0.15943 | 0.15875 | 0.15943 | 188.0 |
| 2016-02-23 | BZ | Futures | 28.81 | 29.28 | 27.47 | 27.75 | 41038.0 |
| 2016-02-23 | C | Futures | 2220.0 | 2244.0 | 2193.0 | 2237.0 | 6161.0 |
| 2016-02-23 | CB | Futures | 262.183 | 262.183 | 259.744 | 260.353 | 46.0 |
| 2016-02-23 | CC | Futures | 2116.0 | 2131.0 | 2077.0 | 2115.0 | 18174.0 |
| 2016-02-23 | CNH | Futures | 7.1849 | 7.1906 | 7.1849 | 7.1856 | 13.0 |
| 2016-02-23 | CSC | Futures | 3.704 | 3.704 | 3.627 | 3.639 | 73.0 |
| 2016-02-23 | CT | Futures | 67.64 | 67.75 | 66.44 | 66.61 | 18507.0 |
| 2016-02-23 | DC | Futures | 29.29 | 29.29 | 28.63 | 28.63 | 139.0 |
| 2016-02-23 | DX | Futures | 90.939 | 91.154 | 90.752 | 91.065 | 14117.0 |
| 2016-02-23 | E1 | Futures | 1.26362 | 1.27675 | 1.26324 | 1.27284 | 21295.0 |
| 2016-02-23 | E6 | Futures | 1.29005 | 1.29309 | 1.28572 | 1.28794 | 158570.0 |
| 2016-02-23 | E7 | Futures | 1.2826 | 1.2857 | 1.2786 | 1.2807 | 3301.0 |
| 2016-02-23 | EBM | Futures | 216.11 | 216.11 | 211.88 | 212.23 | 12925.0 |
| 2016-02-23 | ED | Futures | 95.6361 | 95.6385 | 95.6241 | 95.6241 | 161242.0 |
| 2016-02-23 | ER | Futures | 98.288 | 98.293 | 98.283 | 98.288 | 57401.0 |
| 2016-02-23 | EW | Futures | 1387.8 | 1393.5 | 1379.1 | 1381.0 | 15700.0 |
| 2016-02-23 | FBON | Futures | 116.34 | 116.75 | 116.32 | 116.53 | 285.0 |
| 2016-02-23 | FBTP | Futures | 105.55 | 105.59 | 105.25 | 105.37 | 71978.0 |
| 2016-02-23 | FBTS | Futures | 100.846 | 100.855 | 100.811 | 100.846 | 18231.0 |
| 2016-02-23 | FCE | Futures | 3554.4 | 3582.7 | 3518.5 | 3528.5 | 81258.0 |
| 2016-02-23 | FDAX | Futures | 10296.1 | 10338.4 | 10186.6 | 10219.1 | 94491.0 |
| 2016-02-23 | FDXM | Futures | 9836.3 | 9885.0 | 9740.9 | 9771.0 | 20414.0 |
| 2016-02-23 | FESX | Futures | 2212.6 | 2230.9 | 2187.5 | 2195.9 | 1108812.0 |
| 2016-02-23 | FEU3 | Futures | 98.947 | 98.947 | 98.947 | 98.947 | 136.0 |
| 2016-02-23 | FGBL | Futures | 145.81 | 145.92 | 145.21 | 145.82 | 745193.0 |
| 2016-02-23 | FGBM | Futures | 127.59 | 127.62 | 127.39 | 127.56 | 428517.0 |
| 2016-02-23 | FGBS | Futures | 111.793 | 111.802 | 111.758 | 111.778 | 232247.0 |
| 2016-02-23 | FGBX | Futures | 172.86 | 173.83 | 171.71 | 173.34 | 34804.0 |
| 2016-02-23 | FMWO | Futures | 5239.3 | 5253.0 | 5206.9 | 5208.2 | 288.0 |
| 2016-02-23 | FOAT | Futures | 132.46 | 132.62 | 132.04 | 132.48 | 88585.0 |
| 2016-02-23 | FTDX | Futures | 1555.8 | 1565.9 | 1543.4 | 1551.0 | 375.0 |
| 2016-02-23 | FTI | Futures | 370.05 | 372.22 | 366.95 | 367.7 | 26410.0 |
| 2016-02-23 | FTUK | Futures | 4880.9 | 4891.1 | 4829.9 | 4836.1 | 92839.0 |
| 2016-02-23 | FVSA | Futures | 3326.09 | 3367.01 | 3273.48 | 3355.32 | 6669.0 |
| 2016-02-23 | FXXP | Futures | 258.6 | 260.7 | 256.7 | 257.4 | 23470.0 |
| 2016-02-23 | G | Futures | 108.68 | 108.76 | 107.87 | 108.49 | 303654.0 |
| 2016-02-23 | GF | Futures | 305.378 | 310.188 | 303.709 | 308.323 | 2339.0 |
> showing 50 of 110 rows — these rows as CSV