MadiTop minters by number of minted NFTs
Updated 2022-12-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with addressesss as (select DISTINCT address from solana.core.dim_labels
where ADDRESS_NAME ='lily'),
df as (select
BLOCK_TIMESTAMP,
TX_ID,
PURCHASER,
MINT_PRICE,
MINT
from solana.core.fact_nft_mints
where SUCCEEDED = 'TRUE' and MINT_CURRENCY = 'So11111111111111111111111111111111111111111'
and mint in (select address from addressesss))
select
PURCHASER as minter,
count(DISTINCT MINT) as nfts,
sum(MINT_PRICE) as amount,
concat ('https://solscan.io/account/',PURCHASER) as "Link on Solscan.io"
from df group by 1,4 order by 2 desc limit 100
Run a query to Download Data