D3 Team[Blast]
Updated 2024-07-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
count(distinct from_address) as "Total User",
count(distinct tx_hash) as "Total Transactions",
sum(value) as "Total ETH Transfer",
(
sum(
case
when status = 'SUCCESS' then 1
else 0
end
) / (count(distinct tx_hash))
) * 100 as "% Successful Tx"
from
blast.core.fact_transactions
QueryRunArchived: QueryRun has been archived