distinct contract_address as pool_address,

token_in,

token_out

from base.defi.ez_dex_swaps

where platform ILIKE 'aerodrome'

)

select

*

from base.core.ez_native_transfers

where origin_from_address in (select pool_address from tab1)

limit 100