headitmanagerMost Popular Jupiter Swaps - part2
Updated 2022-03-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
›
⌄
with top10popular as (Select SWAP_TO_MINT as swap_for,
count(*) as swapcount
From Solana.swaps s LEFT OUTER JOIN Solana.labels b
ON s.swap_program=b.label
Where block_timestamp::date >= '2022-02-01'
And succeeded = 'True' and swap_program='jupiter aggregator v2'
Group by swap_for
order by swapcount DESC
limit 10)
,
tbl_popular as (select max(swapcount) as mostpopular from top10popular)
select case
when swap_for = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then 'USD Coin'
when swap_for = 'So11111111111111111111111111111111111111112' then 'Wrapped SOL'
when swap_for = '4k3Dyjzvzp8eMZWUXbBCjEvwSkkk59S5iCNLY3QrkX6R' then 'Token Raydium'
when swap_for = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' then 'USDT'
when swap_for = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' then 'Marinade staked SOL (mSOL)'
when swap_for = 'StepAscQoEioFxxWGnh2sLBDFp9d8rvKz2Yp39iDpyT' then 'Step'
when swap_for = '9n4nbM75f5Ui33ZbPYXn59EwSgE8CGsHtAeTH5YFeJ9E' then 'Wrapped Bitcoin (Sollet)'
when swap_for = 'SUNNYWgPQmFxe9wTZzNK7iPnJ3vYDrkgnxJRJm1s3ag' then 'Sunny Governance Token'
when swap_for = 'DubwWZNWiNGMMeeQHPnMATNj77YZPZSAz2WVR5WjLJqz' then 'CropperFinance'
when swap_for = '9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' then 'UST (Wormhole)'
when swap_for = 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB' then 'GST'
when swap_for = '7vfCXTUXx5WJV5JADk17DUJ4ksgau7utNKj4b963voxs' then 'Ether (Wormhole)'
when swap_for = 'orcaEKTdK7LKz57vaAYr9QeNsVEPfiu6QeMU1kektZE' then 'ORCA'
when swap_for = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then 'ATLAS'
end as tokenname,
swapcount,
case when swapcount = (select mostpopular from tbl_popular) then 'most popular'
else 'popular' end as popular from top10popular