MLDZMNcubi3
Updated 2023-07-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
-- '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