select

contract_address,

symbol,

case

when contract_address = '0xda10009cbd5d07dd0cecc66161fc93d7c9000da1' then sum(event_inputs:value)/pow(10,18)

when contract_address = '0x7f5c764cbc14f9669b88837ca1490cca17c31607' then sum(event_inputs:value)/pow(10,6)

when contract_address = '0xdeaddeaddeaddeaddeaddeaddeaddeaddead0000' then sum(event_inputs:value)/pow(10,18)

when contract_address = '0x94b008aa00579c1307b0ef2c499ad98a8ce58e58' then sum(event_inputs:value)/pow(10,6)

end as Bridge_Volume,

count(distinct origin_from_address) as bridgooor_count,

count(distinct tx_hash) as bridge_transactions,

date_trunc('day', block_timestamp::date) as TIME

from optimism.core.fact_event_logs l

join optimism.core.dim_contracts c on c.address = l.contract_address

where origin_to_address in ('0x4200000000000000000000000000000000000010', '0x467194771dae2967aef3ecbedd3bf9a310c76c65')

and event_name = 'Transfer'

and contract_address in (

'0xdeaddeaddeaddeaddeaddeaddeaddeaddead0000'

)

and TX_STATUS = 'SUCCESS'

and block_timestamp > CURRENT_DATE - 120

group by 1, 2, TIME