PREVIEW / etf_daily / 2015-08-03
file: by_date/etf_daily/2015/2015-08-03.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-08-03 | SPY | ETF | 210.46 | 210.53 | 208.65 | 209.79 | 113965700.0 |
| 2015-08-03 | QQQ | ETF | 111.97 | 112.28 | 110.861 | 111.6 | 25001780.0 |
| 2015-08-03 | IWM | ETF | 123.03 | 123.16 | 121.46 | 122.35 | 34033200.0 |
| 2015-08-03 | DIA | ETF | 176.82 | 176.87 | 174.74 | 175.75 | 4530500.0 |
| 2015-08-03 | GLD | ETF | 104.59 | 104.82 | 104.05 | 104.1 | 3528600.0 |
| 2015-08-03 | TLT | ETF | 122.32 | 123.75 | 122.32 | 123.55 | 11753700.0 |
| 2015-08-03 | AADR | ETF | 39.95 | 39.95 | 39.94 | 39.95 | 700.0 |
| 2015-08-03 | AAXJ | ETF | 58.6 | 58.61 | 58.19 | 58.35 | 3003400.0 |
| 2015-08-03 | ACTX | ETF | 1.475 | 1.475 | 1.18 | 1.18 | 14.0 |
| 2015-08-03 | ACWF | ETF | 24.43 | 24.57 | 24.33 | 24.51 | 6997.0 |
| 2015-08-03 | ACWI | ETF | 59.92 | 59.94 | 59.5 | 59.75 | 2243300.0 |
| 2015-08-03 | ACWV | ETF | 71.16 | 71.26 | 70.85 | 71.12 | 38100.0 |
| 2015-08-03 | ACWX | ETF | 43.93 | 43.99 | 43.6901 | 43.845 | 211250.0 |
| 2015-08-03 | ADRE | ETF | 32.39 | 32.4248 | 32.222 | 32.3926 | 12994.0 |
| 2015-08-03 | AFK | ETF | 22.45 | 22.4999 | 21.95 | 22.1045 | 51778.0 |
| 2015-08-03 | AFTY | ETF | 18.15 | 18.35 | 18.0 | 18.19 | 67200.0 |
| 2015-08-03 | AGG | ETF | 109.29 | 109.54 | 109.19 | 109.4 | 2563900.0 |
| 2015-08-03 | AGQ | ETF | 31.83 | 31.89 | 30.54 | 30.99 | 206500.0 |
| 2015-08-03 | AGZ | ETF | 113.5371 | 113.5371 | 113.1101 | 113.45 | 11086.0 |
| 2015-08-03 | AGZD | ETF | 24.335 | 24.355 | 24.235 | 24.295 | 21400.0 |
| 2015-08-03 | AIA | ETF | 46.57 | 46.57 | 46.22 | 46.3268 | 24948.0 |
| 2015-08-03 | AIQ | ETF | 15.06 | 16.26 | 15.06 | 15.38 | 23465.0 |
| 2015-08-03 | AIRR | ETF | 17.56 | 17.56 | 17.18 | 17.21 | 71000.0 |
| 2015-08-03 | AIVI | ETF | 43.19 | 43.21 | 42.85 | 42.98 | 12500.0 |
| 2015-08-03 | ALTY | ETF | 15.06 | 15.06 | 14.88 | 14.88 | 900.0 |
| 2015-08-03 | AMJ | ETF | 38.15 | 38.15 | 37.29 | 37.43 | 1422206.0 |
| 2015-08-03 | AMLP | ETF | 76.65 | 76.95 | 75.6 | 75.75 | 1103960.0 |
| 2015-08-03 | AMZA | ETF | 183.7 | 185.2 | 178.7 | 179.37 | 3820.0 |
| 2015-08-03 | ANGL | ETF | 26.99 | 26.99 | 26.88 | 26.92 | 26900.0 |
| 2015-08-03 | AOA | ETF | 47.34 | 47.34 | 47.01 | 47.16 | 40900.0 |
| 2015-08-03 | AOK | ETF | 32.54 | 32.599 | 32.46 | 32.525 | 15831.0 |
| 2015-08-03 | AOM | ETF | 35.21 | 35.25 | 35.1 | 35.23 | 44385.0 |
| 2015-08-03 | AOR | ETF | 40.57 | 40.59 | 40.4 | 40.49 | 18598.0 |
| 2015-08-03 | ARGT | ETF | 18.37 | 18.37 | 18.12 | 18.12 | 2500.0 |
| 2015-08-03 | ARKG | ETF | 22.79 | 22.79 | 22.64 | 22.64 | 2400.0 |
| 2015-08-03 | ARKK | ETF | 21.11 | 21.11 | 21.11 | 21.11 | 200.0 |
| 2015-08-03 | ARKQ | ETF | 19.38 | 19.38 | 19.3 | 19.3 | 1300.0 |
| 2015-08-03 | ARKW | ETF | 23.89 | 23.89 | 23.305 | 23.305 | 600.0 |
| 2015-08-03 | ASEA | ETF | 14.43 | 14.46 | 14.43 | 14.44 | 4900.0 |
| 2015-08-03 | ASHR | ETF | 39.17 | 39.46 | 39.15 | 39.32 | 2306100.0 |
| 2015-08-03 | ASHS | ETF | 47.63 | 47.63 | 46.72 | 46.88 | 84100.0 |
| 2015-08-03 | ATMP | ETF | 25.88 | 25.88 | 25.57 | 25.58 | 48100.0 |
| 2015-08-03 | AWAY | ETF | 30.0 | 30.0 | 28.74 | 28.95 | 2016105.0 |
| 2015-08-03 | BAB | ETF | 29.2 | 29.38 | 29.2 | 29.29 | 84131.0 |
| 2015-08-03 | BAL | ETF | 42.43 | 42.75 | 42.4201 | 42.64 | 6449.0 |
| 2015-08-03 | BBC | ETF | 36.26 | 37.0 | 36.105 | 36.44 | 62777.0 |
| 2015-08-03 | BBH | ETF | 140.17 | 140.75 | 138.59 | 139.89 | 140400.0 |
| 2015-08-03 | BBP | ETF | 36.0 | 36.45 | 35.87 | 36.09 | 9200.0 |
| 2015-08-03 | BCHP | ETF | 19.0371 | 19.0371 | 19.0371 | 19.0371 | 214.0 |
| 2015-08-03 | BCM | ETF | 27.358 | 27.358 | 27.35 | 27.35 | 357.0 |
> showing 50 of 1,193 rows — these rows as CSV