SELECT

--project_name,

LABEL_TYPE,

count(DISTINCT tx_hash) as transactions,

count(DISTINCT tx_signer) as users,

sum(transaction_fee / power(10, 24)) as gas_usd,

count(DISTINCT tx_hash) / count(DISTINCT tx_signer) as avg_txs_per_user

FROM near.core.fact_transactions

LEFT outer join near.core.dim_address_labels

on TX_RECEIVER = ADDRESS

where block_timestamp > current_date - {{ past_days }}

and tx_status like 'Success'

and not blockchain is NULL

GROUP BY 1

ORDER BY 4 DESC