SELECT date_trunc('week',BLOCK_TIMESTAMP) as week, asset,
sum(RUNE_AMOUNT_USD) as USD_vol,
count(DISTINCT TO_ADDRESS) as wallets
from flipside_prod_db.thorchain.transfers
where BLOCK_TIMESTAMP::date >= '2022-01-01'
and FROM_ADDRESS = 'thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6'
and TO_ADDRESS ilike '%thor%'
GROUP by 1,2