Query editor
WITH all_txs AS (-- RELAYSELECT evt_block_date AS block_date, 'Relay' AS protocol, evt_tx_hash AS tx_hashFROM relay_multichain.relaydepository_evt_relaynativedeposit WHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, 'Relay', evt_tx_hashFROM relay_multichain.relaydepository_evt_relayerc20deposit WHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAY-- DEBRIDGEUNION ALLSELECT evt_block_date, 'DeBridge', evt_tx_hashFROM debridge_multichain.debridgegate_evt_sent WHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT call_block_date, 'DeBridge', call_tx_hashFROM debridge_multichain.dlnsource_call_createsaltedorder WHERE call_block_date >= CURRENT_DATE - INTERVAL '90' DAY AND call_success = trueUNION ALLSELECT call_block_date, 'DeBridge', call_tx_hashFROM debridge_multichain.dlnsource_call_createorder WHERE call_block_date >= CURRENT_DATE - INTERVAL '90' DAY AND call_success = true-- MAYAN (EVM only)UNION ALLSELECT evt_block_date, 'Mayan', evt_tx_hashFROM mayan_multichain.mayanforwarder_evt_forwardederc20 WHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, 'Mayan', evt_tx_hashFROM mayan_multichain.mayanforwarder_evt_swapandforwardederc20 WHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, 'Mayan', evt_tx_hashFROM mayan_multichain.mayanforwarder_evt_forwardedeth WHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, 'Mayan', evt_tx_hashFROM mayan_multichain.mayanforwarder_evt_swapandforwardedeth WHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAY-- AORIUNION ALLSELECT evt_block_date, 'Aori', evt_tx_hashFROM aori_multichain.aori_evt_settle WHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT call_block_date, 'Aori', call_tx_hashFROM aori_multichain.aori_call_fill WHERE call_block_date >= CURRENT_DATE - INTERVAL '90' DAY AND call_success = true)SELECTprotocol,COUNT(DISTINCT CASE WHEN block_date >= CURRENT_DATE - INTERVAL '30' DAY THEN tx_hash END) AS tx_count_30d,COUNT(DISTINCT CASE WHEN block_date >= CURRENT_DATE - INTERVAL '60' DAY THEN tx_hash END) AS tx_count_60d,COUNT(DISTINCT tx_hash) AS tx_count_90d,ROUND(100.0 * COUNT(DISTINCT CASE WHEN block_date >= CURRENT_DATE - INTERVAL '30' DAY THEN tx_hash END)/ SUM(COUNT(DISTINCT CASE WHEN block_date >= CURRENT_DATE - INTERVAL '30' DAY THEN tx_hash END)) OVER (), 2) AS market_share_30d_pctFROM all_txsGROUP BY 1ORDER BY tx_count_30d DESC