Query editor
WITH relay AS (SELECT evt_block_date AS block_date, evt_tx_hash AS tx_hashFROM relay_multichain.relaydepository_evt_relaynativedepositWHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, 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, evt_tx_hash AS tx_hashFROM debridge_multichain.dlnsource_evt_createdorderWHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, 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, evt_tx_hash AS tx_hashFROM mayan_multichain.mayanforwarder_evt_forwardederc20WHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, evt_tx_hashFROM mayan_multichain.mayanforwarder_evt_swapandforwardederc20WHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, evt_tx_hashFROM mayan_multichain.mayanforwarder_evt_forwardedethWHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, 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, call_tx_hash AS tx_hashFROM aori_multichain.aori_call_fillWHERE call_block_date >= CURRENT_DATE - INTERVAL '90' DAYAND call_success = true),dates AS (SELECT DISTINCT block_date FROM (SELECT block_date FROM relayUNION SELECT block_date FROM debridgeUNION SELECT block_date FROM mayanUNION SELECT block_date FROM aori))SELECTd.block_date,COALESCE(r.txs, 0) AS relay_txs,COALESCE(db.txs, 0) AS debridge_txs,COALESCE(a.txs, 0) AS aori_txs,COALESCE(m.txs, 0) AS mayan_txsFROM dates dLEFT JOIN (SELECT block_date, COUNT(DISTINCT tx_hash) AS txs FROM relay GROUP BY 1) r ON d.block_date = r.block_dateLEFT JOIN (SELECT block_date, COUNT(DISTINCT tx_hash) AS txs FROM debridge GROUP BY 1) db ON d.block_date = db.block_dateLEFT JOIN (SELECT block_date, COUNT(DISTINCT tx_hash) AS txs FROM aori GROUP BY 1) a ON d.block_date = a.block_date