group by week(block_timestamp::date))

,number_of_wallets as (select count(distinct to_address),week(block_timestamp::date) from thorchain.upgrades

group by week(block_timestamp::date))

,how_much as (select sum(rune_amount),burn_asset from thorchain.upgrades

group by burn_asset)

,how_much_overtime as (select sum(rune_amount),burn_asset,week(block_timestamp::date) from thorchain.upgrades

group by burn_asset,week(block_timestamp::date))

select * from number_of_wallets