Afonso_DiazGrouping txns
Updated 2024-12-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,
decoded_log:avaxAmount / 1e18 as amount_avax,
decoded_log:shareAmount / 1e18 as amount_savax,
origin_from_address as user,
case event_name
when 'Submitted' then 'Mint'
when 'Redeem' then 'Redeem'
end as event_name
from avalanche.core.ez_decoded_event_logs
where
event_name in ('Submitted', 'Redeem')
and contract_address = '0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be'
and block_timestamp >= '2024-01-01'
)
select
event_name,
case
when amount_savax < 1 then 'a. Less than 1 $sAVAX'
when amount_savax <= 5 then 'b. 1 - 5 $sAVAX'
when amount_savax <= 10 then 'b. 6 - 10 $sAVAX'
when amount_savax <= 20 then 'b. 11 - 20 $sAVAX'
when amount_savax <= 50 then 'b. 21 - 50 $sAVAX'
when amount_savax <= 100 then 'c. 50 - 100 $sAVAX'
when amount_savax <= 500 then 'd. 100 - 500 $sAVAX'
when amount_savax <= 1000 then 'e. 500 - 1000 $sAVAX'
when amount_savax <= 5000 then 'f. 1000 - 5000 $sAVAX'
when amount_savax <= 10000 then 'g. 5000 - 10,000 $sAVAX'
when amount_savax <= 100000 then 'h. 10,000 - 100,000 $sAVAX'
else 'i. More than 100,000 $sAVAX'
end as type,
QueryRunArchived: QueryRun has been archived