sum(AMOUNT/ pow(10,18)) as lp_amount,

count(distinct liquidity_provider_address) as providers,

count(distinct Tx_id) as transactions

from osmosis.core.fact_liquidity_provider_actions

where POOL_ID = '604'

and action = 'lp_tokens_minted'

and TX_STATUS = 'SUCCEEDED'

and BLOCK_TIMESTAMP > CURRENT_DATE - 7