to_address as collection_address,

regexp_substr_all(substr(data,11, len(data)), '.{64}') as segmented,

TRIM(TRY_HEX_DECODE_STRING(segmented[6]::STRING), '\x00') AS name,

TRIM(TRY_HEX_DECODE_STRING(segmented[7]::STRING), '\x00') AS name1,

concat(name,' ',name1) as collection_name

from monad.testnet.fact_traces a join monad.testnet.fact_event_logs b on a.tx_hash = b.tx_hash and a.block_timestamp = b.block_timestamp

where a.block_timestamp::Date >= '2025-01-08'

and TYPE IN ('CREATE', 'CREATE2')

and OUTPUT IS NOT NULL

and a.TX_SUCCEEDED = 'TRUE'

and a.TRACE_SUCCEEDED = 'TRUE'

having collection_name is not null )

select distinct collection_address,

name,

from base

limit 10000