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) AS taker,

'0x'||SUBSTRING(INPUT_DATA, 355, 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 = '0x173260eb'

UNION ALL

SELECT

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

'0x'||SUBSTRING(INPUT_DATA, 419, 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 = '0x28b2a796'