Query editor
WITH relay AS (SELECT evt_block_date AS block_date, 'Relay' AS protocol, CAST(evt_tx_hash AS varchar) AS tx_idFROM relay_multichain.relaydepository_evt_relaynativedepositWHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, 'Relay', CAST(evt_tx_hash AS varchar)FROM relay_multichain.relaydepository_evt_relayerc20depositWHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAY),debridge_evm AS (SELECT call_block_date AS block_date, 'DeBridge' AS protocol, CAST(call_tx_hash AS varchar) AS tx_idFROM debridge_multichain.dlnsource_call_createorderWHERE call_block_date >= CURRENT_DATE - INTERVAL '90' DAY AND call_success = trueUNION ALLSELECT call_block_date, 'DeBridge', CAST(call_tx_hash AS varchar)FROM debridge_multichain.dlnsource_call_createsaltedorderWHERE call_block_date >= CURRENT_DATE - INTERVAL '90' DAY AND call_success = true),debridge_solana AS (SELECT call_block_date AS block_date, 'DeBridge' AS protocol, call_tx_id AS tx_idFROM dln_trade_solana.dln_dst_call_fulfillorderWHERE call_block_date >= CURRENT_DATE - INTERVAL '90' DAY),mayan_evm AS (SELECT evt_block_date AS block_date, 'Mayan' AS protocol, CAST(evt_tx_hash AS varchar) AS tx_idFROM mayan_multichain.mayanforwarder_evt_forwardederc20WHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, 'Mayan', CAST(evt_tx_hash AS varchar)FROM mayan_multichain.mayanforwarder_evt_forwardedethWHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, 'Mayan', CAST(evt_tx_hash AS varchar)FROM mayan_multichain.mayanforwarder_evt_swapandforwardederc20WHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, 'Mayan', CAST(evt_tx_hash AS varchar)FROM mayan_multichain.mayanforwarder_evt_swapandforwardedethWHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAY),mayan_solana AS (SELECT call_block_date AS block_date, 'Mayan' AS protocol, call_tx_id AS tx_idFROM mayan_solana.swift_call_initorderWHERE call_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT call_block_date, 'Mayan', call_tx_idFROM mayan_solana.mctp_call_settle_orderWHERE call_block_date >= CURRENT_DATE - INTERVAL '90' DAY),aori AS (SELECT call_block_date AS block_date, 'Aori' AS protocol, CAST(call_tx_hash AS varchar) AS tx_idFROM aori_multichain.aori_call_depositWHERE call_block_date >= CURRENT_DATE - INTERVAL '90' DAY AND call_success = true),lifi AS (SELECT evt_block_date AS block_date, 'LI.FI' AS protocol, CAST(evt_tx_hash AS varchar) AS tx_idFROM lifi_multichain.lifidiamond_evt_lifitransferstartedWHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNIONSELECT evt_block_date, 'LI.FI', CAST(evt_tx_hash AS varchar)