PREVIEW / etf_daily / 2015-08-11
file: by_date/etf_daily/2015/2015-08-11.parquet size: 48 KB rows: 1,187
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-11 | SPY | ETF | 208.97 | 209.47 | 207.76 | 208.67 | 126081400.0 |
| 2015-08-11 | QQQ | ETF | 110.98 | 111.4101 | 109.53 | 110.14 | 36123270.0 |
| 2015-08-11 | IWM | ETF | 120.48 | 121.09 | 119.65 | 120.22 | 33383800.0 |
| 2015-08-11 | DIA | ETF | 174.59 | 174.89 | 173.58 | 174.11 | 6761100.0 |
| 2015-08-11 | GLD | ETF | 106.49 | 106.63 | 105.77 | 106.26 | 4060900.0 |
| 2015-08-11 | TLT | ETF | 124.3 | 125.13 | 124.16 | 124.75 | 11145700.0 |
| 2015-08-11 | AADR | ETF | 40.18 | 40.18 | 38.85 | 38.85 | 3300.0 |
| 2015-08-11 | AAXJ | ETF | 57.78 | 57.82 | 57.28 | 57.69 | 2349600.0 |
| 2015-08-11 | ACTX | ETF | 1.77 | 1.77 | 1.77 | 1.77 | 311.0 |
| 2015-08-11 | ACWI | ETF | 59.42 | 59.6 | 59.17 | 59.42 | 1025700.0 |
| 2015-08-11 | ACWV | ETF | 70.91 | 71.09 | 70.69 | 70.98 | 366500.0 |
| 2015-08-11 | ACWX | ETF | 43.79 | 43.79 | 43.51 | 43.7 | 435526.0 |
| 2015-08-11 | ADRE | ETF | 32.41 | 32.41 | 31.883 | 32.13 | 9314.0 |
| 2015-08-11 | AFK | ETF | 22.38 | 22.39 | 22.02 | 22.2199 | 32699.0 |
| 2015-08-11 | AFTY | ETF | 18.41 | 18.63 | 18.41 | 18.56 | 113900.0 |
| 2015-08-11 | AGG | ETF | 109.42 | 109.58 | 109.28 | 109.42 | 1537300.0 |
| 2015-08-11 | AGQ | ETF | 34.47 | 34.55 | 33.82 | 34.48 | 259500.0 |
| 2015-08-11 | AGZ | ETF | 113.4 | 113.67 | 113.395 | 113.49 | 13740.0 |
| 2015-08-11 | AGZD | ETF | 24.33 | 24.435 | 24.315 | 24.315 | 15200.0 |
| 2015-08-11 | AIA | ETF | 45.95 | 45.95 | 45.6208 | 45.87 | 39651.0 |
| 2015-08-11 | AIQ | ETF | 14.74 | 15.13 | 14.53 | 15.05 | 14591.0 |
| 2015-08-11 | AIRR | ETF | 17.004 | 17.034 | 16.84 | 16.93 | 30700.0 |
| 2015-08-11 | AIVI | ETF | 43.21 | 43.24 | 42.88 | 43.17 | 30100.0 |
| 2015-08-11 | ALTY | ETF | 14.86 | 14.86 | 14.86 | 14.86 | 200.0 |
| 2015-08-11 | AMJ | ETF | 35.76 | 36.04 | 35.47 | 36.03 | 1811530.0 |
| 2015-08-11 | AMLP | ETF | 73.0 | 73.9 | 72.9 | 73.9 | 1592480.0 |
| 2015-08-11 | AMZA | ETF | 166.9 | 167.5 | 162.8 | 166.4 | 1880.0 |
| 2015-08-11 | ANGL | ETF | 26.72 | 26.73 | 26.59 | 26.59 | 21000.0 |
| 2015-08-11 | AOA | ETF | 47.24 | 47.24 | 46.83 | 47.01 | 26600.0 |
| 2015-08-11 | AOK | ETF | 32.37 | 32.45 | 32.36 | 32.39 | 32574.0 |
| 2015-08-11 | AOM | ETF | 35.15 | 35.1699 | 35.02 | 35.1 | 43199.0 |
| 2015-08-11 | AOR | ETF | 40.32 | 40.4375 | 40.2287 | 40.34 | 44223.0 |
| 2015-08-11 | ARGT | ETF | 19.4 | 19.43 | 19.14 | 19.38 | 27900.0 |
| 2015-08-11 | ARKG | ETF | 21.7 | 21.7 | 21.52 | 21.69 | 5100.0 |
| 2015-08-11 | ARKK | ETF | 20.917 | 20.998 | 20.917 | 20.998 | 500.0 |
| 2015-08-11 | ARKQ | ETF | 19.26 | 19.298 | 19.26 | 19.298 | 1200.0 |
| 2015-08-11 | ARKW | ETF | 23.4 | 23.511 | 23.33 | 23.511 | 600.0 |
| 2015-08-11 | ASEA | ETF | 13.79 | 13.79 | 13.56 | 13.62 | 14700.0 |
| 2015-08-11 | ASHR | ETF | 41.32 | 41.39 | 40.76 | 41.19 | 2634500.0 |
| 2015-08-11 | ASHS | ETF | 53.04 | 53.04 | 50.0 | 51.57 | 59900.0 |
| 2015-08-11 | ATMP | ETF | 24.43 | 24.65 | 24.3 | 24.65 | 170000.0 |
| 2015-08-11 | AWAY | ETF | 30.81 | 31.14 | 30.36 | 30.58 | 1353489.0 |
| 2015-08-11 | BAB | ETF | 29.33 | 29.45 | 29.236 | 29.39 | 68864.0 |
| 2015-08-11 | BAL | ETF | 41.21 | 41.27 | 41.18 | 41.18 | 1191.0 |
| 2015-08-11 | BBC | ETF | 33.25 | 33.9 | 32.6 | 32.86 | 50798.0 |
| 2015-08-11 | BBH | ETF | 135.54 | 136.92 | 134.4 | 135.67 | 176100.0 |
| 2015-08-11 | BBP | ETF | 34.05 | 34.563 | 33.683 | 34.1 | 27000.0 |
| 2015-08-11 | BCHP | ETF | 19.0 | 19.0 | 18.95 | 18.95 | 17933.0 |
| 2015-08-11 | BCM | ETF | 27.453 | 27.58 | 27.453 | 27.58 | 8831.0 |
| 2015-08-11 | BFOR | ETF | 8.195 | 8.195 | 8.1275 | 8.175 | 56400.0 |
> showing 50 of 1,187 rows — these rows as CSV