Sbhn_NPsticky-azure
Updated 2025-04-09
9
1
2
3
4
5
6
7
8
9
›
⌄
select utils.udf_hex_to_string(regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}')[5]) as name,
sum(ethereum.public.udf_hex_to_int(regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}')[2]) / pow(10,18)) as usd
from ronin.core.ez_decoded_event_logs
where contract_address = '0x662852853614cbbb5d04bf2e29955b97e3c50b69'
and origin_to_address = '0x662852853614cbbb5d04bf2e29955b97e3c50b69'
and event_name = 'NameRegistered'
group by 1
order by 2 desc
limit 5
QueryRunArchived: QueryRun has been archived