ethereum.public.udf_hex_to_int(right(topics[2]::string,4)) as raft,

concat('0x',right(topics[1]::string,40)) as creator,

count(tx_hash) as creations

from

optimism.core.fact_event_logs

where block_timestamp::Date > '2022-09-01'::date

and contract_address = lower('0x7f9279b24d1c36fa3e517041fdb4e8788dc63d25')

and origin_function_signature = '0x445a62b9'

group by 1,2