select origin_from_address, tx_hash

from ethereum.defi.ez_dex_swaps

where block_timestamp :: date >= current_date - 31

and platform IN ('uniswap-v2', 'uniswap-v3')

select uniswap.origin_from_address as user, count(distinct uniswap.tx_hash) as n_swaps, count(distinct nft.tx_hash) as n_nft_purchases

from uniswap

join ethereum.nft.ez_nft_sales nft on uniswap.origin_from_address = nft.buyer_address

where nft.block_timestamp :: date >= current_date - 31

group by user

order by n_nft_purchases desc

limit 100