par_rnDaily number of top apps Used by Solana Stakers since September
    Updated 2022-12-24
    with tab1 as (
    SELECT
    DISTINCT signers[0] ,
    trunc(block_timestamp,'day') as date
    from solana.fact_staking_lp_actions
    )


    SELECT
    trunc(block_timestamp,'day') as date,
    CASE WHEN program_id LIKE '9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin' then 'Serum DEX V3'
    WHEN program_id LIKE '11111111111111111111111111111111' then 'Wrapped SOL'
    WHEN program_id LIKE 'mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68' then 'Mango Markets V3'
    WHEN program_id LIKE '675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8' then 'Raydium Liquidity Pool V4'
    WHEN program_id LIKE 'JUP2jxvXaqu7NQY1GmNF4m1vodw12LVXYxbFL2uJvfo' then 'Jupiter Aggregator v2'
    WHEN program_id LIKE 'arbBLsceGLi5xSgNn8Fou2XGTjYBphSATAaSC2NTpS3' then 'BPF Upgradeable Loader' END,
    COUNT(*)
    FROM solana.fact_events
    --WHERE instruction['account'][1] in (SELECT * FROM tab1)

    WHERE not CASE WHEN program_id LIKE '9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin' then 'Serum DEX V3'
    WHEN program_id LIKE '11111111111111111111111111111111' then 'Wrapped SOL'
    WHEN program_id LIKE 'mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68' then 'Mango Markets V3'
    WHEN program_id LIKE '675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8' then 'Raydium Liquidity Pool V4'
    WHEN program_id LIKE 'JUP2jxvXaqu7NQY1GmNF4m1vodw12LVXYxbFL2uJvfo' then 'Jupiter Aggregator v2'
    WHEN program_id LIKE 'arbBLsceGLi5xSgNn8Fou2XGTjYBphSATAaSC2NTpS3' then 'BPF Upgradeable Loader' END is NULL
    and BLOCK_TIMESTAMP>='2022-09-01'

    GROUP BY 1,2

    Run a query to Download Data