PREVIEW / etf_daily / 2015-03-03
file: by_date/etf_daily/2015/2015-03-03.parquet size: 48 KB rows: 1,175
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-03 | SPY | ETF | 211.47 | 212.05 | 210.08 | 211.12 | 110325800.0 |
| 2015-03-03 | QQQ | ETF | 109.05 | 109.16 | 108.18 | 108.87 | 20788924.0 |
| 2015-03-03 | IWM | ETF | 123.19 | 123.19 | 122.26 | 122.74 | 23068400.0 |
| 2015-03-03 | DIA | ETF | 182.23 | 182.39 | 181.19 | 181.87 | 2825800.0 |
| 2015-03-03 | GLD | ETF | 116.04 | 116.61 | 115.35 | 115.47 | 4738300.0 |
| 2015-03-03 | TLT | ETF | 126.89 | 127.37 | 126.38 | 126.41 | 8599000.0 |
| 2015-03-03 | AAXJ | ETF | 63.89 | 63.9 | 63.61 | 63.7 | 721400.0 |
| 2015-03-03 | ACWI | ETF | 60.93 | 61.11 | 60.64 | 60.83 | 1976100.0 |
| 2015-03-03 | ACWV | ETF | 71.93 | 72.04 | 71.49 | 71.74 | 177200.0 |
| 2015-03-03 | ACWX | ETF | 45.2 | 45.2 | 44.9505 | 45.025 | 226522.0 |
| 2015-03-03 | ADRE | ETF | 36.13 | 36.21 | 35.97 | 35.99 | 5666.0 |
| 2015-03-03 | AFK | ETF | 25.76 | 25.84 | 25.7198 | 25.79 | 18690.0 |
| 2015-03-03 | AGG | ETF | 110.44 | 110.57 | 110.31 | 110.31 | 4228400.0 |
| 2015-03-03 | AGQ | ETF | 40.95 | 41.5 | 39.64 | 40.01 | 183900.0 |
| 2015-03-03 | AGZ | ETF | 113.79 | 114.14 | 113.3401 | 113.39 | 54891.0 |
| 2015-03-03 | AGZD | ETF | 24.575 | 24.72 | 24.575 | 24.585 | 8600.0 |
| 2015-03-03 | AIA | ETF | 49.47 | 49.49 | 49.3385 | 49.44 | 10215.0 |
| 2015-03-03 | AIQ | ETF | 23.71 | 23.74 | 22.75 | 22.85 | 22073.0 |
| 2015-03-03 | AIRR | ETF | 18.529 | 18.529 | 18.39 | 18.41 | 11300.0 |
| 2015-03-03 | AIVI | ETF | 45.25 | 45.37 | 45.12 | 45.23 | 13100.0 |
| 2015-03-03 | AMJ | ETF | 44.17 | 44.55 | 43.97 | 44.45 | 2096048.0 |
| 2015-03-03 | AMLP | ETF | 84.2 | 85.0 | 84.15 | 84.85 | 671020.0 |
| 2015-03-03 | AMZA | ETF | 221.5 | 222.5 | 221.5 | 222.1 | 60.0 |
| 2015-03-03 | ANGL | ETF | 27.48 | 27.53 | 27.26 | 27.38 | 4600.0 |
| 2015-03-03 | AOA | ETF | 48.0 | 48.0 | 47.62 | 47.75 | 29300.0 |
| 2015-03-03 | AOK | ETF | 33.08 | 33.09 | 32.81 | 32.82 | 181656.0 |
| 2015-03-03 | AOM | ETF | 35.7 | 35.71 | 35.53 | 35.62 | 47784.0 |
| 2015-03-03 | AOR | ETF | 41.13 | 41.13 | 40.89 | 40.99 | 224665.0 |
| 2015-03-03 | ARGT | ETF | 20.08 | 20.19 | 20.08 | 20.1 | 800.0 |
| 2015-03-03 | ARKG | ETF | 23.3 | 23.3 | 23.0 | 23.085 | 5300.0 |
| 2015-03-03 | ARKK | ETF | 21.34 | 21.34 | 21.34 | 21.34 | 500.0 |
| 2015-03-03 | ARKQ | ETF | 20.409 | 20.412 | 20.341 | 20.344 | 2500.0 |
| 2015-03-03 | ARKW | ETF | 22.32 | 22.32 | 22.136 | 22.136 | 3600.0 |
| 2015-03-03 | ASEA | ETF | 15.75 | 15.75 | 15.66 | 15.67 | 20800.0 |
| 2015-03-03 | ASHR | ETF | 35.84 | 35.88 | 35.62 | 35.75 | 585700.0 |
| 2015-03-03 | ASHS | ETF | 40.34 | 40.34 | 40.11 | 40.2 | 8100.0 |
| 2015-03-03 | ATMP | ETF | 29.36 | 29.72 | 29.36 | 29.62 | 177700.0 |
| 2015-03-03 | AVIV | ETF | 36.27 | 36.3 | 35.85 | 36.14 | 92809.0 |
| 2015-03-03 | AWAY | ETF | 30.86 | 31.84 | 30.86 | 31.8 | 1575049.0 |
| 2015-03-03 | BAB | ETF | 30.13 | 30.26 | 30.0265 | 30.15 | 68181.0 |
| 2015-03-03 | BAL | ETF | 43.669 | 43.84 | 43.17 | 43.17 | 13371.0 |
| 2015-03-03 | BALT | ETF | 1.56 | 1.73 | 1.55 | 1.67 | 639809.0 |
| 2015-03-03 | BAR | ETF | 2.884 | 2.884 | 2.821 | 2.826 | 7580.0 |
| 2015-03-03 | BBC | ETF | 31.88 | 31.88 | 31.03 | 31.55 | 9319.0 |
| 2015-03-03 | BBH | ETF | 128.54 | 128.78 | 126.9 | 128.45 | 163200.0 |
| 2015-03-03 | BBP | ETF | 30.4 | 30.4 | 30.06 | 30.28 | 5400.0 |
| 2015-03-03 | BCHP | ETF | 19.5325 | 19.5325 | 19.4001 | 19.45 | 1466.0 |
| 2015-03-03 | BCM | ETF | 31.76 | 31.831 | 31.76 | 31.831 | 7211.0 |
| 2015-03-03 | BFOR | ETF | 8.2125 | 8.225 | 8.165 | 8.195 | 20000.0 |
| 2015-03-03 | BIB | ETF | 77.995 | 77.995 | 75.386 | 77.135 | 1060208.0 |
> showing 50 of 1,175 rows — these rows as CSV