Query editor
with curated as (select * from query_5076695), combined as (selecttime,tx_hash,ARRAY_JOIN(ARRAY_DISTINCT(ARRAY_AGG(liquidator)), ', ') as liquidator,ARRAY_JOIN(ARRAY_DISTINCT(ARRAY_AGG(silo)), ', ') as silo,ARRAY_JOIN(ARRAY_DISTINCT(ARRAY_AGG(user)), ', ') as user,ARRAY_JOIN(ARRAY_DISTINCT(ARRAY_AGG(symbol)), ', ') AS seized_asset, -- Concatenate asset namesSUM(liq_usd) AS liq_usd -- Sum liquidation valuesfrom curatedGROUP BY time, tx_hash), oev as (select*,liq_usd * 0.05 as oev_usd,liq_usd * 0.05 * 0.8 as protocol_revenue,liq_usd * 0.05 * 0.2 as searcher_revenuefrom combined)selectROW_NUMBER() over (order by time asc) as rn,*,SUM(liq_usd) over (ORDER BY time asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as cum_liq_total,sum(oev_usd) over (ORDER BY time asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as cum_oev,sum(protocol_revenue) over (ORDER BY time asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as cum_protocol_rev,sum(searcher_revenue) over (ORDER BY time asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as cum_searcher_revfrom oevorder by time desc