Madimint/minter ratio
    Updated 2022-12-08
    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