daily_token_prices AS (

SELECT recorded_at::date AS utc_date

, symbol

, price

FROM osmosis.core.dim_prices

WHERE symbol IN ('OSMO','EVMOS')

QUALIFY row_number() OVER (partition by symbol, utc_date order by recorded_at desc) = 1

),

lp_token_txs AS (

SELECT lpa.tx_id

, lpa.block_timestamp

, lpa.pool_id

, 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 = 722

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

AND tx_status = 'SUCCEEDED'

),

lp_token_daily_supply AS (

SELECT 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 supply_change

, sum(supply_change) OVER (order by utc_date

rows between unbounded preceding

and current row) AS cumulative_supply

FROM lp_token_txs