PREVIEW / etf_daily / 2015-05-05
file: by_date/etf_daily/2015/2015-05-05.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-05-05 | SPY | ETF | 211.03 | 211.46 | 208.73 | 208.9 | 113326200.0 |
| 2015-05-05 | QQQ | ETF | 108.8 | 109.0 | 107.4 | 107.45 | 47843265.0 |
| 2015-05-05 | IWM | ETF | 122.35 | 122.62 | 120.28 | 120.85 | 56891600.0 |
| 2015-05-05 | DIA | ETF | 180.23 | 180.59 | 178.78 | 179.01 | 5316300.0 |
| 2015-05-05 | GLD | ETF | 114.89 | 115.11 | 114.39 | 114.42 | 3856500.0 |
| 2015-05-05 | TLT | ETF | 122.86 | 123.03 | 121.69 | 122.66 | 13935500.0 |
| 2015-05-05 | AADR | ETF | 40.13 | 40.13 | 40.13 | 40.13 | 700.0 |
| 2015-05-05 | AAXJ | ETF | 68.45 | 68.55 | 67.89 | 67.98 | 1188900.0 |
| 2015-05-05 | ACTX | ETF | 2.95 | 2.95 | 2.36 | 2.36 | 730.0 |
| 2015-05-05 | ACWF | ETF | 25.06 | 25.06 | 25.0 | 25.0 | 550.0 |
| 2015-05-05 | ACWI | ETF | 62.19 | 62.31 | 61.6 | 61.65 | 2304900.0 |
| 2015-05-05 | ACWV | ETF | 73.37 | 73.53 | 72.72 | 72.84 | 137900.0 |
| 2015-05-05 | ACWX | ETF | 47.04 | 47.2 | 46.55 | 46.6 | 252561.0 |
| 2015-05-05 | ADRE | ETF | 37.6 | 37.7411 | 37.52 | 37.555 | 4642.0 |
| 2015-05-05 | AFK | ETF | 27.08 | 27.14 | 26.84 | 26.84 | 19749.0 |
| 2015-05-05 | AFTY | ETF | 22.36 | 22.423 | 22.205 | 22.24 | 109300.0 |
| 2015-05-05 | AGG | ETF | 110.19 | 110.22 | 109.84 | 110.03 | 1481200.0 |
| 2015-05-05 | AGQ | ETF | 41.47 | 41.63 | 40.74 | 40.84 | 121900.0 |
| 2015-05-05 | AGZ | ETF | 113.38 | 113.4 | 113.12 | 113.21 | 26532.0 |
| 2015-05-05 | AGZD | ETF | 24.455 | 24.52 | 24.455 | 24.52 | 4600.0 |
| 2015-05-05 | AIA | ETF | 53.88 | 53.88 | 53.37 | 53.4272 | 62074.0 |
| 2015-05-05 | AIQ | ETF | 21.02 | 21.2 | 20.54 | 20.59 | 21142.0 |
| 2015-05-05 | AIRR | ETF | 18.287 | 18.3 | 18.08 | 18.16 | 15400.0 |
| 2015-05-05 | AIVI | ETF | 46.08 | 46.13 | 45.63 | 45.68 | 87400.0 |
| 2015-05-05 | ALTL | ETF | 36.8 | 36.8 | 36.8 | 36.8 | 400.0 |
| 2015-05-05 | AMJ | ETF | 45.61 | 45.8061 | 45.29 | 45.46 | 1362666.0 |
| 2015-05-05 | AMLP | ETF | 86.15 | 86.5 | 85.8 | 86.2 | 2724580.0 |
| 2015-05-05 | AMZA | ETF | 225.1 | 226.3 | 224.8 | 225.2 | 550.0 |
| 2015-05-05 | ANGL | ETF | 27.64 | 27.67 | 27.49 | 27.67 | 5400.0 |
| 2015-05-05 | AOA | ETF | 48.64 | 48.65 | 48.07 | 48.07 | 20200.0 |
| 2015-05-05 | AOK | ETF | 33.0 | 33.0 | 32.85 | 32.9 | 34323.0 |
| 2015-05-05 | AOM | ETF | 35.8 | 35.8799 | 35.66 | 35.7 | 40684.0 |
| 2015-05-05 | AOR | ETF | 41.5 | 41.5 | 41.11 | 41.17 | 44050.0 |
| 2015-05-05 | ARGT | ETF | 22.5 | 22.67 | 22.44 | 22.49 | 7700.0 |
| 2015-05-05 | ARKG | ETF | 22.92 | 22.92 | 22.419 | 22.486 | 2300.0 |
| 2015-05-05 | ARKK | ETF | 20.77 | 20.77 | 20.77 | 20.77 | 100.0 |
| 2015-05-05 | ARKQ | ETF | 19.599 | 19.599 | 19.579 | 19.579 | 500.0 |
| 2015-05-05 | ARKW | ETF | 22.1 | 22.1 | 22.1 | 22.1 | 200.0 |
| 2015-05-05 | ASEA | ETF | 16.04 | 16.04 | 15.93 | 15.94 | 13900.0 |
| 2015-05-05 | ASHR | ETF | 47.6 | 47.65 | 47.08 | 47.11 | 2704200.0 |
| 2015-05-05 | ASHS | ETF | 53.91 | 53.91 | 53.24 | 53.41 | 73700.0 |
| 2015-05-05 | ATMP | ETF | 30.98 | 30.98 | 30.55 | 30.68 | 34300.0 |
| 2015-05-05 | AWAY | ETF | 27.74 | 27.87 | 27.0 | 27.13 | 1419123.0 |
| 2015-05-05 | BAB | ETF | 29.71 | 29.77 | 29.47 | 29.62 | 251997.0 |
| 2015-05-05 | BAL | ETF | 45.13 | 45.24 | 45.13 | 45.2 | 4792.0 |
| 2015-05-05 | BALT | ETF | 1.42 | 1.43 | 1.39 | 1.42 | 445421.0 |
| 2015-05-05 | BAR | ETF | 2.742 | 2.742 | 2.659 | 2.659 | 6900.0 |
| 2015-05-05 | BBC | ETF | 31.5 | 31.5 | 30.4278 | 30.58 | 23687.0 |
| 2015-05-05 | BBH | ETF | 129.05 | 129.05 | 126.22 | 126.46 | 113900.0 |
| 2015-05-05 | BBP | ETF | 30.57 | 30.57 | 30.0 | 30.1 | 3700.0 |
> showing 50 of 1,188 rows — these rows as CSV