Query editor
WITH dln_salted AS (SELECTcall_block_date AS block_date,chain,contract_address,call_tx_hash AS tx_hashFROM debridge_multichain.dlnsource_call_createsaltedorderWHERE call_block_date >= CURRENT_DATE - INTERVAL '90' DAYAND call_success = true),dln_standard AS (SELECTcall_block_date AS block_date,chain,contract_address,call_tx_hash AS tx_hashFROM debridge_multichain.dlnsource_call_createorderWHERE call_block_date >= CURRENT_DATE - INTERVAL '90' DAYAND call_success = true),dln_all AS (SELECT * FROM dln_saltedUNION ALLSELECT * FROM dln_standard),dln_priced AS (SELECTo.block_date,o.tx_hash,SUM(t.amount_usd) AS amount_usdFROM dln_all oINNER JOIN tokens.transfers tON t.tx_hash = o.tx_hashAND t.blockchain = o.chainAND t.to = o.contract_addressAND t.block_date = o.block_dateGROUP BY 1, 2),token_map AS (SELECT DISTINCT debridgeId, chain, tokenAddressFROM debridge_multichain.debridgegate_evt_pairadded),gate_sends AS (SELECTs.evt_block_date AS block_date,s.chain,tm.tokenAddress AS token,CAST(s.amount AS double) AS amount_raw,s.evt_tx_hashFROM debridge_multichain.debridgegate_evt_sent sLEFT JOIN token_map tmON s.debridgeId = tm.debridgeId AND s.chain = tm.chainWHERE s.evt_block_date >= CURRENT_DATE - INTERVAL '90' DAY),gate_priced AS (SELECTg.block_date,g.evt_tx_hash AS tx_hash,CASEWHEN g.token = 0x0000000000000000000000000000000000000000