PREVIEW / etf_daily / 2015-12-24
file: by_date/etf_daily/2015/2015-12-24.parquet size: 47 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-12-24 | SPY | ETF | 205.72 | 206.33 | 205.42 | 205.68 | 48539600.0 |
| 2015-12-24 | QQQ | ETF | 112.57 | 112.9 | 112.54 | 112.59 | 11480244.0 |
| 2015-12-24 | IWM | ETF | 114.44 | 115.16 | 114.15 | 114.5 | 13370500.0 |
| 2015-12-24 | DIA | ETF | 175.66 | 175.82 | 175.18 | 175.22 | 1765100.0 |
| 2015-12-24 | GLD | ETF | 102.82 | 103.05 | 102.77 | 103.05 | 1710200.0 |
| 2015-12-24 | TLT | ETF | 121.47 | 121.87 | 121.4 | 121.83 | 3364600.0 |
| 2015-12-24 | AADR | ETF | 39.18 | 39.24 | 39.0 | 39.0 | 400.0 |
| 2015-12-24 | AAXJ | ETF | 55.52 | 55.52 | 53.97 | 54.48 | 380800.0 |
| 2015-12-24 | ACTX | ETF | 7.0801 | 7.0801 | 5.9001 | 6.4901 | 237.0 |
| 2015-12-24 | ACWI | ETF | 56.51 | 56.63 | 56.4 | 56.47 | 1860300.0 |
| 2015-12-24 | ACWV | ETF | 69.58 | 69.71 | 69.41 | 69.67 | 408500.0 |
| 2015-12-24 | ACWX | ETF | 40.04 | 40.66 | 40.04 | 40.14 | 893698.0 |
| 2015-12-24 | ADRE | ETF | 29.92 | 30.013 | 29.8401 | 29.8601 | 1177.0 |
| 2015-12-24 | AFK | ETF | 18.0 | 18.22 | 17.8999 | 17.93 | 28864.0 |
| 2015-12-24 | AFTY | ETF | 14.798 | 14.86 | 14.798 | 14.83 | 30700.0 |
| 2015-12-24 | AGG | ETF | 107.95 | 108.05 | 107.92 | 108.01 | 1248800.0 |
| 2015-12-24 | AGQ | ETF | 29.2 | 29.36 | 29.1 | 29.27 | 126900.0 |
| 2015-12-24 | AGZ | ETF | 112.85 | 113.052 | 112.8 | 112.8 | 10520.0 |
| 2015-12-24 | AGZD | ETF | 23.935 | 23.955 | 23.935 | 23.955 | 1400.0 |
| 2015-12-24 | AIA | ETF | 43.16 | 43.27 | 43.126 | 43.22 | 6838.0 |
| 2015-12-24 | AIQ | ETF | 8.93 | 9.0 | 8.9101 | 8.94 | 9858.0 |
| 2015-12-24 | AIRR | ETF | 16.91 | 16.97 | 16.91 | 16.97 | 1100.0 |
| 2015-12-24 | AIVI | ETF | 38.63 | 38.77 | 38.52 | 38.55 | 61300.0 |
| 2015-12-24 | AMJ | ETF | 28.88 | 29.45 | 28.77 | 28.97 | 2654709.0 |
| 2015-12-24 | AMLP | ETF | 59.95 | 60.7 | 59.45 | 59.7 | 1969400.0 |
| 2015-12-24 | AMZA | ETF | 110.5 | 114.4 | 109.3 | 113.4 | 9240.0 |
| 2015-12-24 | ANGL | ETF | 24.55 | 24.6 | 24.44 | 24.57 | 22300.0 |
| 2015-12-24 | AOA | ETF | 45.55 | 45.63 | 45.41 | 45.52 | 61700.0 |
| 2015-12-24 | AOK | ETF | 31.79 | 31.907 | 31.79 | 31.85 | 38984.0 |
| 2015-12-24 | AOM | ETF | 34.42 | 34.48 | 34.2821 | 34.43 | 291895.0 |
| 2015-12-24 | AOR | ETF | 39.09 | 39.39 | 39.09 | 39.32 | 451471.0 |
| 2015-12-24 | ARGT | ETF | 18.28 | 18.45 | 18.28 | 18.37 | 15700.0 |
| 2015-12-24 | ARKG | ETF | 20.905 | 20.905 | 20.905 | 20.905 | 100.0 |
| 2015-12-24 | ARKK | ETF | 20.879 | 20.879 | 20.879 | 20.879 | 100.0 |
| 2015-12-24 | ARKQ | ETF | 19.626 | 19.626 | 19.626 | 19.626 | 100.0 |
| 2015-12-24 | ARKW | ETF | 23.31 | 23.31 | 23.162 | 23.29 | 2500.0 |
| 2015-12-24 | ASEA | ETF | 12.61 | 12.77 | 12.61 | 12.71 | 2100.0 |
| 2015-12-24 | ASET | ETF | 24.72 | 24.72 | 24.72 | 24.72 | 3800.0 |
| 2015-12-24 | ASHR | ETF | 29.2 | 29.24 | 29.03 | 29.08 | 942200.0 |
| 2015-12-24 | ASHS | ETF | 43.67 | 43.67 | 43.02 | 43.11 | 39200.0 |
| 2015-12-24 | ASHX | ETF | 26.3 | 26.34 | 26.3 | 26.34 | 1438.0 |
| 2015-12-24 | ATMP | ETF | 18.95 | 19.25 | 18.66 | 18.82 | 344300.0 |
| 2015-12-24 | BAB | ETF | 28.91 | 29.01 | 28.91 | 28.95 | 53190.0 |
| 2015-12-24 | BAL | ETF | 41.74 | 42.42 | 41.72 | 42.23 | 6368.0 |
| 2015-12-24 | BBC | ETF | 29.35 | 29.76 | 29.35 | 29.73 | 2206.0 |
| 2015-12-24 | BBH | ETF | 126.54 | 127.5 | 125.42 | 127.15 | 17000.0 |
| 2015-12-24 | BBP | ETF | 31.0 | 31.12 | 30.91 | 30.94 | 8000.0 |
| 2015-12-24 | BFOR | ETF | 7.6075 | 7.645 | 7.6075 | 7.615 | 128800.0 |
| 2015-12-24 | BIB | ETF | 71.6 | 72.45 | 71.33 | 72.04 | 191649.0 |
| 2015-12-24 | BIL | ETF | 91.36 | 91.38 | 91.36 | 91.38 | 521050.0 |
> showing 50 of 1,188 rows — these rows as CSV