date_trunc('week', block_timestamp) as blocktime,

substr(burn_asset,1, position('-', burn_asset,1) - 1) as burn_asset,

count(distinct to_address) as distinct_upgrades

from thorchain.upgrades

where blocktime > getdate() - interval'6 weeks'

group by blocktime, burn_asset