daily_token_prices AS (

SELECT recorded_at::date AS utc_date

, symbol

, price

FROM osmosis.core.dim_prices

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

),

token_symbols AS (

SELECT *

FROM (

SELECT address AS currency

, project_name AS symbol

FROM osmosis.core.dim_labels

WHERE label_type = 'token'

) AS s

QUALIFY row_number() OVER (partition by currency order by symbol) = 1

),

lp_token_txs AS (

SELECT lpa.tx_id

, lpa.block_timestamp

, lpa.liquidity_provider_address

, 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.action IN ('lp_tokens_minted','lp_tokens_burned')

AND tx_status = 'SUCCEEDED'

),