select DISTINCT

block_timestamp,

parse_json(attribute_value):address::string as contract_address

from evmos.core.fact_msg_attributes fma

where block_timestamp > current_date - 30

and attribute_key = 'txLog'

select contract_address, address_name, count(1) as n_uses from ctx

join evmos.core.dim_labels labs

on lower(ctx.contract_address) = lower(labs.address)

WHERE address_name ilike '%space%'

group by 1,2

having n_uses > 50

order by 3 desc;