PREVIEW / etf_daily / 2015-12-03
file: by_date/etf_daily/2015/2015-12-03.parquet size: 50 KB rows: 1,242
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-12-03 | SPY | ETF | 208.83 | 209.15 | 204.75 | 205.61 | 166224200.0 |
| 2015-12-03 | QQQ | ETF | 114.76 | 114.96 | 111.8432 | 112.51 | 42754345.0 |
| 2015-12-03 | IWM | ETF | 118.93 | 119.45 | 116.14 | 116.6 | 39485400.0 |
| 2015-12-03 | DIA | ETF | 177.66 | 177.84 | 174.26 | 174.83 | 7005500.0 |
| 2015-12-03 | GLD | ETF | 101.23 | 101.97 | 100.85 | 101.76 | 6499900.0 |
| 2015-12-03 | TLT | ETF | 121.36 | 121.4 | 118.99 | 119.53 | 16612200.0 |
| 2015-12-03 | AADR | ETF | 39.39 | 39.39 | 39.15 | 39.15 | 400.0 |
| 2015-12-03 | AAXJ | ETF | 55.55 | 55.55 | 54.76 | 54.97 | 1378600.0 |
| 2015-12-03 | ACTX | ETF | 8.2601 | 10.0301 | 7.0801 | 8.8501 | 2276.0 |
| 2015-12-03 | ACWF | ETF | 23.88 | 23.9 | 23.634 | 23.634 | 6910.0 |
| 2015-12-03 | ACWI | ETF | 57.9 | 57.94 | 56.9 | 57.1 | 3196900.0 |
| 2015-12-03 | ACWV | ETF | 70.13 | 70.13 | 69.14 | 69.38 | 134900.0 |
| 2015-12-03 | ACWX | ETF | 41.32 | 41.32 | 40.67 | 40.89 | 1655853.0 |
| 2015-12-03 | ADRE | ETF | 30.92 | 30.92 | 30.4001 | 30.41 | 4857.0 |
| 2015-12-03 | AFK | ETF | 19.01 | 19.04 | 18.8 | 18.8621 | 29110.0 |
| 2015-12-03 | AFTY | ETF | 17.03 | 17.03 | 16.95 | 16.95 | 36400.0 |
| 2015-12-03 | AGG | ETF | 108.41 | 108.41 | 107.81 | 107.89 | 4634100.0 |
| 2015-12-03 | AGQ | ETF | 28.32 | 28.61 | 27.86 | 28.45 | 123000.0 |
| 2015-12-03 | AGZ | ETF | 113.17 | 113.17 | 112.7871 | 112.84 | 10487.0 |
| 2015-12-03 | AGZD | ETF | 24.055 | 24.08 | 23.985 | 24.04 | 4400.0 |
| 2015-12-03 | AIA | ETF | 44.5996 | 44.5996 | 44.08 | 44.28 | 12913.0 |
| 2015-12-03 | AIQ | ETF | 9.47 | 9.48 | 8.785 | 8.95 | 30934.0 |
| 2015-12-03 | AIRR | ETF | 17.95 | 18.05 | 17.73 | 17.745 | 1300.0 |
| 2015-12-03 | AIVI | ETF | 39.68 | 39.68 | 39.05 | 39.14 | 22000.0 |
| 2015-12-03 | ALTY | ETF | 14.15 | 14.19 | 14.15 | 14.19 | 400.0 |
| 2015-12-03 | AMJ | ETF | 28.8 | 29.04 | 27.63 | 27.75 | 7532618.0 |
| 2015-12-03 | AMLP | ETF | 59.05 | 59.45 | 56.45 | 56.6 | 3957460.0 |
| 2015-12-03 | AMZA | ETF | 118.5 | 118.5 | 111.35 | 113.0 | 4420.0 |
| 2015-12-03 | ANGL | ETF | 25.44 | 25.44 | 25.23 | 25.34 | 24700.0 |
| 2015-12-03 | AOA | ETF | 46.13 | 46.14 | 45.41 | 45.55 | 323200.0 |
| 2015-12-03 | AOK | ETF | 32.14 | 32.14 | 31.76 | 31.85 | 119935.0 |
| 2015-12-03 | AOM | ETF | 34.74 | 34.76 | 34.3432 | 34.41 | 225923.0 |
| 2015-12-03 | AOR | ETF | 39.81 | 39.81 | 39.21 | 39.32 | 264818.0 |
| 2015-12-03 | ARGT | ETF | 18.48 | 18.65 | 18.27 | 18.27 | 17800.0 |
| 2015-12-03 | ARKG | ETF | 20.26 | 20.26 | 19.81 | 19.81 | 400.0 |
| 2015-12-03 | ARKK | ETF | 20.88 | 20.915 | 20.85 | 20.85 | 500.0 |
| 2015-12-03 | ARKQ | ETF | 19.6 | 19.6 | 19.6 | 19.6 | 300.0 |
| 2015-12-03 | ARKW | ETF | 24.34 | 24.47 | 23.7 | 23.73 | 7500.0 |
| 2015-12-03 | ASEA | ETF | 12.82 | 12.82 | 12.75 | 12.75 | 1100.0 |
| 2015-12-03 | ASET | ETF | 24.67 | 24.67 | 24.67 | 24.67 | 500.0 |
| 2015-12-03 | ASHR | ETF | 37.15 | 37.23 | 36.88 | 36.97 | 1335700.0 |
| 2015-12-03 | ASHS | ETF | 45.41 | 45.95 | 45.31 | 45.48 | 63900.0 |
| 2015-12-03 | ASHX | ETF | 26.2801 | 26.2801 | 26.08 | 26.09 | 1009.0 |
| 2015-12-03 | ATMP | ETF | 18.98 | 19.18 | 18.26 | 18.3 | 488300.0 |
| 2015-12-03 | AWAY | ETF | 35.19 | 35.83 | 35.07 | 35.2 | 2702737.0 |
| 2015-12-03 | BAB | ETF | 29.31 | 29.31 | 28.95 | 29.04 | 85955.0 |
| 2015-12-03 | BAL | ETF | 42.34 | 42.7905 | 42.34 | 42.56 | 4327.0 |
| 2015-12-03 | BBC | ETF | 31.6 | 31.6 | 29.85 | 30.05 | 10049.0 |
| 2015-12-03 | BBH | ETF | 124.81 | 124.81 | 119.45 | 120.07 | 78100.0 |
| 2015-12-03 | BBP | ETF | 31.2 | 31.34 | 30.337 | 30.35 | 5400.0 |
> showing 50 of 1,242 rows — these rows as CSV