PREVIEW / futures_daily / 2014-06-04
file: by_date/futures_daily/2014/2014-06-04.parquet size: 9 KB rows: 105
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 |
|---|---|---|---|---|---|---|---|
| 2014-06-04 | ES | Futures | 1989.35 | 1993.75 | 1982.37 | 1992.45 | 917108.0 |
| 2014-06-04 | NQ | Futures | 4296.79 | 4315.78 | 4275.2 | 4308.87 | 188803.0 |
| 2014-06-04 | YM | Futures | 16783.5 | 16801.6 | 16730.3 | 16786.5 | 83973.0 |
| 2014-06-04 | CL | Futures | 186.97 | 188.61 | 186.15 | 186.7 | 208540.0 |
| 2014-06-04 | GC | Futures | 1640.3 | 1646.3 | 1637.5 | 1639.5 | 76990.0 |
| 2014-06-04 | ZN | Futures | 116.083686 | 116.315477 | 115.938817 | 116.040226 | 51300.0 |
| 2014-06-04 | A6 | Futures | 0.88943 | 0.89299 | 0.88809 | 0.89059 | 61724.0 |
| 2014-06-04 | AD | Futures | 0.92921 | 0.92921 | 0.92526 | 0.92688 | 57607.0 |
| 2014-06-04 | ALI | Futures | 2753.58 | 2753.58 | 2753.58 | 2753.58 | 0.0 |
| 2014-06-04 | B | Futures | 113.24 | 113.82 | 112.38 | 112.74 | 167922.0 |
| 2014-06-04 | B6 | Futures | 1.7604 | 1.7623 | 1.7549 | 1.7596 | 73953.0 |
| 2014-06-04 | BFX | Futures | 3808.2 | 3808.6 | 3808.2 | 3808.6 | 4.0 |
| 2014-06-04 | BR | Futures | 0.22577 | 0.22664 | 0.22453 | 0.2254 | 542.0 |
| 2014-06-04 | BZ | Futures | 114.2 | 114.83 | 113.59 | 113.73 | 12910.0 |
| 2014-06-04 | C | Futures | 2019.0 | 2039.0 | 2018.0 | 2035.0 | 14346.0 |
| 2014-06-04 | CB | Futures | 107.989 | 109.834 | 107.989 | 108.716 | 14.0 |
| 2014-06-04 | CC | Futures | 2264.0 | 2276.0 | 2255.0 | 2268.0 | 16091.0 |
| 2014-06-04 | CSC | Futures | 4.43 | 4.466 | 4.424 | 4.424 | 58.0 |
| 2014-06-04 | CT | Futures | 98.49 | 98.89 | 96.75 | 96.93 | 16318.0 |
| 2014-06-04 | DC | Futures | 35.22 | 35.25 | 34.91 | 35.04 | 37.0 |
| 2014-06-04 | DX | Futures | 76.572 | 76.681 | 76.487 | 76.673 | 13360.0 |
| 2014-06-04 | E1 | Futures | 1.4316 | 1.43417 | 1.42891 | 1.43058 | 26408.0 |
| 2014-06-04 | E6 | Futures | 1.60861 | 1.61014 | 1.60506 | 1.60542 | 149928.0 |
| 2014-06-04 | E7 | Futures | 1.5979 | 1.5995 | 1.5944 | 1.5947 | 1809.0 |
| 2014-06-04 | ED | Futures | 95.4114 | 95.4138 | 95.4091 | 95.4138 | 91117.0 |
| 2014-06-04 | ER | Futures | 97.881 | 97.896 | 97.876 | 97.886 | 132412.0 |
| 2014-06-04 | EW | Futures | 1425.1 | 1432.4 | 1419.6 | 1431.9 | 11044.0 |
| 2014-06-04 | FBTP | Futures | 89.45 | 89.67 | 89.38 | 89.48 | 106503.0 |
| 2014-06-04 | FBTS | Futures | 97.548 | 97.654 | 97.548 | 97.627 | 29614.0 |
| 2014-06-04 | FCE | Futures | 3590.0 | 3598.0 | 3566.1 | 3591.2 | 89084.0 |
| 2014-06-04 | FDAX | Futures | 10931.6 | 10979.6 | 10897.3 | 10965.3 | 73794.0 |
| 2014-06-04 | FESX | Futures | 2323.2 | 2330.4 | 2310.2 | 2326.1 | 659204.0 |
| 2014-06-04 | FEU3 | Futures | 98.507 | 98.512 | 98.507 | 98.512 | 2.0 |
| 2014-06-04 | FGBL | Futures | 126.04 | 126.21 | 125.83 | 125.93 | 1184002.0 |
| 2014-06-04 | FGBM | Futures | 120.8 | 120.89 | 120.75 | 120.78 | 930096.0 |
| 2014-06-04 | FGBS | Futures | 110.738 | 110.778 | 110.738 | 110.748 | 577720.0 |
| 2014-06-04 | FGBX | Futures | 130.28 | 130.69 | 129.88 | 130.1 | 52406.0 |
| 2014-06-04 | FMWO | Futures | 5695.7 | 5709.6 | 5693.2 | 5709.6 | 75.0 |
| 2014-06-04 | FOAT | Futures | 115.38 | 115.65 | 115.19 | 115.28 | 174040.0 |
| 2014-06-04 | FTDX | Futures | 1208.4 | 1229.5 | 1200.5 | 1220.6 | 485.0 |
| 2014-06-04 | FTI | Futures | 352.05 | 353.04 | 350.97 | 352.31 | 19731.0 |
| 2014-06-04 | FTUK | Futures | 5209.5 | 5211.0 | 5178.2 | 5190.8 | 65093.0 |
| 2014-06-04 | FVSA | Futures | 1592.35 | 1606.36 | 1550.32 | 1554.99 | 13133.0 |
| 2014-06-04 | FXXP | Futures | 257.0 | 257.8 | 256.6 | 257.5 | 6142.0 |
| 2014-06-04 | G | Futures | 93.84 | 93.85 | 93.29 | 93.4 | 154437.0 |
| 2014-06-04 | GF | Futures | 304.067 | 305.331 | 302.343 | 304.642 | 3277.0 |
| 2014-06-04 | GSCI | Futures | 1074.45 | 1076.03 | 1069.48 | 1069.81 | 176.0 |
| 2014-06-04 | HE | Futures | 128.682 | 128.708 | 126.788 | 127.84 | 15517.0 |
| 2014-06-04 | HG | Futures | 4.0116 | 4.0154 | 3.9413 | 3.9522 | 50130.0 |
| 2014-06-04 | HH | Futures | 58.159 | 58.945 | 58.007 | 58.818 | 1286.0 |
> showing 50 of 105 rows — these rows as CSV