0xBlackfishSolend Users
    Updated 2023-11-03
    select
    signers[0]::string as pub_key
    , count(e.tx_id) as n_transactions
    from solana.core.fact_events e
    inner join solana.core.dim_labels l on l.address = e.program_id
    where
    date(e.block_timestamp) between date('2022-11-01') and date('2023-10-31')
    and l.label = 'solend'
    and e.succeeded
    group by 1
    order by 2 desc
    Run a query to Download Data