PREVIEW / etf_daily / 2015-02-25
file: by_date/etf_daily/2015/2015-02-25.parquet size: 48 KB rows: 1,171
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-02-25 | SPY | ETF | 211.66 | 212.24 | 211.22 | 211.63 | 73061700.0 |
| 2015-02-25 | QQQ | ETF | 108.44 | 108.86 | 108.09 | 108.33 | 19472341.0 |
| 2015-02-25 | IWM | ETF | 122.57 | 123.04 | 122.23 | 122.8 | 17059600.0 |
| 2015-02-25 | DIA | ETF | 181.81 | 182.17 | 181.56 | 181.96 | 2822900.0 |
| 2015-02-25 | GLD | ETF | 115.83 | 115.89 | 115.33 | 115.7 | 5032500.0 |
| 2015-02-25 | TLT | ETF | 129.46 | 130.39 | 129.08 | 130.23 | 8019800.0 |
| 2015-02-25 | AADR | ETF | 38.9 | 39.17 | 38.9 | 39.14 | 1000.0 |
| 2015-02-25 | AAXJ | ETF | 63.88 | 63.95 | 63.75 | 63.76 | 3678900.0 |
| 2015-02-25 | ACWI | ETF | 61.03 | 61.28 | 61.02 | 61.16 | 1119800.0 |
| 2015-02-25 | ACWV | ETF | 71.85 | 72.18 | 71.72 | 71.88 | 381400.0 |
| 2015-02-25 | ACWX | ETF | 45.32 | 45.4299 | 45.25 | 45.37 | 330277.0 |
| 2015-02-25 | ADRE | ETF | 36.52 | 36.73 | 36.52 | 36.6 | 7806.0 |
| 2015-02-25 | AFK | ETF | 26.14 | 26.3399 | 26.076 | 26.17 | 24661.0 |
| 2015-02-25 | AGG | ETF | 111.2 | 111.32 | 111.07 | 111.32 | 2319300.0 |
| 2015-02-25 | AGQ | ETF | 41.5 | 41.65 | 41.03 | 41.5 | 217400.0 |
| 2015-02-25 | AGZ | ETF | 114.41 | 114.535 | 113.8701 | 114.215 | 19921.0 |
| 2015-02-25 | AGZD | ETF | 24.595 | 24.6 | 24.495 | 24.495 | 20400.0 |
| 2015-02-25 | AIA | ETF | 49.47 | 49.63 | 49.4401 | 49.48 | 19581.0 |
| 2015-02-25 | AIQ | ETF | 24.41 | 24.73 | 24.28 | 24.67 | 10209.0 |
| 2015-02-25 | AIRR | ETF | 18.44 | 18.44 | 18.31 | 18.44 | 24900.0 |
| 2015-02-25 | AIVI | ETF | 45.9 | 45.9 | 45.69 | 45.86 | 25700.0 |
| 2015-02-25 | AMJ | ETF | 45.45 | 46.13 | 45.38 | 45.82 | 602031.0 |
| 2015-02-25 | AMLP | ETF | 85.35 | 86.25 | 85.25 | 85.95 | 749480.0 |
| 2015-02-25 | AMZA | ETF | 226.4 | 227.6 | 226.4 | 227.1 | 170.0 |
| 2015-02-25 | ANGL | ETF | 27.32 | 27.36 | 27.26 | 27.36 | 6500.0 |
| 2015-02-25 | AOA | ETF | 47.8 | 48.05 | 47.8 | 47.95 | 31500.0 |
| 2015-02-25 | AOK | ETF | 33.2 | 33.2 | 32.9601 | 33.04 | 57205.0 |
| 2015-02-25 | AOM | ETF | 35.87 | 35.87 | 35.69 | 35.74 | 59249.0 |
| 2015-02-25 | AOR | ETF | 41.2 | 41.21 | 41.08 | 41.12 | 48528.0 |
| 2015-02-25 | ARGT | ETF | 20.12 | 20.48 | 20.12 | 20.29 | 5300.0 |
| 2015-02-25 | ARKG | ETF | 23.271 | 23.45 | 23.271 | 23.36 | 4300.0 |
| 2015-02-25 | ARKK | ETF | 21.51 | 21.56 | 21.43 | 21.43 | 2400.0 |
| 2015-02-25 | ARKQ | ETF | 20.25 | 20.26 | 20.2 | 20.2 | 1500.0 |
| 2015-02-25 | ARKW | ETF | 22.18 | 22.3 | 22.18 | 22.24 | 11900.0 |
| 2015-02-25 | ASEA | ETF | 15.8 | 15.85 | 15.8 | 15.83 | 1800.0 |
| 2015-02-25 | ASHR | ETF | 35.75 | 35.84 | 35.48 | 35.51 | 754500.0 |
| 2015-02-25 | ASHS | ETF | 38.95 | 39.02 | 38.86 | 39.0 | 11300.0 |
| 2015-02-25 | ATMP | ETF | 30.3 | 30.58 | 30.3 | 30.43 | 28400.0 |
| 2015-02-25 | AVIV | ETF | 36.28 | 37.21 | 36.1399 | 36.65 | 332448.0 |
| 2015-02-25 | AWAY | ETF | 31.73 | 33.7297 | 31.4376 | 33.155 | 4391988.0 |
| 2015-02-25 | BAB | ETF | 30.23 | 30.29 | 30.16 | 30.2 | 106776.0 |
| 2015-02-25 | BAL | ETF | 44.25 | 44.98 | 44.19 | 44.61 | 19463.0 |
| 2015-02-25 | BALT | ETF | 1.67 | 1.8 | 1.66 | 1.76 | 702260.0 |
| 2015-02-25 | BAR | ETF | 2.848 | 2.848 | 2.8031 | 2.8031 | 12090.0 |
| 2015-02-25 | BBC | ETF | 30.52 | 31.44 | 30.5 | 31.17 | 11741.0 |
| 2015-02-25 | BBH | ETF | 127.41 | 129.69 | 126.26 | 128.88 | 172100.0 |
| 2015-02-25 | BBP | ETF | 29.5 | 30.14 | 29.355 | 30.01 | 5900.0 |
| 2015-02-25 | BCHP | ETF | 19.26 | 19.26 | 19.26 | 19.26 | 114.0 |
| 2015-02-25 | BCM | ETF | 31.63 | 31.979 | 31.63 | 31.926 | 10722.0 |
| 2015-02-25 | BFOR | ETF | 8.2 | 8.23 | 8.2 | 8.2125 | 27200.0 |
> showing 50 of 1,171 rows — these rows as CSV