PREVIEW / etf_daily / 2015-10-28
file: by_date/etf_daily/2015/2015-10-28.parquet size: 49 KB rows: 1,228
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-10-28 | SPY | ETF | 207.0 | 208.98 | 206.21 | 208.95 | 135906700.0 |
| 2015-10-28 | QQQ | ETF | 113.25 | 114.02 | 112.34 | 114.02 | 42221867.0 |
| 2015-10-28 | IWM | ETF | 114.14 | 117.14 | 113.92 | 117.12 | 65529900.0 |
| 2015-10-28 | DIA | ETF | 176.01 | 177.68 | 175.36 | 177.68 | 7348500.0 |
| 2015-10-28 | GLD | ETF | 112.68 | 113.25 | 110.31 | 110.78 | 8201200.0 |
| 2015-10-28 | TLT | ETF | 124.27 | 124.34 | 123.3 | 123.83 | 8468700.0 |
| 2015-10-28 | AADR | ETF | 38.98 | 38.99 | 38.38 | 38.58 | 34200.0 |
| 2015-10-28 | AAXJ | ETF | 57.66 | 57.85 | 56.7 | 57.07 | 893400.0 |
| 2015-10-28 | ACTX | ETF | 10.6201 | 11.2101 | 8.2601 | 8.2601 | 563.0 |
| 2015-10-28 | ACWF | ETF | 23.819 | 23.9 | 23.813 | 23.9 | 2187.0 |
| 2015-10-28 | ACWI | ETF | 58.12 | 58.57 | 57.81 | 58.49 | 1936800.0 |
| 2015-10-28 | ACWV | ETF | 70.9 | 71.21 | 70.36 | 71.04 | 124300.0 |
| 2015-10-28 | ACWX | ETF | 42.0 | 42.3 | 41.7 | 42.03 | 587754.0 |
| 2015-10-28 | ADRE | ETF | 30.82 | 31.24 | 30.74 | 30.9696 | 8542.0 |
| 2015-10-28 | AFK | ETF | 20.69 | 20.8 | 20.4 | 20.53 | 4348.0 |
| 2015-10-28 | AFTY | ETF | 15.946 | 15.987 | 15.77 | 15.8 | 6500.0 |
| 2015-10-28 | AGG | ETF | 109.98 | 110.05 | 109.57 | 109.63 | 1661300.0 |
| 2015-10-28 | AGGY | ETF | 50.06 | 50.06 | 50.0 | 50.0 | 400.0 |
| 2015-10-28 | AGQ | ETF | 37.15 | 38.32 | 35.26 | 36.63 | 366000.0 |
| 2015-10-28 | AGZ | ETF | 113.92 | 114.08 | 113.736 | 113.92 | 15033.0 |
| 2015-10-28 | AGZD | ETF | 23.935 | 23.94 | 23.935 | 23.94 | 2000.0 |
| 2015-10-28 | AIA | ETF | 46.21 | 46.35 | 45.56 | 45.93 | 60938.0 |
| 2015-10-28 | AIQ | ETF | 8.38 | 8.65 | 7.94 | 8.01 | 99757.0 |
| 2015-10-28 | AIRR | ETF | 16.59 | 16.68 | 16.354 | 16.68 | 11600.0 |
| 2015-10-28 | AIVI | ETF | 40.54 | 40.95 | 40.34 | 40.64 | 23800.0 |
| 2015-10-28 | ALTY | ETF | 14.467 | 14.477 | 14.467 | 14.477 | 300.0 |
| 2015-10-28 | AMJ | ETF | 31.13 | 32.37 | 31.01 | 32.3 | 2704224.0 |
| 2015-10-28 | AMLP | ETF | 63.5 | 66.0 | 63.3 | 65.95 | 2244420.0 |
| 2015-10-28 | AMZA | ETF | 130.9 | 138.0 | 130.9 | 137.4 | 2030.0 |
| 2015-10-28 | ANGL | ETF | 26.2 | 26.2 | 26.12 | 26.15 | 10700.0 |
| 2015-10-28 | AOA | ETF | 46.1 | 46.38 | 45.97 | 46.34 | 32900.0 |
| 2015-10-28 | AOK | ETF | 32.24 | 32.4099 | 32.24 | 32.33 | 22877.0 |
| 2015-10-28 | AOM | ETF | 34.85 | 34.9378 | 34.69 | 34.88 | 34401.0 |
| 2015-10-28 | AOR | ETF | 39.74 | 39.99 | 39.6501 | 39.9 | 49196.0 |
| 2015-10-28 | ARGT | ETF | 18.87 | 19.93 | 18.84 | 19.62 | 57600.0 |
| 2015-10-28 | ARKG | ETF | 19.975 | 19.975 | 19.975 | 19.975 | 100.0 |
| 2015-10-28 | ARKK | ETF | 19.82 | 19.82 | 19.82 | 19.82 | 200.0 |
| 2015-10-28 | ARKQ | ETF | 18.81 | 18.81 | 18.81 | 18.81 | 100.0 |
| 2015-10-28 | ARKW | ETF | 22.705 | 22.705 | 22.705 | 22.705 | 200.0 |
| 2015-10-28 | ASEA | ETF | 13.34 | 13.38 | 13.13 | 13.17 | 4000.0 |
| 2015-10-28 | ASHR | ETF | 35.18 | 35.37 | 34.78 | 34.95 | 1761500.0 |
| 2015-10-28 | ASHS | ETF | 42.5 | 42.54 | 42.01 | 42.25 | 65500.0 |
| 2015-10-28 | ASHX | ETF | 25.36 | 25.36 | 24.49 | 24.49 | 23815.0 |
| 2015-10-28 | ATMP | ETF | 21.44 | 22.11 | 20.92 | 21.89 | 122600.0 |
| 2015-10-28 | AWAY | ETF | 30.95 | 31.5 | 30.43 | 31.5 | 939097.0 |
| 2015-10-28 | BAB | ETF | 29.39 | 29.39 | 29.17 | 29.18 | 91702.0 |
| 2015-10-28 | BAL | ETF | 41.641 | 41.81 | 41.63 | 41.77 | 14218.0 |
| 2015-10-28 | BBC | ETF | 27.0 | 28.24 | 26.91 | 28.24 | 4323.0 |
| 2015-10-28 | BBH | ETF | 124.97 | 125.99 | 123.01 | 125.91 | 85900.0 |
| 2015-10-28 | BBP | ETF | 30.02 | 30.73 | 29.85 | 30.73 | 6100.0 |
> showing 50 of 1,228 rows — these rows as CSV