PREVIEW / etf_daily / 2015-02-17
file: by_date/etf_daily/2015/2015-02-17.parquet size: 47 KB rows: 1,169
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-17 | SPY | ETF | 209.4 | 210.32 | 209.1 | 210.11 | 76968200.0 |
| 2015-02-17 | QQQ | ETF | 106.91 | 107.08 | 106.6432 | 107.01 | 17675344.0 |
| 2015-02-17 | IWM | ETF | 121.66 | 122.06 | 121.26 | 121.91 | 16868500.0 |
| 2015-02-17 | DIA | ETF | 180.06 | 180.7 | 179.71 | 180.57 | 2850900.0 |
| 2015-02-17 | GLD | ETF | 116.4 | 116.54 | 115.58 | 116.01 | 7225200.0 |
| 2015-02-17 | TLT | ETF | 127.8 | 127.93 | 125.92 | 126.26 | 14968800.0 |
| 2015-02-17 | AADR | ETF | 38.84 | 38.84 | 38.18 | 38.29 | 1800.0 |
| 2015-02-17 | AAXJ | ETF | 63.62 | 63.66 | 63.28 | 63.51 | 738300.0 |
| 2015-02-17 | ACWI | ETF | 60.26 | 60.59 | 60.2 | 60.49 | 1311700.0 |
| 2015-02-17 | ACWV | ETF | 71.18 | 71.35 | 70.99 | 71.18 | 62800.0 |
| 2015-02-17 | ACWX | ETF | 44.65 | 44.8099 | 44.4533 | 44.74 | 283135.0 |
| 2015-02-17 | ADRE | ETF | 36.82 | 36.94 | 36.57 | 36.87 | 19448.0 |
| 2015-02-17 | AFK | ETF | 25.31 | 25.77 | 25.2 | 25.42 | 97002.0 |
| 2015-02-17 | AGG | ETF | 110.67 | 110.73 | 110.24 | 110.31 | 2043000.0 |
| 2015-02-17 | AGQ | ETF | 41.08 | 41.58 | 40.42 | 41.58 | 789300.0 |
| 2015-02-17 | AGZ | ETF | 115.85 | 115.85 | 113.66 | 113.77 | 54756.0 |
| 2015-02-17 | AGZD | ETF | 24.595 | 24.62 | 24.525 | 24.525 | 9200.0 |
| 2015-02-17 | AIA | ETF | 49.19 | 49.2799 | 49.068 | 49.16 | 10988.0 |
| 2015-02-17 | AIQ | ETF | 24.5326 | 25.11 | 24.5 | 24.77 | 16967.0 |
| 2015-02-17 | AIRR | ETF | 18.22 | 18.26 | 18.034 | 18.09 | 21200.0 |
| 2015-02-17 | AIVI | ETF | 44.74 | 45.09 | 44.64 | 45.07 | 26200.0 |
| 2015-02-17 | AMJ | ETF | 45.84 | 46.39 | 45.34 | 45.9 | 851623.0 |
| 2015-02-17 | AMLP | ETF | 85.4 | 86.05 | 84.9 | 85.7 | 892860.0 |
| 2015-02-17 | AMZA | ETF | 221.2 | 224.2 | 220.8 | 223.7 | 1010.0 |
| 2015-02-17 | ANGL | ETF | 27.46 | 27.49 | 27.21 | 27.4 | 18800.0 |
| 2015-02-17 | AOA | ETF | 47.15 | 47.44 | 47.15 | 47.34 | 32000.0 |
| 2015-02-17 | AOK | ETF | 32.54 | 32.7299 | 32.51 | 32.64 | 46874.0 |
| 2015-02-17 | AOM | ETF | 35.1 | 35.39 | 35.1 | 35.37 | 47739.0 |
| 2015-02-17 | AOR | ETF | 40.73 | 40.73 | 40.5616 | 40.71 | 31382.0 |
| 2015-02-17 | ARGT | ETF | 19.95 | 20.1 | 19.94 | 20.08 | 3800.0 |
| 2015-02-17 | ARKG | ETF | 23.12 | 23.179 | 22.928 | 23.179 | 3800.0 |
| 2015-02-17 | ARKK | ETF | 21.6 | 21.6 | 21.3 | 21.34 | 3400.0 |
| 2015-02-17 | ARKQ | ETF | 20.11 | 20.11 | 20.01 | 20.076 | 3600.0 |
| 2015-02-17 | ARKW | ETF | 22.04 | 22.04 | 21.9 | 21.9 | 2000.0 |
| 2015-02-17 | ASEA | ETF | 15.67 | 15.84 | 15.65 | 15.74 | 63300.0 |
| 2015-02-17 | ASHR | ETF | 35.89 | 36.18 | 35.87 | 36.18 | 1268200.0 |
| 2015-02-17 | ASHS | ETF | 38.55 | 38.56 | 38.45 | 38.49 | 5200.0 |
| 2015-02-17 | ATMP | ETF | 30.26 | 30.8 | 30.26 | 30.68 | 22400.0 |
| 2015-02-17 | AVIV | ETF | 36.34 | 36.72 | 36.11 | 36.25 | 138490.0 |
| 2015-02-17 | AWAY | ETF | 29.67 | 30.06 | 29.542 | 30.05 | 1157354.0 |
| 2015-02-17 | BAB | ETF | 30.43 | 30.52 | 30.25 | 30.37 | 177181.0 |
| 2015-02-17 | BAL | ETF | 42.79 | 44.13 | 42.79 | 44.13 | 73619.0 |
| 2015-02-17 | BALT | ETF | 1.76 | 1.8 | 1.69 | 1.69 | 461426.0 |
| 2015-02-17 | BAR | ETF | 3.069 | 3.069 | 2.817 | 2.855 | 63770.0 |
| 2015-02-17 | BBC | ETF | 28.8 | 29.86 | 28.8 | 29.7099 | 12817.0 |
| 2015-02-17 | BBH | ETF | 122.49 | 123.91 | 122.45 | 123.42 | 142700.0 |
| 2015-02-17 | BBP | ETF | 28.649 | 29.1 | 28.649 | 29.05 | 11700.0 |
| 2015-02-17 | BCHP | ETF | 19.19 | 19.3 | 19.13 | 19.234 | 33389.0 |
| 2015-02-17 | BFOR | ETF | 8.08 | 8.125 | 8.07 | 8.115 | 164000.0 |
| 2015-02-17 | BIB | ETF | 70.875 | 72.34 | 70.475 | 71.97 | 541964.0 |
> showing 50 of 1,169 rows — these rows as CSV