Afonso_DiazTotal
Updated 2025-03-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
›
⌄
with
main as (
select
tx_hash,
block_timestamp,
decoded_log:beneficiary::string as user,
decoded_log:avusd_amount / 1e18 as amount_usd,
event_name
from
avalanche.core.ez_decoded_event_logs
where
tx_succeeded
and origin_to_address = '0x1499cb3197427b78dc0e2d356a1e0e4149e0ed51'
and origin_to_address = contract_address
and event_name in ('Redeem', 'Mint')
)
select
event_name,
count(distinct tx_hash) as transactions,
count(distinct user) as users,
sum(amount_usd) as volume_usd,
avg(amount_usd) as average_amount_usd
from
main
group by 1
QueryRunArchived: QueryRun has been archived