superflyUntitled Query
Updated 2022-11-21Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
date_trunc('day', w.block_timestamp) as day,
initcap(label) as program,
count(distinct(w.tx_id)) as number_of_transactions,
count(distinct(swapper)) as number_of_users
from solana.core.fact_events w join solana.core.dim_labels m on w.program_id = m.address
join solana.core.fact_swaps q on w.tx_id = q.tx_id
where w.block_timestamp >= '2022-10-01'
and w.succeeded = 'TRUE'
and label_type IN ('defi','dex')
group by 1,2
order by 1 desc
Run a query to Download Data