Abbas_ra21Arb: General 2
Updated 2024-02-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
-- forked from 38b0cf2f-20f4-459b-b1f3-48f30dc09521
select
count(*) AS "Transcations Count",
count(DISTINCT FROM_ADDRESS) AS "Unique Active users",
sum(TX_FEE) as "Total Transaction Fee (ETH)",
avg(TX_FEE) as "Average Transaction Fee (ETH)"
from
arbitrum.core.fact_transactions
where
BLOCK_TIMESTAMP >= dateadd(Day,- {{Last-N-Days}} ,current_date)
QueryRunArchived: QueryRun has been archived