PREVIEW / etf_daily / 2015-11-24
file: by_date/etf_daily/2015/2015-11-24.parquet size: 49 KB rows: 1,227
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-24 | SPY | ETF | 207.87 | 209.83 | 207.41 | 209.35 | 98874400.0 |
| 2015-11-24 | QQQ | ETF | 113.42 | 114.32 | 112.8377 | 114.05 | 26374412.0 |
| 2015-11-24 | IWM | ETF | 116.88 | 118.42 | 116.56 | 118.25 | 24994500.0 |
| 2015-11-24 | DIA | ETF | 176.67 | 178.41 | 176.61 | 177.98 | 4369900.0 |
| 2015-11-24 | GLD | ETF | 103.12 | 103.25 | 102.69 | 102.94 | 3479600.0 |
| 2015-11-24 | TLT | ETF | 120.9 | 121.2 | 120.58 | 120.81 | 3371500.0 |
| 2015-11-24 | AADR | ETF | 40.53 | 40.53 | 38.97 | 39.21 | 1400.0 |
| 2015-11-24 | AAXJ | ETF | 55.78 | 56.45 | 55.71 | 56.33 | 844700.0 |
| 2015-11-24 | ACTX | ETF | 4.13 | 4.72 | 3.54 | 4.13 | 3268.0 |
| 2015-11-24 | ACWF | ETF | 23.75 | 23.75 | 23.75 | 23.75 | 650.0 |
| 2015-11-24 | ACWI | ETF | 57.54 | 58.11 | 57.48 | 57.96 | 2757000.0 |
| 2015-11-24 | ACWV | ETF | 70.04 | 70.53 | 69.92 | 70.38 | 163500.0 |
| 2015-11-24 | ACWX | ETF | 40.97 | 41.34 | 40.925 | 41.25 | 978374.0 |
| 2015-11-24 | ADRE | ETF | 30.825 | 31.0105 | 30.64 | 30.95 | 23920.0 |
| 2015-11-24 | AFK | ETF | 18.81 | 19.12 | 18.81 | 19.12 | 10517.0 |
| 2015-11-24 | AFTY | ETF | 16.88 | 16.95 | 16.87 | 16.95 | 1100.0 |
| 2015-11-24 | AGG | ETF | 108.75 | 108.8 | 108.66 | 108.75 | 1335300.0 |
| 2015-11-24 | AGQ | ETF | 28.8 | 29.22 | 28.62 | 28.71 | 124500.0 |
| 2015-11-24 | AGZ | ETF | 113.25 | 113.54 | 113.22 | 113.22 | 11699.0 |
| 2015-11-24 | AGZD | ETF | 24.02 | 24.035 | 24.02 | 24.035 | 2600.0 |
| 2015-11-24 | AIA | ETF | 44.73 | 45.26 | 44.73 | 45.17 | 51459.0 |
| 2015-11-24 | AIQ | ETF | 8.7 | 8.9399 | 8.64 | 8.9 | 21292.0 |
| 2015-11-24 | AIRR | ETF | 17.34 | 17.668 | 17.33 | 17.66 | 4100.0 |
| 2015-11-24 | AIVI | ETF | 39.04 | 39.45 | 39.04 | 39.36 | 18100.0 |
| 2015-11-24 | AMJ | ETF | 30.53 | 31.195 | 30.52 | 30.88 | 4391414.0 |
| 2015-11-24 | AMLP | ETF | 60.85 | 62.5 | 60.75 | 61.85 | 2276560.0 |
| 2015-11-24 | AMZA | ETF | 125.5 | 129.5 | 122.3 | 127.6 | 840.0 |
| 2015-11-24 | ANGL | ETF | 25.44 | 25.46 | 25.42 | 25.45 | 14500.0 |
| 2015-11-24 | AOA | ETF | 45.71 | 46.12 | 45.71 | 46.0 | 164200.0 |
| 2015-11-24 | AOK | ETF | 32.04 | 32.1 | 32.01 | 32.07 | 76784.0 |
| 2015-11-24 | AOM | ETF | 34.55 | 34.685 | 34.515 | 34.64 | 141772.0 |
| 2015-11-24 | AOR | ETF | 39.51 | 39.71 | 39.482 | 39.66 | 269640.0 |
| 2015-11-24 | ARGT | ETF | 19.39 | 19.39 | 19.08 | 19.1 | 27700.0 |
| 2015-11-24 | ARKG | ETF | 20.3 | 20.3 | 20.3 | 20.3 | 100.0 |
| 2015-11-24 | ARKK | ETF | 20.647 | 20.647 | 20.63 | 20.63 | 1000.0 |
| 2015-11-24 | ARKQ | ETF | 19.03 | 19.03 | 19.03 | 19.03 | 100.0 |
| 2015-11-24 | ARKW | ETF | 23.67 | 23.69 | 23.37 | 23.69 | 6000.0 |
| 2015-11-24 | ASEA | ETF | 12.95 | 13.06 | 12.93 | 13.04 | 2400.0 |
| 2015-11-24 | ASET | ETF | 24.85 | 24.8799 | 24.85 | 24.8799 | 600.0 |
| 2015-11-24 | ASHR | ETF | 37.23 | 37.53 | 37.15 | 37.51 | 871400.0 |
| 2015-11-24 | ASHS | ETF | 46.64 | 47.54 | 46.64 | 47.13 | 151900.0 |
| 2015-11-24 | ASHX | ETF | 26.36 | 26.47 | 26.36 | 26.47 | 469.0 |
| 2015-11-24 | ATMP | ETF | 20.45 | 20.77 | 20.31 | 20.55 | 173500.0 |
| 2015-11-24 | AWAY | ETF | 35.56 | 35.56 | 34.74 | 34.93 | 2477150.0 |
| 2015-11-24 | BAB | ETF | 29.05 | 29.1499 | 29.05 | 29.13 | 64884.0 |
| 2015-11-24 | BAL | ETF | 41.07 | 41.295 | 41.07 | 41.295 | 1211.0 |
| 2015-11-24 | BBC | ETF | 30.5799 | 30.7921 | 30.52 | 30.7921 | 3088.0 |
| 2015-11-24 | BBH | ETF | 124.51 | 125.99 | 123.83 | 125.6 | 43100.0 |
| 2015-11-24 | BBP | ETF | 31.067 | 31.28 | 30.94 | 31.242 | 3300.0 |
| 2015-11-24 | BCM | ETF | 25.25 | 25.31 | 25.25 | 25.258 | 2018.0 |
> showing 50 of 1,227 rows — these rows as CSV