select ADDRESS , ADDRESS_NAME

from solana.core.dim_labels

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

group by 1 ,2

select date_trunc(week,BLOCK_TIMESTAMP) weekly,

ADDRESS_NAME platform,

count (distinct tx_id) num_transactions,

count (distinct tx_to) num_wallets,

sum (amount) Transferred_volume,

sum (Transferred_volume) over (partition by platform order by weekly) cum_Transferred_volume

from solana.core.fact_transfers join labels on TX_FROM = ADDRESS

and mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'

and BLOCK_TIMESTAMP ::date >= '2022-01-01'

group by 1,2