PREVIEW / etf_daily / 2015-12-30
file: by_date/etf_daily/2015/2015-12-30.parquet size: 50 KB rows: 1,240
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-30 | SPY | ETF | 207.11 | 207.21 | 205.76 | 205.93 | 63317700.0 |
| 2015-12-30 | QQQ | ETF | 114.16 | 114.24 | 113.25 | 113.27 | 19520081.0 |
| 2015-12-30 | IWM | ETF | 115.05 | 115.35 | 114.0 | 114.04 | 21273200.0 |
| 2015-12-30 | DIA | ETF | 176.57 | 176.72 | 175.62 | 175.8 | 2910000.0 |
| 2015-12-30 | GLD | ETF | 101.47 | 101.6 | 101.35 | 101.42 | 3745000.0 |
| 2015-12-30 | TLT | ETF | 119.92 | 120.54 | 119.67 | 120.04 | 5508900.0 |
| 2015-12-30 | AADR | ETF | 38.94 | 38.94 | 38.88 | 38.88 | 400.0 |
| 2015-12-30 | AAXJ | ETF | 53.69 | 53.8 | 53.55 | 53.56 | 893200.0 |
| 2015-12-30 | ACTX | ETF | 6.4901 | 7.6701 | 6.4901 | 7.6701 | 501.0 |
| 2015-12-30 | ACWF | ETF | 23.9 | 23.9 | 23.59 | 23.59 | 926.0 |
| 2015-12-30 | ACWI | ETF | 56.65 | 56.67 | 56.33 | 56.38 | 2460200.0 |
| 2015-12-30 | ACWV | ETF | 70.07 | 70.19 | 69.82 | 69.88 | 262800.0 |
| 2015-12-30 | ACWX | ETF | 40.13 | 40.16 | 39.97 | 39.97 | 1694913.0 |
| 2015-12-30 | ADRE | ETF | 29.57 | 29.57 | 29.21 | 29.24 | 36168.0 |
| 2015-12-30 | AFK | ETF | 17.75 | 17.8989 | 17.71 | 17.72 | 40325.0 |
| 2015-12-30 | AFTY | ETF | 14.34 | 14.37 | 14.25 | 14.25 | 26400.0 |
| 2015-12-30 | AGG | ETF | 107.64 | 107.78 | 107.6 | 107.72 | 3731400.0 |
| 2015-12-30 | AGQ | ETF | 27.08 | 27.26 | 27.0 | 27.15 | 120200.0 |
| 2015-12-30 | AGZ | ETF | 112.5032 | 112.9899 | 112.5001 | 112.8038 | 10841.0 |
| 2015-12-30 | AGZD | ETF | 24.03 | 24.03 | 23.965 | 23.965 | 4800.0 |
| 2015-12-30 | AIA | ETF | 42.5 | 42.58 | 42.39 | 42.39 | 23840.0 |
| 2015-12-30 | AIQ | ETF | 9.1 | 9.1 | 8.6 | 8.79 | 20153.0 |
| 2015-12-30 | AIRR | ETF | 16.855 | 16.855 | 16.75 | 16.76 | 6300.0 |
| 2015-12-30 | AIVI | ETF | 38.59 | 38.69 | 38.52 | 38.53 | 70000.0 |
| 2015-12-30 | AMJ | ETF | 27.7 | 28.11 | 27.22 | 27.86 | 5172867.0 |
| 2015-12-30 | AMLP | ETF | 57.0 | 57.9 | 55.95 | 57.6 | 4017060.0 |
| 2015-12-30 | AMZA | ETF | 105.04 | 105.8 | 103.4 | 105.8 | 1270.0 |
| 2015-12-30 | ANGL | ETF | 24.42 | 24.42 | 24.3 | 24.33 | 22300.0 |
| 2015-12-30 | AOA | ETF | 45.47 | 45.47 | 45.22 | 45.25 | 135400.0 |
| 2015-12-30 | AOK | ETF | 31.72 | 31.7499 | 31.6501 | 31.71 | 93551.0 |
| 2015-12-30 | AOM | ETF | 34.25 | 34.29 | 34.1501 | 34.17 | 224009.0 |
| 2015-12-30 | AOR | ETF | 39.15 | 39.15 | 39.04 | 39.08 | 410809.0 |
| 2015-12-30 | ARGT | ETF | 18.16 | 18.25 | 18.11 | 18.16 | 23200.0 |
| 2015-12-30 | ARKG | ETF | 21.03 | 21.15 | 21.0 | 21.0 | 7900.0 |
| 2015-12-30 | ARKK | ETF | 20.91 | 20.91 | 20.837 | 20.84 | 3000.0 |
| 2015-12-30 | ARKQ | ETF | 19.53 | 19.54 | 19.47 | 19.47 | 1000.0 |
| 2015-12-30 | ARKW | ETF | 23.63 | 23.63 | 23.41 | 23.41 | 1700.0 |
| 2015-12-30 | ASEA | ETF | 12.21 | 12.22 | 12.15 | 12.16 | 3200.0 |
| 2015-12-30 | ASET | ETF | 24.537 | 24.537 | 24.48 | 24.48 | 500.0 |
| 2015-12-30 | ASHR | ETF | 28.22 | 28.4 | 28.15 | 28.3 | 1260900.0 |
| 2015-12-30 | ASHS | ETF | 42.34 | 42.46 | 41.99 | 42.0 | 107100.0 |
| 2015-12-30 | ASHX | ETF | 25.93 | 25.93 | 25.63 | 25.64 | 1044.0 |
| 2015-12-30 | ATMP | ETF | 18.38 | 18.41 | 17.85 | 18.26 | 363600.0 |
| 2015-12-30 | BAB | ETF | 28.92 | 28.94 | 28.75 | 28.94 | 141221.0 |
| 2015-12-30 | BAL | ETF | 42.62 | 42.62 | 42.62 | 42.62 | 335.0 |
| 2015-12-30 | BBC | ETF | 29.34 | 29.735 | 29.2599 | 29.2599 | 6038.0 |
| 2015-12-30 | BBH | ETF | 128.08 | 128.34 | 127.1 | 127.47 | 64300.0 |
| 2015-12-30 | BBP | ETF | 31.16 | 31.208 | 31.0 | 31.0 | 8900.0 |
| 2015-12-30 | BCM | ETF | 23.5783 | 23.62 | 23.55 | 23.62 | 30081.0 |
| 2015-12-30 | BFOR | ETF | 7.6575 | 7.6575 | 7.59 | 7.5975 | 67200.0 |
> showing 50 of 1,240 rows — these rows as CSV