PREVIEW / futures_daily / 2015-08-18
file: by_date/futures_daily/2015/2015-08-18.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-18 | ES | Futures | 2223.76 | 2229.59 | 2215.28 | 2219.26 | 1135552.0 |
| 2015-08-18 | NQ | Futures | 5326.81 | 5339.65 | 5293.24 | 5305.21 | 164755.0 |
| 2015-08-18 | YM | Futures | 17967.7 | 18008.8 | 17906.1 | 17954.4 | 107544.0 |
| 2015-08-18 | CL | Futures | 69.15 | 70.75 | 68.4 | 70.33 | 248262.0 |
| 2015-08-18 | GC | Futures | 1442.2 | 1446.3 | 1430.9 | 1441.8 | 119945.0 |
| 2015-08-18 | ZN | Futures | 121.718636 | 122.001806 | 121.49508 | 121.569599 | 744608.0 |
| 2015-08-18 | A6 | Futures | 0.729 | 0.73059 | 0.72395 | 0.72583 | 73768.0 |
| 2015-08-18 | AD | Futures | 0.78109 | 0.78395 | 0.77884 | 0.78222 | 43582.0 |
| 2015-08-18 | ALI | Futures | 2139.17 | 2139.17 | 2139.17 | 2139.17 | 0.0 |
| 2015-08-18 | B | Futures | 44.94 | 45.39 | 44.66 | 45.18 | 191533.0 |
| 2015-08-18 | B6 | Futures | 1.6401 | 1.6539 | 1.6376 | 1.6483 | 102364.0 |
| 2015-08-18 | BFX | Futures | 4424.5 | 4424.5 | 4408.8 | 4420.3 | 51.0 |
| 2015-08-18 | BR | Futures | 0.17062 | 0.17254 | 0.17023 | 0.17203 | 1729.0 |
| 2015-08-18 | BZ | Futures | 44.86 | 45.34 | 44.61 | 45.14 | 16384.0 |
| 2015-08-18 | C | Futures | 2161.0 | 2181.0 | 2161.0 | 2178.0 | 2624.0 |
| 2015-08-18 | CB | Futures | 174.251 | 177.108 | 174.251 | 177.108 | 4.0 |
| 2015-08-18 | CC | Futures | 2246.0 | 2267.0 | 2244.0 | 2261.0 | 12209.0 |
| 2015-08-18 | CNH | Futures | 7.2571 | 7.2701 | 7.2545 | 7.2551 | 73.0 |
| 2015-08-18 | CSC | Futures | 4.442 | 4.49 | 4.427 | 4.475 | 49.0 |
| 2015-08-18 | CT | Futures | 82.83 | 83.21 | 82.38 | 83.13 | 15.0 |
| 2015-08-18 | DC | Futures | 35.36 | 35.94 | 35.36 | 35.86 | 192.0 |
| 2015-08-18 | DX | Futures | 90.655 | 90.894 | 90.51 | 90.866 | 25295.0 |
| 2015-08-18 | E1 | Futures | 1.29862 | 1.30307 | 1.29735 | 1.30002 | 11768.0 |
| 2015-08-18 | E6 | Futures | 1.30213 | 1.30377 | 1.29461 | 1.29496 | 156672.0 |
| 2015-08-18 | E7 | Futures | 1.2953 | 1.2966 | 1.2876 | 1.2878 | 2974.0 |
| 2015-08-18 | EBM | Futures | 287.33 | 287.74 | 284.05 | 284.87 | 10985.0 |
| 2015-08-18 | ED | Futures | 95.6222 | 95.627 | 95.6175 | 95.6222 | 163981.0 |
| 2015-08-18 | ER | Futures | 98.122 | 98.126 | 98.117 | 98.126 | 15360.0 |
| 2015-08-18 | EW | Futures | 1586.8 | 1589.7 | 1575.4 | 1577.0 | 11236.0 |
| 2015-08-18 | FBTP | Futures | 101.75 | 101.84 | 101.17 | 101.31 | 53552.0 |
| 2015-08-18 | FBTS | Futures | 100.159 | 100.177 | 100.097 | 100.133 | 11026.0 |
| 2015-08-18 | FCE | Futures | 4184.2 | 4190.5 | 4149.5 | 4164.1 | 133876.0 |
| 2015-08-18 | FDAX | Futures | 12131.3 | 12142.9 | 12027.9 | 12068.3 | 72323.0 |
| 2015-08-18 | FDIV | Futures | 148.62 | 148.62 | 148.11 | 148.11 | 1.0 |
| 2015-08-18 | FESX | Futures | 2595.4 | 2599.1 | 2574.7 | 2588.0 | 697417.0 |
| 2015-08-18 | FEU3 | Futures | 98.764 | 98.764 | 98.764 | 98.764 | 5.0 |
| 2015-08-18 | FGBL | Futures | 138.28 | 138.54 | 137.91 | 138.13 | 420899.0 |
| 2015-08-18 | FGBM | Futures | 125.02 | 125.03 | 124.88 | 124.93 | 280191.0 |
| 2015-08-18 | FGBS | Futures | 111.278 | 111.293 | 111.268 | 111.283 | 135565.0 |
| 2015-08-18 | FGBX | Futures | 159.07 | 159.76 | 157.81 | 158.38 | 17572.0 |
| 2015-08-18 | FMWO | Futures | 5788.0 | 5792.9 | 5784.3 | 5784.3 | 204.0 |
| 2015-08-18 | FOAT | Futures | 126.35 | 126.48 | 125.8 | 126.04 | 42739.0 |
| 2015-08-18 | FTDX | Futures | 1671.1 | 1684.3 | 1661.6 | 1679.1 | 225.0 |
| 2015-08-18 | FTI | Futures | 408.92 | 413.61 | 406.98 | 412.1 | 28215.0 |
| 2015-08-18 | FTUK | Futures | 5207.8 | 5214.2 | 5162.1 | 5187.5 | 77344.0 |
| 2015-08-18 | FVSA | Futures | 1818.57 | 1852.72 | 1818.57 | 1848.45 | 7660.0 |
| 2015-08-18 | FXXP | Futures | 298.0 | 299.1 | 296.1 | 298.5 | 12025.0 |
| 2015-08-18 | G | Futures | 103.42 | 103.53 | 102.75 | 102.88 | 137483.0 |
| 2015-08-18 | GF | Futures | 360.39 | 362.502 | 360.39 | 361.424 | 1071.0 |
| 2015-08-18 | GSCI | Futures | 594.58 | 597.87 | 592.68 | 596.88 | 506.0 |
> showing 50 of 108 rows — these rows as CSV