Query editor
SELECTblock_date,COUNT(distinct account_keys[0]) as active_users,COUNT(signer) as transactions,COUNT(signer)/COUNT(distinct account_keys[0]) as trans_per_users,ROUND((COUNT(signer) - LAG(COUNT(signer)) OVER(ORDER BY block_date ASC)) / LAG(COUNT(signer)) OVER(ORDER BY block_date ASC) * 100,2) AS growth_transactions,ROUND((COUNT(distinct account_keys[0]) - LAG(COUNT(distinct account_keys[0])) OVER(ORDER BY block_date ASC)) / LAG(COUNT(distinct account_keys[0])) OVER(ORDER BY block_date ASC) * 100,2) AS growth_usersFROM solana.transactionsWHEREblock_date >= (CURRENT_DATE - '30 days'::INTERVAL)AND block_date < CURRENT_DATEAND ( ARRAY_CONTAINS(account_keys,"STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK") -- Address deposit SOL from Wallet to SpendingOR ARRAY_CONTAINS(account_keys,"HLS5Y68QSQgJP7wUbbbbCjEnMknVZrHXYDwwVaDcsdK7")OR ARRAY_CONTAINS(account_keys,"7i5KKsX2weiTkry7jA4ZwSuXGhs5eJBEjY8vVxR4pfRx")OR ARRAY_CONTAINS(account_keys,"AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB") )AND error is NULLGROUP BYblock_dateORDER BYblock_date desc