daily_token_prices AS (

SELECT recorded_at::date AS utc_date

, symbol

, price

FROM osmosis.core.dim_prices

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

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[0]

, 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[0] = 584

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

AND TX_SUCCEEDED = TRUE

),

lp_token_daily_supply AS (

SELECT block_timestamp::date AS utc_date

, 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

GROUP BY utc_date

),