PREVIEW / futures_daily / 2016-05-10
file: by_date/futures_daily/2016/2016-05-10.parquet size: 9 KB rows: 106
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-10 | ES | Futures | 2205.42 | 2233.06 | 2198.97 | 2230.65 | 1416966.0 |
| 2016-05-10 | NQ | Futures | 5093.36 | 5168.56 | 5080.44 | 5160.63 | 204247.0 |
| 2016-05-10 | YM | Futures | 18347.5 | 18574.1 | 18304.8 | 18562.7 | 142357.0 |
| 2016-05-10 | CL | Futures | 51.52 | 53.36 | 51.26 | 53.2 | 709415.0 |
| 2016-05-10 | GC | Futures | 1631.0 | 1639.5 | 1621.9 | 1630.2 | 174083.0 |
| 2016-05-10 | ZN | Futures | 126.369872 | 126.400046 | 126.128478 | 126.279349 | 992388.0 |
| 2016-05-10 | A6 | Futures | 0.73934 | 0.74541 | 0.73782 | 0.74379 | 95089.0 |
| 2016-05-10 | AD | Futures | 0.78893 | 0.7921 | 0.7877 | 0.79098 | 58138.0 |
| 2016-05-10 | ALI | Futures | 2107.95 | 2107.95 | 2107.95 | 2107.95 | 0.0 |
| 2016-05-10 | B | Futures | 36.1 | 37.93 | 35.97 | 37.78 | 343209.0 |
| 2016-05-10 | B6 | Futures | 1.5172 | 1.5247 | 1.5153 | 1.5201 | 63751.0 |
| 2016-05-10 | BR | Futures | 0.1838 | 0.18666 | 0.1838 | 0.18623 | 528.0 |
| 2016-05-10 | BZ | Futures | 36.04 | 37.8 | 35.86 | 37.66 | 32801.0 |
| 2016-05-10 | C | Futures | 2359.0 | 2381.0 | 2349.0 | 2370.0 | 18470.0 |
| 2016-05-10 | CC | Futures | 2256.0 | 2282.0 | 2250.0 | 2268.0 | 19605.0 |
| 2016-05-10 | CNH | Futures | 7.1155 | 7.1189 | 7.1113 | 7.1113 | 20.0 |
| 2016-05-10 | CSC | Futures | 3.31 | 3.324 | 3.286 | 3.322 | 106.0 |
| 2016-05-10 | CT | Futures | 70.0 | 70.49 | 68.93 | 69.27 | 24422.0 |
| 2016-05-10 | DC | Futures | 25.86 | 25.92 | 25.57 | 25.86 | 462.0 |
| 2016-05-10 | DX | Futures | 87.759 | 87.95 | 87.652 | 87.886 | 13362.0 |
| 2016-05-10 | E1 | Futures | 1.29504 | 1.2973 | 1.28863 | 1.28939 | 17268.0 |
| 2016-05-10 | E6 | Futures | 1.32858 | 1.33202 | 1.32602 | 1.32724 | 125704.0 |
| 2016-05-10 | E7 | Futures | 1.3213 | 1.3247 | 1.3188 | 1.3201 | 2112.0 |
| 2016-05-10 | EBM | Futures | 192.46 | 193.96 | 191.26 | 191.86 | 9936.0 |
| 2016-05-10 | ED | Futures | 95.7593 | 95.7593 | 95.7497 | 95.7545 | 127486.0 |
| 2016-05-10 | ER | Futures | 98.259 | 98.269 | 98.259 | 98.269 | 27964.0 |
| 2016-05-10 | EW | Futures | 1532.6 | 1551.2 | 1527.5 | 1550.1 | 12771.0 |
| 2016-05-10 | FBON | Futures | 118.06 | 118.49 | 117.64 | 118.12 | 354.0 |
| 2016-05-10 | FBTP | Futures | 106.28 | 106.67 | 105.86 | 106.27 | 116924.0 |
| 2016-05-10 | FBTS | Futures | 101.096 | 101.114 | 101.078 | 101.096 | 20679.0 |
| 2016-05-10 | FCE | Futures | 3670.3 | 3711.1 | 3663.1 | 3678.8 | 83676.0 |
| 2016-05-10 | FDAX | Futures | 10778.5 | 10865.0 | 10735.0 | 10781.8 | 96188.0 |
| 2016-05-10 | FDXM | Futures | 10386.1 | 10459.6 | 10338.5 | 10382.0 | 21616.0 |
| 2016-05-10 | FESX | Futures | 2289.3 | 2318.1 | 2285.4 | 2294.0 | 1246683.0 |
| 2016-05-10 | FGBL | Futures | 146.73 | 147.01 | 146.56 | 146.92 | 674337.0 |
| 2016-05-10 | FGBM | Futures | 127.76 | 127.82 | 127.72 | 127.78 | 551594.0 |
| 2016-05-10 | FGBS | Futures | 111.683 | 111.688 | 111.673 | 111.678 | 156829.0 |
| 2016-05-10 | FGBX | Futures | 174.36 | 175.49 | 173.54 | 174.71 | 41768.0 |
| 2016-05-10 | FMWO | Futures | 5630.3 | 5640.2 | 5621.6 | 5632.8 | 215.0 |
| 2016-05-10 | FOAT | Futures | 133.98 | 134.26 | 133.85 | 134.21 | 85759.0 |
| 2016-05-10 | FTDX | Futures | 1548.5 | 1553.8 | 1546.1 | 1551.9 | 61.0 |
| 2016-05-10 | FTI | Futures | 387.54 | 391.63 | 387.54 | 389.03 | 233.0 |
| 2016-05-10 | FTUK | Futures | 5014.3 | 5070.4 | 5011.8 | 5042.8 | 96134.0 |
| 2016-05-10 | FVSA | Futures | 2565.73 | 2602.46 | 2529.0 | 2549.99 | 10220.0 |
| 2016-05-10 | FXXP | Futures | 267.1 | 269.2 | 266.5 | 267.4 | 26452.0 |
| 2016-05-10 | G | Futures | 108.67 | 108.9 | 108.55 | 108.86 | 177812.0 |
| 2016-05-10 | GF | Futures | 301.222 | 302.021 | 298.776 | 300.174 | 3833.0 |
| 2016-05-10 | GSCI | Futures | 501.83 | 509.99 | 500.89 | 509.99 | 2438.0 |
| 2016-05-10 | HE | Futures | 98.008 | 98.83 | 97.856 | 98.343 | 17718.0 |
| 2016-05-10 | HG | Futures | 2.6305 | 2.6549 | 2.6179 | 2.6204 | 63010.0 |
> showing 50 of 106 rows — these rows as CSV