0-MIDcoll avg copy
    Updated 2024-12-14

    select
    PROJECT_NAME as collection
    ,sum(PRICE_USD) as volume
    ,count(distinct TOKENID) as sold_token
    ,count(distinct BUYER_ADDRESS) as buyers
    ,count(distinct SELLER_ADDRESS) as sellers
    ,count(distinct TX_HASH) as sales
    from avalanche.nft.ez_nft_sales
    where PLATFORM_NAME='salvor'
    group by 1
    order by 2 desc
    limit 10


    QueryRunArchived: QueryRun has been archived