Query editor
WITH flashloan_rows AS (SELECT chain, evt_tx_hash AS tx_hash, evt_block_date AS block_date FROM morpho_blue_multichain.morphoblue_evt_flashloan WHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION ALL SELECT chain, evt_tx_hash, evt_block_date FROM aave_v3_multichain.pool_evt_flashloan WHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION ALL SELECT chain, evt_tx_hash, evt_block_date FROM aave_v3_multichain.l2pool_evt_flashloan WHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION ALL SELECT chain, evt_tx_hash, evt_block_date FROM balancer_v2_multichain.vault_evt_flashloan WHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION ALL SELECT chain, evt_tx_hash, evt_block_date FROM swaap_v2_multichain.vault_evt_flashloan WHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION ALL SELECT chain, evt_tx_hash, evt_block_date FROM aave_v2_multichain.lendingpool_evt_flashloan WHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION ALL SELECT chain, call_tx_hash, call_block_date FROM euler_v2_multichain.evault_call_flashloan WHERE call_block_date >= CURRENT_DATE - INTERVAL '30' DAY AND call_successUNION ALL SELECT chain, call_tx_hash, call_block_date FROM dodo_multichain.dpp_call_flashloan WHERE call_block_date >= CURRENT_DATE - INTERVAL '30' DAY AND call_successUNION ALL SELECT chain, call_tx_hash, call_block_date FROM dodo_multichain.dppadvanced_call_flashloan WHERE call_block_date >= CURRENT_DATE - INTERVAL '30' DAY AND call_successUNION ALL SELECT chain, call_tx_hash, call_block_date FROM dodo_multichain.dpporacle_call_flashloan WHERE call_block_date >= CURRENT_DATE - INTERVAL '30' DAY AND call_successUNION ALL SELECT chain, call_tx_hash, call_block_date FROM dodo_multichain.dvm_call_flashloan WHERE call_block_date >= CURRENT_DATE - INTERVAL '30' DAY AND call_successUNION ALL SELECT chain, call_tx_hash, call_block_date FROM dodo_multichain.dsp_call_flashloan WHERE call_block_date >= CURRENT_DATE - INTERVAL '30' DAY AND call_successUNION ALL SELECT chain, call_tx_hash, call_block_date FROM dodo_multichain.gsp_call_flashloan WHERE call_block_date >= CURRENT_DATE - INTERVAL '30' DAY AND call_successUNION ALL SELECT chain, call_tx_hash, call_block_date FROM maverick_v2_multichain.v2pool_call_flashloan WHERE call_block_date >= CURRENT_DATE - INTERVAL '30' DAY AND call_successUNION ALL SELECT chain, evt_tx_hash, evt_block_date FROM trader_joe_v2_1_multichain.lbpair_evt_flashloan WHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION ALL SELECT chain, evt_tx_hash, evt_block_date FROM trader_joe_v2_2_multichain.lbpair_evt_flashloan WHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAY),flashloans AS (SELECT chain, tx_hash, MIN(block_date) AS block_dateFROM flashloan_rowsWHERE chain IN ('ethereum','base','arbitrum','optimism','polygon','bnb','avalanche_c','gnosis','linea','scroll','sonic','monad','unichain')GROUP BY 1, 2),liquidations AS (SELECT DISTINCT chain, evt_tx_hash AS tx_hash FROM morpho_blue_multichain.morphoblue_evt_liquidate WHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION SELECT DISTINCT chain, evt_tx_hash FROM aave_v3_multichain.pool_evt_liquidationcall WHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION SELECT DISTINCT chain, evt_tx_hash FROM aave_v3_multichain.l2pool_evt_liquidationcall WHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION SELECT DISTINCT chain, evt_tx_hash FROM aave_v2_multichain.lendingpool_evt_liquidationcall WHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAY),lending_activity AS (SELECT DISTINCT chain, evt_tx_hash AS tx_hash FROM morpho_blue_multichain.morphoblue_evt_borrow WHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION SELECT DISTINCT chain, evt_tx_hash FROM morpho_blue_multichain.morphoblue_evt_repay WHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION SELECT DISTINCT chain, evt_tx_hash FROM morpho_blue_multichain.morphoblue_evt_supply WHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION SELECT DISTINCT chain, evt_tx_hash FROM morpho_blue_multichain.morphoblue_evt_withdraw WHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION SELECT DISTINCT chain, evt_tx_hash FROM morpho_blue_multichain.morphoblue_evt_withdrawcollateral WHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION SELECT DISTINCT chain, evt_tx_hash FROM aave_v3_multichain.pool_evt_borrow WHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION SELECT DISTINCT chain, evt_tx_hash FROM aave_v3_multichain.pool_evt_repay WHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION SELECT DISTINCT chain, evt_tx_hash FROM aave_v3_multichain.pool_evt_supply WHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION SELECT DISTINCT chain, evt_tx_hash FROM aave_v3_multichain.pool_evt_withdraw WHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION SELECT DISTINCT chain, evt_tx_hash FROM aave_v3_multichain.l2pool_evt_borrow WHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION SELECT DISTINCT chain, evt_tx_hash FROM aave_v3_multichain.l2pool_evt_repay WHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION SELECT DISTINCT chain, evt_tx_hash FROM aave_v3_multichain.l2pool_evt_supply WHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION SELECT DISTINCT chain, evt_tx_hash FROM aave_v3_multichain.l2pool_evt_withdraw WHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION SELECT DISTINCT chain, evt_tx_hash FROM aave_v2_multichain.lendingpool_evt_borrow WHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION SELECT DISTINCT chain, evt_tx_hash FROM aave_v2_multichain.lendingpool_evt_repay WHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION SELECT DISTINCT chain, evt_tx_hash FROM aave_v2_multichain.lendingpool_evt_deposit WHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION SELECT DISTINCT chain, evt_tx_hash FROM aave_v2_multichain.lendingpool_evt_withdraw WHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAY),dex_by_tx AS (SELECT d.blockchain AS chain, d.tx_hash,COUNT(*) AS trade_count,MIN_BY(d.token_sold_address, d.evt_index) AS first_token_sold,MAX_BY(d.token_bought_address, d.evt_index) AS last_token_boughtFROM dex.trades dINNER JOIN flashloans f ON f.chain = d.blockchain AND f.tx_hash = d.tx_hashWHERE d.blockchain IN ('ethereum','base','arbitrum','optimism','polygon','bnb','avalanche_c','gnosis','linea','scroll','sonic','monad','unichain')AND d.block_month >= DATE_TRUNC('month', CURRENT_DATE - INTERVAL '30' DAY)AND d.block_date >= CURRENT_DATE - INTERVAL '30' DAYGROUP BY 1, 2