PREVIEW / etf_daily / 2015-06-30
file: by_date/etf_daily/2015/2015-06-30.parquet size: 48 KB rows: 1,196
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-06-30 | SPY | ETF | 207.26 | 207.32 | 205.28 | 205.85 | 182925100.0 |
| 2015-06-30 | QQQ | ETF | 107.49 | 107.72 | 106.74 | 107.07 | 34809920.0 |
| 2015-06-30 | IWM | ETF | 125.18 | 125.32 | 124.29 | 124.86 | 39631300.0 |
| 2015-06-30 | DIA | ETF | 177.0 | 177.01 | 175.45 | 175.82 | 9149800.0 |
| 2015-06-30 | GLD | ETF | 112.24 | 113.05 | 111.84 | 112.37 | 7897000.0 |
| 2015-06-30 | TLT | ETF | 117.4 | 118.7 | 117.33 | 117.46 | 13469000.0 |
| 2015-06-30 | AADR | ETF | 39.27 | 39.28 | 38.64 | 38.64 | 3900.0 |
| 2015-06-30 | AAXJ | ETF | 63.5 | 63.6 | 62.93 | 63.0 | 2059300.0 |
| 2015-06-30 | ACTX | ETF | 1.77 | 2.36 | 1.652 | 1.77 | 2040.0 |
| 2015-06-30 | ACWF | ETF | 24.62 | 24.62 | 24.62 | 24.62 | 340.0 |
| 2015-06-30 | ACWI | ETF | 60.03 | 60.04 | 59.23 | 59.45 | 1727700.0 |
| 2015-06-30 | ACWV | ETF | 70.12 | 70.19 | 69.47 | 69.69 | 161200.0 |
| 2015-06-30 | ACWX | ETF | 44.71 | 44.71 | 44.07 | 44.18 | 1289950.0 |
| 2015-06-30 | ADRE | ETF | 35.26 | 35.2848 | 35.031 | 35.189 | 8476.0 |
| 2015-06-30 | AFK | ETF | 24.6 | 24.6 | 24.32 | 24.36 | 8869.0 |
| 2015-06-30 | AFTY | ETF | 21.05 | 21.16 | 20.66 | 20.73 | 101000.0 |
| 2015-06-30 | AGG | ETF | 108.72 | 109.0 | 108.61 | 108.78 | 2159500.0 |
| 2015-06-30 | AGQ | ETF | 36.06 | 37.34 | 35.47 | 36.63 | 362300.0 |
| 2015-06-30 | AGZ | ETF | 113.15 | 113.21 | 113.047 | 113.18 | 16361.0 |
| 2015-06-30 | AGZD | ETF | 24.33 | 24.345 | 24.255 | 24.32 | 13000.0 |
| 2015-06-30 | AIA | ETF | 50.57 | 50.63 | 50.251 | 50.29 | 30731.0 |
| 2015-06-30 | AIQ | ETF | 18.85 | 19.335 | 18.5 | 18.69 | 12252.0 |
| 2015-06-30 | AIRR | ETF | 18.41 | 18.41 | 18.187 | 18.19 | 3300.0 |
| 2015-06-30 | AIVI | ETF | 43.11 | 43.11 | 42.4 | 42.56 | 53400.0 |
| 2015-06-30 | ALTL | ETF | 36.28 | 36.374 | 36.2 | 36.245 | 4000.0 |
| 2015-06-30 | AMJ | ETF | 39.95 | 40.1495 | 39.413 | 39.6 | 2723605.0 |
| 2015-06-30 | AMLP | ETF | 78.6 | 78.8 | 77.6 | 77.8 | 1563980.0 |
| 2015-06-30 | AMZA | ETF | 201.7 | 201.7 | 195.9 | 198.6 | 1650.0 |
| 2015-06-30 | ANGL | ETF | 27.19 | 27.21 | 27.12 | 27.2 | 9200.0 |
| 2015-06-30 | AOA | ETF | 47.55 | 47.59 | 47.31 | 47.43 | 31300.0 |
| 2015-06-30 | AOK | ETF | 32.48 | 32.52 | 32.39 | 32.454 | 16331.0 |
| 2015-06-30 | AOM | ETF | 35.26 | 35.3244 | 35.15 | 35.25 | 39156.0 |
| 2015-06-30 | AOR | ETF | 40.76 | 40.82 | 40.4985 | 40.54 | 167884.0 |
| 2015-06-30 | ARGT | ETF | 20.21 | 20.21 | 20.0 | 20.04 | 3400.0 |
| 2015-06-30 | ARKG | ETF | 22.96 | 23.06 | 22.93 | 23.06 | 3400.0 |
| 2015-06-30 | ARKK | ETF | 21.47 | 21.47 | 21.293 | 21.35 | 3300.0 |
| 2015-06-30 | ARKQ | ETF | 19.79 | 19.79 | 19.74 | 19.76 | 1000.0 |
| 2015-06-30 | ARKW | ETF | 22.95 | 23.07 | 22.87 | 23.06 | 3900.0 |
| 2015-06-30 | ASEA | ETF | 15.01 | 15.05 | 14.98 | 15.02 | 6600.0 |
| 2015-06-30 | ASHR | ETF | 45.78 | 46.04 | 45.45 | 46.01 | 5858100.0 |
| 2015-06-30 | ASHS | ETF | 56.98 | 57.09 | 56.45 | 56.6 | 185900.0 |
| 2015-06-30 | ATMP | ETF | 27.8 | 27.8 | 27.3 | 27.4 | 26000.0 |
| 2015-06-30 | AWAY | ETF | 30.41 | 31.2 | 30.31 | 31.12 | 871492.0 |
| 2015-06-30 | BAB | ETF | 28.84 | 28.955 | 28.71 | 28.78 | 794694.0 |
| 2015-06-30 | BAL | ETF | 44.2 | 45.63 | 44.0 | 45.61 | 21024.0 |
| 2015-06-30 | BALT | ETF | 1.59 | 1.6 | 1.57 | 1.6 | 465188.0 |
| 2015-06-30 | BBC | ETF | 35.22 | 36.22 | 35.05 | 36.22 | 29609.0 |
| 2015-06-30 | BBH | ETF | 133.65 | 135.25 | 132.87 | 134.84 | 167900.0 |
| 2015-06-30 | BBP | ETF | 34.5 | 35.1 | 34.422 | 35.09 | 25000.0 |
| 2015-06-30 | BCHP | ETF | 19.568 | 19.568 | 19.568 | 19.568 | 200.0 |
> showing 50 of 1,196 rows — these rows as CSV