PREVIEW / futures_daily / 2015-06-05
file: by_date/futures_daily/2015/2015-06-05.parquet size: 9 KB rows: 107
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-06-05 | ES | Futures | 2206.76 | 2210.96 | 2190.72 | 2199.92 | 1460654.0 |
| 2015-06-05 | NQ | Futures | 5218.55 | 5232.19 | 5165.72 | 5203.17 | 232923.0 |
| 2015-06-05 | YM | Futures | 18333.7 | 18363.4 | 18215.1 | 18249.9 | 179950.0 |
| 2015-06-05 | CL | Futures | 97.45 | 99.54 | 95.5 | 99.37 | 461016.0 |
| 2015-06-05 | GC | Futures | 1536.5 | 1538.5 | 1517.7 | 1525.5 | 150679.0 |
| 2015-06-05 | ZN | Futures | 119.999738 | 119.999738 | 118.904526 | 119.28933 | 37382.0 |
| 2015-06-05 | A6 | Futures | 0.75684 | 0.76463 | 0.74915 | 0.75112 | 88503.0 |
| 2015-06-05 | AD | Futures | 0.81628 | 0.82149 | 0.81271 | 0.82047 | 83626.0 |
| 2015-06-05 | ALI | Futures | 2372.77 | 2372.77 | 2372.77 | 2372.77 | 0.0 |
| 2015-06-05 | B | Futures | 58.89 | 60.32 | 58.02 | 60.21 | 161461.0 |
| 2015-06-05 | B6 | Futures | 1.6164 | 1.6186 | 1.5989 | 1.6078 | 101262.0 |
| 2015-06-05 | BFX | Futures | 4439.0 | 4439.0 | 4410.9 | 4410.9 | 5.0 |
| 2015-06-05 | BR | Futures | 0.18483 | 0.18635 | 0.18378 | 0.18453 | 173.0 |
| 2015-06-05 | BZ | Futures | 59.27 | 60.44 | 58.17 | 60.33 | 10724.0 |
| 2015-06-05 | C | Futures | 2275.0 | 2285.0 | 2251.0 | 2282.0 | 11536.0 |
| 2015-06-05 | CB | Futures | 161.304 | 162.074 | 159.541 | 160.96 | 35.0 |
| 2015-06-05 | CC | Futures | 2285.0 | 2291.0 | 2253.0 | 2289.0 | 16407.0 |
| 2015-06-05 | CNH | Futures | 6.9777 | 6.9814 | 6.9777 | 6.9814 | 10.0 |
| 2015-06-05 | CSC | Futures | 4.584 | 4.584 | 4.559 | 4.571 | 32.0 |
| 2015-06-05 | CT | Futures | 82.03 | 82.13 | 80.53 | 80.63 | 17901.0 |
| 2015-06-05 | DC | Futures | 37.21 | 37.3 | 36.93 | 37.11 | 41.0 |
| 2015-06-05 | DX | Futures | 89.874 | 91.038 | 89.428 | 90.48 | 74992.0 |
| 2015-06-05 | E1 | Futures | 1.36502 | 1.37063 | 1.34144 | 1.35686 | 32753.0 |
| 2015-06-05 | E6 | Futures | 1.32033 | 1.3268 | 1.2994 | 1.30763 | 341863.0 |
| 2015-06-05 | E7 | Futures | 1.3122 | 1.3232 | 1.2919 | 1.3001 | 8343.0 |
| 2015-06-05 | EBM | Futures | 300.86 | 306.19 | 300.86 | 302.5 | 13603.0 |
| 2015-06-05 | ED | Futures | 95.5645 | 95.5669 | 95.5597 | 95.5621 | 162249.0 |
| 2015-06-05 | ER | Futures | 98.077 | 98.082 | 98.073 | 98.077 | 29497.0 |
| 2015-06-05 | EW | Futures | 1596.3 | 1601.1 | 1582.2 | 1600.3 | 15342.0 |
| 2015-06-05 | FBTP | Futures | 97.59 | 97.77 | 96.95 | 97.13 | 121936.0 |
| 2015-06-05 | FBTS | Futures | 99.75 | 99.75 | 99.679 | 99.706 | 31001.0 |
| 2015-06-05 | FCE | Futures | 4102.5 | 4114.1 | 4051.0 | 4074.2 | 122655.0 |
| 2015-06-05 | FDAX | Futures | 12487.0 | 12526.9 | 12358.8 | 12442.0 | 105960.0 |
| 2015-06-05 | FESX | Futures | 2594.5 | 2604.1 | 2570.2 | 2585.6 | 1093754.0 |
| 2015-06-05 | FEU3 | Futures | 98.715 | 98.72 | 98.715 | 98.72 | 75.0 |
| 2015-06-05 | FGBL | Futures | 134.63 | 134.83 | 133.68 | 134.79 | 961512.0 |
| 2015-06-05 | FGBM | Futures | 123.52 | 123.58 | 123.15 | 123.56 | 664477.0 |
| 2015-06-05 | FGBS | Futures | 111.143 | 111.148 | 111.078 | 111.103 | 373439.0 |
| 2015-06-05 | FGBX | Futures | 153.43 | 153.67 | 149.74 | 152.64 | 41551.0 |
| 2015-06-05 | FMWO | Futures | 5850.8 | 5850.8 | 5821.2 | 5839.7 | 31.0 |
| 2015-06-05 | FOAT | Futures | 123.52 | 123.68 | 122.52 | 123.46 | 165057.0 |
| 2015-06-05 | FTDX | Futures | 1584.7 | 1584.7 | 1565.0 | 1569.7 | 200.0 |
| 2015-06-05 | FTI | Futures | 420.6 | 421.34 | 415.68 | 417.79 | 43548.0 |
| 2015-06-05 | FTUK | Futures | 5388.0 | 5394.0 | 5341.1 | 5362.0 | 108252.0 |
| 2015-06-05 | FVSA | Futures | 1781.94 | 1820.59 | 1770.34 | 1797.4 | 13505.0 |
| 2015-06-05 | FXXP | Futures | 299.8 | 300.3 | 296.6 | 298.6 | 10175.0 |
| 2015-06-05 | G | Futures | 101.25 | 101.29 | 100.55 | 100.9 | 161518.0 |
| 2015-06-05 | GF | Futures | 378.803 | 380.121 | 374.807 | 377.273 | 4426.0 |
| 2015-06-05 | GSCI | Futures | 729.02 | 736.33 | 720.27 | 735.73 | 1648.0 |
| 2015-06-05 | HE | Futures | 87.561 | 89.057 | 87.452 | 88.241 | 19116.0 |
> showing 50 of 107 rows — these rows as CSV