with ETH_table as (

select

tx_hash,

block_timestamp,

decoded_log:from as actor,

decoded_log:value/pow(10,decimals) as amount,

'Deposit' as action

from

bsc.core.ez_decoded_event_logs l

inner join bsc.core.dim_contracts c on c.address = l.contract_address

where event_name = 'Transfer'

and contract_address = '0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c'

and origin_function_signature = '0x6e553f65'

and decoded_log:to = '0xed18f1ce58fed758c7937cc0b8be66cb02dc45c6'

and tx_status = 'SUCCESS'

and block_timestamp > '2022-08-01'

UNION

tx_hash,

block_timestamp,

decoded_log:to as actor,

decoded_log:value/pow(10,decimals) as amount,

'Withdraw' as action

from bsc.core.ez_decoded_event_logs l

inner join bsc.core.dim_contracts c on c.address = l.contract_address

where event_name = 'Transfer'

and contract_address = '0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c'

and origin_function_signature = '0x00f714ce'

and decoded_log:from in ('0xed18f1ce58fed758c7937cc0b8be66cb02dc45c6')

and tx_status = 'SUCCESS'

and block_timestamp > '2022-08-01'

),

data AS (

select