date_trunc('day', block_timestamp) as "Date",

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"/(24) as "TX Per Hour",

"Number of TXs"/(24*60) as "TX Per Min",

"Number of TXs"/(24*60*60) as "TX Per Sec"

from near.core.fact_transactions

where tx_status = 'Success' and block_timestamp >= CURRENT_DATE - INTERVAL '14 days'

GROUP by 1

order by 1