list as (

select

date_trunc('day', block_timestamp) as day,

from_address as safe,

case (to_address)

when '0x8942595a2dc5181df0465af0d7be08c8f23c93af' then '0.1.0'

when '0xb6029ea3b2c51d09a50b53ca8012feeb05bda35a' then '1.0.0'

when '0xae32496491b53841efb51829d6f886387708f99b' then '1.1.0'

when '0x34cfac646f301356faa8b21e94227e3583fe3f5f' then '1.1.1'

when '0x6851d6fdfafd08c0295c392436245e5bc78b0185' then '1.2.0'

when '0xd9db270c1b5e3bd161e8c8503c55ceabee709552' then '1.3.0'

when '0x3e5c63644e683549055b9be8653de26e0b4cd36e' then '1.3.0L2'

end as method

from ethereum.core.fact_traces

where (

substr(input, 1, 10) = '0x0ec78d9e'

and to_address = '0x8942595a2dc5181df0465af0d7be08c8f23c93af'

)

or (

substr(input, 1, 10) = '0xb63e800d'

and to_address in (

'0xae32496491b53841efb51829d6f886387708f99b',

'0x34cfac646f301356faa8b21e94227e3583fe3f5f',

'0x6851d6fdfafd08c0295c392436245e5bc78b0185',

'0xd9db270c1b5e3bd161e8c8503c55ceabee709552',

'0x3e5c63644e683549055b9be8653de26e0b4cd36e'

)

)

or (

substr(input, 1, 10) = '0xa97ab18a'

and to_address = '0xb6029ea3b2c51d09a50b53ca8012feeb05bda35a'

)

and tx_status = 'SUCCESS'

and type = 'DELEGATECALL'

),