Afonso_DiazTop collections
    Updated 2024-09-27
    with t as (
    select
    tx_hash,
    block_timestamp,
    seller_address,
    buyer_address,
    platform_name,
    nft_address,
    price,
    price_usd,
    tx_fee_usd,
    platform_fee_usd
    from
    base.nft.ez_nft_sales
    where
    block_timestamp::date between '{{ start_date }}' and '{{ end_date }}'
    and platform_name = 'opensea'
    )

    select
    nft_address,
    count(distinct tx_hash) as transactions,
    count(distinct seller_address) as sellers,
    count(distinct buyer_address) as buyers,
    sum(price_usd) as volume_usd,
    avg(price_usd) as avg_price_usd
    from t
    group by 1
    order by volume_usd desc
    limit 10




    QueryRunArchived: QueryRun has been archived