WITH Uniswap AS (

SELECT

date_trunc('day',block_timestamp) AS date,

tx_hash,

platform_name,

seller_address,

buyer_address,

nft_address,

tokenid,

price_usd,

creator_fee_usd

FROM ethereum.core.ez_nft_sales

WHERE origin_to_address = lower('0xEf1c6E67703c7BD7107eed8303Fbe6EC2554BF6B')

SELECT

COUNT(*) AS sales,

COUNT(DISTINCT tx_hash) AS tx,

COUNT(DISTINCT seller_address) AS sellers,

COUNT(DISTINCT buyer_address) AS buyers,

SUM(price_usd) AS usd_vol,

SUM(creator_fee_usd) AS usd_royalty

FROM Uniswap