select tx_hash

, date(block_timestamp) dt

, origin_from_address user_address

, 'umbra' txn_type

, (event_inputs:amount /pow(10,18)) amount_eth

from arbitrum.core.fact_event_logs

where contract_address = '0xfb2dc580eed955b528407b4d36ffafe3da685401'

and event_name = 'Announcement'

and event_inputs:token = '0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee'

),

tc_txns as (

select tx_hash

, date(block_timestamp) dt

, event_inputs:to user_address

, 'tornado cash' txn_type

, case when lower(contract_address) = lower('0x84443CFd09A48AF6eF360C6976C5392aC5023a1F') then 0.1

when lower(contract_address) = lower('0xd47438C816c9E7f2E2888E060936a499Af9582b3') then 1

when lower(contract_address) = lower('0x330bdFADE01eE9bF63C209Ee33102DD334618e0a') then 10

when lower(contract_address) = lower('0x1E34A77868E19A6647b1f2F47B51ed72dEDE95DD') then 100 else null end amount_eth

from arbitrum.core.fact_event_logs

where lower(contract_address) in

(lower('0x84443CFd09A48AF6eF360C6976C5392aC5023a1F'),

lower('0xd47438C816c9E7f2E2888E060936a499Af9582b3'),

lower('0x330bdFADE01eE9bF63C209Ee33102DD334618e0a'),

lower('0x1E34A77868E19A6647b1f2F47B51ed72dEDE95DD'))

and user_address is not null

),

txns as (

select *

FROM

(

select * from u_txns

)

union all

(