Query editor
WITH svr_assets (chain, comet, asset, storefront, lf) AS (VALUES('arbitrum','cUSDCv3', 0x912ce59144191c1204e64559fe8253a0e49e6548, 0.6, 0.90),('arbitrum','cUSDCv3', 0x82af49447d8a07e3bd95bd0d56f35241523fbab1, 0.6, 0.93),('arbitrum','cUSDCv3', 0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f, 0.6, 0.90),('arbitrum','cUSDTv3', 0x912ce59144191c1204e64559fe8253a0e49e6548, 0.6, 0.90),('arbitrum','cUSDTv3', 0x82af49447d8a07e3bd95bd0d56f35241523fbab1, 0.6, 0.93),('arbitrum','cUSDTv3', 0x5979d7b546e38e414f7e9822514be443a4800529, 0.6, 0.90),('arbitrum','cUSDTv3', 0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f, 0.6, 0.90),('arbitrum','cWETHv3', 0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9, 0.7, 0.95),('arbitrum','cWETHv3', 0xaf88d065e77c8cc2239327c5edb3a432268e5831, 0.7, 0.95),('base','cUSDCv3', 0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22, 0.6, 0.90),('base','cUSDCv3', 0x4200000000000000000000000000000000000006, 0.6, 0.95),('base','cUSDCv3', 0xc1cba3fcea344f92d9239c08c0568f6f2f0ee452, 0.6, 0.90),('base','cWETHv3', 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913, 0.7, 0.95),('base','cWETHv3', 0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf, 0.7, 0.95),('base','cAEROv3', 0x4200000000000000000000000000000000000006, 0.6, 0.75),('base','cAEROv3', 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913, 0.6, 0.80),('base','cAEROv3', 0xc1cba3fcea344f92d9239c08c0568f6f2f0ee452, 0.6, 0.75)),absorbs AS (SELECT 'arbitrum' AS chain,'cUSDCv3' AS comet, evt_tx_hash, evt_block_time, asset, usdValue/1e8 AS usdFROM compound_v3_arbitrum.cUSDCv3_evt_AbsorbCollateralUNION ALL SELECT 'arbitrum','cUSDTv3', evt_tx_hash, evt_block_time, asset, usdValue/1e8FROM compound_v3_arbitrum.cUSDTv3_evt_AbsorbCollateralUNION ALL SELECT 'arbitrum','cWETHv3', evt_tx_hash, evt_block_time, asset, usdValue/1e8FROM compound_v3_arbitrum.cWETHv3_evt_AbsorbCollateralUNION ALL SELECT 'base','cUSDCv3', evt_tx_hash, evt_block_time, asset, usdValue/1e8FROM compound_v3_base.cUSDCv3_evt_AbsorbCollateralUNION ALL SELECT 'base','cWETHv3', evt_tx_hash, evt_block_time, asset, usdValue/1e8FROM compound_v3_base.cWETHv3_evt_AbsorbCollateralUNION ALL SELECT 'base','cAEROv3', evt_tx_hash, evt_block_time, asset, usdValue/1e8FROM compound_v3_base.cAEROv3_evt_AbsorbCollateral)SELECTa.chain, a.comet, a.evt_tx_hash, a.evt_block_time, a.asset,a.usd AS collateral_usd,(s.asset IS NOT NULL) AS is_svr,COALESCE(a.usd * s.storefront * (1 - s.lf), 0) AS oev_usdFROM absorbs aLEFT JOIN svr_assets sON s.chain = a.chain AND s.comet = a.comet AND s.asset = a.assetWHERE a.evt_block_time >= TIMESTAMP '2026-06-01'AND a.evt_block_time < TIMESTAMP '2026-07-01'ORDER BY oev_usd DESC, collateral_usd DESC