winnie-fsSpecific Avalanche Project's Specific Pool Stats
Updated 2024-06-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
›
⌄
select date_trunc ({{Time_Interval}},date) as date,
case when projects ilike '%aave%' then 'AAVE'
when projects ilike '%joe%' then 'Trader Joe'
when projects ilike '%gmx%' then 'GMX'
else initcap (projects) end as "Project Name",
symbol as "Pool",
initcap(il_risk) as "Impermanent Loss Risk",
median (apy) as "APY",
avg (tvl_usd) as "TVL [$]",
median (volume_usd_1d) as "24H Volume",
median (volume_usd_7d) as "7D Volume",
avg (mu) as "MU (µ)",
avg (sigma) as "SIGMA (σ)"
from external.defillama.fact_pool_yields
where chain ilike 'Avalanche'
and "Project Name" ilike '%{{Project_Name}}%'
and symbol ilike '%{{Yield_Pool}}'
group by 1,2,3,4
order by date desc
QueryRunArchived: QueryRun has been archived