Query editor
WITHmorpho_legs 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, contract_address AS provider_addressFROM morpho_blue_base.morphoblue_evt_flashloanWHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAY),aave_raw AS (SELECT evt_tx_hash, evt_index, evt_block_time, evt_block_date, initiator, asset, amount, contract_addressFROM aave_v3_base.l2pool_evt_flashloanWHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNIONSELECT evt_tx_hash, evt_index, evt_block_time, evt_block_date, initiator, asset, amount, contract_addressFROM aave_v3_base.pool_evt_flashloanWHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAY),aave_legs 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,contract_address AS provider_addressFROM aave_raw),loan_legs AS (SELECT * FROM morpho_legsUNION ALLSELECT * FROM aave_legs),priced_legs AS (SELECT l.*,p.symbol AS borrowed_symbol,CAST(l.amount_raw AS DOUBLE) / POW(10, COALESCE(p.decimals, 18)) * p.price AS amount_usdFROM loan_legs lLEFT JOIN prices.day pON p.blockchain = 'base'AND p.contract_address = l.token_addressAND p.timestamp = CAST(l.block_date AS TIMESTAMP)),flash_tx AS (SELECT l.provider, l.tx_hash, MIN(l.block_time) AS block_time, MIN(l.block_date) AS block_date,MIN(l.borrower) AS borrower, MIN(l.provider_address) AS provider_address,t."from" AS tx_sender,ARRAY_JOIN(ARRAY_SORT(ARRAY_AGG(DISTINCT l.borrowed_symbol)), ', ') AS borrowed_tokens,SUM(l.amount_usd) AS borrowed_usd,(CAST(t.gas_used AS DOUBLE) * CAST(t.gas_price AS DOUBLE) + CAST(t.l1_fee AS DOUBLE)) / 1e18 * ep.price AS gas_cost_usdFROM priced_legs lJOIN base.transactions tON t.hash = l.tx_hashAND t.block_date >= CURRENT_DATE - INTERVAL '90' DAYLEFT JOIN prices.day epON ep.blockchain = 'base'AND ep.contract_address = 0x0000000000000000000000000000000000000000AND ep.timestamp = CAST(l.block_date AS TIMESTAMP)GROUP BY 1, 2, 7, 10),repayment_marker AS (SELECT f.tx_hash, MAX(tt.evt_index) AS repayment_evt_indexFROM flash_tx fJOIN tokens.transfers ttON tt.tx_hash = f.tx_hash