select date(block_timestamp) as date, count(DISTINCT(tx_hash)) as total, count(DISTINCT(TX_SIGNER)) as total_user,
total/24 as tx_per_hour , total/1440 as tx_per_minute, total/86400 as tx_per_second,
total_user/24 as user_per_hour , total_user/1440 as user_per_minute, total_user/86400 as user_per_second
from near.core.fact_transactions
where block_timestamp::date >= CURRENT_DATE - {{N_Days}}
and tx_status = 'Success'
group by 1