MLDZMNgsrd3
    Updated 2022-11-06
    select
    b.PROJECT_NAME as NFT_collection,
    count(TX_ID) as mint_no,
    count(distinct PURCHASER) as minter_no,
    sum(MINT_PRICE) as volume,
    avg(MINT_PRICE) as average_volume,
    minter_no/count(distinct date_trunc(day, block_timestamp)) as average_buyer_day,
    volume/count(distinct date_trunc(day, block_timestamp)) as average_volume_day,
    row_number() over (order by volume desc) as rank
    from solana.core.fact_nft_mints s left outer join solana.core.dim_nft_metadata b on s.mint=b.mint
    where SUCCEEDED='TRUE'
    and BLOCK_TIMESTAMP>=CURRENT_DATE- {{Time_period}}
    group by 1 having NFT_collection is not null
    order by 4 desc
    limit 20
    Run a query to Download Data