par_rnDaily number of top apps Used by Solana Stakers since September
Updated 2022-12-24
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
31
32
›
⌄
with tab1 as (
SELECT
DISTINCT signers[0] ,
trunc(block_timestamp,'day') as date
from solana.fact_staking_lp_actions
)
SELECT
trunc(block_timestamp,'day') as date,
CASE WHEN program_id LIKE '9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin' then 'Serum DEX V3'
WHEN program_id LIKE '11111111111111111111111111111111' then 'Wrapped SOL'
WHEN program_id LIKE 'mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68' then 'Mango Markets V3'
WHEN program_id LIKE '675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8' then 'Raydium Liquidity Pool V4'
WHEN program_id LIKE 'JUP2jxvXaqu7NQY1GmNF4m1vodw12LVXYxbFL2uJvfo' then 'Jupiter Aggregator v2'
WHEN program_id LIKE 'arbBLsceGLi5xSgNn8Fou2XGTjYBphSATAaSC2NTpS3' then 'BPF Upgradeable Loader' END,
COUNT(*)
FROM solana.fact_events
--WHERE instruction['account'][1] in (SELECT * FROM tab1)
WHERE not CASE WHEN program_id LIKE '9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin' then 'Serum DEX V3'
WHEN program_id LIKE '11111111111111111111111111111111' then 'Wrapped SOL'
WHEN program_id LIKE 'mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68' then 'Mango Markets V3'
WHEN program_id LIKE '675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8' then 'Raydium Liquidity Pool V4'
WHEN program_id LIKE 'JUP2jxvXaqu7NQY1GmNF4m1vodw12LVXYxbFL2uJvfo' then 'Jupiter Aggregator v2'
WHEN program_id LIKE 'arbBLsceGLi5xSgNn8Fou2XGTjYBphSATAaSC2NTpS3' then 'BPF Upgradeable Loader' END is NULL
and BLOCK_TIMESTAMP>='2022-09-01'
GROUP BY 1,2
Run a query to Download Data