PREVIEW / etf_daily / 2015-08-24
file: by_date/etf_daily/2015/2015-08-24.parquet size: 49 KB rows: 1,228
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-24 | SPY | ETF | 187.49 | 197.48 | 182.4 | 189.5 | 507244300.0 |
| 2015-08-24 | QQQ | ETF | 94.23 | 102.53 | 84.74 | 98.46 | 150829863.0 |
| 2015-08-24 | IWM | ETF | 109.51 | 114.92 | 108.26 | 110.54 | 83809200.0 |
| 2015-08-24 | DIA | ETF | 155.9 | 163.45 | 150.57 | 158.38 | 35102400.0 |
| 2015-08-24 | GLD | ETF | 111.54 | 112.12 | 109.77 | 110.53 | 18388700.0 |
| 2015-08-24 | TLT | ETF | 128.31 | 128.92 | 125.82 | 126.36 | 16663400.0 |
| 2015-08-24 | AADR | ETF | 34.01 | 35.58 | 34.01 | 35.58 | 12000.0 |
| 2015-08-24 | AAXJ | ETF | 48.11 | 51.21 | 47.61 | 49.56 | 4640600.0 |
| 2015-08-24 | ACTX | ETF | 1.77 | 1.77 | 1.77 | 1.77 | 1580.0 |
| 2015-08-24 | ACWF | ETF | 22.0299 | 24.1 | 22.0299 | 22.3 | 4123.0 |
| 2015-08-24 | ACWI | ETF | 52.19 | 54.96 | 50.37 | 53.46 | 5052400.0 |
| 2015-08-24 | ACWV | ETF | 67.82 | 67.82 | 58.12 | 65.6 | 794200.0 |
| 2015-08-24 | ACWX | ETF | 38.63 | 39.8499 | 37.9508 | 38.94 | 1957707.0 |
| 2015-08-24 | ADRE | ETF | 26.87 | 29.21 | 19.552 | 28.08 | 87548.0 |
| 2015-08-24 | AFK | ETF | 19.67 | 20.15 | 19.1 | 19.54 | 129096.0 |
| 2015-08-24 | AFTY | ETF | 15.3 | 15.3 | 13.0 | 13.87 | 69300.0 |
| 2015-08-24 | AGG | ETF | 110.0 | 110.34 | 109.57 | 109.72 | 5440200.0 |
| 2015-08-24 | AGQ | ETF | 31.61 | 33.42 | 31.41 | 31.93 | 328600.0 |
| 2015-08-24 | AGZ | ETF | 114.89 | 114.89 | 113.55 | 113.765 | 66971.0 |
| 2015-08-24 | AGZD | ETF | 23.89 | 23.9 | 23.89 | 23.9 | 14600.0 |
| 2015-08-24 | AIA | ETF | 40.68 | 40.73 | 38.01 | 39.42 | 113395.0 |
| 2015-08-24 | AIQ | ETF | 14.59 | 14.7 | 13.8 | 13.84 | 28302.0 |
| 2015-08-24 | AIRR | ETF | 15.47 | 16.18 | 14.95 | 15.8 | 9600.0 |
| 2015-08-24 | AIVI | ETF | 39.49 | 39.84 | 38.09 | 38.94 | 175900.0 |
| 2015-08-24 | ALTY | ETF | 14.64 | 14.64 | 13.39 | 14.13 | 6500.0 |
| 2015-08-24 | AMJ | ETF | 32.62 | 34.69 | 31.353 | 33.69 | 5649512.0 |
| 2015-08-24 | AMLP | ETF | 67.0 | 72.25 | 58.75 | 72.25 | 2634580.0 |
| 2015-08-24 | AMZA | ETF | 155.5 | 164.6 | 148.0 | 151.0 | 6150.0 |
| 2015-08-24 | ANGL | ETF | 25.91 | 26.32 | 25.0 | 26.0 | 72200.0 |
| 2015-08-24 | AOA | ETF | 43.22 | 44.21 | 30.89 | 43.47 | 239000.0 |
| 2015-08-24 | AOK | ETF | 31.31 | 31.69 | 15.0 | 31.48 | 273844.0 |
| 2015-08-24 | AOM | ETF | 33.58 | 33.99 | 21.5 | 27.37 | 256151.0 |
| 2015-08-24 | AOR | ETF | 38.09 | 38.49 | 26.7 | 37.97 | 321087.0 |
| 2015-08-24 | ARGT | ETF | 16.68 | 16.68 | 16.0 | 16.5 | 13700.0 |
| 2015-08-24 | ARKG | ETF | 20.05 | 20.2 | 18.67 | 19.507 | 5600.0 |
| 2015-08-24 | ARKK | ETF | 17.75 | 18.96 | 17.51 | 18.96 | 10100.0 |
| 2015-08-24 | ARKQ | ETF | 17.88 | 17.88 | 16.38 | 17.593 | 1600.0 |
| 2015-08-24 | ARKW | ETF | 20.2 | 21.58 | 20.2 | 21.001 | 5400.0 |
| 2015-08-24 | ASEA | ETF | 11.65 | 12.19 | 11.02 | 12.19 | 15600.0 |
| 2015-08-24 | ASHR | ETF | 29.4 | 31.07 | 28.89 | 30.11 | 14065800.0 |
| 2015-08-24 | ASHS | ETF | 43.07 | 43.07 | 32.27 | 36.86 | 162200.0 |
| 2015-08-24 | ATMP | ETF | 15.4 | 23.5 | 15.09 | 22.94 | 28700.0 |
| 2015-08-24 | AWAY | ETF | 26.98 | 28.7 | 26.43 | 27.28 | 2331663.0 |
| 2015-08-24 | BAB | ETF | 29.52 | 29.6 | 29.22 | 29.31 | 128029.0 |
| 2015-08-24 | BAL | ETF | 42.86 | 43.33 | 42.81 | 42.87 | 12658.0 |
| 2015-08-24 | BBC | ETF | 27.02 | 30.62 | 27.01 | 29.02 | 47357.0 |
| 2015-08-24 | BBH | ETF | 116.5 | 125.76 | 95.76 | 119.75 | 388000.0 |
| 2015-08-24 | BBP | ETF | 31.1 | 31.84 | 28.01 | 30.34 | 112300.0 |
| 2015-08-24 | BCHP | ETF | 15.74 | 17.335 | 9.29 | 17.335 | 16065.0 |
| 2015-08-24 | BCM | ETF | 25.98 | 26.16 | 25.67 | 25.8 | 12477.0 |
> showing 50 of 1,228 rows — these rows as CSV