adriaparcerisastrado tvl defi
Updated 2025-02-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select
trunc(x.date,'day') as week,
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 week<trunc(current_date,'day') and week>='2025-01-01'
and protocol ilike '%trado%'
group by 1,2 order by 1 desc
QueryRunArchived: QueryRun has been archived