SELECT 'Ethereum' as chain,

tab1.day,

tab1.TX_HASH,

tab1.ORIGIN_FROM_ADDRESS,

tab2.AMOUNT_USD

FROM (

SELECT BLOCK_TIMESTAMP::date as day,

TX_HASH,

ORIGIN_FROM_ADDRESS

FROM ethereum.core.ez_decoded_event_logs

WHERE ORIGIN_TO_ADDRESS='0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'

AND EVENT_NAME='LiFiGenericSwapCompleted'

AND BLOCK_TIMESTAMP::date >= '2023-08-01'

AND TX_STATUS='SUCCESS'

) AS tab1

JOIN (

SELECT BLOCK_TIMESTAMP::date as day,

AMOUNT_USD,

TX_HASH,

ORIGIN_FROM_ADDRESS,

TO_ADDRESS

FROM ethereum.core.ez_token_transfers

WHERE ORIGIN_TO_ADDRESS='0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'

AND ORIGIN_FROM_ADDRESS = TO_ADDRESS

AND BLOCK_TIMESTAMP::date >= '2023-08-01'

) AS tab2

ON tab1.TX_HASH = tab2.TX_HASH

),

bsc AS (

SELECT 'BSC' as chain,

tab1.day,

tab1.TX_HASH,

tab1.ORIGIN_FROM_ADDRESS,

tab2.AMOUNT_USD

FROM (