Sbhn_NPdecisive-emerald
    Updated 2024-10-06
    select date_trunc('day',block_timestamp) as date,
    count(DISTINCT tx_hash) as sales,
    sum(sales) over (order by date) as cumulative_sales,
    count(DISTINCT buyer_address) as buyers,
    count(DISTINCT seller_address) as sellers,
    sum(price) as volume,
    sum(price_usd) as usd_volume,
    avg(price_usd) as avg_volume
    from near.nft.ez_nft_sales
    where nft_address='aa-harvest-moon-relics.near'
    group by 1

    -- select *
    -- from near.nft.ez_nft_sales
    -- where nft_address='aa-harvest-moon-relics.near'
    -- and method_name = 'resolve_offer'
    -- limit 10
    QueryRunArchived: QueryRun has been archived