PREVIEW / futures_daily / 2016-08-22
file: by_date/futures_daily/2016/2016-08-22.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-08-22 | ES | Futures | 2355.62 | 2358.58 | 2346.71 | 2355.35 | 1543249.0 |
| 2016-08-22 | NQ | Futures | 5668.83 | 5679.15 | 5645.55 | 5671.78 | 196397.0 |
| 2016-08-22 | YM | Futures | 19369.5 | 19387.3 | 19263.0 | 19343.4 | 141866.0 |
| 2016-08-22 | CL | Futures | 54.49 | 54.55 | 52.61 | 52.7 | 515256.0 |
| 2016-08-22 | GC | Futures | 1725.7 | 1726.5 | 1713.3 | 1723.6 | 156447.0 |
| 2016-08-22 | ZN | Futures | 127.380937 | 127.788387 | 127.184757 | 127.758206 | 946754.0 |
| 2016-08-22 | A6 | Futures | 0.77345 | 0.7768 | 0.771 | 0.77579 | 65976.0 |
| 2016-08-22 | AD | Futures | 0.79516 | 0.79526 | 0.78933 | 0.79025 | 57844.0 |
| 2016-08-22 | ALI | Futures | 2153.54 | 2155.74 | 2153.54 | 2155.74 | 2.0 |
| 2016-08-22 | B | Futures | 40.07 | 40.07 | 38.78 | 38.86 | 270367.0 |
| 2016-08-22 | B6 | Futures | 1.3787 | 1.3878 | 1.3747 | 1.3853 | 65407.0 |
| 2016-08-22 | BFX | Futures | 4065.2 | 4065.2 | 4038.6 | 4046.1 | 8.0 |
| 2016-08-22 | BR | Futures | 0.20563 | 0.20736 | 0.20466 | 0.20689 | 1050.0 |
| 2016-08-22 | BZ | Futures | 39.9 | 39.9 | 38.61 | 38.66 | 27608.0 |
| 2016-08-22 | C | Futures | 2646.0 | 2646.0 | 2559.0 | 2562.0 | 8600.0 |
| 2016-08-22 | CB | Futures | 262.867 | 262.867 | 259.147 | 259.147 | 40.0 |
| 2016-08-22 | CC | Futures | 2277.0 | 2277.0 | 2202.0 | 2207.0 | 26048.0 |
| 2016-08-22 | CNH | Futures | 7.2136 | 7.2185 | 7.2072 | 7.2072 | 22.0 |
| 2016-08-22 | CSC | Futures | 4.005 | 4.007 | 3.999 | 3.999 | 8.0 |
| 2016-08-22 | CT | Futures | 76.07 | 77.67 | 76.07 | 76.94 | 27.0 |
| 2016-08-22 | DC | Futures | 32.16 | 32.32 | 32.02 | 32.05 | 238.0 |
| 2016-08-22 | DX | Futures | 87.956 | 88.3 | 87.821 | 87.889 | 13923.0 |
| 2016-08-22 | E1 | Futures | 1.30484 | 1.30635 | 1.29958 | 1.30422 | 16886.0 |
| 2016-08-22 | E6 | Futures | 1.31856 | 1.32054 | 1.31349 | 1.31978 | 103805.0 |
| 2016-08-22 | E7 | Futures | 1.3117 | 1.3135 | 1.3065 | 1.3128 | 1752.0 |
| 2016-08-22 | EBM | Futures | 195.17 | 195.47 | 189.75 | 191.26 | 12842.0 |
| 2016-08-22 | ED | Futures | 95.6316 | 95.6316 | 95.6075 | 95.6195 | 172238.0 |
| 2016-08-22 | ER | Futures | 98.303 | 98.308 | 98.303 | 98.303 | 25406.0 |
| 2016-08-22 | EW | Futures | 1654.6 | 1657.1 | 1647.4 | 1656.1 | 12949.0 |
| 2016-08-22 | FBON | Futures | 124.77 | 124.95 | 124.71 | 124.83 | 222.0 |
| 2016-08-22 | FBTP | Futures | 110.59 | 110.84 | 110.53 | 110.73 | 54778.0 |
| 2016-08-22 | FBTS | Futures | 101.329 | 101.356 | 101.329 | 101.347 | 9195.0 |
| 2016-08-22 | FCE | Futures | 3838.4 | 3881.6 | 3821.8 | 3833.6 | 77126.0 |
| 2016-08-22 | FDAX | Futures | 11203.2 | 11340.5 | 11052.1 | 11148.4 | 92639.0 |
| 2016-08-22 | FDXM | Futures | 10926.4 | 11055.0 | 10770.8 | 10866.8 | 25146.0 |
| 2016-08-22 | FESX | Futures | 2318.9 | 2347.8 | 2308.7 | 2315.0 | 876946.0 |
| 2016-08-22 | FEU3 | Futures | 98.961 | 98.961 | 98.961 | 98.961 | 20.0 |
| 2016-08-22 | FGBL | Futures | 150.18 | 150.85 | 150.13 | 150.72 | 432532.0 |
| 2016-08-22 | FGBM | Futures | 128.77 | 128.94 | 128.74 | 128.91 | 240601.0 |
| 2016-08-22 | FGBS | Futures | 111.852 | 111.877 | 111.847 | 111.867 | 88578.0 |
| 2016-08-22 | FGBX | Futures | 187.87 | 190.01 | 187.63 | 189.47 | 19000.0 |
| 2016-08-22 | FMWO | Futures | 5775.6 | 5796.3 | 5775.6 | 5779.3 | 254.0 |
| 2016-08-22 | FOAT | Futures | 138.16 | 138.74 | 138.15 | 138.62 | 58799.0 |
| 2016-08-22 | FTDX | Futures | 1647.2 | 1662.6 | 1639.9 | 1651.0 | 95.0 |
| 2016-08-22 | FTI | Futures | 403.75 | 407.76 | 402.35 | 403.75 | 26667.0 |
| 2016-08-22 | FTUK | Futures | 5723.3 | 5743.7 | 5681.2 | 5683.7 | 90133.0 |
| 2016-08-22 | FVSA | Futures | 1990.46 | 2003.44 | 1934.21 | 1986.13 | 6005.0 |
| 2016-08-22 | FXXP | Futures | 274.8 | 277.7 | 273.9 | 275.0 | 14931.0 |
| 2016-08-22 | G | Futures | 116.63 | 117.19 | 116.59 | 117.05 | 111334.0 |
| 2016-08-22 | GF | Futures | 289.813 | 294.29 | 287.549 | 290.618 | 3694.0 |
> showing 50 of 110 rows — these rows as CSV