t1 as (

SELECT

from_address as wallets,

'.eth ENS Names' as tag,

input_data,

substr(input_data,139) as name_part,

HEX_DECODE_STRING(name_part :: STRING) as ens_name,

--6173726166756c2e657468000000000000000000000000000000000000000000

x.block_timestamp

from ethereum.core.fact_transactions x

join ethereum.core.fact_event_logs y on x.tx_hash=y.tx_hash

where x.origin_function_signature='0xc47f0027'

and to_address='0x084b1c3c81545d370f3634392de611caabff8148'

and contract_name='ENSRegistryWithFallback'

and event_name='NewOwner'

--and x.tx_hash='0xbf10c6279e41ce453f5c54cc4c2c6a1b884d182898c275a6b7e0ae2e352019ef'

select

distinct wallets,ens_name,tag from t1 where block_timestamp between '{{starting_date}}' and '{{ending_date}}'