Query editor
WITH selected_borrowers(borrower, focus) AS (VALUES(0x2DEC2FD5C3FCA86249E9BC670ED3097BE531FE78, 'loop-like'),(0x52477C72741B5DF2DBA46EBB6A96601931D3280F, 'kyberswap'),(0xB3C21B3CAB3DF9294910286DE6C84F3CADCF8C0A, 'kyberswap'),(0xDF5A4AA468311F70BFD61FACE904BACB5DBCA1F5, 'no indexed DEX'),(0x49177C391CB71677D5AC9C14BFDB7260F35A4527, 'no indexed DEX'),(0x6FE749508C3991B9CAAB35D49066EF8E7882D6A7, 'no indexed DEX'),(0x41B722E002ECD1E9AD70A6CFB01E30B8738715BC, 'hidden Uniswap v4/v3'),(0xA654A1C821F7604B5500A2FE8DE67A737497D10D, 'multi-venue arbitrage')), ranked AS (SELECT s.focus, m.caller AS borrower, m.evt_tx_hash AS tx_hash,m.evt_block_time AS block_time, m.token, m.assets,ROW_NUMBER() OVER (PARTITION BY m.caller ORDER BY m.evt_block_time DESC) AS sample_rankFROM morpho_blue_base.morphoblue_evt_flashloan mJOIN selected_borrowers s ON s.borrower = m.callerWHERE m.evt_block_date >= CURRENT_DATE - INTERVAL '7' DAY)SELECT sample_rank, focus,CONCAT('0x', TO_HEX(borrower)) AS borrower,block_time,CONCAT('0x', TO_HEX(token)) AS borrowed_token,CAST(assets AS VARCHAR) AS amount_raw,CONCAT('0x', TO_HEX(tx_hash)) AS tx_hash,'https://basescan.org/tx/0x' || TO_HEX(tx_hash) AS basescanFROM rankedWHERE sample_rank <= 3ORDER BY focus, borrower, sample_rank