Drsimonkem 2
    Updated 2024-12-30
    select
    DATE_TRUNC('{{Time_frame}}', block_timestamp) AS DATE,
    count(distinct BUYER_ADDRESS) AS BUYERS ,
    count(distinct SELLER_ADDRESS ) * -1 AS SELLERS ,
    count(distinct tx_hash) as nft_sales ,
    count(distinct tokenid) ,
    sum(price) as price_eth,
    sum(price_usd) as price_usd
    from base.nft.ez_nft_sales
    where nft_address = lower('0xee7d1b184be8185adc7052635329152a4d0cdefa')
    group by 1
    order by 2 desc
    Auto-refreshes every 12 hours
    QueryRunArchived: QueryRun has been archived