superflyliquidity yield
Updated 2024-11-07
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT
pool_name,
AVG(CASE WHEN LP_ACTION = 'add_liquidity' THEN rune_amount_usd ELSE NULL END) AS avg_deposit_yield,
AVG(CASE WHEN LP_ACTION = 'remove_liquidity' THEN rune_amount_usd ELSE NULL END) AS avg_withdraw_yield
FROM
thorchain.defi.fact_liquidity_actions
WHERE
block_timestamp >= DATE_TRUNC('year', CURRENT_DATE)
GROUP BY
pool_name
QueryRunArchived: QueryRun has been archived