select

origin_from_address,

tx_hash

from ethereum.defi.ez_dex_swaps

WHERE block_timestamp:: date >= current_date

and

platform in ('uniswap-v2','uniswap-v3')

select

uniswap.origin_from_address as user,

count(DISTINCT uniswap.tx_hash) as n_swap,

count(DISTINCT nft.tx_hash) as n_nft

from uniswap

join ethereum.nft.ez_nft_sales as nft

ON

uniswap.origin_from_address = nft.buyer_address

group by user

order by n_nft DESC

limit 100

;