KaskoazulSolana Top 5 Programs
Updated 2022-02-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
SELECT
CASE program_id
WHEN 'FsJ3A3u2vn5cTVofAjvy6y5kwABJAqYWpe4975bi2epH' THEN 'Pyth Oracle'
WHEN '9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin' THEN 'Serum DEX V3'
WHEN 'DtmE9D2CSB4L5D6A15mraeEjrGMm6auWVzgaD8hK2tZM' THEN 'Switchboard Oracle'
WHEN 'mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68' THEN 'Mango Markets V3'
WHEN '11111111111111111111111111111111' THEN 'Wrapped SOL'
WHEN 'GDDMwNyyx8uB6zrqwBFHjLLG3TBYk2F8Az4yrQC5RzMp' THEN 'N/A'
END AS Program_name,
program_id,
count(program_id) as Number_of_transactions
FROM
solana.transactions
WHERE
succeeded = 'TRUE'
AND block_timestamp >= '2022-01-01'
GROUP BY 1, 2
ORDER BY 3 DESC
LIMIT 5
Run a query to Download Data