Query editor
withfluid_blockchains as (select *from "query_5044493"), timeline_daily as (select timestamp as dayfrom utils.dayswhere timestamp >= (select min(deploy_date) from fluid_blockchains)), timeline as (select distinctdate_trunc('{{frequency}}', day) as from_ts, date_add('{{frequency}}', 1, date_trunc('{{frequency}}', day)) - interval '1' day as till_tsfrom timeline_daily), fluid_liquidity_users as (select *from "query_6782325"), fluid_vaults as (select *-- from "query_6157247"from dune."0xfluid".result_fluid_vaults), fluid_smart_lending as (select *from "query_6901651"), fluid_user_reserves_daily as (select *from dune."0xfluid".result_fluid_user_reserves), fluid_vaults_tvl as (select*, coalesce(coll_token0_usd, 0) + coalesce(coll_token1_usd, 0) as coll_usd, coalesce(debt_token0_usd, 0) + coalesce(debt_token1_usd, 0) as debt_usd, coalesce(coll_token0_usd, 0) + coalesce(coll_token1_usd, 0) - coalesce(debt_token0_usd, 0) - coalesce(debt_token1_usd, 0) as tvl_usdfrom (selectt.day, v.address as vault_address, v.blockchain, v.id as vault_id, v.type as vault_type, v.vault_name, casewhen v.type in (1, 3) then vr.token0_suppliedwhen v.type in (2, 4) then (vr.cum_coll_shares / drc.cum_coll_shares ) * drc.token0_suppliedelse nullend as coll_token0