count(distinct tx_signer) as "Number of 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",

avg(TRANSACTION_FEE/pow(10,24)) as "Average Tx Fee",

sum(GAS_USED/1e18) as "Total Gas Used",

Avg(GAS_USED/1e18) as "Average Gas Used",

"Number of TXs"/(COUNT(DISTINCT date_trunc('day', block_timestamp))*24) as "TX Per Hour",

"Number of TXs"/(COUNT(DISTINCT date_trunc('day', block_timestamp))*24*60) as "TX Per Min",

"Number of TXs"/(COUNT(DISTINCT date_trunc('day', block_timestamp))*24*60*60) as "TX Per Sec"

from near.core.fact_transactions

where tx_status = 'Success' and block_timestamp BETWEEN '{{From}}' and DATEADD(DAY, 7, '{{From}}')