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

union all

select '0x'||SUBSTRING(INPUT_DATA,483,40) as taker,

'0x'||SUBSTRING(INPUT_DATA,547,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='0xec983776'),

swap_in as (

select BLOCK_TIMESTAMP, FROM_ADDRESS as USER, AMOUNT, ifnull(AMOUNT_USD, AMOUNT*PRICE) as AMOUNT_USD, a.SYMBOL, CONTRACT_ADDRESS,