swappers AS (

SELECT '0x'||SUBSTRING(INPUT_DATA, 419, 40) AS taker,

'0x'||SUBSTRING(INPUT_DATA, 483, 40) AS receiver,

tx_hash AS tx,

BLOCK_TIMESTAMP AS date

FROM blast.core.fact_transactions

WHERE STATUS = 'SUCCESS'

AND TO_ADDRESS = '0xbebebeb035351f58602e0c1c8b59ecbff5d5f47b'

AND ORIGIN_FUNCTION_SIGNATURE = '0x87528f13'

UNION ALL

SELECT '0x'||SUBSTRING(INPUT_DATA, 291, 40),

'0x'||SUBSTRING(INPUT_DATA, 355, 40),

tx_hash,

BLOCK_TIMESTAMP

FROM blast.core.fact_transactions

WHERE STATUS = 'SUCCESS'

AND TO_ADDRESS = '0xbebebeb035351f58602e0c1c8b59ecbff5d5f47b'

AND ORIGIN_FUNCTION_SIGNATURE = '0x173260eb'

UNION ALL

SELECT '0x'||SUBSTRING(INPUT_DATA, 355, 40),

'0x'||SUBSTRING(INPUT_DATA, 419, 40),

tx_hash,

BLOCK_TIMESTAMP

FROM blast.core.fact_transactions

WHERE STATUS = 'SUCCESS'

AND TO_ADDRESS = '0xbebebeb035351f58602e0c1c8b59ecbff5d5f47b'

AND ORIGIN_FUNCTION_SIGNATURE = '0x28b2a796'

UNION ALL

SELECT '0x'||SUBSTRING(INPUT_DATA, 483, 40),

'0x'||SUBSTRING(INPUT_DATA, 547, 40),

tx_hash,

BLOCK_TIMESTAMP

FROM blast.core.fact_transactions

WHERE STATUS = 'SUCCESS'

AND TO_ADDRESS = '0xbebebeb035351f58602e0c1c8b59ecbff5d5f47b'