Query editor
WITH provider_activity AS (SELECT chain, evt_tx_hash AS tx_hash, evt_block_date AS block_date,'Morpho Blue' AS provider, caller AS receiver, 'event' AS source_qualityFROM morpho_blue_multichain.morphoblue_evt_flashloanWHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION ALLSELECT chain, evt_tx_hash, evt_block_date,'Aave V3', target, 'event'FROM aave_v3_multichain.pool_evt_flashloanWHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION ALLSELECT chain, evt_tx_hash, evt_block_date,'Aave V3', target, 'event'FROM aave_v3_multichain.l2pool_evt_flashloanWHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION ALLSELECT chain, evt_tx_hash, evt_block_date,'Balancer V2', recipient, 'event'FROM balancer_v2_multichain.vault_evt_flashloanWHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION ALLSELECT chain, evt_tx_hash, evt_block_date,'Swaap V2', recipient, 'event'FROM swaap_v2_multichain.vault_evt_flashloanWHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION ALLSELECT chain, evt_tx_hash, evt_block_date,'Aave V2', target, 'event'FROM aave_v2_multichain.lendingpool_evt_flashloanWHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION ALLSELECT chain, call_tx_hash, call_block_date,'Euler V2', call_tx_from, 'successful decoded call'FROM euler_v2_multichain.evault_call_flashloanWHERE call_block_date >= CURRENT_DATE - INTERVAL '30' DAYAND call_successUNION ALLSELECT chain, call_tx_hash, call_block_date,'DODO', call_tx_from, 'successful decoded call'FROM dodo_multichain.dpp_call_flashloanWHERE call_block_date >= CURRENT_DATE - INTERVAL '30' DAY AND call_successUNION ALLSELECT chain, call_tx_hash, call_block_date,'DODO', call_tx_from, 'successful decoded call'FROM dodo_multichain.dppadvanced_call_flashloanWHERE call_block_date >= CURRENT_DATE - INTERVAL '30' DAY AND call_successUNION ALLSELECT chain, call_tx_hash, call_block_date,'DODO', call_tx_from, 'successful decoded call'FROM dodo_multichain.dpporacle_call_flashloanWHERE call_block_date >= CURRENT_DATE - INTERVAL '30' DAY AND call_successUNION ALLSELECT chain, call_tx_hash, call_block_date,