origin_from_address as swapper,

count(distinct(tx_hash)) as tx_count

from ethereum.uniswapv3.ez_pools a

join ethereum.core.fact_event_logs b

using (tx_hash)

where a.block_timestamp::date > current_date - interval '1 month'

and origin_function_signature in ('0xb6b55f25')

and token0_symbol in ('USDT', 'USDC', 'BUSD', 'DAI', 'USDP', 'TUSD', 'USDD', 'USDN', 'GUSD', 'FEI', 'FRAX', 'LUSD', 'SUSD')

and token1_symbol in ('USDT', 'USDC', 'BUSD', 'DAI', 'USDP', 'TUSD', 'USDD', 'USDN', 'GUSD', 'FEI', 'FRAX', 'LUSD', 'SUSD')

group by 1

order by 2 desc

limit 10