greyswandiamond hands_long collection specific
    Updated 2023-07-10
    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,
    1 - trades / mints as zero_sales,
    trades,
    mints
    from
    counts t1
    left join mints t2 on t1.label = t2.label
    Run a query to Download Data