PREVIEW / futures_daily / 2016-05-27
file: by_date/futures_daily/2016/2016-05-27.parquet size: 9 KB rows: 110
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 |
|---|---|---|---|---|---|---|---|
| 2016-05-27 | ES | Futures | 2244.61 | 2253.46 | 2241.92 | 2251.85 | 1035175.0 |
| 2016-05-27 | NQ | Futures | 5280.48 | 5303.39 | 5276.08 | 5299.28 | 153739.0 |
| 2016-05-27 | YM | Futures | 18533.6 | 18573.1 | 18509.7 | 18558.5 | 84723.0 |
| 2016-05-27 | CL | Futures | 57.8 | 58.14 | 57.08 | 57.83 | 406386.0 |
| 2016-05-27 | GC | Futures | 1572.5 | 1577.0 | 1555.4 | 1565.3 | 200002.0 |
| 2016-05-27 | ZN | Futures | 125.359034 | 125.434469 | 125.012029 | 125.328859 | 939608.0 |
| 2016-05-27 | A6 | Futures | 0.73083 | 0.73174 | 0.72547 | 0.7282 | 89527.0 |
| 2016-05-27 | AD | Futures | 0.78791 | 0.78842 | 0.78228 | 0.78607 | 51810.0 |
| 2016-05-27 | ALI | Futures | 2086.91 | 2086.91 | 2086.91 | 2086.91 | 0.0 |
| 2016-05-27 | B | Futures | 40.5 | 40.63 | 39.99 | 40.49 | 228657.0 |
| 2016-05-27 | B6 | Futures | 1.5448 | 1.5468 | 1.538 | 1.5412 | 66009.0 |
| 2016-05-27 | BR | Futures | 0.17996 | 0.18003 | 0.17867 | 0.17943 | 2786.0 |
| 2016-05-27 | BZ | Futures | 40.45 | 40.52 | 39.88 | 40.39 | 19402.0 |
| 2016-05-27 | C | Futures | 2279.0 | 2320.0 | 2279.0 | 2312.0 | 15032.0 |
| 2016-05-27 | CB | Futures | 253.167 | 254.369 | 253.167 | 254.369 | 14.0 |
| 2016-05-27 | CC | Futures | 2162.0 | 2200.0 | 2150.0 | 2198.0 | 35202.0 |
| 2016-05-27 | CNH | Futures | 7.1411 | 7.1469 | 7.1411 | 7.1424 | 2.0 |
| 2016-05-27 | CSC | Futures | 3.34 | 3.361 | 3.325 | 3.325 | 16.0 |
| 2016-05-27 | CT | Futures | 73.18 | 73.47 | 72.32 | 73.12 | 13718.0 |
| 2016-05-27 | DC | Futures | 26.44 | 26.44 | 26.15 | 26.19 | 31.0 |
| 2016-05-27 | DX | Futures | 88.71 | 89.288 | 88.64 | 89.036 | 18434.0 |
| 2016-05-27 | E1 | Futures | 1.27067 | 1.27155 | 1.2635 | 1.26753 | 16720.0 |
| 2016-05-27 | E6 | Futures | 1.30584 | 1.30683 | 1.29634 | 1.2996 | 138986.0 |
| 2016-05-27 | E7 | Futures | 1.2989 | 1.2998 | 1.2892 | 1.2926 | 2916.0 |
| 2016-05-27 | EBM | Futures | 200.88 | 201.48 | 199.38 | 200.88 | 14387.0 |
| 2016-05-27 | ED | Futures | 95.6967 | 95.6967 | 95.6654 | 95.6846 | 243134.0 |
| 2016-05-27 | ER | Futures | 98.259 | 98.269 | 98.259 | 98.264 | 89213.0 |
| 2016-05-27 | EW | Futures | 1567.5 | 1578.0 | 1563.9 | 1575.9 | 14702.0 |
| 2016-05-27 | FBON | Futures | 119.24 | 119.32 | 119.16 | 119.2 | 219.0 |
| 2016-05-27 | FBTP | Futures | 107.2 | 107.43 | 107.16 | 107.22 | 76714.0 |
| 2016-05-27 | FBTS | Futures | 101.167 | 101.176 | 101.158 | 101.167 | 12875.0 |
| 2016-05-27 | FCE | Futures | 3855.5 | 3867.2 | 3841.8 | 3861.1 | 52261.0 |
| 2016-05-27 | FDAX | Futures | 11042.8 | 11072.3 | 11001.4 | 11034.2 | 58869.0 |
| 2016-05-27 | FDIV | Futures | 134.46 | 134.56 | 134.46 | 134.56 | 40.0 |
| 2016-05-27 | FDXM | Futures | 10629.2 | 10660.2 | 10594.0 | 10625.1 | 10420.0 |
| 2016-05-27 | FESX | Futures | 2386.8 | 2396.9 | 2378.2 | 2390.7 | 843068.0 |
| 2016-05-27 | FEU3 | Futures | 98.922 | 98.922 | 98.917 | 98.917 | 620.0 |
| 2016-05-27 | FGBL | Futures | 146.72 | 147.01 | 146.59 | 146.68 | 494314.0 |
| 2016-05-27 | FGBM | Futures | 127.78 | 127.82 | 127.74 | 127.76 | 322000.0 |
| 2016-05-27 | FGBS | Futures | 111.688 | 111.708 | 111.683 | 111.688 | 174513.0 |
| 2016-05-27 | FGBX | Futures | 173.74 | 174.59 | 173.1 | 173.58 | 31456.0 |
| 2016-05-27 | FMWO | Futures | 5699.9 | 5708.6 | 5695.0 | 5704.9 | 186.0 |
| 2016-05-27 | FOAT | Futures | 134.25 | 134.58 | 134.2 | 134.26 | 65103.0 |
| 2016-05-27 | FTDX | Futures | 1610.9 | 1619.4 | 1605.2 | 1609.9 | 47.0 |
| 2016-05-27 | FTI | Futures | 403.17 | 405.47 | 401.96 | 404.75 | 21713.0 |
| 2016-05-27 | FTUK | Futures | 5160.8 | 5169.1 | 5146.4 | 5158.7 | 68910.0 |
| 2016-05-27 | FVSA | Futures | 2289.94 | 2289.94 | 2248.05 | 2271.32 | 10691.0 |
| 2016-05-27 | FXXP | Futures | 279.5 | 280.5 | 278.8 | 280.0 | 21441.0 |
| 2016-05-27 | G | Futures | 109.0 | 109.02 | 108.58 | 108.63 | 147756.0 |
| 2016-05-27 | GF | Futures | 290.838 | 293.235 | 290.639 | 292.935 | 3535.0 |
> showing 50 of 110 rows — these rows as CSV