Query editor
WITH selected_borrowers(borrower, strategy) AS (VALUES(0xDF5A4AA468311F70BFD61FACE904BACB5DBCA1F5, 'DODO hidden loop'),(0x49177C391CB71677D5AC9C14BFDB7260F35A4527, 'DODO hidden loop'),(0x6FE749508C3991B9CAAB35D49066EF8E7882D6A7, 'DODO hidden loop'),(0x41B722E002ECD1E9AD70A6CFB01E30B8738715BC, 'Uniswap V4/V3 hidden loop'),(0x52477C72741B5DF2DBA46EBB6A96601931D3280F, 'Kyber/Uniswap V4 routing'),(0xB3C21B3CAB3DF9294910286DE6C84F3CADCF8C0A, 'Kyber/Uniswap V4 routing')), flash_tx AS (SELECT m.evt_tx_hash AS tx_hash, m.caller AS borrowerFROM morpho_blue_base.morphoblue_evt_flashloan mJOIN selected_borrowers s ON s.borrower = m.callerWHERE m.evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYGROUP BY 1, 2)SELECT s.strategy,CONCAT('0x', TO_HEX(l.contract_address)) AS borrower,CONCAT('0x', TO_HEX(l.topic0)) AS topic0,COUNT(*) AS events,COUNT(DISTINCT l.tx_hash) AS transactions,MIN(LENGTH(l.data)) AS min_data_bytes,MAX(LENGTH(l.data)) AS max_data_bytesFROM base.logs lJOIN flash_tx f ON f.tx_hash = l.tx_hash AND f.borrower = l.contract_addressJOIN selected_borrowers s ON s.borrower = l.contract_addressWHERE l.block_date >= CURRENT_DATE - INTERVAL '30' DAYGROUP BY 1, 2, 3ORDER BY strategy, transactions DESC