PREVIEW / etf_daily / 2015-11-25
file: by_date/etf_daily/2015/2015-11-25.parquet size: 48 KB rows: 1,208
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-11-25 | SPY | ETF | 209.5 | 209.74 | 209.01 | 209.32 | 51980100.0 |
| 2015-11-25 | QQQ | ETF | 114.19 | 114.36 | 113.91 | 114.15 | 14159935.0 |
| 2015-11-25 | IWM | ETF | 118.3 | 119.32 | 118.11 | 119.17 | 20772600.0 |
| 2015-11-25 | DIA | ETF | 178.01 | 178.33 | 177.79 | 177.93 | 2227400.0 |
| 2015-11-25 | GLD | ETF | 102.47 | 102.69 | 102.21 | 102.46 | 2931300.0 |
| 2015-11-25 | TLT | ETF | 121.17 | 121.42 | 120.95 | 121.09 | 3280900.0 |
| 2015-11-25 | AADR | ETF | 39.32 | 39.47 | 39.3 | 39.47 | 2000.0 |
| 2015-11-25 | AAXJ | ETF | 56.18 | 56.27 | 55.97 | 56.19 | 251000.0 |
| 2015-11-25 | ACTX | ETF | 4.72 | 5.31 | 4.13 | 4.13 | 3441.0 |
| 2015-11-25 | ACWF | ETF | 23.91 | 24.0 | 23.91 | 24.0 | 1882.0 |
| 2015-11-25 | ACWI | ETF | 58.07 | 58.12 | 57.84 | 58.01 | 1748200.0 |
| 2015-11-25 | ACWV | ETF | 70.39 | 70.46 | 70.3 | 70.37 | 71900.0 |
| 2015-11-25 | ACWX | ETF | 41.23 | 41.37 | 41.19 | 41.295 | 1437900.0 |
| 2015-11-25 | ADRE | ETF | 30.78 | 30.89 | 30.66 | 30.67 | 5501.0 |
| 2015-11-25 | AFK | ETF | 18.9 | 18.99 | 18.7701 | 18.96 | 10086.0 |
| 2015-11-25 | AFTY | ETF | 17.0 | 17.03 | 16.93 | 17.0 | 15700.0 |
| 2015-11-25 | AGG | ETF | 108.77 | 108.84 | 108.69 | 108.8 | 1169300.0 |
| 2015-11-25 | AGGY | ETF | 49.4 | 49.54 | 49.36 | 49.49 | 8600.0 |
| 2015-11-25 | AGQ | ETF | 28.31 | 28.87 | 28.23 | 28.78 | 230400.0 |
| 2015-11-25 | AGZ | ETF | 113.402 | 113.4399 | 113.16 | 113.4 | 12152.0 |
| 2015-11-25 | AGZD | ETF | 24.095 | 24.095 | 23.975 | 24.01 | 27600.0 |
| 2015-11-25 | AIA | ETF | 45.09 | 45.0999 | 44.93 | 45.07 | 42772.0 |
| 2015-11-25 | AIQ | ETF | 9.3 | 9.4703 | 9.15 | 9.22 | 25036.0 |
| 2015-11-25 | AIRR | ETF | 17.71 | 17.71 | 17.71 | 17.71 | 100.0 |
| 2015-11-25 | AIVI | ETF | 39.4 | 39.56 | 39.3 | 39.44 | 21700.0 |
| 2015-11-25 | AMJ | ETF | 30.24 | 30.58 | 29.84 | 30.21 | 3377590.0 |
| 2015-11-25 | AMLP | ETF | 61.55 | 62.3 | 60.85 | 61.6 | 1524480.0 |
| 2015-11-25 | AMZA | ETF | 125.6 | 127.5 | 124.82 | 127.3 | 680.0 |
| 2015-11-25 | ANGL | ETF | 25.38 | 25.45 | 25.38 | 25.45 | 12700.0 |
| 2015-11-25 | AOA | ETF | 46.18 | 46.18 | 45.98 | 46.08 | 79800.0 |
| 2015-11-25 | AOK | ETF | 32.12 | 32.12 | 32.06 | 32.0962 | 35709.0 |
| 2015-11-25 | AOM | ETF | 34.61 | 34.73 | 34.61 | 34.69 | 100155.0 |
| 2015-11-25 | AOR | ETF | 39.73 | 39.73 | 39.6104 | 39.69 | 404394.0 |
| 2015-11-25 | ARGT | ETF | 19.09 | 19.09 | 18.67 | 18.75 | 37000.0 |
| 2015-11-25 | ARKG | ETF | 20.37 | 20.37 | 20.37 | 20.37 | 200.0 |
| 2015-11-25 | ARKK | ETF | 20.81 | 20.9 | 20.81 | 20.9 | 200.0 |
| 2015-11-25 | ARKQ | ETF | 19.464 | 19.48 | 19.43 | 19.43 | 2200.0 |
| 2015-11-25 | ARKW | ETF | 23.81 | 23.94 | 23.73 | 23.9 | 2700.0 |
| 2015-11-25 | ASEA | ETF | 12.97 | 12.99 | 12.97 | 12.99 | 500.0 |
| 2015-11-25 | ASET | ETF | 25.0 | 25.0 | 25.0 | 25.0 | 500.0 |
| 2015-11-25 | ASHR | ETF | 37.9 | 37.92 | 37.69 | 37.85 | 813700.0 |
| 2015-11-25 | ASHS | ETF | 48.28 | 48.28 | 47.89 | 48.23 | 37000.0 |
| 2015-11-25 | ASHX | ETF | 26.63 | 26.63 | 26.63 | 26.63 | 409.0 |
| 2015-11-25 | ATMP | ETF | 20.2 | 20.33 | 19.83 | 20.15 | 96700.0 |
| 2015-11-25 | AWAY | ETF | 34.9 | 35.58 | 34.9 | 35.49 | 1574327.0 |
| 2015-11-25 | BAB | ETF | 29.09 | 29.16 | 29.07 | 29.12 | 48731.0 |
| 2015-11-25 | BAL | ETF | 41.61 | 42.24 | 41.61 | 42.07 | 2090.0 |
| 2015-11-25 | BBC | ETF | 30.68 | 31.62 | 30.68 | 31.5 | 49719.0 |
| 2015-11-25 | BBH | ETF | 125.76 | 126.65 | 125.69 | 126.44 | 30200.0 |
| 2015-11-25 | BBP | ETF | 31.25 | 31.815 | 31.25 | 31.75 | 27500.0 |
> showing 50 of 1,208 rows — these rows as CSV