with tokens as (
select
distinct CONTRACT_ADDRESS as tokens,
BLOCK_TIMESTAMP as time_created
from ethereum.core.ez_token_transfers
where ORIGIN_TO_ADDRESS ='0x7603a35af5cf10b113f167d424eb75bb7062c8ce'
)
SELECT
SYMBOL_OUT,
sum(AMOUNT_OUT_USD) as usd_amounts
from ethereum.core.ez_dex_swaps
where TOKEN_IN in (select tokens from tokens)
--or TOKEN_OUT in (select tokens from tokens))
group by 1