WITH transferTb AS (

SELECT

BLOCK_TIMESTAMP,

'External xDAI' as transfer_type,

TX_HASH,

FROM_ADDRESS,

TO_ADDRESS,

VALUE as volume,

FROM gnosis.core.fact_transactions

WHERE (FROM_ADDRESS IN (select MULTISIG_ADDRESS from crosschain.olas.ez_service_registrations WHERE AGENT_IDS[0] IN (12, 14, 25, 11, 9, 13))

OR TO_ADDRESS IN (select MULTISIG_ADDRESS from crosschain.olas.ez_service_registrations WHERE AGENT_IDS[0] IN (12, 14, 25, 11, 9, 13)))

UNION all

SELECT

BLOCK_TIMESTAMP,

'Internal xDAI' as transfer_type,

TX_HASH,

FROM_ADDRESS,

TO_ADDRESS,

VALUE as volume,

FROM gnosis.core.fact_traces

WHERE (FROM_ADDRESS IN (select MULTISIG_ADDRESS from crosschain.olas.ez_service_registrations WHERE AGENT_IDS[0] IN (12, 14, 25, 11, 9, 13))

OR TO_ADDRESS IN (select MULTISIG_ADDRESS from crosschain.olas.ez_service_registrations WHERE AGENT_IDS[0] IN (12, 14, 25, 11, 9, 13)))

AND VALUE > 0

UNION all

SELECT

BLOCK_TIMESTAMP,

'Wrapped xDAI' as transfer_type,

TX_HASH,

ORIGIN_FROM_ADDRESS as FROM_ADDRESS,

ORIGIN_TO_ADDRESS as TO_ADDRESS,