Query editor
withtimeline as (select timestamp as dayfrom utils.dayswhere timestamp >= timestamp '2024-10-29'), fluid_dexes as (selectcast(dex_id as varchar) as dex_id, 'fluid dex' as dex_type, dex_name-- from "query_6157381"from dune."0xfluid".result_fluid_dexesunionselectcast(dex_id as varchar) as dex_id, 'fluid dex lite' as dex_type, dex_namefrom "query_5571121"), fluid_dex_swaps as (select *from "query_4791524"), fluid_dex_lite_swaps as (select *-- from "query_5572407" -- fullfrom "query_6639013" -- simple), fluid_dex_trading_volume as (selectt.day, t.dex_name, s.volume_usd, sum(coalesce(s.volume_usd, 0)) over (partition by t.dex_name order by t.day) as cum_volume_usd, s.fees_usd, sum(coalesce(s.fees_usd, 0)) over (partition by t.dex_name order by t.day) as cum_fees_usd, s.revenue_usd, sum(coalesce(s.revenue_usd, 0)) over (partition by t.dex_name order by t.day) as cum_revenue_usdfrom (select t.*, d.*from timeline as tcross join (select distinct dex_name from fluid_dexes) as d) as tleft join (selectday, dex_name, sum(coalesce(amount_in_usd, amount_out_usd)) as volume_usd, sum(coalesce(fee_in_usd, fee_out_usd)) as fees_usd, sum(coalesce(revenue_in_usd, revenue_out_usd)) as revenue_usdfrom fluid_dex_swapsgroup by 1, 2