Afonso_DiazGrouping Mint transactions
Updated 2024-12-29
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,
iff(from_address = '0x0000000000000000000000000000000000000000', 'Mint', 'Redeem') as event_type,
origin_from_address as user
from
avalanche.core.ez_token_transfers
where
contract_address = '0x698c34bad17193af7e1b4eb07d1309ff6c5e715e'
and '0x0000000000000000000000000000000000000000' in (from_address, to_address)
and origin_to_address is not null
and event_type = 'Mint'
)
select
case
when amount < 10 then 'a. Less than 10 $xAVAX'
when amount <= 50 then 'b. 10 - 50 $xAVAX'
when amount <= 100 then 'c. 50 - 100 $xAVAX'
when amount <= 500 then 'd. 100 - 500 $xAVAX'
when amount <= 1000 then 'e. 500 - 1000 $xAVAX'
when amount <= 5000 then 'f. 1000 - 5000 $xAVAX'
when amount <= 10000 then 'g. 5000 - 10,000 $xAVAX'
when amount <= 100000 then 'h. 10,000 - 100,000 $xAVAX'
else 'i. More than 100,000 $xAVAX'
end as type,
count(distinct tx_hash) as transactions
from
main
group by 1
order by 1
QueryRunArchived: QueryRun has been archived