yasmin-n-d-r-hUNISWAP TOTAL
    Updated 2023-08-23
    SELECT

    COUNT(DISTINCT TX_HASH) AS tx,
    count(distinct(project_name)) as projects_count,
    count (DISTINCT BUYER_ADDRESS) AS buyer,
    count (DISTINCT SELLER_ADDRESS) as seller ,
    count(distinct nft_address) as collections,
    count(distinct tokenid) as nfts,
    sum(PRICE) as volume,
    sum(PRICE_USD) as volume_usd,
    SUM(TOTAL_FEES_USD) as fee,
    SUM(PLATFORM_FEE_USD) as Platform_Fees,
    SUM(CREATOR_FEE_USD) as Royalty,
    Avg(price_usd) as avg_volume,
    AVG(TOTAL_FEES_USD) as Average_Total_Fees,
    AVG(PLATFORM_FEE_USD) as Average_Platform_Fees,
    AVG(CREATOR_FEE_USD) as Average_Royalty
    FROM
    ethereum.core.ez_nft_sales
    where
    ORIGIN_TO_ADDRESS = lower(
    '0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b' )

    Run a query to Download Data