barbodnet 3
Updated 2022-07-12
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
block_timestamp::date as day,
l.LABEL,
count(distinct t.signers[0]) as user_sol
from solana.fact_transactions t join solana.dim_labels l on t.instructions[0]:programId = l.address
where t.block_timestamp>=CURRENT_DATE-60
and l.label_subtype != 'token_contract'
and l.LABEL_TYPE in ('dex')
and l.label != 'solana'
and t.succeeded = TRUE
group by 1,2
Run a query to Download Data