Updated 2022-12-08
    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