PREVIEW / futures_daily / 2015-07-09
file: by_date/futures_daily/2015/2015-07-09.parquet size: 9 KB rows: 104
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-09 | ES | Futures | 2161.76 | 2191.7 | 2160.17 | 2163.35 | 1981972.0 |
| 2015-07-09 | NQ | Futures | 5076.08 | 5146.42 | 5057.4 | 5066.45 | 260171.0 |
| 2015-07-09 | YM | Futures | 17914.3 | 18155.7 | 17896.9 | 17923.6 | 200488.0 |
| 2015-07-09 | CL | Futures | 86.57 | 89.42 | 85.98 | 88.15 | 382334.0 |
| 2015-07-09 | GC | Futures | 1511.7 | 1524.0 | 1508.5 | 1513.9 | 130014.0 |
| 2015-07-09 | ZN | Futures | 121.554695 | 121.673925 | 120.660472 | 120.824413 | 1170991.0 |
| 2015-07-09 | A6 | Futures | 0.73316 | 0.7393 | 0.7295 | 0.73465 | 91748.0 |
| 2015-07-09 | AD | Futures | 0.80164 | 0.80655 | 0.80154 | 0.80318 | 63927.0 |
| 2015-07-09 | ALI | Futures | 2305.61 | 2305.61 | 2305.61 | 2305.61 | 0.0 |
| 2015-07-09 | B | Futures | 53.6 | 55.37 | 53.33 | 54.79 | 264472.0 |
| 2015-07-09 | B6 | Futures | 1.6162 | 1.6222 | 1.6142 | 1.6162 | 68421.0 |
| 2015-07-09 | BFX | Futures | 4318.1 | 4341.1 | 4318.1 | 4341.1 | 1.0 |
| 2015-07-09 | BR | Futures | 0.18228 | 0.18354 | 0.18198 | 0.18255 | 492.0 |
| 2015-07-09 | BZ | Futures | 53.3 | 55.32 | 53.3 | 54.76 | 38186.0 |
| 2015-07-09 | C | Futures | 2334.0 | 2359.0 | 2326.0 | 2356.0 | 19619.0 |
| 2015-07-09 | CC | Futures | 2388.0 | 2418.0 | 2382.0 | 2410.0 | 17765.0 |
| 2015-07-09 | CNH | Futures | 7.0169 | 7.0201 | 7.0132 | 7.0182 | 14.0 |
| 2015-07-09 | CSC | Futures | 4.369 | 4.445 | 4.353 | 4.422 | 42.0 |
| 2015-07-09 | CT | Futures | 80.31 | 80.69 | 80.12 | 80.41 | 24.0 |
| 2015-07-09 | DC | Futures | 35.24 | 35.79 | 34.89 | 35.67 | 212.0 |
| 2015-07-09 | DX | Futures | 90.276 | 90.744 | 89.967 | 90.602 | 32281.0 |
| 2015-07-09 | E1 | Futures | 1.34548 | 1.35056 | 1.33735 | 1.34154 | 16421.0 |
| 2015-07-09 | E6 | Futures | 1.30213 | 1.30824 | 1.29238 | 1.29485 | 172849.0 |
| 2015-07-09 | E7 | Futures | 1.2952 | 1.301 | 1.2852 | 1.2877 | 4407.0 |
| 2015-07-09 | EBM | Futures | 322.58 | 323.4 | 320.53 | 322.58 | 14480.0 |
| 2015-07-09 | ED | Futures | 95.6702 | 95.6702 | 95.6558 | 95.6558 | 178459.0 |
| 2015-07-09 | ER | Futures | 98.087 | 98.092 | 98.082 | 98.087 | 29835.0 |
| 2015-07-09 | EW | Futures | 1554.5 | 1571.9 | 1549.2 | 1551.2 | 16987.0 |
| 2015-07-09 | FBTP | Futures | 97.86 | 98.2 | 97.52 | 97.94 | 68022.0 |
| 2015-07-09 | FBTS | Futures | 99.35 | 99.447 | 99.296 | 99.421 | 18944.0 |
| 2015-07-09 | FCE | Futures | 3881.6 | 3981.2 | 3877.4 | 3962.4 | 112766.0 |
| 2015-07-09 | FDAX | Futures | 11946.1 | 12199.8 | 11917.9 | 12175.0 | 109992.0 |
| 2015-07-09 | FESX | Futures | 2471.8 | 2540.7 | 2465.9 | 2530.3 | 1381002.0 |
| 2015-07-09 | FGBL | Futures | 136.67 | 136.86 | 135.87 | 136.19 | 533859.0 |
| 2015-07-09 | FGBM | Futures | 124.35 | 124.4 | 124.22 | 124.31 | 355029.0 |
| 2015-07-09 | FGBS | Futures | 111.268 | 111.278 | 111.253 | 111.258 | 211998.0 |
| 2015-07-09 | FGBX | Futures | 156.07 | 156.29 | 152.52 | 153.31 | 34804.0 |
| 2015-07-09 | FMWO | Futures | 5684.6 | 5716.6 | 5680.9 | 5701.8 | 790.0 |
| 2015-07-09 | FOAT | Futures | 124.02 | 124.12 | 123.6 | 123.67 | 49226.0 |
| 2015-07-09 | FTDX | Futures | 1524.1 | 1550.5 | 1524.1 | 1550.0 | 107.0 |
| 2015-07-09 | FTI | Futures | 401.49 | 411.66 | 401.23 | 410.4 | 38583.0 |
| 2015-07-09 | FTUK | Futures | 5126.7 | 5200.7 | 5124.0 | 5186.0 | 97056.0 |
| 2015-07-09 | FVSA | Futures | 2161.2 | 2161.2 | 2032.42 | 2056.56 | 11154.0 |
| 2015-07-09 | FXXP | Futures | 286.7 | 292.6 | 286.1 | 291.9 | 17399.0 |
| 2015-07-09 | G | Futures | 102.46 | 102.59 | 101.85 | 101.99 | 152642.0 |
| 2015-07-09 | GF | Futures | 363.884 | 365.329 | 358.273 | 360.016 | 8346.0 |
| 2015-07-09 | GSCI | Futures | 695.31 | 697.48 | 692.14 | 693.23 | 2016.0 |
| 2015-07-09 | HE | Futures | 85.118 | 85.202 | 81.543 | 81.851 | 26714.0 |
| 2015-07-09 | HG | Futures | 3.115 | 3.2404 | 3.1038 | 3.1843 | 79042.0 |
| 2015-07-09 | HH | Futures | 32.577 | 33.061 | 31.984 | 32.988 | 1772.0 |
> showing 50 of 104 rows — these rows as CSV