PREVIEW / futures_daily / 2015-08-19
file: by_date/futures_daily/2015/2015-08-19.parquet size: 9 KB rows: 108
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-08-19 | ES | Futures | 2218.46 | 2223.5 | 2190.11 | 2196.74 | 2289064.0 |
| 2015-08-19 | NQ | Futures | 5304.04 | 5314.84 | 5234.28 | 5258.21 | 331472.0 |
| 2015-08-19 | YM | Futures | 17951.3 | 17984.2 | 17714.1 | 17752.1 | 223522.0 |
| 2015-08-19 | CL | Futures | 69.92 | 70.43 | 66.56 | 67.31 | 458073.0 |
| 2015-08-19 | GC | Futures | 1442.2 | 1464.3 | 1440.0 | 1456.0 | 154352.0 |
| 2015-08-19 | ZN | Futures | 121.554695 | 122.314784 | 121.256621 | 122.180651 | 1320397.0 |
| 2015-08-19 | A6 | Futures | 0.72573 | 0.7296 | 0.72316 | 0.72841 | 89289.0 |
| 2015-08-19 | AD | Futures | 0.78273 | 0.78498 | 0.77577 | 0.78078 | 92307.0 |
| 2015-08-19 | ALI | Futures | 2141.42 | 2141.42 | 2141.42 | 2141.42 | 0.0 |
| 2015-08-19 | B | Futures | 44.89 | 45.46 | 43.3 | 43.65 | 250806.0 |
| 2015-08-19 | B6 | Futures | 1.6479 | 1.6522 | 1.6454 | 1.6512 | 72125.0 |
| 2015-08-19 | BFX | Futures | 4410.0 | 4410.0 | 4349.5 | 4349.5 | 191.0 |
| 2015-08-19 | BR | Futures | 0.17071 | 0.17239 | 0.16993 | 0.17098 | 2420.0 |
| 2015-08-19 | BZ | Futures | 45.04 | 45.4 | 43.27 | 43.61 | 25829.0 |
| 2015-08-19 | C | Futures | 2176.0 | 2214.0 | 2175.0 | 2209.0 | 6022.0 |
| 2015-08-19 | CB | Futures | 179.499 | 185.213 | 179.499 | 185.213 | 18.0 |
| 2015-08-19 | CC | Futures | 2264.0 | 2300.0 | 2264.0 | 2285.0 | 19926.0 |
| 2015-08-19 | CNH | Futures | 7.2586 | 7.2745 | 7.257 | 7.2745 | 7.0 |
| 2015-08-19 | CSC | Futures | 4.493 | 4.521 | 4.475 | 4.485 | 55.0 |
| 2015-08-19 | CT | Futures | 82.92 | 83.08 | 81.68 | 82.43 | 21.0 |
| 2015-08-19 | DC | Futures | 35.92 | 36.27 | 35.88 | 36.03 | 210.0 |
| 2015-08-19 | DX | Futures | 90.824 | 90.899 | 90.183 | 90.209 | 44757.0 |
| 2015-08-19 | E1 | Futures | 1.30015 | 1.31792 | 1.29964 | 1.31665 | 21450.0 |
| 2015-08-19 | E6 | Futures | 1.2959 | 1.30859 | 1.29473 | 1.308 | 249642.0 |
| 2015-08-19 | E7 | Futures | 1.2883 | 1.3013 | 1.2875 | 1.3008 | 4187.0 |
| 2015-08-19 | EBM | Futures | 283.64 | 284.87 | 277.9 | 279.54 | 10002.0 |
| 2015-08-19 | ED | Futures | 95.6198 | 95.6534 | 95.6175 | 95.6486 | 309866.0 |
| 2015-08-19 | ER | Futures | 98.122 | 98.126 | 98.122 | 98.126 | 25176.0 |
| 2015-08-19 | EW | Futures | 1576.5 | 1579.9 | 1553.3 | 1557.0 | 24896.0 |
| 2015-08-19 | FBTP | Futures | 101.16 | 101.45 | 101.03 | 101.2 | 47522.0 |
| 2015-08-19 | FBTS | Futures | 100.106 | 100.151 | 100.097 | 100.133 | 10217.0 |
| 2015-08-19 | FCE | Futures | 4141.1 | 4147.0 | 4084.2 | 4090.5 | 105892.0 |
| 2015-08-19 | FDAX | Futures | 11991.5 | 12001.4 | 11795.8 | 11813.5 | 102964.0 |
| 2015-08-19 | FESX | Futures | 2571.8 | 2576.2 | 2534.0 | 2540.7 | 1092046.0 |
| 2015-08-19 | FEU3 | Futures | 98.764 | 98.764 | 98.764 | 98.764 | 5.0 |
| 2015-08-19 | FGBL | Futures | 138.15 | 138.77 | 137.89 | 138.22 | 446107.0 |
| 2015-08-19 | FGBM | Futures | 124.95 | 125.08 | 124.86 | 124.96 | 268984.0 |
| 2015-08-19 | FGBS | Futures | 111.278 | 111.293 | 111.268 | 111.278 | 132414.0 |
| 2015-08-19 | FGBX | Futures | 158.54 | 159.97 | 157.59 | 158.48 | 18400.0 |
| 2015-08-19 | FMWO | Futures | 5751.0 | 5762.1 | 5710.4 | 5710.4 | 92.0 |
| 2015-08-19 | FOAT | Futures | 126.02 | 126.24 | 125.8 | 126.06 | 44425.0 |
| 2015-08-19 | FTDX | Futures | 1667.3 | 1671.1 | 1646.6 | 1649.4 | 122.0 |
| 2015-08-19 | FTI | Futures | 410.04 | 410.68 | 403.02 | 403.54 | 27758.0 |
| 2015-08-19 | FTUK | Futures | 5160.5 | 5168.5 | 5069.9 | 5085.0 | 111730.0 |
| 2015-08-19 | FVSA | Futures | 1861.26 | 1921.03 | 1852.72 | 1895.41 | 10741.0 |
| 2015-08-19 | FXXP | Futures | 295.8 | 296.9 | 292.2 | 292.9 | 24177.0 |
| 2015-08-19 | G | Futures | 102.85 | 103.26 | 102.66 | 103.05 | 130896.0 |
| 2015-08-19 | GF | Futures | 360.778 | 361.381 | 355.347 | 356.726 | 2707.0 |
| 2015-08-19 | GSCI | Futures | 596.39 | 596.39 | 583.28 | 583.69 | 249.0 |
| 2015-08-19 | HE | Futures | 90.422 | 90.49 | 87.926 | 90.251 | 17696.0 |
> showing 50 of 108 rows — these rows as CSV