Madimint/minter ratio
Updated 2022-12-08Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with labels as (
select
CASE
WHEN LABEL = 'okay bears' THEN 'Okay Bears'
WHEN LABEL = 'cyber frogs' THEN 'Cyber Frogs'
WHEN LABEL = 'cets on creck' then 'Cets on Creck'
WHEN LABEL = 'boryoku dragonz' then 'Boryoku Dragonz' end as Collection,
address
from solana.core.dim_labels where label in ('okay bears','cets on creck', 'boryoku dragonz','cyber frogs')
),
df as (
select date_trunc ('day', BLOCK_TIMESTAMP) as date, tx_id, purchaser, MINT_PRICE, Collection, Mint
from solana.core.fact_nft_mints join labels on solana.core.fact_nft_mints.mint = labels.address
where SUCCEEDED = 'TRUE')
select collection, count(DISTINCT tx_id) as mints, count(DISTINCT PURCHASER) as unique_minters,
mints/unique_minters as "NFT/Minter Ratio"
from df group by 1
Run a query to Download Data