count(DISTINCT tx_signer) as "Number of Active Users",

count(DISTINCT tx_hash) as "Number of Txs",

count(DISTINCT TX_RECEIVER) as "Number of Smart Contracts",

sum(TRANSACTION_FEE/pow(10,24)) as "Total Tx Fee",

sum(GAS_USED/1e12) as "Total Gas Used"

from near.core.fact_transactions

where TX_STATUS = 'Success'