strawbettytotal number of swaps
Updated 2022-03-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with top10_token_address as (
select
swap_from_mint,
count(*) as swap_count
from solana.swaps
where block_timestamp::date >= '2022-02-01'
and succeeded = 'TRUE'
and swap_program = 'jupiter aggregator v2'
group by 1
order by 2 DESC
limit 10
)
select block_timestamp::date as date, label, count(*)
from solana.swaps swaps left outer join solana.labels labels on swaps.swap_from_mint = labels.address
where block_timestamp::date >= '2022-02-01'
and succeeded = 'TRUE'
and swap_program = 'jupiter aggregator v2'
and (swap_from_mint in (select swap_from_mint from top10_token_address))
group by 1,2
order by 3 desc
Run a query to Download Data