PREVIEW / etf_daily / 2020-12-11
file: by_date/etf_daily/2020/2020-12-11.parquet size: 82 KB rows: 2,163
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 |
|---|---|---|---|---|---|---|---|
| 2020-12-11 | SPY | ETF | 364.9 | 366.74 | 363.26 | 366.3 | 57698600.0 |
| 2020-12-11 | QQQ | ETF | 300.81 | 301.98 | 298.47 | 301.85 | 26760416.0 |
| 2020-12-11 | IWM | ETF | 189.99 | 191.72 | 188.3 | 190.3 | 30865000.0 |
| 2020-12-11 | DIA | ETF | 299.43 | 301.18 | 298.68 | 300.93 | 2454300.0 |
| 2020-12-11 | GLD | ETF | 172.25 | 173.32 | 172.11 | 172.49 | 6084800.0 |
| 2020-12-11 | TLT | ETF | 158.65 | 159.39 | 158.32 | 158.77 | 8135900.0 |
| 2020-12-11 | AAA | ETF | 25.0682 | 25.0682 | 25.06 | 25.06 | 963.0 |
| 2020-12-11 | AAAU | ETF | 18.27 | 18.39 | 18.27 | 18.31 | 220900.0 |
| 2020-12-11 | AADR | ETF | 58.54 | 58.54 | 57.86 | 58.04 | 35700.0 |
| 2020-12-11 | AAXJ | ETF | 87.69 | 87.78 | 87.36 | 87.51 | 2195900.0 |
| 2020-12-11 | ABEQ | ETF | 25.19 | 25.29 | 25.19 | 25.29 | 4900.0 |
| 2020-12-11 | ACES | ETF | 69.07 | 70.53 | 68.83 | 69.66 | 134800.0 |
| 2020-12-11 | ACIO | ETF | 27.266 | 27.42 | 27.266 | 27.39 | 9500.0 |
| 2020-12-11 | ACSI | ETF | 42.6424 | 42.6424 | 42.6424 | 42.6424 | 344.0 |
| 2020-12-11 | ACTV | ETF | 30.93 | 30.94 | 30.79 | 30.8901 | 6289.0 |
| 2020-12-11 | ACTX | ETF | 2.9 | 2.9 | 2.9 | 2.9 | 1409.0 |
| 2020-12-11 | ACVF | ETF | 27.0 | 27.113 | 27.0 | 27.113 | 700.0 |
| 2020-12-11 | ACWF | ETF | 32.81 | 32.93 | 32.69 | 32.86 | 1586.0 |
| 2020-12-11 | ACWI | ETF | 88.91 | 89.19 | 88.53 | 89.16 | 1448100.0 |
| 2020-12-11 | ACWV | ETF | 95.61 | 96.17 | 95.61 | 96.08 | 244600.0 |
| 2020-12-11 | ACWX | ETF | 52.31 | 52.405 | 52.12 | 52.34 | 1394710.0 |
| 2020-12-11 | ADME | ETF | 35.02 | 35.07 | 34.82 | 35.07 | 8400.0 |
| 2020-12-11 | ADRE | ETF | 55.16 | 55.3435 | 55.0 | 55.07 | 11442.0 |
| 2020-12-11 | AESR | ETF | 11.629 | 11.694 | 11.629 | 11.694 | 13200.0 |
| 2020-12-11 | AFIF | ETF | 9.79 | 9.82 | 9.79 | 9.82 | 48397.0 |
| 2020-12-11 | AFK | ETF | 20.45 | 20.625 | 20.45 | 20.56 | 11504.0 |
| 2020-12-11 | AFLG | ETF | 21.76 | 21.865 | 21.76 | 21.833 | 2000.0 |
| 2020-12-11 | AFTY | ETF | 21.73 | 21.73 | 21.637 | 21.637 | 1600.0 |
| 2020-12-11 | AGG | ETF | 118.01 | 118.09 | 117.95 | 118.03 | 5636100.0 |
| 2020-12-11 | AGGY | ETF | 53.58 | 53.64 | 53.567 | 53.63 | 105000.0 |
| 2020-12-11 | AGNG | ETF | 27.0 | 27.04 | 26.947 | 27.03 | 1800.0 |
| 2020-12-11 | AGQ | ETF | 42.25 | 42.97 | 42.1 | 42.43 | 427100.0 |
| 2020-12-11 | AGZ | ETF | 119.73 | 119.751 | 119.6601 | 119.68 | 23912.0 |
| 2020-12-11 | AGZD | ETF | 23.525 | 23.54 | 23.505 | 23.525 | 61200.0 |
| 2020-12-11 | AIA | ETF | 84.97 | 85.0 | 84.62 | 84.76 | 143517.0 |
| 2020-12-11 | AIEQ | ETF | 35.0 | 35.15 | 34.84 | 35.035 | 8300.0 |
| 2020-12-11 | AIQ | ETF | 26.36 | 26.45 | 26.17 | 26.41 | 24763.0 |
| 2020-12-11 | AIRR | ETF | 33.46 | 33.5 | 33.22 | 33.327 | 10200.0 |
| 2020-12-11 | AIVI | ETF | 40.16 | 40.2 | 40.1 | 40.2 | 4300.0 |
| 2020-12-11 | ALTL | ETF | 32.06 | 32.11 | 31.94 | 32.081 | 5872.0 |
| 2020-12-11 | ALTY | ETF | 11.66 | 11.829 | 11.66 | 11.82 | 10700.0 |
| 2020-12-11 | AMJ | ETF | 15.1 | 15.33 | 15.02 | 15.13 | 941952.0 |
| 2020-12-11 | AMLP | ETF | 28.25 | 28.46 | 27.86 | 28.16 | 2168800.0 |
| 2020-12-11 | AMNA | ETF | 27.3925 | 27.3925 | 27.3925 | 27.3925 | 3.0 |
| 2020-12-11 | AMND | ETF | 29.35 | 29.35 | 29.29 | 29.3448 | 1503.0 |
| 2020-12-11 | AMOM | ETF | 38.655 | 38.655 | 38.551 | 38.551 | 1700.0 |
| 2020-12-11 | AMTR | ETF | 30.77 | 30.93 | 30.73 | 30.9204 | 34912.0 |
| 2020-12-11 | AMUB | ETF | 9.52 | 9.5483 | 9.51 | 9.5483 | 3556.0 |
| 2020-12-11 | AMZA | ETF | 21.32 | 21.554 | 21.066 | 21.45 | 60700.0 |
| 2020-12-11 | ANEW | ETF | 40.75 | 40.91 | 40.65 | 40.871 | 3500.0 |
> showing 50 of 2,163 rows — these rows as CSV