ORIGIN_FROM_ADDRESS,

TX_HASH

FROM ethereum.defi.ez_dex_swaps

WHERE block_timestamp :: date >= current_date - 2024-08-15

and platform like 'uniswap%'

uniswap.ORIGIN_FROM_ADDRESS User,

count(distinct uniswap.TX_HASH) no_of_Uniswap_Swaps,

count(distinct nft.TX_HASH) no_of_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 - 2024-08-15

GROUP BY User

ORDER BY no_of_NFT_purchases DESC

LIMIT 100

;