Query editor
-- =====================================================================-- KAMINO USER ACTIVITY: daily SUCCESS actions through Yield.xyz-- =====================================================================WITH a AS (SELECT *FROM dune.yieldxyz.dataset_kamino_actionsWHERE CAST(is_partner_facing AS VARCHAR) IN ('true', 't', '1', 'TRUE'))SELECTCAST(action_date AS DATE) AS day,partner,action_type,integration_type,COUNT(*) AS actions,COUNT(DISTINCT address) AS wallets,ROUND(SUM(CAST(usd_amount AS DOUBLE)), 2) AS usd_volume,ROUND(SUM(CAST(amount AS DOUBLE)), 4) AS native_amountFROM aGROUP BY 1, 2, 3, 4ORDER BY 1, usd_volume DESC