select

block_timestamp::date date,

from_address deployer,

tx_hash

from

ethereum.core.fact_transactions

--ethereum.core.ez_decoded_event_logs

where

block_timestamp::date = '2024-01-05'

and

to_address is null

-- and

-- origin_function_signature = '0x60c06040'

),

initial_token_mints as(

select

tx_hash,

contract_address,

symbol

from

ethereum.core.ez_token_transfers

where

block_timestamp::date = '2024-01-05'

select

distinct

date,

contract_creation.tx_hash,

deployer,

contract_address token_contract,

symbol