superflyDistribution of Sellers By Their Total Sale Actions Uniswap NFT Aggregator
    Updated 2022-12-20
    with maintable as (
    select seller_address,
    count (distinct tx_hash) as Sales_Count,
    count (distinct buyer_address) as Buyers_Count,
    count (distinct seller_address) as Sellers_Count,
    count (distinct tokenid) as Tokens_Count,
    count (distinct nft_address) as Collections_Count,
    count (distinct platform_name) as Platforms_Count,
    sum (price_usd) as Total_Sales_Volume,
    avg (price_usd) as Average_Sales_volume,
    median (price_usd) as median_sale_volume,
    min (price_usd) as minimum_sale_volume,
    max (price_usd) as maximum_sale_volume,
    sum (tx_fee_usd) as Total_TX_Fee,
    avg (tx_fee_usd) as Average_TX_Fee,
    median (tx_fee_usd) as Median_TX_Fee
    from ethereum.core.ez_nft_sales
    where origin_to_address = '0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b'
    group by 1)

    select case when sales_count = 1 then '1 Trade'
    when sales_count > 1 and sales_count <= 5 then '2 - 5 Trades'
    when sales_count > 5 and sales_count <= 10 then '6 - 10 Trades'
    else 'More Than 10 Trades' end as type,
    count (distinct seller_address) as Users_count
    from maintable
    group by 1
    Run a query to Download Data