Query editor
-- RELAY: deposit eventsWITH relay_daily AS (SELECT block_date, 'Relay' AS protocol, tx_count, volume_usdFROM (SELECTevt_block_date AS block_date,COUNT(DISTINCT evt_tx_hash) AS tx_count,0.0 AS volume_usd -- volume from separate query, count is reliableFROM (SELECT evt_block_date, evt_tx_hash FROM relay_multichain.relaydepository_evt_relaynativedeposit WHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, evt_tx_hash FROM relay_multichain.relaydepository_evt_relayerc20deposit WHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAY) rGROUP BY 1)),-- DEBRIDGE: Gate Sent + DLN ordersdebridge_daily AS (SELECT block_date, 'DeBridge' AS protocol, tx_count, 0.0 AS volume_usdFROM (SELECT block_date, COUNT(DISTINCT tx_hash) AS tx_countFROM (SELECT evt_block_date AS block_date, evt_tx_hash AS tx_hash FROM debridge_multichain.debridgegate_evt_sent WHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT call_block_date, call_tx_hash FROM debridge_multichain.dlnsource_call_createsaltedorder WHERE call_block_date >= CURRENT_DATE - INTERVAL '90' DAY AND call_success = trueUNION ALLSELECT call_block_date, call_tx_hash FROM debridge_multichain.dlnsource_call_createorder WHERE call_block_date >= CURRENT_DATE - INTERVAL '90' DAY AND call_success = true)GROUP BY 1)),-- MAYAN: Forwarder events (EVM only)mayan_daily AS (SELECT block_date, 'Mayan' AS protocol, tx_count, 0.0 AS volume_usdFROM (SELECT block_date, COUNT(DISTINCT tx_hash) AS tx_countFROM (SELECT evt_block_date AS block_date, evt_tx_hash AS tx_hash FROM mayan_multichain.mayanforwarder_evt_forwardederc20 WHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, evt_tx_hash FROM mayan_multichain.mayanforwarder_evt_swapandforwardederc20 WHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, evt_tx_hash FROM mayan_multichain.mayanforwarder_evt_forwardedeth WHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, evt_tx_hash FROM mayan_multichain.mayanforwarder_evt_swapandforwardedeth WHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAY)GROUP BY 1)),-- AORI: Fill + Settleaori_daily AS (SELECT block_date, 'Aori' AS protocol, tx_count, 0.0 AS volume_usdFROM (SELECT block_date, COUNT(DISTINCT tx_hash) AS tx_countFROM (SELECT evt_block_date AS block_date, evt_tx_hash AS tx_hash FROM aori_multichain.aori_evt_settle WHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT call_block_date, call_tx_hash FROM aori_multichain.aori_call_fill WHERE call_block_date >= CURRENT_DATE - INTERVAL '90' DAY AND call_success = true)GROUP BY 1