PREVIEW / futures_daily / 2017-05-24
file: by_date/futures_daily/2017/2017-05-24.parquet size: 9 KB rows: 109
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 |
|---|---|---|---|---|---|---|---|
| 2017-05-24 | ES | Futures | 2603.25 | 2610.85 | 2600.8 | 2608.68 | 984358.0 |
| 2017-05-24 | NQ | Futures | 6724.59 | 6754.03 | 6719.58 | 6750.21 | 191514.0 |
| 2017-05-24 | YM | Futures | 22060.4 | 22156.4 | 22046.7 | 22142.7 | 95790.0 |
| 2017-05-24 | CL | Futures | 53.28 | 53.74 | 52.86 | 53.2 | 736341.0 |
| 2017-05-24 | GC | Futures | 1599.9 | 1609.8 | 1595.4 | 1602.5 | 257358.0 |
| 2017-05-24 | ZN | Futures | 123.766822 | 124.104815 | 123.659279 | 123.951182 | 2304901.0 |
| 2017-05-24 | A6 | Futures | 0.76716 | 0.77034 | 0.76367 | 0.76798 | 81061.0 |
| 2017-05-24 | AD | Futures | 0.75498 | 0.76115 | 0.75345 | 0.75947 | 78259.0 |
| 2017-05-24 | ALI | Futures | 2568.37 | 2568.37 | 2568.37 | 2568.37 | 0.0 |
| 2017-05-24 | B | Futures | 38.83 | 39.17 | 38.48 | 38.7 | 351635.0 |
| 2017-05-24 | B6 | Futures | 1.36 | 1.3637 | 1.3561 | 1.3584 | 94180.0 |
| 2017-05-24 | BR | Futures | 0.22053 | 0.22241 | 0.21858 | 0.22111 | 1845.0 |
| 2017-05-24 | BZ | Futures | 38.59 | 38.89 | 38.22 | 38.42 | 52627.0 |
| 2017-05-24 | C | Futures | 1557.0 | 1566.0 | 1473.0 | 1485.0 | 18048.0 |
| 2017-05-24 | CB | Futures | 298.663 | 300.457 | 298.359 | 300.457 | 24.0 |
| 2017-05-24 | CC | Futures | 1526.0 | 1528.0 | 1439.0 | 1448.0 | 33070.0 |
| 2017-05-24 | CNH | Futures | 7.1872 | 7.1909 | 7.1783 | 7.1784 | 21.0 |
| 2017-05-24 | CSC | Futures | 3.616 | 3.632 | 3.603 | 3.618 | 11.0 |
| 2017-05-24 | CT | Futures | 85.68 | 87.18 | 85.39 | 85.87 | 17042.0 |
| 2017-05-24 | DC | Futures | 30.39 | 30.67 | 30.2 | 30.29 | 351.0 |
| 2017-05-24 | DX | Futures | 90.67 | 90.721 | 90.32 | 90.508 | 31819.0 |
| 2017-05-24 | E1 | Futures | 1.26776 | 1.27147 | 1.26541 | 1.26862 | 25694.0 |
| 2017-05-24 | E6 | Futures | 1.28969 | 1.29418 | 1.28802 | 1.29147 | 193571.0 |
| 2017-05-24 | E7 | Futures | 1.2831 | 1.2875 | 1.2814 | 1.2849 | 4065.0 |
| 2017-05-24 | EBM | Futures | 185.39 | 186.23 | 185.39 | 185.95 | 9126.0 |
| 2017-05-24 | ED | Futures | 95.5857 | 95.5978 | 95.5833 | 95.5881 | 334457.0 |
| 2017-05-24 | ER | Futures | 98.337 | 98.337 | 98.332 | 98.332 | 21156.0 |
| 2017-05-24 | EW | Futures | 1830.3 | 1839.0 | 1827.4 | 1835.4 | 11414.0 |
| 2017-05-24 | FBON | Futures | 122.85 | 123.1 | 122.75 | 122.91 | 578.0 |
| 2017-05-24 | FBTP | Futures | 107.17 | 107.38 | 107.04 | 107.08 | 97084.0 |
| 2017-05-24 | FBTS | Futures | 102.507 | 102.535 | 102.498 | 102.507 | 23492.0 |
| 2017-05-24 | FCE | Futures | 4761.8 | 4770.8 | 4745.7 | 4758.7 | 55616.0 |
| 2017-05-24 | FDAX | Futures | 13347.3 | 13366.3 | 13313.5 | 13334.6 | 58953.0 |
| 2017-05-24 | FDXM | Futures | 13237.4 | 13247.8 | 13196.6 | 13217.5 | 15899.0 |
| 2017-05-24 | FESX | Futures | 2920.6 | 2925.5 | 2908.3 | 2912.4 | 527317.0 |
| 2017-05-24 | FGBL | Futures | 147.78 | 148.09 | 147.67 | 147.78 | 666179.0 |
| 2017-05-24 | FGBM | Futures | 129.11 | 129.25 | 129.05 | 129.15 | 458089.0 |
| 2017-05-24 | FGBS | Futures | 112.207 | 112.242 | 112.197 | 112.227 | 193881.0 |
| 2017-05-24 | FGBX | Futures | 164.99 | 166.05 | 164.91 | 165.13 | 41404.0 |
| 2017-05-24 | FMWO | Futures | 6414.5 | 6414.5 | 6408.5 | 6412.1 | 663.0 |
| 2017-05-24 | FOAT | Futures | 134.4 | 134.69 | 134.34 | 134.4 | 116102.0 |
| 2017-05-24 | FTDX | Futures | 2187.6 | 2210.2 | 2187.6 | 2208.2 | 757.0 |
| 2017-05-24 | FTI | Futures | 483.91 | 484.79 | 482.72 | 483.64 | 15336.0 |
| 2017-05-24 | FTUK | Futures | 6409.3 | 6423.0 | 6382.3 | 6415.3 | 85109.0 |
| 2017-05-24 | FVSA | Futures | 521.44 | 528.21 | 509.59 | 521.44 | 8357.0 |
| 2017-05-24 | FXXP | Futures | 330.2 | 330.7 | 329.6 | 330.1 | 32844.0 |
| 2017-05-24 | G | Futures | 115.8 | 116.11 | 115.75 | 115.95 | 479902.0 |
| 2017-05-24 | GF | Futures | 330.924 | 331.528 | 322.967 | 326.369 | 7456.0 |
| 2017-05-24 | GSCI | Futures | 483.93 | 483.93 | 481.78 | 481.96 | 25.0 |
| 2017-05-24 | HE | Futures | 87.096 | 87.583 | 86.582 | 86.772 | 6090.0 |
> showing 50 of 109 rows — these rows as CSV