PREVIEW / etf_daily / 2015-03-10
file: by_date/etf_daily/2015/2015-03-10.parquet size: 47 KB rows: 1,164
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-03-10 | SPY | ETF | 206.71 | 206.81 | 204.93 | 204.98 | 157121300.0 |
| 2015-03-10 | QQQ | ETF | 106.95 | 106.98 | 105.72 | 105.72 | 34234496.0 |
| 2015-03-10 | IWM | ETF | 120.61 | 120.7 | 119.83 | 120.3 | 32440300.0 |
| 2015-03-10 | DIA | ETF | 178.38 | 178.51 | 176.68 | 176.69 | 6070100.0 |
| 2015-03-10 | GLD | ETF | 112.09 | 112.35 | 111.22 | 111.42 | 7019800.0 |
| 2015-03-10 | TLT | ETF | 125.97 | 126.44 | 125.76 | 126.28 | 9277900.0 |
| 2015-03-10 | AAXJ | ETF | 61.49 | 61.62 | 61.18 | 61.19 | 743600.0 |
| 2015-03-10 | ACWI | ETF | 59.3 | 59.3 | 58.77 | 58.78 | 1199500.0 |
| 2015-03-10 | ACWV | ETF | 70.17 | 70.76 | 69.88 | 69.91 | 1603400.0 |
| 2015-03-10 | ACWX | ETF | 43.54 | 43.55 | 43.25 | 43.27 | 237194.0 |
| 2015-03-10 | ADRE | ETF | 34.13 | 34.2278 | 34.01 | 34.0999 | 14882.0 |
| 2015-03-10 | AFK | ETF | 25.15 | 25.23 | 24.85 | 24.85 | 25087.0 |
| 2015-03-10 | AGG | ETF | 110.23 | 110.36 | 110.15 | 110.24 | 1708100.0 |
| 2015-03-10 | AGQ | ETF | 37.65 | 38.01 | 37.1 | 37.24 | 153200.0 |
| 2015-03-10 | AGZ | ETF | 113.55 | 113.55 | 113.301 | 113.49 | 91662.0 |
| 2015-03-10 | AGZD | ETF | 24.625 | 24.67 | 24.585 | 24.635 | 5800.0 |
| 2015-03-10 | AIA | ETF | 47.8 | 47.8 | 47.6488 | 47.73 | 34097.0 |
| 2015-03-10 | AIQ | ETF | 22.87 | 23.0 | 22.685 | 22.78 | 11013.0 |
| 2015-03-10 | AIRR | ETF | 17.81 | 17.88 | 17.75 | 17.77 | 27900.0 |
| 2015-03-10 | AIVI | ETF | 43.42 | 43.42 | 43.09 | 43.1 | 45200.0 |
| 2015-03-10 | ALTL | ETF | 37.0 | 37.0 | 36.9 | 36.9 | 1100.0 |
| 2015-03-10 | AMJ | ETF | 42.5 | 43.0547 | 42.16 | 43.01 | 1329173.0 |
| 2015-03-10 | AMLP | ETF | 82.25 | 83.2 | 81.9 | 83.0 | 1724100.0 |
| 2015-03-10 | AMZA | ETF | 207.2 | 213.1 | 207.2 | 213.1 | 410.0 |
| 2015-03-10 | ANGL | ETF | 27.14 | 27.22 | 27.01 | 27.22 | 12500.0 |
| 2015-03-10 | AOA | ETF | 46.89 | 46.89 | 46.5 | 46.53 | 47800.0 |
| 2015-03-10 | AOK | ETF | 32.5 | 32.581 | 32.47 | 32.51 | 28050.0 |
| 2015-03-10 | AOM | ETF | 35.27 | 35.27 | 35.03 | 35.03 | 63783.0 |
| 2015-03-10 | AOR | ETF | 40.41 | 40.41 | 40.09 | 40.14 | 68028.0 |
| 2015-03-10 | ARGT | ETF | 20.22 | 20.27 | 19.96 | 19.96 | 7500.0 |
| 2015-03-10 | ARKG | ETF | 23.16 | 23.16 | 22.728 | 22.877 | 1500.0 |
| 2015-03-10 | ARKK | ETF | 20.6 | 20.6 | 20.578 | 20.578 | 1100.0 |
| 2015-03-10 | ARKQ | ETF | 19.83 | 19.83 | 19.83 | 19.83 | 100.0 |
| 2015-03-10 | ARKW | ETF | 21.55 | 21.55 | 21.37 | 21.38 | 1800.0 |
| 2015-03-10 | ASEA | ETF | 15.3 | 15.3 | 15.14 | 15.14 | 21300.0 |
| 2015-03-10 | ASHR | ETF | 35.38 | 35.5 | 35.2 | 35.41 | 469700.0 |
| 2015-03-10 | ASHS | ETF | 41.02 | 41.02 | 40.8 | 40.85 | 9500.0 |
| 2015-03-10 | ATMP | ETF | 28.73 | 29.06 | 28.73 | 29.04 | 81200.0 |
| 2015-03-10 | AVIV | ETF | 34.58 | 34.96 | 34.45 | 34.86 | 119836.0 |
| 2015-03-10 | AWAY | ETF | 30.28 | 30.585 | 30.235 | 30.5 | 1153920.0 |
| 2015-03-10 | BAB | ETF | 30.0 | 30.0 | 29.8801 | 29.99 | 103976.0 |
| 2015-03-10 | BAL | ETF | 42.05 | 42.16 | 40.89 | 40.99 | 32382.0 |
| 2015-03-10 | BALT | ETF | 1.43 | 1.43 | 1.28 | 1.32 | 726020.0 |
| 2015-03-10 | BAR | ETF | 2.526 | 2.526 | 2.501 | 2.501 | 7060.0 |
| 2015-03-10 | BBC | ETF | 32.027 | 33.29 | 32.027 | 32.9 | 15168.0 |
| 2015-03-10 | BBH | ETF | 128.95 | 130.76 | 128.06 | 129.3 | 62000.0 |
| 2015-03-10 | BBP | ETF | 30.67 | 31.305 | 30.27 | 31.057 | 36800.0 |
| 2015-03-10 | BCHP | ETF | 18.59 | 18.69 | 18.5801 | 18.69 | 720.0 |
| 2015-03-10 | BCM | ETF | 30.772 | 30.78 | 30.51 | 30.643 | 13741.0 |
| 2015-03-10 | BFOR | ETF | 8.0825 | 8.0825 | 8.01 | 8.035 | 94000.0 |
> showing 50 of 1,164 rows — these rows as CSV