dim_date AS (

SELECT dateadd('day', seq4(), '2022-05-01') as utc_date

FROM TABLE(GENERATOR(rowcount => 10000))

WHERE utc_date BETWEEN '2022-05-01' AND CURRENT_DATE

),

lp_token_txs AS (

SELECT lpa.tx_id

, lpa.block_timestamp

, lpa.pool_id

, lpa.liquidity_provider_address AS wallet

, lpa.action

, lpa.currency

, lpa.amount / power(10, lpa.decimal) AS amount

FROM osmosis.core.fact_liquidity_provider_actions AS lpa

WHERE lpa.pool_id = 604

AND lpa.action IN ('lp_tokens_minted','lp_tokens_burned')

AND tx_status = 'SUCCEEDED'

),

daily_lp_stats AS (

SELECT wallet

, block_timestamp::date AS utc_date

, sum(CASE WHEN action = 'lp_tokens_minted' THEN amount ELSE 0 END) AS lp_tokens_minted

, sum(CASE WHEN action = 'lp_tokens_burned' THEN -amount ELSE 0 END) AS lp_tokens_burned

, sum(CASE WHEN action = 'lp_tokens_minted' THEN amount

WHEN action = 'lp_tokens_burned' THEN -amount END) AS lp_token_balance_change

FROM lp_token_txs

GROUP BY 1,2

),