DATE_TRUNC('hour', block_timestamp),

sum(CASE WHEN ACTION LIKE 'lp_tokens_minted' THEN amount/power(10, decimal) END) as deposit_tokens,

sum(CASE WHEN ACTION LIKE 'lp_tokens_burned' THEN amount/power(10, decimal) END) as withdraw_tokens,

sum(CASE WHEN ACTION LIKE 'lp_tokens_minted' THEN amount/power(10, decimal) END) - sum(CASE WHEN ACTION LIKE 'lp_tokens_burned' THEN amount/power(10, decimal) END) as net_deposit_tokens

FROM osmosis.defi.fact_liquidity_provider_actions

WHERE (ACTION LIKE 'lp_tokens_minted' OR action LIKE 'lp_tokens_burned')

AND ARRAY_CONTAINS({{pool_id}}, pool_id)

GROUP BY 1