PREVIEW / etf_daily / 2015-07-10
file: by_date/etf_daily/2015/2015-07-10.parquet size: 48 KB rows: 1,193
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-07-10 | SPY | ETF | 207.29 | 207.98 | 204.95 | 207.48 | 129456900.0 |
| 2015-07-10 | QQQ | ETF | 107.44 | 108.05 | 107.05 | 107.65 | 26415825.0 |
| 2015-07-10 | IWM | ETF | 123.84 | 124.34 | 123.36 | 124.13 | 28735800.0 |
| 2015-07-10 | DIA | ETF | 177.22 | 177.8 | 176.62 | 177.41 | 4504400.0 |
| 2015-07-10 | GLD | ETF | 111.18 | 111.71 | 111.03 | 111.49 | 3594900.0 |
| 2015-07-10 | TLT | ETF | 116.04 | 116.72 | 115.76 | 116.05 | 13636600.0 |
| 2015-07-10 | AAXJ | ETF | 61.03 | 61.2 | 60.65 | 61.12 | 2208800.0 |
| 2015-07-10 | ACTX | ETF | 1.77 | 1.77 | 1.18 | 1.18 | 31.0 |
| 2015-07-10 | ACWF | ETF | 24.95 | 24.95 | 24.95 | 24.95 | 210.0 |
| 2015-07-10 | ACWI | ETF | 59.57 | 59.82 | 59.38 | 59.72 | 1506700.0 |
| 2015-07-10 | ACWV | ETF | 70.26 | 70.46 | 70.08 | 70.28 | 58500.0 |
| 2015-07-10 | ACWX | ETF | 44.13 | 44.31 | 43.97 | 44.23 | 977091.0 |
| 2015-07-10 | ADRE | ETF | 33.97 | 34.0617 | 33.8101 | 34.055 | 8388.0 |
| 2015-07-10 | AFK | ETF | 23.4799 | 23.55 | 23.2 | 23.23 | 5773.0 |
| 2015-07-10 | AFTY | ETF | 21.65 | 21.65 | 20.82 | 21.49 | 853400.0 |
| 2015-07-10 | AGG | ETF | 108.47 | 108.58 | 108.28 | 108.38 | 2163700.0 |
| 2015-07-10 | AGGY | ETF | 49.62 | 49.62 | 49.6 | 49.6 | 400.0 |
| 2015-07-10 | AGQ | ETF | 35.35 | 36.11 | 35.14 | 35.73 | 185600.0 |
| 2015-07-10 | AGZ | ETF | 112.96 | 113.15 | 112.92 | 112.98 | 14862.0 |
| 2015-07-10 | AGZD | ETF | 24.325 | 24.38 | 24.29 | 24.365 | 8400.0 |
| 2015-07-10 | AIA | ETF | 48.74 | 48.74 | 48.19 | 48.52 | 59312.0 |
| 2015-07-10 | AIQ | ETF | 17.08 | 17.1125 | 16.84 | 17.0 | 26453.0 |
| 2015-07-10 | AIRR | ETF | 17.96 | 18.04 | 17.93 | 18.04 | 6300.0 |
| 2015-07-10 | AIVI | ETF | 42.43 | 43.12 | 42.43 | 43.1 | 16000.0 |
| 2015-07-10 | AMJ | ETF | 39.64 | 40.07 | 39.55 | 40.02 | 1254409.0 |
| 2015-07-10 | AMLP | ETF | 78.05 | 78.6 | 77.9 | 78.55 | 742900.0 |
| 2015-07-10 | AMZA | ETF | 189.3 | 193.6 | 189.3 | 193.0 | 1230.0 |
| 2015-07-10 | ANGL | ETF | 27.24 | 27.24 | 27.04 | 27.11 | 14200.0 |
| 2015-07-10 | AOA | ETF | 46.92 | 47.12 | 46.89 | 47.1 | 28700.0 |
| 2015-07-10 | AOK | ETF | 32.34 | 32.3799 | 32.24 | 32.34 | 32442.0 |
| 2015-07-10 | AOM | ETF | 35.05 | 35.05 | 34.9 | 34.99 | 38165.0 |
| 2015-07-10 | AOR | ETF | 40.19 | 40.3 | 40.15 | 40.29 | 46817.0 |
| 2015-07-10 | ARGT | ETF | 19.35 | 19.55 | 19.33 | 19.52 | 4300.0 |
| 2015-07-10 | ARKG | ETF | 22.85 | 22.87 | 22.85 | 22.85 | 700.0 |
| 2015-07-10 | ARKK | ETF | 21.128 | 21.17 | 21.1 | 21.17 | 6100.0 |
| 2015-07-10 | ARKQ | ETF | 19.52 | 19.52 | 19.52 | 19.52 | 100.0 |
| 2015-07-10 | ARKW | ETF | 22.97 | 23.07 | 22.96 | 23.04 | 4600.0 |
| 2015-07-10 | ASEA | ETF | 14.91 | 14.99 | 14.89 | 14.96 | 3200.0 |
| 2015-07-10 | ASHR | ETF | 43.51 | 43.55 | 42.44 | 43.25 | 8118200.0 |
| 2015-07-10 | ASHS | ETF | 50.92 | 53.69 | 49.5 | 53.49 | 791600.0 |
| 2015-07-10 | ATMP | ETF | 27.15 | 27.35 | 27.09 | 27.34 | 10900.0 |
| 2015-07-10 | AWAY | ETF | 30.05 | 30.87 | 29.99 | 30.66 | 1095114.0 |
| 2015-07-10 | BAB | ETF | 28.73 | 28.8599 | 28.6 | 28.71 | 336028.0 |
| 2015-07-10 | BAL | ETF | 44.77 | 45.09 | 43.85 | 43.94 | 7233.0 |
| 2015-07-10 | BALT | ETF | 1.49 | 1.53 | 1.4 | 1.51 | 283321.0 |
| 2015-07-10 | BBC | ETF | 36.15 | 36.83 | 36.0071 | 36.83 | 28534.0 |
| 2015-07-10 | BBH | ETF | 134.75 | 137.42 | 133.77 | 135.03 | 54200.0 |
| 2015-07-10 | BBP | ETF | 34.93 | 34.93 | 34.305 | 34.762 | 13000.0 |
| 2015-07-10 | BCHP | ETF | 19.31 | 19.394 | 19.31 | 19.394 | 1401.0 |
| 2015-07-10 | BCM | ETF | 30.36 | 30.36 | 30.3457 | 30.3457 | 900.0 |
> showing 50 of 1,193 rows — these rows as CSV