PREVIEW / etf_daily / 2015-06-24
file: by_date/etf_daily/2015/2015-06-24.parquet size: 48 KB rows: 1,188
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-06-24 | SPY | ETF | 211.72 | 212.17 | 210.47 | 210.5 | 92307300.0 |
| 2015-06-24 | QQQ | ETF | 110.66 | 111.13 | 110.19 | 110.22 | 15815914.0 |
| 2015-06-24 | IWM | ETF | 128.76 | 129.1 | 127.73 | 127.92 | 26436800.0 |
| 2015-06-24 | DIA | ETF | 180.56 | 180.97 | 179.39 | 179.41 | 4328900.0 |
| 2015-06-24 | GLD | ETF | 112.48 | 112.74 | 112.31 | 112.59 | 2975500.0 |
| 2015-06-24 | TLT | ETF | 116.51 | 117.17 | 116.16 | 116.95 | 8600400.0 |
| 2015-06-24 | AADR | ETF | 39.82 | 39.82 | 39.74 | 39.74 | 600.0 |
| 2015-06-24 | AAXJ | ETF | 65.46 | 65.65 | 65.15 | 65.15 | 1529100.0 |
| 2015-06-24 | ACTX | ETF | 2.36 | 2.36 | 1.77 | 2.36 | 559.0 |
| 2015-06-24 | ACWF | ETF | 25.21 | 25.22 | 25.21 | 25.22 | 2545.0 |
| 2015-06-24 | ACWI | ETF | 62.09 | 62.24 | 61.85 | 61.86 | 567100.0 |
| 2015-06-24 | ACWV | ETF | 71.9 | 71.92 | 71.53 | 71.64 | 93500.0 |
| 2015-06-24 | ACWX | ETF | 46.46 | 46.547 | 46.28 | 46.31 | 154384.0 |
| 2015-06-24 | ADRE | ETF | 36.08 | 36.24 | 35.9631 | 36.0239 | 7785.0 |
| 2015-06-24 | AFK | ETF | 25.0 | 25.13 | 24.6 | 24.96 | 28756.0 |
| 2015-06-24 | AFTY | ETF | 22.2 | 22.2 | 21.84 | 21.89 | 178300.0 |
| 2015-06-24 | AGG | ETF | 108.55 | 108.68 | 108.45 | 108.59 | 1527800.0 |
| 2015-06-24 | AGQ | ETF | 37.26 | 37.57 | 37.12 | 37.41 | 126400.0 |
| 2015-06-24 | AGZ | ETF | 112.9 | 113.075 | 112.898 | 113.05 | 10176.0 |
| 2015-06-24 | AGZD | ETF | 24.325 | 24.335 | 24.28 | 24.33 | 11400.0 |
| 2015-06-24 | AIA | ETF | 52.07 | 52.24 | 51.8 | 51.84 | 39024.0 |
| 2015-06-24 | AIQ | ETF | 19.74 | 20.19 | 19.55 | 19.64 | 17293.0 |
| 2015-06-24 | AIRR | ETF | 18.86 | 18.86 | 18.58 | 18.65 | 8800.0 |
| 2015-06-24 | AIVI | ETF | 44.39 | 44.53 | 44.28 | 44.3 | 13600.0 |
| 2015-06-24 | ALTL | ETF | 37.1951 | 37.25 | 37.19 | 37.234 | 885.0 |
| 2015-06-24 | AMJ | ETF | 41.34 | 41.65 | 41.28 | 41.37 | 2333012.0 |
| 2015-06-24 | AMLP | ETF | 80.5 | 80.65 | 80.25 | 80.4 | 763120.0 |
| 2015-06-24 | AMZA | ETF | 208.1 | 212.45 | 206.6 | 206.6 | 3380.0 |
| 2015-06-24 | ANGL | ETF | 27.31 | 27.31 | 27.23 | 27.27 | 27400.0 |
| 2015-06-24 | AOA | ETF | 48.63 | 48.63 | 48.27 | 48.37 | 41900.0 |
| 2015-06-24 | AOK | ETF | 32.72 | 32.742 | 32.6401 | 32.72 | 39492.0 |
| 2015-06-24 | AOM | ETF | 35.58 | 35.66 | 35.53 | 35.62 | 57439.0 |
| 2015-06-24 | AOR | ETF | 41.37 | 41.37 | 41.1501 | 41.1801 | 45162.0 |
| 2015-06-24 | ARGT | ETF | 20.93 | 21.06 | 20.93 | 20.98 | 4700.0 |
| 2015-06-24 | ARKG | ETF | 23.78 | 23.78 | 23.7 | 23.7 | 200.0 |
| 2015-06-24 | ARKK | ETF | 21.94 | 21.94 | 21.94 | 21.94 | 200.0 |
| 2015-06-24 | ARKQ | ETF | 20.328 | 20.328 | 20.328 | 20.328 | 100.0 |
| 2015-06-24 | ARKW | ETF | 23.87 | 23.89 | 23.58 | 23.58 | 17900.0 |
| 2015-06-24 | ASEA | ETF | 15.3 | 15.33 | 15.24 | 15.24 | 3900.0 |
| 2015-06-24 | ASHR | ETF | 51.07 | 51.1 | 50.33 | 50.39 | 4322300.0 |
| 2015-06-24 | ASHS | ETF | 67.76 | 67.88 | 66.83 | 66.95 | 128500.0 |
| 2015-06-24 | ATMP | ETF | 28.19 | 28.62 | 28.19 | 28.44 | 36900.0 |
| 2015-06-24 | AWAY | ETF | 31.5 | 31.77 | 31.18 | 31.6 | 1151710.0 |
| 2015-06-24 | BAB | ETF | 28.66 | 28.83 | 28.66 | 28.8 | 72843.0 |
| 2015-06-24 | BAL | ETF | 43.1026 | 43.19 | 43.02 | 43.17 | 2499.0 |
| 2015-06-24 | BALT | ETF | 1.57 | 1.65 | 1.57 | 1.6 | 413035.0 |
| 2015-06-24 | BBC | ETF | 37.11 | 37.4899 | 36.6405 | 36.8 | 11061.0 |
| 2015-06-24 | BBH | ETF | 140.08 | 140.36 | 138.16 | 138.37 | 112300.0 |
| 2015-06-24 | BBP | ETF | 36.66 | 36.66 | 35.568 | 35.66 | 45800.0 |
| 2015-06-24 | BCHP | ETF | 20.19 | 20.19 | 20.19 | 20.19 | 320.0 |
> showing 50 of 1,188 rows — these rows as CSV