PREVIEW / futures_daily / 2015-11-19
file: by_date/futures_daily/2015/2015-11-19.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 |
|---|---|---|---|---|---|---|---|
| 2015-11-19 | ES | Futures | 2210.74 | 2222.44 | 2207.55 | 2211.81 | 1284869.0 |
| 2015-11-19 | NQ | Futures | 5436.53 | 5468.39 | 5433.02 | 5448.51 | 217266.0 |
| 2015-11-19 | YM | Futures | 18249.0 | 18333.7 | 18205.7 | 18269.7 | 119473.0 |
| 2015-11-19 | CL | Futures | 64.95 | 65.44 | 63.71 | 64.44 | 422086.0 |
| 2015-11-19 | GC | Futures | 1380.3 | 1402.7 | 1379.1 | 1391.4 | 177555.0 |
| 2015-11-19 | ZN | Futures | 121.281771 | 121.551186 | 121.221901 | 121.446413 | 1016791.0 |
| 2015-11-19 | A6 | Futures | 0.70983 | 0.72073 | 0.70973 | 0.71863 | 110733.0 |
| 2015-11-19 | AD | Futures | 0.76933 | 0.77302 | 0.76923 | 0.77045 | 56265.0 |
| 2015-11-19 | ALI | Futures | 2103.84 | 2103.84 | 2103.84 | 2103.84 | 0.0 |
| 2015-11-19 | B | Futures | 39.08 | 39.48 | 38.55 | 38.97 | 201033.0 |
| 2015-11-19 | B6 | Futures | 1.6036 | 1.6148 | 1.6035 | 1.6102 | 90003.0 |
| 2015-11-19 | BFX | Futures | 4506.6 | 4521.8 | 4491.4 | 4491.4 | 86.0 |
| 2015-11-19 | BR | Futures | 0.16285 | 0.16515 | 0.16285 | 0.16448 | 1993.0 |
| 2015-11-19 | BZ | Futures | 38.81 | 39.23 | 38.3 | 38.72 | 23334.0 |
| 2015-11-19 | C | Futures | 2444.0 | 2460.0 | 2442.0 | 2449.0 | 5371.0 |
| 2015-11-19 | CB | Futures | 241.108 | 246.963 | 240.124 | 246.52 | 87.0 |
| 2015-11-19 | CC | Futures | 2483.0 | 2502.0 | 2476.0 | 2490.0 | 13922.0 |
| 2015-11-19 | CNH | Futures | 7.1394 | 7.1394 | 7.1251 | 7.1251 | 95.0 |
| 2015-11-19 | CSC | Futures | 4.112 | 4.12 | 4.097 | 4.097 | 13.0 |
| 2015-11-19 | CT | Futures | 73.84 | 74.64 | 73.8 | 73.87 | 5738.0 |
| 2015-11-19 | DC | Futures | 33.01 | 33.1 | 32.75 | 32.88 | 136.0 |
| 2015-11-19 | DX | Futures | 93.03 | 93.077 | 92.399 | 92.651 | 39261.0 |
| 2015-11-19 | E1 | Futures | 1.24447 | 1.25398 | 1.24409 | 1.25309 | 25232.0 |
| 2015-11-19 | E6 | Futures | 1.24898 | 1.26128 | 1.24887 | 1.25765 | 249315.0 |
| 2015-11-19 | E7 | Futures | 1.2422 | 1.2543 | 1.2422 | 1.2507 | 5274.0 |
| 2015-11-19 | EBM | Futures | 258.32 | 262.71 | 257.96 | 257.96 | 26360.0 |
| 2015-11-19 | ED | Futures | 95.6847 | 95.6871 | 95.6775 | 95.6799 | 142375.0 |
| 2015-11-19 | ER | Futures | 98.239 | 98.239 | 98.229 | 98.234 | 105395.0 |
| 2015-11-19 | EW | Futures | 1520.0 | 1525.7 | 1513.4 | 1517.1 | 18215.0 |
| 2015-11-19 | FBON | Futures | 115.38 | 115.74 | 115.36 | 115.64 | 832.0 |
| 2015-11-19 | FBTP | Futures | 105.26 | 105.42 | 105.05 | 105.3 | 94012.0 |
| 2015-11-19 | FBTS | Futures | 100.695 | 100.713 | 100.659 | 100.677 | 16152.0 |
| 2015-11-19 | FCE | Futures | 4129.2 | 4147.6 | 4092.9 | 4105.4 | 42846.0 |
| 2015-11-19 | FDAX | Futures | 12170.1 | 12284.1 | 12153.0 | 12213.1 | 95740.0 |
| 2015-11-19 | FDXM | Futures | 11370.4 | 11477.5 | 11357.1 | 11409.5 | 11836.0 |
| 2015-11-19 | FESX | Futures | 2592.4 | 2605.9 | 2575.9 | 2586.4 | 1049334.0 |
| 2015-11-19 | FEU3 | Futures | 98.882 | 98.882 | 98.882 | 98.882 | 2.0 |
| 2015-11-19 | FGBL | Futures | 140.4 | 140.68 | 140.27 | 140.61 | 584671.0 |
| 2015-11-19 | FGBM | Futures | 125.95 | 126.05 | 125.89 | 126.02 | 423780.0 |
| 2015-11-19 | FGBS | Futures | 111.533 | 111.548 | 111.513 | 111.543 | 183056.0 |
| 2015-11-19 | FGBX | Futures | 158.88 | 159.89 | 158.85 | 159.73 | 31436.0 |
| 2015-11-19 | FMWO | Futures | 5700.3 | 5712.7 | 5691.6 | 5700.3 | 211.0 |
| 2015-11-19 | FOAT | Futures | 129.11 | 129.36 | 128.9 | 129.21 | 88437.0 |
| 2015-11-19 | FTDX | Futures | 1735.8 | 1750.5 | 1728.7 | 1733.9 | 159.0 |
| 2015-11-19 | FTI | Futures | 407.37 | 410.63 | 406.29 | 407.59 | 16901.0 |
| 2015-11-19 | FTUK | Futures | 5075.9 | 5119.7 | 5067.4 | 5094.3 | 118972.0 |
| 2015-11-19 | FVSA | Futures | 2096.48 | 2162.73 | 2077.55 | 2124.87 | 9286.0 |
| 2015-11-19 | FXXP | Futures | 297.4 | 298.9 | 295.9 | 296.9 | 19577.0 |
| 2015-11-19 | G | Futures | 104.11 | 104.43 | 104.1 | 104.34 | 138092.0 |
| 2015-11-19 | GF | Futures | 316.468 | 317.771 | 312.029 | 313.573 | 3026.0 |
> showing 50 of 109 rows — these rows as CSV