PREVIEW / etf_daily / 2015-12-10
file: by_date/etf_daily/2015/2015-12-10.parquet size: 49 KB rows: 1,221
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-12-10 | SPY | ETF | 205.42 | 207.43 | 205.14 | 205.87 | 116128900.0 |
| 2015-12-10 | QQQ | ETF | 113.15 | 114.16 | 112.811 | 113.4 | 30154621.0 |
| 2015-12-10 | IWM | ETF | 113.89 | 115.08 | 113.65 | 114.46 | 31278800.0 |
| 2015-12-10 | DIA | ETF | 175.18 | 177.13 | 174.85 | 175.88 | 5613800.0 |
| 2015-12-10 | GLD | ETF | 102.51 | 102.83 | 102.34 | 102.55 | 3853500.0 |
| 2015-12-10 | TLT | ETF | 121.79 | 122.03 | 121.49 | 121.84 | 5606900.0 |
| 2015-12-10 | AADR | ETF | 38.66 | 38.66 | 38.66 | 38.66 | 300.0 |
| 2015-12-10 | AAXJ | ETF | 53.95 | 54.18 | 53.76 | 53.8 | 1666100.0 |
| 2015-12-10 | ACTX | ETF | 7.0801 | 7.6701 | 6.4311 | 6.4311 | 2062.0 |
| 2015-12-10 | ACWF | ETF | 23.45 | 23.45 | 23.45 | 23.45 | 416.0 |
| 2015-12-10 | ACWI | ETF | 56.53 | 56.9 | 56.47 | 56.51 | 3692000.0 |
| 2015-12-10 | ACWV | ETF | 69.53 | 69.76 | 69.34 | 69.4 | 181900.0 |
| 2015-12-10 | ACWX | ETF | 40.08 | 40.17 | 39.845 | 39.93 | 2039325.0 |
| 2015-12-10 | ADRE | ETF | 30.03 | 30.0599 | 29.9 | 29.95 | 6196.0 |
| 2015-12-10 | AFK | ETF | 18.04 | 18.21 | 18.04 | 18.0799 | 13231.0 |
| 2015-12-10 | AFTY | ETF | 16.29 | 16.29 | 16.19 | 16.25 | 18200.0 |
| 2015-12-10 | AGG | ETF | 108.51 | 108.51 | 108.36 | 108.42 | 2001500.0 |
| 2015-12-10 | AGGY | ETF | 49.37 | 49.46 | 49.37 | 49.4 | 3600.0 |
| 2015-12-10 | AGQ | ETF | 28.45 | 28.64 | 28.31 | 28.31 | 68800.0 |
| 2015-12-10 | AGZ | ETF | 113.28 | 113.28 | 112.8332 | 113.1 | 12410.0 |
| 2015-12-10 | AGZD | ETF | 23.99 | 24.045 | 23.99 | 24.045 | 4200.0 |
| 2015-12-10 | AIA | ETF | 43.38 | 43.478 | 43.23 | 43.268 | 20776.0 |
| 2015-12-10 | AIQ | ETF | 8.87 | 8.87 | 8.53 | 8.72 | 18099.0 |
| 2015-12-10 | AIRR | ETF | 17.05 | 17.07 | 17.05 | 17.06 | 2600.0 |
| 2015-12-10 | AIVI | ETF | 38.42 | 38.55 | 38.27 | 38.27 | 32700.0 |
| 2015-12-10 | AMJ | ETF | 27.62 | 27.96 | 26.94 | 26.97 | 7145742.0 |
| 2015-12-10 | AMLP | ETF | 55.7 | 57.05 | 54.8 | 55.25 | 4827680.0 |
| 2015-12-10 | AMZA | ETF | 106.0 | 106.3 | 102.39 | 103.1 | 3140.0 |
| 2015-12-10 | ANGL | ETF | 24.99 | 24.99 | 24.83 | 24.85 | 18500.0 |
| 2015-12-10 | AOA | ETF | 45.39 | 45.45 | 45.18 | 45.28 | 209800.0 |
| 2015-12-10 | AOK | ETF | 31.83 | 31.91 | 31.818 | 31.82 | 246647.0 |
| 2015-12-10 | AOM | ETF | 34.43 | 34.441 | 34.31 | 34.33 | 453241.0 |
| 2015-12-10 | AOR | ETF | 39.29 | 39.29 | 39.11 | 39.13 | 522148.0 |
| 2015-12-10 | ARGT | ETF | 17.99 | 18.08 | 17.92 | 17.98 | 3700.0 |
| 2015-12-10 | ARKG | ETF | 19.99 | 19.99 | 19.99 | 19.99 | 100.0 |
| 2015-12-10 | ARKK | ETF | 21.07 | 21.07 | 21.07 | 21.07 | 100.0 |
| 2015-12-10 | ARKQ | ETF | 19.459 | 19.479 | 19.459 | 19.479 | 700.0 |
| 2015-12-10 | ARKW | ETF | 23.89 | 23.903 | 23.86 | 23.87 | 1000.0 |
| 2015-12-10 | ASEA | ETF | 12.62 | 12.62 | 12.55 | 12.55 | 1700.0 |
| 2015-12-10 | ASET | ETF | 24.34 | 24.34 | 24.2785 | 24.34 | 6350.0 |
| 2015-12-10 | ASHR | ETF | 35.55 | 35.77 | 35.4 | 35.55 | 2114500.0 |
| 2015-12-10 | ASHS | ETF | 43.7 | 44.3 | 43.69 | 44.3 | 76800.0 |
| 2015-12-10 | ASHX | ETF | 25.4 | 25.4 | 25.22 | 25.25 | 3400.0 |
| 2015-12-10 | ATMP | ETF | 17.96 | 18.26 | 17.71 | 17.85 | 403400.0 |
| 2015-12-10 | AWAY | ETF | 35.79 | 36.21 | 35.47 | 35.99 | 4644422.0 |
| 2015-12-10 | BAB | ETF | 29.22 | 29.2699 | 29.16 | 29.18 | 37127.0 |
| 2015-12-10 | BAL | ETF | 42.97 | 43.08 | 42.421 | 42.46 | 3815.0 |
| 2015-12-10 | BBC | ETF | 28.65 | 29.1415 | 28.65 | 29.1389 | 3679.0 |
| 2015-12-10 | BBH | ETF | 122.17 | 123.91 | 122.05 | 123.31 | 27000.0 |
| 2015-12-10 | BBP | ETF | 29.92 | 30.349 | 29.92 | 30.339 | 1700.0 |
> showing 50 of 1,221 rows — these rows as CSV