WITH b0 AS (

SELECT pool_name

FROM thorchain.core.fact_daily_pool_stats

WHERE swap_count > 0

GROUP BY 1

), b1 AS (

SELECT day

, SUM((rune_liquidity * rune_price_usd) + (asset_liquidity + asset_price_usd)) AS tvl

FROM thorchain.core.fact_daily_pool_stats t

JOIN b0 ON b0.pool_name = t.pool_name

WHERE day >= DATEADD('month', -18, CURRENT_DATE)

AND NOT SPLIT(t.pool_name, '-')[0] IN (

'ETH.KYL'

, 'ETH.HOT'

, 'ETH.RAZE'

)

GROUP BY 1

), mx AS (

SELECT MAX(tvl) AS mx_tvl

FROM b1

SELECT b1.*

, ROUND(100 * b1.tvl / mx_tvl, 1) AS pct_of_max_tvl

FROM b1

JOIN mx ON TRUE