Query editor
SELECT 'DEST_CHAIN_ID' AS grain,CAST(destinationChainId AS varchar) AS name,COUNT(*) AS events_30d,COUNT(DISTINCT chain) AS source_chains,CAST(NULL AS varchar) AS noteFROM rango_exchange_multichain.rangodiamond_evt_rangobridgeinitiatedWHERE evt_block_time >= now() - INTERVAL '30' dayGROUP BY 2UNION ALLSELECT 'SAME_CHAIN_SWAP' AS grain, chain AS name, COUNT(*) AS events_30d,1 AS source_chains, 'rangoswap event' AS noteFROM rango_exchange_multichain.rangodiamond_evt_rangoswapWHERE evt_block_time >= now() - INTERVAL '30' dayGROUP BY 2ORDER BY grain, events_30d DESC