token_creations as (

SELECT

TO_ADDRESS AS CONTRACT_ADDRESS,

BLOCK_NUMBER AS CREATION_BLOCK,

BLOCK_TIMESTAMP AS CREATION_TS,

FROM_ADDRESS AS CREATOR_ADDRESS

FROM ethereum.core.fact_traces t

WHERE t.type = 'CREATE'

AND BLOCK_NUMBER > 17608910

SELECT

tc.creation_block,

tc.contract_address,

tc.CREATOR_ADDRESS,

0 as total_supply,

'' as factory,

REPLACE(c.name, ',','.') as NAME,

REPLACE(c.SYMBOL, ',','.') as SYMBOL,

c.DECIMALS

FROM token_creations tc

join ethereum.core.dim_contracts c

on tc.contract_address = c.address

WHERE c.DECIMALS IS NOT NULL