Sbhn_NPsticky-azure
    Updated 2025-04-09
    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