headitmanagerswap
Updated 2022-04-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with stakers as (select distinct INSTRUCTION:parsed:info:stakeAuthority as users from solana.events where event_type='delegate')
, swap_program as (select count(*),swap_program from solana.swaps
where block_timestamp > CURRENT_DATE() - interval '1 month' and swapper in (select users from stakers)
group by swap_program )
, nft_swap_program as (select count(*),swap_program from solana.fact_swaps
where block_timestamp > CURRENT_DATE() - interval '1 month' and swapper in (select users from stakers)
group by swap_program)
select * from swap_program
Run a query to Download Data