mariyaTotal mint (by top NFT collection users-weekly)
    Updated 2022-11-12
    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)
    , fnl as ( select date(block_timestamp) as date, buyer_address, project_name
    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 block_timestamp::date >= CURRENT_DATE - 180
    ) select trunc(block_timestamp,'week') as date, b.project_name, count(DISTINCT(tx_hash)) as total
    from ethereum.core.ez_nft_mints a join fnl b on a.NFT_TO_ADDRESS = b.buyer_address
    where block_timestamp::date >= CURRENT_DATE - 180 and b.project_name is not null
    group by 1,2
    Run a query to Download Data