date_trunc('hour', block_timestamp) as DATE,

count (distinct TX_SIGNER) as active_users,

count(distinct tx_hash) as no_txn,

sum(TRANSACTION_FEE/1e24) as total_fee,

avg(TRANSACTION_FEE/1e24) as avg_fee,

median(TRANSACTION_FEE/1e24) as median_fee

from near.core.fact_transactions

WHERE block_timestamp >= CURRENT_DATE - 7

and TX_HASH is not null

group by 1