PREVIEW / futures_daily / 2016-05-09
file: by_date/futures_daily/2016/2016-05-09.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-05-09 | ES | Futures | 2204.34 | 2211.59 | 2199.24 | 2205.68 | 1370423.0 |
| 2016-05-09 | NQ | Futures | 5087.49 | 5118.92 | 5073.68 | 5094.54 | 206931.0 |
| 2016-05-09 | YM | Futures | 18375.5 | 18431.7 | 18294.4 | 18347.5 | 120192.0 |
| 2016-05-09 | CL | Futures | 53.61 | 54.73 | 51.51 | 51.75 | 767568.0 |
| 2016-05-09 | GC | Futures | 1658.5 | 1662.1 | 1627.7 | 1632.6 | 225229.0 |
| 2016-05-09 | ZN | Futures | 126.037955 | 126.384959 | 125.947432 | 126.294436 | 875121.0 |
| 2016-05-09 | A6 | Futures | 0.74429 | 0.74652 | 0.73863 | 0.73984 | 88778.0 |
| 2016-05-09 | AD | Futures | 0.79087 | 0.7922 | 0.78545 | 0.78862 | 66973.0 |
| 2016-05-09 | ALI | Futures | 2124.75 | 2124.75 | 2112.8 | 2115.38 | 19.0 |
| 2016-05-09 | B | Futures | 37.98 | 38.58 | 36.05 | 36.22 | 364584.0 |
| 2016-05-09 | B6 | Futures | 1.5185 | 1.5248 | 1.5138 | 1.5177 | 74279.0 |
| 2016-05-09 | BFX | Futures | 3907.3 | 3916.1 | 3906.7 | 3912.6 | 26.0 |
| 2016-05-09 | BR | Futures | 0.18461 | 0.18461 | 0.17618 | 0.1838 | 2492.0 |
| 2016-05-09 | BZ | Futures | 37.95 | 38.44 | 35.98 | 36.1 | 36293.0 |
| 2016-05-09 | C | Futures | 2339.0 | 2365.0 | 2338.0 | 2359.0 | 9955.0 |
| 2016-05-09 | CB | Futures | 253.037 | 253.646 | 253.037 | 253.646 | 12.0 |
| 2016-05-09 | CC | Futures | 2243.0 | 2262.0 | 2238.0 | 2252.0 | 16311.0 |
| 2016-05-09 | CNH | Futures | 7.0918 | 7.1139 | 7.0907 | 7.1139 | 33.0 |
| 2016-05-09 | CSC | Futures | 3.393 | 3.393 | 3.331 | 3.336 | 95.0 |
| 2016-05-09 | CT | Futures | 70.31 | 70.59 | 69.59 | 69.76 | 16274.0 |
| 2016-05-09 | DC | Futures | 26.56 | 26.73 | 25.92 | 26.01 | 416.0 |
| 2016-05-09 | DX | Futures | 87.516 | 87.819 | 87.451 | 87.745 | 14008.0 |
| 2016-05-09 | E1 | Futures | 1.29303 | 1.29919 | 1.29228 | 1.2958 | 15188.0 |
| 2016-05-09 | E6 | Futures | 1.33068 | 1.33325 | 1.328 | 1.32946 | 118599.0 |
| 2016-05-09 | E7 | Futures | 1.3236 | 1.3259 | 1.3208 | 1.3223 | 1752.0 |
| 2016-05-09 | EBM | Futures | 193.36 | 194.57 | 191.56 | 191.86 | 10311.0 |
| 2016-05-09 | ED | Futures | 95.7449 | 95.7593 | 95.7449 | 95.7545 | 128722.0 |
| 2016-05-09 | ER | Futures | 98.259 | 98.264 | 98.259 | 98.264 | 21273.0 |
| 2016-05-09 | EW | Futures | 1533.6 | 1538.9 | 1526.5 | 1533.0 | 10229.0 |
| 2016-05-09 | FBON | Futures | 117.7 | 118.41 | 117.69 | 117.9 | 252.0 |
| 2016-05-09 | FBTP | Futures | 105.93 | 106.43 | 105.71 | 106.08 | 86821.0 |
| 2016-05-09 | FBTS | Futures | 101.051 | 101.096 | 101.042 | 101.087 | 15786.0 |
| 2016-05-09 | FCE | Futures | 3664.4 | 3687.8 | 3634.6 | 3652.9 | 85560.0 |
| 2016-05-09 | FDAX | Futures | 10699.1 | 10823.7 | 10612.0 | 10722.7 | 111731.0 |
| 2016-05-09 | FDXM | Futures | 10300.3 | 10420.3 | 10219.6 | 10326.1 | 19409.0 |
| 2016-05-09 | FESX | Futures | 2280.7 | 2300.2 | 2262.0 | 2274.5 | 1153994.0 |
| 2016-05-09 | FEU3 | Futures | 98.912 | 98.917 | 98.912 | 98.917 | 15.0 |
| 2016-05-09 | FGBL | Futures | 146.26 | 146.81 | 146.24 | 146.73 | 610386.0 |
| 2016-05-09 | FGBM | Futures | 127.65 | 127.81 | 127.65 | 127.77 | 403739.0 |
| 2016-05-09 | FGBS | Futures | 111.668 | 111.693 | 111.668 | 111.688 | 132635.0 |
| 2016-05-09 | FGBX | Futures | 173.25 | 174.59 | 172.86 | 174.26 | 30009.0 |
| 2016-05-09 | FMWO | Futures | 5597.9 | 5597.9 | 5576.8 | 5576.8 | 53.0 |
| 2016-05-09 | FOAT | Futures | 133.46 | 134.03 | 133.37 | 133.92 | 68449.0 |
| 2016-05-09 | FTDX | Futures | 1538.5 | 1550.4 | 1531.9 | 1545.2 | 185.0 |
| 2016-05-09 | FTI | Futures | 389.85 | 392.24 | 386.82 | 387.54 | 28263.0 |
| 2016-05-09 | FTUK | Futures | 5051.9 | 5068.0 | 5008.1 | 5013.1 | 87945.0 |
| 2016-05-09 | FVSA | Futures | 2644.43 | 2707.39 | 2586.72 | 2639.18 | 36428.0 |
| 2016-05-09 | FXXP | Futures | 265.8 | 267.9 | 264.4 | 265.1 | 23869.0 |
| 2016-05-09 | G | Futures | 108.64 | 108.81 | 108.51 | 108.74 | 185528.0 |
| 2016-05-09 | GF | Futures | 297.676 | 303.319 | 297.676 | 301.222 | 3158.0 |
> showing 50 of 110 rows — these rows as CSV