PREVIEW / etf_daily / 2015-01-05
file: by_date/etf_daily/2015/2015-01-05.parquet size: 47 KB rows: 1,155
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-01-05 | SPY | ETF | 204.17 | 204.37 | 201.35 | 201.72 | 169632600.0 |
| 2015-01-05 | QQQ | ETF | 102.49 | 102.61 | 101.14 | 101.43 | 36521270.0 |
| 2015-01-05 | IWM | ETF | 118.23 | 118.71 | 116.79 | 117.34 | 51141900.0 |
| 2015-01-05 | DIA | ETF | 177.06 | 177.21 | 174.46 | 174.84 | 6700200.0 |
| 2015-01-05 | GLD | ETF | 114.78 | 116.0 | 114.73 | 115.8 | 8177400.0 |
| 2015-01-05 | TLT | ETF | 128.01 | 129.63 | 127.96 | 129.32 | 9789500.0 |
| 2015-01-05 | AADR | ETF | 36.13 | 36.44 | 36.13 | 36.19 | 600.0 |
| 2015-01-05 | AAXJ | ETF | 60.61 | 60.61 | 59.88 | 59.94 | 614000.0 |
| 2015-01-05 | ACWI | ETF | 58.03 | 58.03 | 57.1 | 57.21 | 2173500.0 |
| 2015-01-05 | ACWV | ETF | 68.47 | 68.47 | 67.92 | 68.01 | 98900.0 |
| 2015-01-05 | ACWX | ETF | 42.32 | 42.32 | 41.72 | 41.83 | 1054691.0 |
| 2015-01-05 | ADRE | ETF | 34.81 | 34.81 | 34.43 | 34.4641 | 13066.0 |
| 2015-01-05 | AFK | ETF | 26.13 | 26.3699 | 25.5 | 25.84 | 247514.0 |
| 2015-01-05 | AGG | ETF | 110.56 | 110.76 | 110.48 | 110.67 | 3446200.0 |
| 2015-01-05 | AGQ | ETF | 39.55 | 40.75 | 39.08 | 40.46 | 347500.0 |
| 2015-01-05 | AGZ | ETF | 113.65 | 113.69 | 113.1 | 113.46 | 73210.0 |
| 2015-01-05 | AGZD | ETF | 24.54 | 24.635 | 24.54 | 24.635 | 7200.0 |
| 2015-01-05 | AIA | ETF | 46.57 | 46.6499 | 46.15 | 46.31 | 17929.0 |
| 2015-01-05 | AIQ | ETF | 21.81 | 22.13 | 21.1 | 21.28 | 12156.0 |
| 2015-01-05 | AIRR | ETF | 17.97 | 18.185 | 17.776 | 17.79 | 31300.0 |
| 2015-01-05 | AIVI | ETF | 42.17 | 42.17 | 41.56 | 41.67 | 43300.0 |
| 2015-01-05 | AMJ | ETF | 46.51 | 46.56 | 44.68 | 44.79 | 1907890.0 |
| 2015-01-05 | AMLP | ETF | 87.65 | 87.95 | 85.8 | 85.9 | 1380140.0 |
| 2015-01-05 | AMZA | ETF | 228.4 | 229.7 | 221.59 | 221.59 | 750.0 |
| 2015-01-05 | ANGL | ETF | 26.28 | 26.39 | 26.16 | 26.2 | 6000.0 |
| 2015-01-05 | AOA | ETF | 45.95 | 45.95 | 45.45 | 45.5 | 129900.0 |
| 2015-01-05 | AOK | ETF | 32.5 | 32.5099 | 32.36 | 32.41 | 91731.0 |
| 2015-01-05 | AOM | ETF | 35.03 | 35.03 | 34.77 | 34.84 | 191881.0 |
| 2015-01-05 | AOR | ETF | 39.81 | 39.91 | 39.54 | 39.62 | 68345.0 |
| 2015-01-05 | ARGT | ETF | 18.11 | 18.15 | 17.96 | 18.01 | 4100.0 |
| 2015-01-05 | ARKG | ETF | 21.29 | 21.46 | 21.19 | 21.23 | 3900.0 |
| 2015-01-05 | ARKK | ETF | 20.37 | 20.37 | 19.653 | 19.684 | 3200.0 |
| 2015-01-05 | ARKQ | ETF | 19.41 | 19.41 | 19.08 | 19.08 | 1300.0 |
| 2015-01-05 | ARKW | ETF | 20.31 | 20.31 | 20.0 | 20.01 | 2000.0 |
| 2015-01-05 | ASEA | ETF | 15.52 | 15.52 | 15.24 | 15.25 | 233100.0 |
| 2015-01-05 | ASHR | ETF | 37.89 | 37.98 | 37.3 | 37.46 | 1819600.0 |
| 2015-01-05 | ASHS | ETF | 35.56 | 35.56 | 35.24 | 35.27 | 11900.0 |
| 2015-01-05 | ATMP | ETF | 30.59 | 30.6 | 29.69 | 29.73 | 36000.0 |
| 2015-01-05 | AVIV | ETF | 35.6 | 36.29 | 35.36 | 36.24 | 221849.0 |
| 2015-01-05 | AWAY | ETF | 28.56 | 28.74 | 27.07 | 27.31 | 2426701.0 |
| 2015-01-05 | BAB | ETF | 30.7 | 30.79 | 30.4776 | 30.75 | 251672.0 |
| 2015-01-05 | BAL | ETF | 41.06 | 41.62 | 41.01 | 41.389 | 5726.0 |
| 2015-01-05 | BALT | ETF | 2.36 | 2.4 | 2.26 | 2.29 | 478653.0 |
| 2015-01-05 | BBC | ETF | 28.57 | 29.1 | 28.32 | 28.58 | 31253.0 |
| 2015-01-05 | BBH | ETF | 115.81 | 117.78 | 115.34 | 116.59 | 281400.0 |
| 2015-01-05 | BBP | ETF | 26.87 | 26.87 | 26.31 | 26.471 | 6100.0 |
| 2015-01-05 | BCHP | ETF | 17.72 | 17.72 | 17.5 | 17.539 | 1454.0 |
| 2015-01-05 | BCM | ETF | 31.57 | 31.74 | 31.5608 | 31.588 | 34774.0 |
| 2015-01-05 | BFOR | ETF | 7.8025 | 7.8025 | 7.68 | 7.725 | 156800.0 |
| 2015-01-05 | BIB | ETF | 62.75 | 65.14 | 62.69 | 63.67 | 451026.0 |
> showing 50 of 1,155 rows — these rows as CSV