Eman-RazBridging to/From Blast Over Time
Updated 2024-07-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select date_trunc('{{Time_Frame}}',created_at) as "Date", count(distinct call:receipt:from) as "senders Count",
sum(amount) as "💰Transfers Volume ($USD)", count(distinct id) as "🚀Transfers Count",
avg(amount) as "💸Average Transfers Volume ($USD)",
median(amount) as "📊Median Transfers Volume ($USD)",
Max(amount) as "📈Max Transfers Volume ($USD)",
min(amount) as "📉Min Transfers Volume ($USD)"
from axelar.axelscan.fact_gmp
where (call:chain='blast' or call:returnValues:destinationChain='blast') and event='ContractCallWithToken'
group by 1
order by 1
-- call:receipt:from
-- call:transaction:from
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived