Afonso_DiazTotal
Updated 2025-03-10
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
28
29
30
31
32
33
34
35
36
›
⌄
with
main as (
select
tx_hash,
block_timestamp,
amount,
amount_usd,
origin_from_address as user,
iff(from_address = '0x0000000000000000000000000000000000000000', 'Mint', 'Burn') as event_name
from
avalanche.core.ez_token_transfers
where
contract_address = '0x8729438eb15e2c8b576fcc6aecda6a148776c0f5'
and '0x0000000000000000000000000000000000000000' in (from_address, to_address)
)
select
count(distinct iff(event_name = 'Mint', tx_hash, null)) as mints,
count(distinct iff(event_name = 'Burn', tx_hash, null)) as burns,
count(distinct iff(event_name = 'Mint', user, null)) as minters,
count(distinct iff(event_name = 'Burn', user, null)) as burners,
sum(iff(event_name = 'Mint', amount, 0)) as mint_volume,
sum(iff(event_name = 'Burn', amount, 0)) as burn_volume,
avg(iff(event_name = 'Mint', amount, 0)) as mint_average_amount,
avg(iff(event_name = 'Burn', amount, 0)) as burn_average_amount,
sum(iff(event_name = 'Mint', amount_usd, 0)) as mint_volume_usd,
sum(iff(event_name = 'Burn', amount_usd, 0)) as burn_volume_usd,
avg(iff(event_name = 'Mint', amount_usd, 0)) as mint_average_amount_usd,
avg(iff(event_name = 'Burn', amount_usd, 0)) as burn_average_amount_usd,
mint_volume - burn_volume as netflow_volume
from
main