trunc(block_timestamp,'day') as date,

address_name as platform,

sum(amount) as volume

from solana.core.fact_transfers x

join solana.core.dim_labels y on x.tx_to= y.address

where mint= 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' -- USDC contract

and date>=CURRENT_DATE-INTERVAL '{{n_weeks}} WEEKS'

group by 1,2

order by 1 asc