nsa2000o1
Updated 2022-12-08
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
date_trunc('day', block_timestamp) as day,
CASE WHEN block_timestamp > CURRENT_DATE - 7 THEN 'Past week' ELSE 'Other weeks' END as week,
count(DISTINCT CASE WHEN ACTION LIKE 'lp_tokens_minted' THEN LIQUIDITY_PROVIDER_ADDRESS END) as deposit,
count(DISTINCT CASE WHEN ACTION LIKE 'lp_tokens_burned' THEN LIQUIDITY_PROVIDER_ADDRESS END) as withdraw_
FROM osmosis.core.fact_liquidity_provider_actions
WHERE (ACTION LIKE 'lp_tokens_minted'
OR action LIKE 'lp_tokens_burned')
AND block_timestamp >= '2022-8-01'
AND pool_id = {{pool_id}}
GROUP BY 1,2
Run a query to Download Data