Query editor
WITHstrategies(borrower, fixed_beneficiary, strategy, beneficiary_rule) AS (VALUES(0x52477C72741B5DF2DBA46EBB6A96601931D3280F, 0x03FAFA0B33BB05056DDC156DB1A4DF47D681539A, 'Kyber + Uniswap V4 multi-venue arbitrage', 'fixed recurring recipient'),(0xB3C21B3CAB3DF9294910286DE6C84F3CADCF8C0A, CAST(NULL AS VARBINARY), 'Kyber + Uniswap V4 multi-venue arbitrage', 'transaction sender')),flash_tx AS (SELECT m.evt_tx_hash AS tx_hash,MIN(m.evt_block_date) AS block_date,m.caller AS borrower,s.strategy,s.beneficiary_rule,CASE WHEN s.fixed_beneficiary IS NOT NULL THEN s.fixed_beneficiary ELSE t."from" END AS beneficiary,SUM(CAST(m.assets AS DOUBLE) / POW(10, COALESCE(p.decimals, 18)) * p.price) AS borrowed_usd,MAX(CAST(t.gas_used AS DOUBLE) * CAST(t.gas_price AS DOUBLE) + CAST(t.l1_fee AS DOUBLE)) / 1e18 AS gas_ethFROM morpho_blue_base.morphoblue_evt_flashloan mJOIN strategies s ON s.borrower = m.callerJOIN base.transactions tON t.hash = m.evt_tx_hashAND t.block_date >= CURRENT_DATE - INTERVAL '30' DAYLEFT JOIN prices.day pON p.blockchain = 'base'AND p.contract_address = m.tokenAND p.timestamp = CAST(m.evt_block_date AS TIMESTAMP)WHERE m.evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYGROUP BY 1, 3, 4, 5, 6),beneficiary_flows AS (SELECT f.tx_hash,COUNT_IF(tt."from" = f.beneficiary OR tt."to" = f.beneficiary) AS touched_transfers,COUNT_IF((tt."from" = f.beneficiary OR tt."to" = f.beneficiary) AND tt.amount_usd IS NOT NULL) AS priced_transfers,SUM(CASE WHEN tt."to" = f.beneficiary THEN COALESCE(tt.amount_usd, 0) ELSE 0 END- CASE WHEN tt."from" = f.beneficiary THEN COALESCE(tt.amount_usd, 0) ELSE 0 END) AS beneficiary_gross_usdFROM flash_tx fLEFT JOIN tokens.transfers ttON tt.tx_hash = f.tx_hashAND tt.blockchain = 'base'AND tt.block_month >= DATE_TRUNC('month', CURRENT_DATE - INTERVAL '30' DAY)AND tt.block_date >= CURRENT_DATE - INTERVAL '30' DAYAND (tt."from" = f.beneficiary OR tt."to" = f.beneficiary)GROUP BY 1),profit_tx AS (SELECT f.*,COALESCE(b.beneficiary_gross_usd, 0) AS beneficiary_gross_usd,f.gas_eth * ep.price AS gas_cost_usd,COALESCE(b.beneficiary_gross_usd, 0) - f.gas_eth * ep.price AS estimated_net_profit_usd,100.0 * b.priced_transfers / NULLIF(b.touched_transfers, 0) AS price_coverage_pctFROM flash_tx fJOIN beneficiary_flows b ON b.tx_hash = f.tx_hashLEFT JOIN prices.day epON ep.blockchain = 'base'AND ep.contract_address = 0x0000000000000000000000000000000000000000AND ep.timestamp = CAST(f.block_date AS TIMESTAMP))SELECT strategy,beneficiary_rule,CONCAT('0x', TO_HEX(borrower)) AS borrower,CASE WHEN beneficiary_rule = 'fixed recurring recipient' THEN CONCAT('0x', TO_HEX(MIN(beneficiary))) ELSE 'dynamic: transaction sender' END AS validated_beneficiary,COUNT(*) AS transactions,