MLDZMNgsrd3
Updated 2022-11-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
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