flow defi tvl by protocol 2

adriaparcerisasflow defi tvl by protocol 2

Updated 1 day ago

select

x.protocol,

case when x.protocol ilike '%more markets%' then avg(chain_tvl)+15000000 else avg(chain_tvl) end as tvl

--sum(volume) as dex_volume,

--sum(dex_volume) over (order by week) as total_dex_volume

from external.defillama.fact_protocol_tvl x

--join external.defillama.fact_dex_volume y on lower(x.chain)=y.chain and x.date=y.date

where x.chain ilike '%Flow%' and trunc(date,'week')=trunc(current_date,'week')-7

group by 1 order by 2 desc

Last run: 1 day ago

479B

flipside