Query editor
-- DeBridge Gate: Sent events (bridge transfers)WITH gate_sent AS (SELECTevt_block_date AS block_date,chain,evt_tx_hashFROM debridge_multichain.debridgegate_evt_sentWHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAY),-- DLN: Order creation counts (salted + regular)dln_orders AS (SELECT call_block_date AS block_date, chain, call_tx_hash AS tx_hashFROM debridge_multichain.dlnsource_call_createsaltedorderWHERE call_block_date >= CURRENT_DATE - INTERVAL '90' DAYAND call_success = trueUNION ALLSELECT call_block_date AS block_date, chain, call_tx_hash AS tx_hashFROM debridge_multichain.dlnsource_call_createorderWHERE call_block_date >= CURRENT_DATE - INTERVAL '90' DAYAND call_success = true),-- DLN fulfilled ordersdln_fulfilled AS (SELECT evt_block_date AS block_date, chain, evt_tx_hash AS tx_hashFROM debridge_multichain.dlndestination_evt_fulfilledorderWHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAY),daily_gate AS (SELECT block_date, COUNT(DISTINCT evt_tx_hash) AS gate_tx_countFROM gate_sent GROUP BY 1),daily_dln_created AS (SELECT block_date, COUNT(DISTINCT tx_hash) AS dln_orders_createdFROM dln_orders GROUP BY 1),daily_dln_filled AS (SELECT block_date, COUNT(DISTINCT tx_hash) AS dln_orders_filledFROM dln_fulfilled GROUP BY 1)SELECTCOALESCE(g.block_date, dc.block_date, df.block_date) AS block_date,COALESCE(g.gate_tx_count, 0) AS gate_tx_count,COALESCE(dc.dln_orders_created, 0) AS dln_orders_created,COALESCE(df.dln_orders_filled, 0) AS dln_orders_filled,COALESCE(g.gate_tx_count, 0) + COALESCE(dc.dln_orders_created, 0) AS total_tx_countFROM daily_gate gFULL OUTER JOIN daily_dln_created dc ON g.block_date = dc.block_dateFULL OUTER JOIN daily_dln_filled df ON COALESCE(g.block_date, dc.block_date) = df.block_dateORDER BY 1