PREVIEW / etf_daily / 2015-04-29
file: by_date/etf_daily/2015/2015-04-29.parquet size: 48 KB rows: 1,177
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-04-29 | SPY | ETF | 210.37 | 211.29 | 209.6 | 210.57 | 125684900.0 |
| 2015-04-29 | QQQ | ETF | 109.43 | 110.07 | 108.75 | 109.35 | 34043905.0 |
| 2015-04-29 | IWM | ETF | 124.47 | 124.9 | 123.63 | 123.8 | 26437900.0 |
| 2015-04-29 | DIA | ETF | 179.8 | 180.71 | 179.24 | 180.07 | 6559400.0 |
| 2015-04-29 | GLD | ETF | 116.06 | 116.39 | 115.28 | 115.51 | 7170500.0 |
| 2015-04-29 | TLT | ETF | 125.81 | 126.44 | 125.28 | 125.73 | 11554800.0 |
| 2015-04-29 | AAXJ | ETF | 69.01 | 69.2 | 68.77 | 69.01 | 1160900.0 |
| 2015-04-29 | ACTX | ETF | 15.08 | 15.11 | 15.04 | 15.11 | 6239.0 |
| 2015-04-29 | ACWI | ETF | 62.34 | 62.55 | 62.15 | 62.39 | 794200.0 |
| 2015-04-29 | ACWV | ETF | 73.89 | 73.94 | 73.52 | 73.73 | 94000.0 |
| 2015-04-29 | ACWX | ETF | 47.35 | 47.49 | 47.17 | 47.33 | 311560.0 |
| 2015-04-29 | ADRE | ETF | 38.25 | 38.29 | 38.0901 | 38.24 | 7182.0 |
| 2015-04-29 | AFK | ETF | 26.89 | 26.97 | 26.67 | 26.86 | 36200.0 |
| 2015-04-29 | AFTY | ETF | 23.4 | 23.4 | 23.03 | 23.1 | 1871400.0 |
| 2015-04-29 | AGG | ETF | 110.89 | 110.97 | 110.7 | 110.86 | 1313200.0 |
| 2015-04-29 | AGQ | ETF | 41.5 | 41.83 | 40.73 | 40.85 | 188600.0 |
| 2015-04-29 | AGZ | ETF | 113.95 | 113.96 | 113.64 | 113.8799 | 10461.0 |
| 2015-04-29 | AGZD | ETF | 24.55 | 24.555 | 24.475 | 24.475 | 4800.0 |
| 2015-04-29 | AIA | ETF | 54.54 | 54.65 | 54.381 | 54.4 | 10807.0 |
| 2015-04-29 | AIQ | ETF | 22.48 | 22.54 | 21.78 | 22.26 | 27542.0 |
| 2015-04-29 | AIRR | ETF | 18.6 | 18.75 | 18.6 | 18.64 | 6100.0 |
| 2015-04-29 | AIVI | ETF | 46.28 | 46.31 | 46.1 | 46.22 | 13300.0 |
| 2015-04-29 | ALTL | ETF | 37.38 | 37.38 | 37.38 | 37.38 | 164.0 |
| 2015-04-29 | AMJ | ETF | 44.32 | 45.37 | 44.32 | 45.13 | 938590.0 |
| 2015-04-29 | AMLP | ETF | 85.0 | 86.35 | 85.0 | 85.95 | 1179480.0 |
| 2015-04-29 | AMZA | ETF | 221.1 | 224.44 | 221.1 | 224.1 | 390.0 |
| 2015-04-29 | ANGL | ETF | 27.8 | 27.8 | 27.69 | 27.78 | 16900.0 |
| 2015-04-29 | AOA | ETF | 48.65 | 48.76 | 48.47 | 48.69 | 70900.0 |
| 2015-04-29 | AOK | ETF | 33.26 | 33.37 | 33.11 | 33.11 | 53278.0 |
| 2015-04-29 | AOM | ETF | 36.07 | 36.07 | 35.9 | 35.97 | 60654.0 |
| 2015-04-29 | AOR | ETF | 41.6 | 41.6891 | 41.4307 | 41.55 | 55167.0 |
| 2015-04-29 | ARGT | ETF | 22.22 | 22.22 | 22.09 | 22.11 | 3100.0 |
| 2015-04-29 | ARKG | ETF | 23.024 | 23.08 | 22.814 | 22.96 | 2600.0 |
| 2015-04-29 | ARKK | ETF | 21.54 | 21.58 | 21.227 | 21.55 | 2000.0 |
| 2015-04-29 | ARKQ | ETF | 20.2 | 20.2 | 20.075 | 20.075 | 1000.0 |
| 2015-04-29 | ARKW | ETF | 22.625 | 23.02 | 22.625 | 23.0 | 1900.0 |
| 2015-04-29 | ASEA | ETF | 16.29 | 16.31 | 16.2 | 16.31 | 7600.0 |
| 2015-04-29 | ASHR | ETF | 49.04 | 49.2 | 48.78 | 48.95 | 1822900.0 |
| 2015-04-29 | ASHS | ETF | 55.0 | 55.31 | 54.95 | 55.01 | 49200.0 |
| 2015-04-29 | ATMP | ETF | 30.41 | 30.77 | 30.41 | 30.68 | 17000.0 |
| 2015-04-29 | AWAY | ETF | 27.03 | 27.41 | 26.67 | 27.11 | 1142361.0 |
| 2015-04-29 | BAB | ETF | 30.06 | 30.09 | 29.96 | 30.02 | 128549.0 |
| 2015-04-29 | BAL | ETF | 45.31 | 45.7899 | 45.26 | 45.7899 | 3067.0 |
| 2015-04-29 | BALT | ETF | 1.49 | 1.5 | 1.42 | 1.44 | 185373.0 |
| 2015-04-29 | BAR | ETF | 2.78 | 2.782 | 2.78 | 2.782 | 25920.0 |
| 2015-04-29 | BBC | ETF | 31.57 | 32.48 | 31.31 | 31.6 | 31604.0 |
| 2015-04-29 | BBH | ETF | 127.96 | 129.76 | 126.9 | 128.44 | 244600.0 |
| 2015-04-29 | BBP | ETF | 30.63 | 31.202 | 30.63 | 30.94 | 10000.0 |
| 2015-04-29 | BCM | ETF | 32.25 | 32.34 | 32.18 | 32.23 | 14170.0 |
| 2015-04-29 | BFOR | ETF | 8.39 | 8.4175 | 8.375 | 8.395 | 68800.0 |
> showing 50 of 1,177 rows — these rows as CSV