DATE_TRUNC('week', block_timestamp) as week,

SUM(CASE WHEN lp_action = 'add_liquidity' THEN asset_amount_usd ELSE 0 END) AS add,

SUM (CASE WHEN lp_action = 'remove_liquidity' THEN asset_amount_usd ELSE 0 END) AS rem,

FROM thorchain.defi.fact_liquidity_actions

WHERE pool_name = 'BTC.BTC'

AND block_timestamp :: date >= '2024-01-01'

GROUP BY week

ORDER BY week DESC;