Query editor
WITHvalidated_morpho_borrowers(borrower) AS (VALUES(0xDF5A4AA468311F70BFD61FACE904BACB5DBCA1F5),(0x49177C391CB71677D5AC9C14BFDB7260F35A4527),(0x6FE749508C3991B9CAAB35D49066EF8E7882D6A7),(0x41B722E002ECD1E9AD70A6CFB01E30B8738715BC),(0x52477C72741B5DF2DBA46EBB6A96601931D3280F),(0xB3C21B3CAB3DF9294910286DE6C84F3CADCF8C0A)),morpho AS (SELECT 'Morpho Blue' AS provider, evt_tx_hash AS tx_hash, evt_block_time AS block_time,evt_block_date AS block_date, caller AS borrower, token AS token_address,assets AS amount_raw, CAST(0 AS uint256) AS fee_rawFROM morpho_blue_base.morphoblue_evt_flashloanWHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAY),aave_raw AS (SELECT evt_tx_hash, evt_index, evt_block_time, evt_block_date, initiator, asset, amount, premiumFROM aave_v3_base.l2pool_evt_flashloanWHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNIONSELECT evt_tx_hash, evt_index, evt_block_time, evt_block_date, initiator, asset, amount, premiumFROM aave_v3_base.pool_evt_flashloanWHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAY),aave AS (SELECT 'Aave V3' AS provider, evt_tx_hash, evt_block_time, evt_block_date,initiator AS borrower, asset AS token_address, amount AS amount_raw, premium AS fee_rawFROM aave_raw),priced AS (SELECT l.*,CAST(l.amount_raw AS DOUBLE) / POW(10, COALESCE(p.decimals, 18)) * p.price AS borrowed_usd,CAST(l.fee_raw AS DOUBLE) / POW(10, COALESCE(p.decimals, 18)) * p.price AS provider_fee_usdFROM (SELECT * FROM morpho UNION ALL SELECT * FROM aave) lLEFT JOIN prices.day p ON p.blockchain = 'base' AND p.contract_address = l.token_addressAND p.timestamp = CAST(l.block_date AS TIMESTAMP)),flash_tx AS (SELECT provider, tx_hash, MIN(block_time) AS block_time, MIN(block_date) AS block_date,MIN(borrower) AS borrower, SUM(borrowed_usd) AS borrowed_usd,SUM(provider_fee_usd) AS provider_fee_usdFROM priced GROUP BY 1, 2),hashes AS (SELECT tx_hash FROM flash_tx),dex_tx AS (SELECT d.tx_hash FROM dex.trades d JOIN hashes h ON h.tx_hash = d.tx_hashWHERE d.blockchain = 'base'AND d.block_month >= DATE_TRUNC('month', CURRENT_DATE - INTERVAL '30' DAY)AND d.block_date >= CURRENT_DATE - INTERVAL '30' DAYGROUP BY 1),liq AS (SELECT evt_tx_hash AS tx_hash FROM morpho_blue_base.morphoblue_evt_liquidate WHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION SELECT evt_tx_hash FROM aave_v3_base.l2pool_evt_liquidationcall WHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION SELECT evt_tx_hash FROM aave_v3_base.pool_evt_liquidationcall WHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAY),borrow AS (SELECT evt_tx_hash AS tx_hash FROM morpho_blue_base.morphoblue_evt_borrow WHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAY