PREVIEW / futures_daily / 2015-05-04
file: by_date/futures_daily/2015/2015-05-04.parquet size: 9 KB rows: 101
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-05-04 | ES | Futures | 2209.91 | 2223.84 | 2205.97 | 2217.8 | 1000837.0 |
| 2015-05-04 | NQ | Futures | 5191.85 | 5228.71 | 5174.72 | 5197.36 | 191856.0 |
| 2015-05-04 | YM | Futures | 18348.0 | 18469.8 | 18318.4 | 18406.4 | 97945.0 |
| 2015-05-04 | CL | Futures | 100.69 | 101.42 | 99.25 | 100.06 | 215046.0 |
| 2015-05-04 | GC | Futures | 1539.6 | 1559.8 | 1539.6 | 1552.9 | 107753.0 |
| 2015-05-04 | ZN | Futures | 121.124551 | 121.316953 | 120.858148 | 121.02095 | 880995.0 |
| 2015-05-04 | A6 | Futures | 0.77094 | 0.77262 | 0.76769 | 0.77203 | 54334.0 |
| 2015-05-04 | AD | Futures | 0.83885 | 0.84426 | 0.83783 | 0.84344 | 44128.0 |
| 2015-05-04 | ALI | Futures | 2587.62 | 2587.62 | 2587.62 | 2587.62 | 0.0 |
| 2015-05-04 | B | Futures | 64.0 | 64.59 | 63.52 | 63.99 | 63830.0 |
| 2015-05-04 | B6 | Futures | 1.5935 | 1.5968 | 1.5879 | 1.5912 | 79174.0 |
| 2015-05-04 | BFX | Futures | 4424.1 | 4439.9 | 4424.1 | 4431.4 | 67.0 |
| 2015-05-04 | BR | Futures | 0.18414 | 0.18471 | 0.18263 | 0.18332 | 706.0 |
| 2015-05-04 | BZ | Futures | 63.36 | 63.95 | 62.94 | 63.38 | 11062.0 |
| 2015-05-04 | CB | Futures | 153.333 | 153.94 | 152.929 | 153.92 | 17.0 |
| 2015-05-04 | CC | Futures | 2126.0 | 2132.0 | 2114.0 | 2121.0 | 6205.0 |
| 2015-05-04 | CNH | Futures | 7.0017 | 7.0067 | 6.9992 | 6.9992 | 46.0 |
| 2015-05-04 | CSC | Futures | 4.532 | 4.644 | 4.532 | 4.604 | 89.0 |
| 2015-05-04 | CT | Futures | 83.91 | 84.26 | 82.91 | 83.98 | 13195.0 |
| 2015-05-04 | DC | Futures | 36.84 | 38.41 | 36.84 | 37.9 | 509.0 |
| 2015-05-04 | DX | Futures | 89.578 | 89.935 | 89.371 | 89.8 | 29211.0 |
| 2015-05-04 | E1 | Futures | 1.36744 | 1.37037 | 1.36018 | 1.36578 | 17300.0 |
| 2015-05-04 | E6 | Futures | 1.31692 | 1.32069 | 1.30869 | 1.31057 | 174738.0 |
| 2015-05-04 | E7 | Futures | 1.3093 | 1.313 | 1.301 | 1.303 | 4512.0 |
| 2015-05-04 | EBM | Futures | 285.63 | 285.63 | 280.82 | 282.82 | 13309.0 |
| 2015-05-04 | ED | Futures | 95.5477 | 95.5477 | 95.5381 | 95.5429 | 75366.0 |
| 2015-05-04 | ER | Futures | 98.068 | 98.087 | 98.068 | 98.077 | 37302.0 |
| 2015-05-04 | EW | Futures | 1582.9 | 1596.0 | 1579.6 | 1589.6 | 13805.0 |
| 2015-05-04 | FBTP | Futures | 102.35 | 102.35 | 101.56 | 101.76 | 56990.0 |
| 2015-05-04 | FBTS | Futures | 99.67 | 99.706 | 99.635 | 99.67 | 13065.0 |
| 2015-05-04 | FCE | Futures | 4124.2 | 4173.5 | 4089.6 | 4145.6 | 87502.0 |
| 2015-05-04 | FDAX | Futures | 12798.2 | 12959.1 | 12675.0 | 12928.5 | 88544.0 |
| 2015-05-04 | FESX | Futures | 2632.1 | 2657.1 | 2604.1 | 2643.1 | 797268.0 |
| 2015-05-04 | FGBL | Futures | 139.2 | 139.26 | 138.11 | 138.3 | 632928.0 |
| 2015-05-04 | FGBM | Futures | 124.18 | 124.2 | 123.99 | 124.03 | 473415.0 |
| 2015-05-04 | FGBS | Futures | 111.203 | 111.213 | 111.178 | 111.208 | 236571.0 |
| 2015-05-04 | FGBX | Futures | 169.88 | 170.02 | 166.44 | 166.76 | 34074.0 |
| 2015-05-04 | FMWO | Futures | 5912.4 | 5934.6 | 5911.2 | 5924.8 | 358.0 |
| 2015-05-04 | FOAT | Futures | 128.17 | 128.17 | 127.1 | 127.28 | 62155.0 |
| 2015-05-04 | FTDX | Futures | 1490.8 | 1536.3 | 1490.8 | 1535.4 | 250.0 |
| 2015-05-04 | FTI | Futures | 421.82 | 427.09 | 419.13 | 425.22 | 21968.0 |
| 2015-05-04 | FVSA | Futures | 1784.59 | 1828.12 | 1733.15 | 1760.85 | 8819.0 |
| 2015-05-04 | FXXP | Futures | 301.2 | 304.2 | 299.6 | 302.9 | 11943.0 |
| 2015-05-04 | GF | Futures | 367.588 | 369.951 | 367.545 | 369.736 | 3108.0 |
| 2015-05-04 | GSCI | Futures | 758.68 | 758.68 | 752.46 | 755.7 | 187.0 |
| 2015-05-04 | HE | Futures | 88.028 | 89.222 | 88.001 | 88.869 | 12639.0 |
| 2015-05-04 | HG | Futures | 3.6788 | 3.68 | 3.6292 | 3.6644 | 30412.0 |
| 2015-05-04 | HH | Futures | 33.462 | 34.288 | 33.389 | 34.276 | 1833.0 |
| 2015-05-04 | HO | Futures | 1.6084 | 1.6197 | 1.5962 | 1.6074 | 47120.0 |
| 2015-05-04 | HRC | Futures | 1806.2 | 1806.2 | 1806.2 | 1806.2 | 0.0 |
> showing 50 of 101 rows — these rows as CSV