MLDZMNprograms1
Updated 2023-04-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with t2 as (
select
signers[0] as users
from solana.core.fact_events
where program_id = '4MangoMjqJ2firMokCjjGgoK8d4MXcrgL7XJaL3w6fVg'
)
select
l.LABEL as programs,
count(distinct t.signers[0]) as sender,
count(distinct t.tx_id) as no_txn
from solana.core.fact_events t join solana.core.dim_labels l on t.PROGRAM_ID = l.address
where t.block_timestamp>= '2023-01-01'
and l.label_subtype != 'token_contract'
and l.LABEL_TYPE in ('defi','nft','dex')
and l.label != 'solana'
and t.succeeded = TRUE
and t.signers[0] in (select users from t2)
and programs not in ('mango markets')
group by 1
order by 2 desc limit 10
Run a query to Download Data