project_name,

count(DISTINCT tx_id) as total_transaction,

count(DISTINCT tx_from) as total_users

from solana.core.fact_transfers x join flipside_prod_db.crosschain.address_labels y on

x.tx_to = address

where tx_from not in ( select address

from flipside_prod_db.crosschain.address_labels

where label_subtype = 'hot_wallet'

and blockchain = 'solana')

and label_subtype = 'hot_wallet'

and date >= CURRENT_DATE - 20

group by date,project_name

order by date