greyswandiamond hands
    Updated 2023-07-03
    with
    counts as (
    select
    count(distinct mint) as trades,
    sum(sales_amount) as volume,
    label
    from
    solana.core.fact_nft_sales
    left join solana.core.dim_labels on mint = address
    where
    succeeded = True
    and block_timestamp >= '2023-01-01'
    group by
    label
    order by
    count(mint) desc
    ),
    mints as (
    select
    count(address) as mints,
    label
    from
    solana.core.dim_labels
    where
    LABEL_SUBTYPE = 'nf_token_contract'
    group by
    label
    )
    select
    t1.label as collection,
    trades / mints as share,
    1 - trades / mints as zero_sales,
    trades,
    mints,
    volume
    from
    Run a query to Download Data