TYPE | TRANSACTIONS | USERS | MERGED_ORBS | |
|---|---|---|---|---|
1 | Merge Coppers To Bronze / Silver | 4517 | 709 | 13551 |
2 | Merge Bronzes To Silver | 1265 | 362 | 3795 |
3 | Merge Silvers To Gold | 305 | 170 | 915 |
4 | Merge Golds To Diamond | 50 | 45 | 150 |
5 | Merge Diamonds To Holy | 8 | 8 | 24 |
Ali3NMerges Overview (Yellow Ket Orbs)
Updated 21 hours ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
select case when decoded_log:id = '1' then 'Merge Coppers To Bronze / Silver'
when decoded_log:id = '2' then 'Merge Bronzes To Silver'
when decoded_log:id = '3' then 'Merge Silvers To Gold'
when decoded_log:id = '4' then 'Merge Golds To Diamond'
when decoded_log:id = '5' then 'Merge Diamonds To Holy'
end as type,
count (distinct tx_hash) as Transactions,
count (distinct origin_from_address) as Users,
sum (decoded_log:value) as Merged_Orbs,
from avalanche.core.ez_decoded_event_logs
where origin_to_address = '0x412cb1580c33c421b2765e91a6c231a246347839'
and origin_function_signature = '0x7721f505'
and contract_address = '0xec18aa29d678f5e5767076e9b5a293e21af8450c'
and tx_succeeded
and event_name = 'TransferSingle'
group by 1
order by 2 desc
--and tx_hash = '0xb5d576be5830251de1a9c129d518abaa68f1c7f1a945adbb54f65203664dd018'
Last run: about 21 hours agoAuto-refreshes every 24 hours
5
204B
4s