from osmosis.core.dim_labels

where (project_name ilike '%DAI%' or project_name ilike '%USDC%' or project_name ilike '%USDT%'))

select date_trunc('week', block_timestamp) as week,

project_name,

count(distinct(tx_id)) as count_tx,

count(distinct(sender)) as count_senders,

sum(amount/pow(10, decimal)) as sum_volume

from osmosis.core.fact_transfers a

join base b

on a.currency = b.address

where tx_status = 'SUCCEEDED'

group by 1,2

order by 3 desc