flow defi tvl by protocol 2

adriaparcerisasflow defi tvl by protocol 2

Updated 2 days ago

select

x.protocol,

avg(chain_tvl) 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')

group by 1 order by 2 desc

Last run: 1 day ago

396B

flipside