MLDZMNcubi3
    Updated 2023-07-23
    -- '2023-06-23' to '2023-07-03'

    select
    'Accepted projects' as actions,
    count(distinct s.tx_id) as no_projects
    from solana.core.fact_transactions s
    join (select distinct block_timestamp, tx_id
    from solana.core.fact_events where succeeded = True
    and program_id = 'BVo5TquTYMAASZhfX392BcjFUxda6DKzHStNapJE6Wyz') events
    using(tx_id, block_timestamp)
    join lateral flatten (input => log_messages) logs
    where BLOCK_TIMESTAMP >= '2023-06-18'
    and logs.value = 'Program log: Instruction: ProjectRoundJoin'

    Run a query to Download Data