Query editor
WITH relay AS (SELECT evt_block_date AS block_date, 'Relay' AS protocol, evt_tx_hash AS tx_hashFROM relay_multichain.relaydepository_evt_relaynativedepositWHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, 'Relay', evt_tx_hashFROM 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_hashFROM debridge_multichain.dlnsource_evt_createdorderWHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, 'DeBridge', evt_tx_hashFROM 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_hashFROM mayan_multichain.mayanforwarder_evt_forwardederc20WHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, 'Mayan', evt_tx_hashFROM mayan_multichain.mayanforwarder_evt_swapandforwardederc20WHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, 'Mayan', evt_tx_hashFROM mayan_multichain.mayanforwarder_evt_forwardedethWHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, 'Mayan', evt_tx_hashFROM 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_hashFROM 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)SELECTblock_date,protocol,COUNT(DISTINCT tx_hash) AS daily_txsFROM all_protocolsGROUP BY 1, 2ORDER BY 1, 2