PREVIEW / etf_daily / 2015-06-19
file: by_date/etf_daily/2015/2015-06-19.parquet size: 48 KB rows: 1,191
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-19 | SPY | ETF | 211.46 | 211.55 | 210.36 | 210.81 | 130478700.0 |
| 2015-06-19 | QQQ | ETF | 110.49 | 110.575 | 109.81 | 109.89 | 27877574.0 |
| 2015-06-19 | IWM | ETF | 127.82 | 128.16 | 127.6 | 127.86 | 23310900.0 |
| 2015-06-19 | DIA | ETF | 180.64 | 180.74 | 179.73 | 179.76 | 3964000.0 |
| 2015-06-19 | GLD | ETF | 115.34 | 115.46 | 114.95 | 115.12 | 4611600.0 |
| 2015-06-19 | TLT | ETF | 118.51 | 119.19 | 118.49 | 119.08 | 10439200.0 |
| 2015-06-19 | AAXJ | ETF | 64.29 | 64.44 | 64.12 | 64.13 | 752100.0 |
| 2015-06-19 | ACTX | ETF | 3.54 | 4.13 | 1.77 | 2.36 | 15905.0 |
| 2015-06-19 | ACWF | ETF | 25.12 | 25.2 | 25.12 | 25.2 | 2400.0 |
| 2015-06-19 | ACWI | ETF | 61.75 | 61.75 | 61.42 | 61.42 | 852500.0 |
| 2015-06-19 | ACWV | ETF | 71.8 | 71.82 | 71.51 | 71.59 | 222000.0 |
| 2015-06-19 | ACWX | ETF | 45.7101 | 45.83 | 45.68 | 45.68 | 95579.0 |
| 2015-06-19 | ADRE | ETF | 35.69 | 35.69 | 35.42 | 35.42 | 5198.0 |
| 2015-06-19 | AFK | ETF | 24.99 | 25.1199 | 24.86 | 24.918 | 4945.0 |
| 2015-06-19 | AFTY | ETF | 20.74 | 20.87 | 20.65 | 20.75 | 158300.0 |
| 2015-06-19 | AGG | ETF | 109.1 | 109.26 | 109.04 | 109.21 | 2048500.0 |
| 2015-06-19 | AGQ | ETF | 38.73 | 38.84 | 37.5 | 38.4 | 235400.0 |
| 2015-06-19 | AGZ | ETF | 113.165 | 113.5299 | 113.09 | 113.47 | 20485.0 |
| 2015-06-19 | AGZD | ETF | 24.43 | 24.43 | 24.325 | 24.38 | 7400.0 |
| 2015-06-19 | AIA | ETF | 51.08 | 51.2599 | 51.07 | 51.13 | 24747.0 |
| 2015-06-19 | AIQ | ETF | 20.12 | 20.55 | 20.03 | 20.04 | 33545.0 |
| 2015-06-19 | AIRR | ETF | 18.65 | 18.819 | 18.65 | 18.819 | 14900.0 |
| 2015-06-19 | AIVI | ETF | 44.83 | 44.83 | 44.63 | 44.73 | 99900.0 |
| 2015-06-19 | AMJ | ETF | 42.08 | 42.2099 | 41.32 | 41.35 | 1656156.0 |
| 2015-06-19 | AMLP | ETF | 81.05 | 81.35 | 80.45 | 80.55 | 967020.0 |
| 2015-06-19 | AMZA | ETF | 205.1 | 207.0 | 205.1 | 205.3 | 1090.0 |
| 2015-06-19 | ANGL | ETF | 27.3 | 27.34 | 27.28 | 27.28 | 15800.0 |
| 2015-06-19 | AOA | ETF | 48.18 | 48.35 | 48.1 | 48.11 | 55200.0 |
| 2015-06-19 | AOK | ETF | 32.77 | 32.77 | 32.6801 | 32.76 | 15897.0 |
| 2015-06-19 | AOM | ETF | 35.5 | 35.65 | 35.4322 | 35.53 | 31043.0 |
| 2015-06-19 | AOR | ETF | 41.24 | 41.24 | 41.08 | 41.08 | 34717.0 |
| 2015-06-19 | ARGT | ETF | 20.37 | 20.51 | 20.34 | 20.34 | 31800.0 |
| 2015-06-19 | ARKG | ETF | 23.78 | 23.78 | 23.677 | 23.68 | 14900.0 |
| 2015-06-19 | ARKK | ETF | 22.01 | 22.01 | 22.0 | 22.0 | 4800.0 |
| 2015-06-19 | ARKQ | ETF | 20.41 | 20.41 | 20.4 | 20.4 | 5700.0 |
| 2015-06-19 | ARKW | ETF | 23.83 | 23.83 | 23.8 | 23.83 | 1900.0 |
| 2015-06-19 | ASEA | ETF | 15.22 | 15.22 | 15.19 | 15.19 | 400.0 |
| 2015-06-19 | ASHR | ETF | 48.23 | 48.57 | 47.92 | 48.24 | 6505700.0 |
| 2015-06-19 | ASHS | ETF | 65.2 | 65.5 | 64.65 | 64.77 | 414000.0 |
| 2015-06-19 | ATMP | ETF | 28.49 | 28.49 | 28.22 | 28.23 | 35100.0 |
| 2015-06-19 | AWAY | ETF | 31.82 | 31.82 | 30.84 | 31.06 | 1506507.0 |
| 2015-06-19 | BAB | ETF | 28.85 | 29.03 | 28.85 | 28.95 | 69218.0 |
| 2015-06-19 | BAL | ETF | 43.1 | 43.1 | 42.48 | 43.0 | 24399.0 |
| 2015-06-19 | BALT | ETF | 1.57 | 1.58 | 1.53 | 1.56 | 260735.0 |
| 2015-06-19 | BAR | ETF | 2.682 | 2.737 | 2.682 | 2.737 | 16630.0 |
| 2015-06-19 | BBC | ETF | 36.82 | 36.82 | 36.0 | 36.45 | 9753.0 |
| 2015-06-19 | BBH | ETF | 138.55 | 139.35 | 137.85 | 138.84 | 120600.0 |
| 2015-06-19 | BBP | ETF | 35.9 | 35.96 | 35.28 | 35.71 | 36000.0 |
| 2015-06-19 | BCM | ETF | 31.11 | 31.1177 | 31.06 | 31.1177 | 4361.0 |
| 2015-06-19 | BFOR | ETF | 8.525 | 8.525 | 8.5025 | 8.5125 | 87200.0 |
> showing 50 of 1,191 rows — these rows as CSV