PREVIEW / etf_daily / 2015-05-18
file: by_date/etf_daily/2015/2015-05-18.parquet size: 48 KB rows: 1,185
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-18 | SPY | ETF | 212.24 | 213.4 | 212.16 | 213.1 | 74549700.0 |
| 2015-05-18 | QQQ | ETF | 109.4 | 110.28 | 109.32 | 110.06 | 17631135.0 |
| 2015-05-18 | IWM | ETF | 123.4 | 125.16 | 123.17 | 125.05 | 30846000.0 |
| 2015-05-18 | DIA | ETF | 182.43 | 183.01 | 182.19 | 182.68 | 2890500.0 |
| 2015-05-18 | GLD | ETF | 117.78 | 117.88 | 117.27 | 117.52 | 5079900.0 |
| 2015-05-18 | TLT | ETF | 120.32 | 120.43 | 119.47 | 119.55 | 10208300.0 |
| 2015-05-18 | AADR | ETF | 40.46 | 40.67 | 40.45 | 40.67 | 1200.0 |
| 2015-05-18 | AAXJ | ETF | 67.67 | 67.67 | 67.42 | 67.43 | 1388500.0 |
| 2015-05-18 | ACTX | ETF | 3.54 | 3.54 | 2.95 | 2.95 | 677.0 |
| 2015-05-18 | ACWF | ETF | 25.44 | 25.44 | 25.44 | 25.44 | 1000.0 |
| 2015-05-18 | ACWI | ETF | 62.73 | 62.92 | 62.64 | 62.86 | 356100.0 |
| 2015-05-18 | ACWV | ETF | 73.85 | 73.91 | 73.64 | 73.76 | 202700.0 |
| 2015-05-18 | ACWX | ETF | 47.5 | 47.558 | 47.44 | 47.54 | 827047.0 |
| 2015-05-18 | ADRE | ETF | 37.43 | 37.43 | 37.0201 | 37.108 | 6057.0 |
| 2015-05-18 | AFK | ETF | 26.97 | 27.24 | 26.8 | 27.05 | 43280.0 |
| 2015-05-18 | AFTY | ETF | 21.3 | 21.3 | 21.11 | 21.15 | 18900.0 |
| 2015-05-18 | AGG | ETF | 109.93 | 110.01 | 109.76 | 109.78 | 863900.0 |
| 2015-05-18 | AGQ | ETF | 46.54 | 46.83 | 46.0 | 46.5 | 204700.0 |
| 2015-05-18 | AGZ | ETF | 113.36 | 113.36 | 113.13 | 113.16 | 12734.0 |
| 2015-05-18 | AGZD | ETF | 24.605 | 24.605 | 24.435 | 24.525 | 23800.0 |
| 2015-05-18 | AIA | ETF | 53.08 | 53.08 | 52.87 | 53.02 | 15652.0 |
| 2015-05-18 | AIQ | ETF | 21.04 | 21.58 | 20.5 | 20.52 | 16420.0 |
| 2015-05-18 | AIRR | ETF | 18.331 | 18.455 | 18.25 | 18.45 | 22200.0 |
| 2015-05-18 | AIVI | ETF | 46.73 | 46.84 | 46.57 | 46.68 | 20300.0 |
| 2015-05-18 | AMJ | ETF | 45.09 | 45.41 | 44.8 | 45.39 | 596732.0 |
| 2015-05-18 | AMLP | ETF | 84.4 | 84.95 | 84.25 | 84.85 | 717720.0 |
| 2015-05-18 | AMZA | ETF | 225.6 | 228.03 | 224.9 | 226.5 | 2520.0 |
| 2015-05-18 | ANGL | ETF | 28.14 | 29.14 | 27.59 | 27.64 | 15900.0 |
| 2015-05-18 | AOA | ETF | 49.02 | 49.1 | 48.88 | 49.01 | 32800.0 |
| 2015-05-18 | AOK | ETF | 33.1 | 33.12 | 33.0101 | 33.1 | 79899.0 |
| 2015-05-18 | AOM | ETF | 36.05 | 36.05 | 35.88 | 35.96 | 111690.0 |
| 2015-05-18 | AOR | ETF | 41.75 | 41.75 | 41.59 | 41.72 | 76357.0 |
| 2015-05-18 | ARGT | ETF | 22.3 | 22.36 | 22.25 | 22.25 | 2800.0 |
| 2015-05-18 | ARKG | ETF | 23.17 | 23.17 | 23.1 | 23.15 | 900.0 |
| 2015-05-18 | ARKK | ETF | 21.249 | 21.249 | 21.249 | 21.249 | 300.0 |
| 2015-05-18 | ARKQ | ETF | 19.925 | 20.03 | 19.925 | 20.03 | 500.0 |
| 2015-05-18 | ARKW | ETF | 22.91 | 23.079 | 22.91 | 23.04 | 1400.0 |
| 2015-05-18 | ASEA | ETF | 16.07 | 16.07 | 16.04 | 16.07 | 1000.0 |
| 2015-05-18 | ASHR | ETF | 47.18 | 47.23 | 47.05 | 47.13 | 1128000.0 |
| 2015-05-18 | ASHS | ETF | 57.97 | 58.81 | 57.97 | 58.47 | 51600.0 |
| 2015-05-18 | ATMP | ETF | 30.47 | 30.83 | 30.47 | 30.78 | 42400.0 |
| 2015-05-18 | AWAY | ETF | 28.05 | 28.56 | 27.82 | 28.51 | 1173560.0 |
| 2015-05-18 | BAB | ETF | 29.14 | 29.1563 | 28.95 | 28.95 | 99023.0 |
| 2015-05-18 | BAL | ETF | 45.11 | 45.11 | 43.8501 | 43.8501 | 39642.0 |
| 2015-05-18 | BALT | ETF | 1.51 | 1.53 | 1.45 | 1.46 | 119005.0 |
| 2015-05-18 | BAR | ETF | 2.895 | 2.928 | 2.877 | 2.877 | 32270.0 |
| 2015-05-18 | BBC | ETF | 33.15 | 34.1 | 33.01 | 34.1 | 11449.0 |
| 2015-05-18 | BBH | ETF | 132.18 | 134.35 | 132.14 | 134.11 | 57500.0 |
| 2015-05-18 | BBP | ETF | 31.54 | 32.17 | 31.54 | 32.07 | 6100.0 |
| 2015-05-18 | BCHP | ETF | 20.754 | 20.77 | 20.733 | 20.77 | 1600.0 |
> showing 50 of 1,185 rows — these rows as CSV