select block_timestamp::date as date,

case when tx_receiver = 'token.paras.near' then '$PARAS Token'

when tx_receiver = 'staking.paras.near' then 'Staked $PARAS'

when tx_receiver in ('nft.paras.near','marketplace.paras.near','x.paras.near') then 'PARAS NFT'

else null end as paras_type,

count (distinct tx_hash) as TX_Count,

count (distinct tx_signer) as Users_Count,

sum (transaction_fee/ pow (10,24)) as TX_Fee,

avg (transaction_fee/ pow (10,24)) as AVG_TX_Fee

from near.core.fact_transactions

where paras_type is not null and tx_status = 'Success'

group by 1,2)

select paras_type, avg (tx_count), avg (users_count), avg (tx_fee)

from table1

group by 1