PREVIEW / futures_daily / 2015-07-28
file: by_date/futures_daily/2015/2015-07-28.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 |
|---|---|---|---|---|---|---|---|
| 2015-07-28 | ES | Futures | 2189.05 | 2213.96 | 2184.81 | 2212.1 | 1725788.0 |
| 2015-07-28 | NQ | Futures | 5278.65 | 5325.35 | 5250.33 | 5319.22 | 280667.0 |
| 2015-07-28 | YM | Futures | 17866.1 | 18045.8 | 17840.4 | 18020.1 | 164190.0 |
| 2015-07-28 | CL | Futures | 78.07 | 80.43 | 77.51 | 79.66 | 338107.0 |
| 2015-07-28 | GC | Futures | 1412.5 | 1418.3 | 1408.5 | 1415.7 | 78103.0 |
| 2015-07-28 | ZN | Futures | 121.346043 | 121.360947 | 120.958546 | 121.137391 | 851800.0 |
| 2015-07-28 | A6 | Futures | 0.71801 | 0.72554 | 0.71692 | 0.72395 | 90768.0 |
| 2015-07-28 | AD | Futures | 0.78406 | 0.79173 | 0.78365 | 0.7904 | 60855.0 |
| 2015-07-28 | ALI | Futures | 2245.32 | 2245.32 | 2245.32 | 2245.32 | 10.0 |
| 2015-07-28 | B | Futures | 49.41 | 50.54 | 48.86 | 49.85 | 156721.0 |
| 2015-07-28 | B6 | Futures | 1.6371 | 1.6443 | 1.6337 | 1.641 | 72824.0 |
| 2015-07-28 | BFX | Futures | 4468.1 | 4495.9 | 4468.1 | 4495.9 | 1.0 |
| 2015-07-28 | BR | Futures | 0.17638 | 0.17689 | 0.17311 | 0.17521 | 4279.0 |
| 2015-07-28 | BZ | Futures | 49.53 | 50.48 | 48.83 | 49.81 | 20413.0 |
| 2015-07-28 | C | Futures | 2280.0 | 2290.0 | 2269.0 | 2287.0 | 12423.0 |
| 2015-07-28 | CB | Futures | 155.813 | 155.813 | 153.989 | 154.8 | 42.0 |
| 2015-07-28 | CC | Futures | 2342.0 | 2359.0 | 2334.0 | 2356.0 | 12841.0 |
| 2015-07-28 | CNH | Futures | 7.0087 | 7.01 | 7.0051 | 7.0051 | 1.0 |
| 2015-07-28 | CSC | Futures | 4.31 | 4.331 | 4.298 | 4.313 | 48.0 |
| 2015-07-28 | CT | Futures | 78.48 | 79.04 | 77.46 | 78.78 | 88.0 |
| 2015-07-28 | DC | Futures | 34.59 | 34.83 | 34.59 | 34.68 | 98.0 |
| 2015-07-28 | DX | Futures | 90.482 | 90.871 | 90.384 | 90.672 | 24175.0 |
| 2015-07-28 | E1 | Futures | 1.32199 | 1.32389 | 1.31437 | 1.32021 | 16470.0 |
| 2015-07-28 | E6 | Futures | 1.30401 | 1.30471 | 1.29567 | 1.29802 | 154264.0 |
| 2015-07-28 | E7 | Futures | 1.2965 | 1.2975 | 1.2885 | 1.2909 | 3906.0 |
| 2015-07-28 | EBM | Futures | 298.4 | 301.27 | 298.4 | 298.81 | 12281.0 |
| 2015-07-28 | ED | Futures | 95.6318 | 95.6366 | 95.6222 | 95.627 | 140346.0 |
| 2015-07-28 | ER | Futures | 98.107 | 98.117 | 98.107 | 98.112 | 29064.0 |
| 2015-07-28 | EW | Futures | 1533.5 | 1549.6 | 1526.8 | 1547.5 | 17484.0 |
| 2015-07-28 | FBTP | Futures | 100.45 | 100.62 | 100.22 | 100.51 | 48361.0 |
| 2015-07-28 | FBTS | Futures | 99.999 | 100.062 | 99.981 | 100.053 | 13499.0 |
| 2015-07-28 | FCE | Futures | 4129.9 | 4169.1 | 4117.4 | 4150.8 | 69724.0 |
| 2015-07-28 | FDAX | Futures | 12271.2 | 12435.3 | 12233.6 | 12343.0 | 116751.0 |
| 2015-07-28 | FESX | Futures | 2610.2 | 2640.6 | 2605.1 | 2626.5 | 891834.0 |
| 2015-07-28 | FGBL | Futures | 137.29 | 137.33 | 136.75 | 137.25 | 435610.0 |
| 2015-07-28 | FGBM | Futures | 124.52 | 124.6 | 124.38 | 124.59 | 338442.0 |
| 2015-07-28 | FGBS | Futures | 111.198 | 111.228 | 111.178 | 111.228 | 170992.0 |
| 2015-07-28 | FGBX | Futures | 156.52 | 156.64 | 155.18 | 156.41 | 22529.0 |
| 2015-07-28 | FMWO | Futures | 5758.4 | 5770.7 | 5733.8 | 5762.1 | 505.0 |
| 2015-07-28 | FOAT | Futures | 125.79 | 125.8 | 125.33 | 125.72 | 47401.0 |
| 2015-07-28 | FTDX | Futures | 1657.4 | 1678.6 | 1657.4 | 1663.1 | 697.0 |
| 2015-07-28 | FTI | Futures | 414.41 | 418.73 | 413.9 | 416.88 | 27602.0 |
| 2015-07-28 | FTUK | Futures | 5141.0 | 5196.7 | 5141.0 | 5170.5 | 82829.0 |
| 2015-07-28 | FVSA | Futures | 1890.51 | 1890.51 | 1780.86 | 1798.4 | 14900.0 |
| 2015-07-28 | FXXP | Futures | 297.5 | 300.3 | 296.5 | 299.1 | 13407.0 |
| 2015-07-28 | G | Futures | 102.11 | 102.26 | 101.79 | 102.18 | 129927.0 |
| 2015-07-28 | GF | Futures | 354.958 | 360.738 | 354.66 | 359.166 | 3726.0 |
| 2015-07-28 | GSCI | Futures | 633.5 | 642.08 | 632.17 | 638.33 | 11.0 |
| 2015-07-28 | HE | Futures | 86.542 | 89.111 | 85.872 | 88.776 | 10922.0 |
| 2015-07-28 | HG | Futures | 2.9278 | 3.0158 | 2.9272 | 2.9983 | 55533.0 |
> showing 50 of 106 rows — these rows as CSV