SELECT

BLOCK_TIMESTAMP,

'External xDAI' as transfer_type,

TX_HASH,

FROM_ADDRESS as user,

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))

UNION all

SELECT

BLOCK_TIMESTAMP,

'Internal xDAI' as transfer_type,

TX_HASH,

FROM_ADDRESS as user,

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))

AND VALUE > 0

UNION all

SELECT

BLOCK_TIMESTAMP,

'Wrapped xDAI' as transfer_type,

TX_HASH,

ORIGIN_FROM_ADDRESS as user,

FROM gnosis.core.ez_token_transfers

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

AND contract_address = lower('0xe91D153E0b41518A2Ce8Dd3D7944Fa863463a97d')

UNION all

SELECT

BLOCK_TIMESTAMP,

'External xDAI' as transfer_type,