0-MIDthe salvors daily past three month
    Updated 2024-12-14

    select date_trunc('day',BLOCK_TIMESTAMP) as day
    ,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'
    and date_trunc('day',BLOCK_TIMESTAMP)>=current_date-90
    and PROJECT_NAME='The Salvors'
    group by 1


    QueryRunArchived: QueryRun has been archived