with contract_creation as(

select

distinct

block_timestamp,

origin_from_address deployer,

tx_hash,

contract_address

from

--ethereum.core.fact_transactions

ethereum.core.ez_decoded_event_logs

where

block_timestamp::date >= '2023-12-01'

and

origin_to_address is null

-- and

-- origin_function_signature = '0x60c06040'

),

initial_token_mints as(

select

distinct

contract_address,

symbol

from

ethereum.core.ez_token_transfers

where

block_timestamp::date >= '2023-12-01'

and

contract_address in (select contract_address from contract_creation)

and

from_address = '0x0000000000000000000000000000000000000000'

),

prep as(

select

distinct