select

address ,

address_name

from solana.core.dim_labels

where label_type not in ('nft','token')

group by address ,address_name

select

date_trunc('week',block_timestamp) as date,

ADDRESS_NAME platform,

count (distinct tx_id) num_transactions,

sum (amount) Transferred_volume

from solana.core.fact_transfers join labels on tx_to = address

and mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'

and block_timestamp::date >= '2022-03-01'

group by date,2