WITH ERC20_CREATIONS AS (

SELECT

BLOCK_NUMBER AS CREATION_BLOCK,

TO_ADDRESS AS CONTRACT_ADDRESS

FROM ethereum.core.fact_traces

WHERE

TX_STATUS = 'SUCCESS'

AND INPUT LIKE '0x608060%' -- Contract creation

AND INPUT LIKE '%23b872dd%' -- transferFrom

AND INPUT LIKE '%a9059cbb%' -- transfer

AND INPUT LIKE '%18160ddd%' -- totalSupply

AND INPUT LIKE '%70a08231%' -- balanceOf

AND INPUT LIKE '%095ea7b3%' -- approve

AND INPUT LIKE '%dd62ed3e%' -- allowance

AND INPUT NOT LIKE '%6352211e%'

--AND TX_HASH = '0x14e367e746d7d5de435b80dcc3178d89c779c52b73a73134d5b37f625b76b31b'

AND TRACE_STATUS = 'SUCCESS'

AND BLOCK_NUMBER > {{param_FlOC}}

SELECT *

FROM ERC20_CREATIONS c

LEFT JOIN ethereum.core.dim_contracts cc

ON cc.address = c.contract_address