vahid-2jsEENa7opsol
Updated 2022-12-05
9
1
2
3
4
5
6
7
›
⌄
select count(distinct TX_ID),SWAPPER,trunc(block_timestamp, 'MONTH') from solana.core.fact_swaps
where swap_program='orca' and SUCCEEDED='TRUE' and SWAPPER in (select SWAPPER from solana.core.fact_swaps
where swap_program='orca' and SUCCEEDED='TRUE'
group by 1
order by count(distinct TX_ID) DESC
limit 10)
group by 2,3
Run a query to Download Data