Query editor
WITH relay AS (SELECT evt_block_date AS block_date, 'Relay' AS protocol, evt_tx_hash AS tx_hash,chain, "from" AS walletFROM relay_multichain.relaydepository_evt_relaynativedepositWHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, 'Relay', evt_tx_hash, chain, "from"FROM relay_multichain.relaydepository_evt_relayerc20depositWHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAY),debridge AS (SELECT evt_block_date AS block_date, 'DeBridge' AS protocol, evt_tx_hash AS tx_hash,chain, evt_tx_from AS walletFROM debridge_multichain.dlnsource_evt_createdorderWHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, 'DeBridge', evt_tx_hash, chain, nativeSenderFROM debridge_multichain.debridgegate_evt_sentWHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAY),mayan AS (SELECT evt_block_date AS block_date, 'Mayan' AS protocol, evt_tx_hash AS tx_hash,chain, evt_tx_from AS walletFROM mayan_multichain.mayanforwarder_evt_forwardederc20WHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, 'Mayan', evt_tx_hash, chain, evt_tx_fromFROM mayan_multichain.mayanforwarder_evt_swapandforwardederc20WHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, 'Mayan', evt_tx_hash, chain, evt_tx_fromFROM mayan_multichain.mayanforwarder_evt_forwardedethWHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, 'Mayan', evt_tx_hash, chain, evt_tx_fromFROM mayan_multichain.mayanforwarder_evt_swapandforwardedethWHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAY),aori AS (SELECT call_block_date AS block_date, 'Aori' AS protocol, call_tx_hash AS tx_hash,chain, call_tx_from AS walletFROM aori_multichain.aori_call_fillWHERE call_block_date >= CURRENT_DATE - INTERVAL '90' DAYAND call_success = true),all_protocols AS (SELECT * FROM relayUNION ALL SELECT * FROM debridgeUNION ALL SELECT * FROM mayanUNION ALL SELECT * FROM aori)SELECTprotocol,COUNT(DISTINCT tx_hash) AS total_txs,COUNT(DISTINCT wallet) AS unique_wallets,COUNT(DISTINCT chain) AS chains_active,MIN(block_date) AS first_activity,MAX(block_date) AS last_activity,ROUND(