MINTS | BURNS | MINTERS | BURNERS | MINT_VOLUME | BURN_VOLUME | MINT_AVERAGE_AMOUNT | BURN_AVERAGE_AMOUNT | MINT_VOLUME_USD | BURN_VOLUME_USD | MINT_AVERAGE_AMOUNT_USD | BURN_AVERAGE_AMOUNT_USD | NETFLOW_VOLUME | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | 0 | 1 | 0 | 1000000000 | 0 | 1000000000 | 0 | 0 | 0 | 1000000000 |
Afonso_DiazTotal
Updated 2025-05-18
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 = '0x0f669808d88b2b0b3d23214dcd2a1cc6a8b1b5cd'
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
Last run: 16 days ago
1
62B
4s