PREVIEW / etf_daily / 2015-03-11
file: by_date/etf_daily/2015/2015-03-11.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-03-11 | SPY | ETF | 205.29 | 205.5 | 204.4 | 204.5 | 110145700.0 |
| 2015-03-11 | QQQ | ETF | 105.875 | 106.01 | 105.07 | 105.11 | 25459733.0 |
| 2015-03-11 | IWM | ETF | 120.47 | 121.14 | 119.88 | 121.04 | 20914500.0 |
| 2015-03-11 | DIA | ETF | 176.98 | 177.29 | 176.23 | 176.35 | 5584600.0 |
| 2015-03-11 | GLD | ETF | 111.23 | 111.25 | 110.16 | 110.75 | 6550400.0 |
| 2015-03-11 | TLT | ETF | 126.26 | 127.46 | 126.12 | 127.2 | 6663100.0 |
| 2015-03-11 | AAXJ | ETF | 61.38 | 61.59 | 61.35 | 61.54 | 966700.0 |
| 2015-03-11 | ACWI | ETF | 58.83 | 58.99 | 58.7 | 58.81 | 993700.0 |
| 2015-03-11 | ACWV | ETF | 70.01 | 70.11 | 69.75 | 69.91 | 2650000.0 |
| 2015-03-11 | ACWX | ETF | 43.37 | 43.4539 | 43.222 | 43.4 | 2187548.0 |
| 2015-03-11 | ADRE | ETF | 33.99 | 34.13 | 33.89 | 33.993 | 17007.0 |
| 2015-03-11 | AFK | ETF | 24.77 | 24.9599 | 24.71 | 24.7693 | 10357.0 |
| 2015-03-11 | AGG | ETF | 110.21 | 110.53 | 110.21 | 110.46 | 1171600.0 |
| 2015-03-11 | AGQ | ETF | 37.02 | 37.02 | 35.37 | 36.32 | 476900.0 |
| 2015-03-11 | AGZ | ETF | 113.3 | 113.63 | 113.3 | 113.486 | 37024.0 |
| 2015-03-11 | AGZD | ETF | 24.57 | 24.655 | 24.57 | 24.585 | 9800.0 |
| 2015-03-11 | AIA | ETF | 48.1 | 48.102 | 47.9952 | 48.05 | 10690.0 |
| 2015-03-11 | AIQ | ETF | 22.77 | 22.77 | 21.97 | 22.32 | 19614.0 |
| 2015-03-11 | AIRR | ETF | 17.78 | 17.814 | 17.711 | 17.8 | 24000.0 |
| 2015-03-11 | AIVI | ETF | 43.1 | 43.17 | 42.88 | 43.04 | 34000.0 |
| 2015-03-11 | AMJ | ETF | 42.89 | 42.95 | 42.16 | 42.22 | 868006.0 |
| 2015-03-11 | AMLP | ETF | 83.05 | 83.2 | 81.75 | 81.8 | 715740.0 |
| 2015-03-11 | AMZA | ETF | 212.5 | 212.5 | 208.7 | 208.7 | 190.0 |
| 2015-03-11 | ANGL | ETF | 27.02 | 27.36 | 27.02 | 27.31 | 5300.0 |
| 2015-03-11 | AOA | ETF | 46.63 | 46.66 | 46.47 | 46.58 | 35400.0 |
| 2015-03-11 | AOK | ETF | 32.4928 | 32.59 | 32.46 | 32.56 | 13949.0 |
| 2015-03-11 | AOM | ETF | 35.15 | 35.2 | 35.09 | 35.18 | 31664.0 |
| 2015-03-11 | AOR | ETF | 40.2 | 40.24 | 40.12 | 40.21 | 94288.0 |
| 2015-03-11 | ARGT | ETF | 19.99 | 20.28 | 19.99 | 20.28 | 3500.0 |
| 2015-03-11 | ARKG | ETF | 22.85 | 22.877 | 22.82 | 22.87 | 2000.0 |
| 2015-03-11 | ARKK | ETF | 20.649 | 20.665 | 20.649 | 20.665 | 600.0 |
| 2015-03-11 | ARKQ | ETF | 19.84 | 19.85 | 19.797 | 19.85 | 1100.0 |
| 2015-03-11 | ARKW | ETF | 21.44 | 21.497 | 21.44 | 21.497 | 800.0 |
| 2015-03-11 | ASEA | ETF | 15.17 | 15.2 | 15.15 | 15.19 | 7900.0 |
| 2015-03-11 | ASHR | ETF | 35.88 | 35.9 | 35.77 | 35.83 | 425300.0 |
| 2015-03-11 | ASHS | ETF | 41.16 | 41.29 | 41.12 | 41.25 | 13600.0 |
| 2015-03-11 | ATMP | ETF | 28.95 | 28.95 | 28.48 | 28.48 | 19800.0 |
| 2015-03-11 | AVIV | ETF | 34.93 | 35.12 | 34.65 | 35.0 | 120970.0 |
| 2015-03-11 | AWAY | ETF | 30.6 | 30.65 | 30.25 | 30.35 | 1235223.0 |
| 2015-03-11 | BAB | ETF | 29.95 | 30.06 | 29.9 | 30.0 | 92455.0 |
| 2015-03-11 | BAL | ETF | 41.29 | 41.36 | 40.87 | 40.9401 | 9002.0 |
| 2015-03-11 | BALT | ETF | 1.33 | 1.44 | 1.3001 | 1.38 | 586101.0 |
| 2015-03-11 | BAR | ETF | 2.451 | 2.455 | 2.4289 | 2.4301 | 22370.0 |
| 2015-03-11 | BBC | ETF | 33.09 | 33.65 | 32.68 | 33.29 | 16018.0 |
| 2015-03-11 | BBH | ETF | 129.74 | 129.78 | 128.68 | 129.15 | 77700.0 |
| 2015-03-11 | BBP | ETF | 31.25 | 31.7 | 30.8 | 31.01 | 8400.0 |
| 2015-03-11 | BCM | ETF | 30.54 | 30.72 | 30.49 | 30.72 | 430560.0 |
| 2015-03-11 | BFOR | ETF | 8.0425 | 8.0575 | 8.015 | 8.0575 | 27200.0 |
| 2015-03-11 | BIB | ETF | 79.44 | 79.87 | 77.885 | 79.15 | 500162.0 |
| 2015-03-11 | BICK | ETF | 22.57 | 22.58 | 22.57 | 22.57 | 922.0 |
> showing 50 of 1,155 rows — these rows as CSV