select

address ,

address_name

from solana.core.dim_labels

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

group by address ,address_name

select

count (distinct tx_id) num_transactions,

sum (amount) Transferred_volume

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

and mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'

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