mariyaWeekly share of transactions
    Updated 2022-11-11
    with top_10 as ( select nft_address , sum(price_usd) as volume
    from ethereum.core.ez_nft_sales
    where price_usd is not null and block_timestamp::date >=CURRENT_DATE - 180
    group by 1
    order by 2 desc
    limit 11)

    select trunc(block_timestamp,'week') as date, project_name,
    count(DISTINCT(tx_hash)) as total_sales,
    count(DISTINCT(buyer_address)) total_buyer,
    count(DISTINCT(seller_address)) as total_seller, sum(price_usd) as total_volume, avg(price_usd) as avg_price,
    sum(total_volume) over (partition by project_name order by date asc) as cum_volume,
    sum(total_sales) over (partition by project_name order by date asc) as cum_sales,
    count(DISTINCT(tokenid)) as total_nfts
    from ethereum.core.ez_nft_sales a join ethereum.core.dim_labels b on a.nft_address = b.address
    where nft_address in ( select nft_address from top_10)
    and date >= CURRENT_DATE - 180 and project_name is not null
    group by 1,2
    Run a query to Download Data