-- How much liquidity is being added and removed from the THORChain pools over time? Is there a noticeable trend?
-- Hint: use thorchain.liquidity_actions
select
date_trunc('week',block_timestamp) as date,
pool_name,
sum(rune_amount_usd) as tvl
from thorchain.liquidity_actions
where lp_action = 'add_liquidity'
group by date,pool_name