PREVIEW / etf_daily / 2015-05-22
file: by_date/etf_daily/2015/2015-05-22.parquet size: 47 KB rows: 1,166
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-22 | SPY | ETF | 213.04 | 213.54 | 212.91 | 212.99 | 57433500.0 |
| 2015-05-22 | QQQ | ETF | 110.45 | 110.87 | 110.38 | 110.47 | 13543774.0 |
| 2015-05-22 | IWM | ETF | 124.76 | 125.24 | 124.0 | 124.43 | 22601400.0 |
| 2015-05-22 | DIA | ETF | 182.51 | 182.74 | 182.04 | 182.26 | 2357000.0 |
| 2015-05-22 | GLD | ETF | 115.51 | 115.93 | 115.32 | 115.6 | 1780200.0 |
| 2015-05-22 | TLT | ETF | 120.65 | 120.75 | 119.8 | 120.4 | 5417900.0 |
| 2015-05-22 | AADR | ETF | 40.7 | 40.7 | 40.46 | 40.46 | 200.0 |
| 2015-05-22 | AAXJ | ETF | 68.34 | 68.57 | 68.23 | 68.42 | 1220200.0 |
| 2015-05-22 | ACTX | ETF | 3.009 | 3.54 | 2.95 | 2.95 | 439.0 |
| 2015-05-22 | ACWF | ETF | 26.03 | 26.03 | 25.5017 | 25.5017 | 1172.0 |
| 2015-05-22 | ACWI | ETF | 62.86 | 62.92 | 62.74 | 62.74 | 273900.0 |
| 2015-05-22 | ACWV | ETF | 73.56 | 73.61 | 73.39 | 73.44 | 91300.0 |
| 2015-05-22 | ACWX | ETF | 47.47 | 47.49 | 47.36 | 47.41 | 103176.0 |
| 2015-05-22 | ADRE | ETF | 37.0 | 37.18 | 37.0 | 37.056 | 7751.0 |
| 2015-05-22 | AFK | ETF | 26.68 | 26.69 | 26.52 | 26.52 | 7579.0 |
| 2015-05-22 | AFTY | ETF | 23.02 | 23.37 | 23.01 | 23.37 | 66500.0 |
| 2015-05-22 | AGG | ETF | 109.85 | 109.86 | 109.62 | 109.79 | 1087000.0 |
| 2015-05-22 | AGQ | ETF | 43.4 | 43.93 | 43.12 | 43.32 | 170500.0 |
| 2015-05-22 | AGZ | ETF | 113.3401 | 113.5399 | 113.2601 | 113.31 | 10682.0 |
| 2015-05-22 | AGZD | ETF | 24.535 | 24.535 | 24.415 | 24.42 | 6800.0 |
| 2015-05-22 | AIA | ETF | 53.56 | 54.05 | 53.56 | 53.94 | 77830.0 |
| 2015-05-22 | AIQ | ETF | 20.26 | 20.3 | 20.05 | 20.06 | 18569.0 |
| 2015-05-22 | AIRR | ETF | 18.49 | 18.513 | 18.4 | 18.4 | 4100.0 |
| 2015-05-22 | AIVI | ETF | 46.5 | 46.5 | 46.29 | 46.39 | 12600.0 |
| 2015-05-22 | AMJ | ETF | 44.68 | 45.1099 | 44.64 | 45.01 | 692055.0 |
| 2015-05-22 | AMLP | ETF | 84.05 | 84.55 | 83.95 | 84.45 | 465300.0 |
| 2015-05-22 | AMZA | ETF | 222.4 | 223.5 | 222.3 | 223.28 | 620.0 |
| 2015-05-22 | ANGL | ETF | 27.58 | 27.63 | 27.55 | 27.63 | 9500.0 |
| 2015-05-22 | AOA | ETF | 49.05 | 49.05 | 48.86 | 48.94 | 42000.0 |
| 2015-05-22 | AOK | ETF | 33.01 | 33.0999 | 32.99 | 33.0654 | 34980.0 |
| 2015-05-22 | AOM | ETF | 35.87 | 36.0 | 35.8601 | 35.91 | 60000.0 |
| 2015-05-22 | AOR | ETF | 41.81 | 41.81 | 41.61 | 41.68 | 56726.0 |
| 2015-05-22 | ARGT | ETF | 21.87 | 21.87 | 21.71 | 21.84 | 6100.0 |
| 2015-05-22 | ARKG | ETF | 23.2 | 23.25 | 23.2 | 23.2 | 2400.0 |
| 2015-05-22 | ARKK | ETF | 21.52 | 21.52 | 21.457 | 21.457 | 300.0 |
| 2015-05-22 | ARKQ | ETF | 20.07 | 20.11 | 20.07 | 20.11 | 3400.0 |
| 2015-05-22 | ARKW | ETF | 23.39 | 23.39 | 23.35 | 23.36 | 3800.0 |
| 2015-05-22 | ASEA | ETF | 16.01 | 16.02 | 15.86 | 15.9 | 6900.0 |
| 2015-05-22 | ASHR | ETF | 51.6 | 52.23 | 51.52 | 52.09 | 1982600.0 |
| 2015-05-22 | ASHS | ETF | 66.0 | 66.01 | 64.54 | 65.49 | 125800.0 |
| 2015-05-22 | ATMP | ETF | 30.34 | 30.62 | 30.34 | 30.6 | 6600.0 |
| 2015-05-22 | AWAY | ETF | 28.4 | 28.67 | 28.32 | 28.5 | 721218.0 |
| 2015-05-22 | BAB | ETF | 29.02 | 29.05 | 28.91 | 28.93 | 125478.0 |
| 2015-05-22 | BAL | ETF | 43.021 | 43.09 | 42.91 | 42.9217 | 3423.0 |
| 2015-05-22 | BALT | ETF | 1.5 | 1.56 | 1.49 | 1.52 | 525869.0 |
| 2015-05-22 | BAR | ETF | 2.7565 | 2.7565 | 2.7264 | 2.7264 | 2670.0 |
| 2015-05-22 | BBC | ETF | 34.88 | 34.88 | 34.38 | 34.63 | 17583.0 |
| 2015-05-22 | BBH | ETF | 134.99 | 135.78 | 134.97 | 135.32 | 88300.0 |
| 2015-05-22 | BBP | ETF | 32.62 | 32.62 | 32.289 | 32.496 | 7900.0 |
| 2015-05-22 | BCHP | ETF | 20.73 | 20.73 | 20.73 | 20.73 | 254.0 |
> showing 50 of 1,166 rows — these rows as CSV