hessDaily Transactions
Updated 2024-09-09
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select trunc(block_timestamp,'day') as daily,
count(DISTINCT tx_hash) as transactions,
sum(transactions) over (order by daily asc) as "Cumulative Transactions",
count(DISTINCT from_address) as "Senders",
transactions/users as "Avg Transaction Per user",
sum(tx_fee) as "Fee (FLOW)",
avg(tx_fee) as "Avg Fee (FLOW)"
from flow.core_evm.fact_event_logs
where block_timestamp::date >= '2024-09-05'
group by 1
QueryRunArchived: QueryRun has been archived