DAILY TRANSACTION ON THE BASIS OF HOUR, MINUTE & SECOND DAILY USERS ON THE BASIS OF HOURS,MINUTES & SECONDS

superflyDAILY TRANSACTION ON THE BASIS OF HOUR, MINUTE & SECOND DAILY USERS ON THE BASIS OF HOURS,MINUTES & SECONDS

Updated 2023-01-18

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

Run a query to Download Data

flipside