ORB | MINTED_KET | AVERAGE_MINTED_KET | REDEEMS | REDEEMERS | REDEEMED_ORBS | |
|---|---|---|---|---|---|---|
1 | Gold | 16440 | 5480 | 3 | 3 | 3 |
2 | Copper | 12825 | 2565 | 5 | 5 | 111 |
3 | Silver | 11945 | 1493.125 | 8 | 7 | 11 |
4 | Bronze | 11130 | 1011.818181818 | 11 | 9 | 41 |
Ali3NRedeems By Orb Type Overview (Yellow Ket Orbs)
Updated 7 hours ago
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 txtable as (
select tx_hash,
decoded_log:value/1e18 as ket_volume
from avalanche.core.ez_decoded_event_logs
where origin_to_address = lower ('0x1F240DeF4C98408E22A28DAEc1e920810Ef8B1D2')
and origin_function_signature = '0xa5574046'
and contract_address in ('0xffff003a6bad9b743d658048742935fffe2b6ed7')
and tx_succeeded
and event_name in ('Transfer'))
select case when decoded_log:id = '1' then 'Copper'
when decoded_log:id = '2' then 'Bronze'
when decoded_log:id = '3' then 'Silver'
when decoded_log:id = '4' then 'Gold'
when decoded_log:id = '5' then 'Diamond'
when decoded_log:id = '6' then 'Holy' end as orb,
sum (ket_volume) as Minted_KET,
avg (ket_volume) as Average_Minted_KET,
count (distinct t1.tx_hash) as Redeems,
count (distinct t1.decoded_log:from) as Redeemers,
sum (t1.decoded_log:value) as Redeemed_Orbs,
from avalanche.core.ez_decoded_event_logs t1 join txtable t2 on t1.tx_hash = t2.tx_hash
where origin_to_address = lower ('0x1F240DeF4C98408E22A28DAEc1e920810Ef8B1D2')
and origin_function_signature = '0xa5574046'
and contract_address in ('0xec18aa29d678f5e5767076e9b5a293e21af8450c')
and tx_succeeded
and event_name in ('TransferSingle')
group by 1
order by 2 desc
--and tx_hash = '0x19f6d04c3f29a53267f048d97ef1b8fbcf757ba04da43f35216d271969ecd3ed'
/*
select *
from avalanche.core.ez_decoded_event_logs
where origin_to_address = lower ('0x1F240DeF4C98408E22A28DAEc1e920810Ef8B1D2')
Last run: about 7 hours agoAuto-refreshes every 12 hours
4
130B
68s