h4wkbase
Updated 2023-11-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
s-- select label, label_type, address
-- from solana.core.dim_labels
-- where label = 'jupiter' and label_type = 'dex'
select block_timestamp::date as date,
label,
count(distinct signers[0]) as users,
count(distinct tx_id) as txs
from solana.core.fact_events
join solana.core.dim_labels on program_id = address
where
block_timestamp >= CURRENT_DATE - 14 and block_timestamp < CURRENT_DATE
-- block_timestamp::date = '2023-11-11'
and succeeded = TRUE and label != 'solana'
group by 1,2
-- order by users desc
-- limit 20
Run a query to Download Data