kimkimTotal Solend users in 2022
    Updated 2022-08-02
    with Table1 as (
    select
    a.BLOCK_TIMESTAMP::date as date,
    count(distinct (signers[0])) as users
    FROM solana.core.fact_events a
    join solana.core.fact_transactions b
    on a.tx_id = b.tx_id
    where a.PROGRAM_ID = 'So1endDq2YkqhipRh3WViPa8hdiSpxWy6z3Z6tMCpAo'
    and a.BLOCK_TIMESTAMP >='2022-01-01'
    group by 1
    )
    select
    sum(users) as Total_users
    from Table1
    Run a query to Download Data