PREVIEW / futures_daily / 2016-04-06
file: by_date/futures_daily/2016/2016-04-06.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 |
|---|---|---|---|---|---|---|---|
| 2016-04-06 | ES | Futures | 2192.53 | 2212.4 | 2185.02 | 2212.13 | 1894599.0 |
| 2016-04-06 | NQ | Futures | 5259.33 | 5331.89 | 5249.05 | 5328.66 | 241958.0 |
| 2016-04-06 | YM | Futures | 18252.9 | 18340.2 | 18145.8 | 18328.8 | 168209.0 |
| 2016-04-06 | CL | Futures | 44.33 | 46.01 | 44.22 | 45.82 | 751048.0 |
| 2016-04-06 | GC | Futures | 1588.7 | 1590.3 | 1568.9 | 1577.4 | 135333.0 |
| 2016-04-06 | ZN | Futures | 126.354785 | 126.400046 | 126.022868 | 126.188826 | 944334.0 |
| 2016-04-06 | A6 | Futures | 0.7611 | 0.76889 | 0.75998 | 0.76626 | 90608.0 |
| 2016-04-06 | AD | Futures | 0.7783 | 0.7828 | 0.77543 | 0.78024 | 65027.0 |
| 2016-04-06 | ALI | Futures | 2066.9 | 2066.9 | 2061.08 | 2061.08 | 8.0 |
| 2016-04-06 | B | Futures | 31.98 | 33.26 | 31.93 | 33.18 | 323374.0 |
| 2016-04-06 | B6 | Futures | 1.491 | 1.4925 | 1.475 | 1.4878 | 123625.0 |
| 2016-04-06 | BR | Futures | 0.17267 | 0.17543 | 0.17267 | 0.17543 | 132.0 |
| 2016-04-06 | BZ | Futures | 31.66 | 32.92 | 31.49 | 32.84 | 33370.0 |
| 2016-04-06 | C | Futures | 2252.0 | 2273.0 | 2242.0 | 2267.0 | 5695.0 |
| 2016-04-06 | CB | Futures | 254.835 | 261.451 | 254.835 | 260.963 | 56.0 |
| 2016-04-06 | CC | Futures | 2115.0 | 2134.0 | 2098.0 | 2130.0 | 15672.0 |
| 2016-04-06 | CNH | Futures | 7.0816 | 7.0816 | 7.0736 | 7.0736 | 3.0 |
| 2016-04-06 | CSC | Futures | 3.627 | 3.627 | 3.615 | 3.615 | 29.0 |
| 2016-04-06 | CT | Futures | 67.59 | 68.08 | 67.36 | 67.47 | 11825.0 |
| 2016-04-06 | DC | Futures | 28.63 | 28.63 | 28.42 | 28.49 | 61.0 |
| 2016-04-06 | DX | Futures | 88.23 | 88.64 | 87.861 | 88.049 | 32356.0 |
| 2016-04-06 | E1 | Futures | 1.31766 | 1.32218 | 1.30962 | 1.31866 | 21090.0 |
| 2016-04-06 | E6 | Futures | 1.33021 | 1.33587 | 1.32357 | 1.3329 | 228244.0 |
| 2016-04-06 | E7 | Futures | 1.323 | 1.3286 | 1.3165 | 1.3257 | 3771.0 |
| 2016-04-06 | EBM | Futures | 199.78 | 200.42 | 197.52 | 197.85 | 25605.0 |
| 2016-04-06 | ED | Futures | 95.7304 | 95.7304 | 95.7112 | 95.7208 | 164799.0 |
| 2016-04-06 | ER | Futures | 98.259 | 98.264 | 98.254 | 98.264 | 66406.0 |
| 2016-04-06 | EW | Futures | 1503.7 | 1515.7 | 1496.3 | 1514.8 | 19085.0 |
| 2016-04-06 | FBON | Futures | 118.57 | 118.61 | 118.43 | 118.44 | 267.0 |
| 2016-04-06 | FBTP | Futures | 107.7 | 107.7 | 107.42 | 107.43 | 61202.0 |
| 2016-04-06 | FBTS | Futures | 101.006 | 101.015 | 100.979 | 100.997 | 18856.0 |
| 2016-04-06 | FCE | Futures | 3548.8 | 3581.7 | 3533.0 | 3568.4 | 72939.0 |
| 2016-04-06 | FDAX | Futures | 10330.6 | 10420.3 | 10245.2 | 10383.2 | 113466.0 |
| 2016-04-06 | FDXM | Futures | 9946.5 | 10038.6 | 9866.9 | 9998.2 | 22799.0 |
| 2016-04-06 | FESX | Futures | 2199.6 | 2219.9 | 2188.7 | 2210.5 | 1241738.0 |
| 2016-04-06 | FGBL | Futures | 146.77 | 146.93 | 146.43 | 146.59 | 617477.0 |
| 2016-04-06 | FGBM | Futures | 127.57 | 127.63 | 127.5 | 127.59 | 446221.0 |
| 2016-04-06 | FGBS | Futures | 111.628 | 111.643 | 111.618 | 111.643 | 163882.0 |
| 2016-04-06 | FGBX | Futures | 177.1 | 177.47 | 175.47 | 175.84 | 41743.0 |
| 2016-04-06 | FMWO | Futures | 5504.7 | 5524.6 | 5488.5 | 5522.1 | 251.0 |
| 2016-04-06 | FOAT | Futures | 134.43 | 134.57 | 134.14 | 134.27 | 79833.0 |
| 2016-04-06 | FTDX | Futures | 1537.6 | 1555.2 | 1527.1 | 1553.8 | 148.0 |
| 2016-04-06 | FTI | Futures | 380.53 | 383.55 | 379.16 | 382.13 | 26761.0 |
| 2016-04-06 | FTUK | Futures | 4982.1 | 5059.7 | 4980.5 | 5034.5 | 113257.0 |
| 2016-04-06 | FVSA | Futures | 2832.46 | 2871.11 | 2716.52 | 2744.12 | 6495.0 |
| 2016-04-06 | FXXP | Futures | 260.3 | 261.4 | 258.5 | 260.8 | 27916.0 |
| 2016-04-06 | G | Futures | 108.93 | 109.04 | 108.62 | 108.92 | 152114.0 |
| 2016-04-06 | GF | Futures | 300.422 | 304.643 | 298.998 | 300.716 | 1808.0 |
| 2016-04-06 | GSCI | Futures | 470.99 | 478.28 | 469.34 | 477.23 | 1170.0 |
| 2016-04-06 | HE | Futures | 95.68 | 97.382 | 95.68 | 97.286 | 414.0 |
> showing 50 of 108 rows — these rows as CSV