Updated 2024-08-22

    select date_trunc('week',BLOCK_TIMESTAMP)as week
    ,sum(PRICE_USD) as volume
    ,avg(PRICE_USD) avg_volume
    ,count(distinct BUYER_ADDRESS) as buyers
    ,count(distinct SELLER_ADDRESS) as sellers
    ,count(distinct TOKENID) as sold_token
    from arbitrum.nft.ez_nft_sales
    where PLATFORM_NAME='treasure'
    group by 1



    QueryRunArchived: QueryRun has been archived