MINTED_KET | AVERAGE_MINTED_KET | REDEEMS | REDEEMERS | REDEEMED_ORBS | |
|---|---|---|---|---|---|
1 | 52340 | 1938.518518519 | 27 | 27 | 166 |
Ali3NRedeems Overview (Yellow Ket Orbs)
Updated 2 hours ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select sum (case when contract_address = '0xffff003a6bad9b743d658048742935fffe2b6ed7' then decoded_log:value/1e18 end) as Minted_KET,
avg (case when contract_address = '0xffff003a6bad9b743d658048742935fffe2b6ed7' then decoded_log:value/1e18 end) as Average_Minted_KET,
count (distinct tx_hash) as Redeems,
count (case when contract_address = '0xec18aa29d678f5e5767076e9b5a293e21af8450c' then decoded_log:from end) as Redeemers,
sum (case when contract_address = '0xec18aa29d678f5e5767076e9b5a293e21af8450c' then decoded_log:value end) as Redeemed_Orbs,
from avalanche.core.ez_decoded_event_logs
where origin_to_address = lower ('0x1F240DeF4C98408E22A28DAEc1e920810Ef8B1D2')
and origin_function_signature = '0xa5574046'
and contract_address in ('0xffff003a6bad9b743d658048742935fffe2b6ed7','0xec18aa29d678f5e5767076e9b5a293e21af8450c')
and tx_succeeded
and event_name in ('TransferSingle','Transfer')
--and tx_hash = '0x19f6d04c3f29a53267f048d97ef1b8fbcf757ba04da43f35216d271969ecd3ed'
Last run: about 2 hours agoAuto-refreshes every 12 hours
1
34B
6s