0xHaM-dMost popular top 10 program
    Updated 2022-07-05
    SELECT
    label,
    COUNT(DISTINCT tx_id) AS tx_count,
    COUNT(DISTINCT program_id) AS program_count
    from solana.core.fact_events a
    JOIN solana.core.dim_labels b
    on a.program_id = b.address
    where label_subtype NOT IN ('general_contract', 'hot_wallet')
    and block_timestamp >= '2022-01-01'
    and succeeded='true'
    group by 1
    order by 2 desc
    limit 10
    Run a query to Download Data