MLDZMNother applications
    Updated 2022-06-24
    with tb1 as (select
    *
    from solana.core.fact_transactions
    where INSTRUCTIONS[0]:parsed:info:mint='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
    and INSTRUCTIONS[1]:programId='781wH11JGQgEoBkBzuc8uoQLtp8KxeHk1yZiS1JhFYKy'
    and SUCCEEDED='TRUE'
    )

    select
    l.LABEL_TYPE,
    count(t.signers[0]) as no_holders
    from solana.core.fact_transactions t join solana.core.dim_labels l on t.instructions[0]:programId = l.address
    where t.block_timestamp>='2022-01-01'
    and l.label_subtype != 'token_contract'
    -- and l.LABEL_TYPE in ('defi','nft')
    and t.signers[0] in (select signers[0] from tb1)
    and l.label != 'solana'
    and t.succeeded = TRUE
    group by 1
    Run a query to Download Data