WITH stOSMO_db AS(

SELECT block_timestamp::date AS date , 'Double Side' AS LP_sided ,'stOSMO/OSMO' AS pool_name ,

COUNT(DISTINCT tx_id)AS tx_count ,

COUNT(DISTINCT liquidity_provider_address) AS users_count ,

sum(amount/pow(10,DECIMAL)) AS amount_usd,

sum(tx_count) OVER (ORDER BY DATE ASC) AS cumu_tx,

sum(users_count) OVER (ORDER BY DATE ASC) AS cumu_users,

sum(amount_usd) OVER (ORDER BY DATE ASC) AS cumu_volume

FROM osmosis.core.fact_liquidity_provider_actions

WHERE block_timestamp::date >= '2022-11-11'

AND currency = 'gamm/pool/833'

AND action = 'lp_tokens_minted' --add both assets

AND pool_id[0] = '833'

AND tx_status = 'SUCCEEDED'

GROUP BY 1 , 2 , 3

) ,

IST_db AS (

SELECT block_timestamp::date AS date , 'Double Side' AS LP_sided ,'IST/OSMO' AS pool_name ,

COUNT(DISTINCT tx_id)AS tx_count ,

COUNT(DISTINCT liquidity_provider_address) AS users_count ,

sum(amount/pow(10,DECIMAL)) AS amount_usd,

sum(tx_count) OVER (ORDER BY DATE ASC) AS cumu_tx,

sum(users_count) OVER (ORDER BY DATE ASC) AS cumu_users,

sum(amount_usd) OVER (ORDER BY DATE ASC) AS cumu_volume

FROM osmosis.core.fact_liquidity_provider_actions

WHERE block_timestamp::date >= '2022-11-15'

AND currency = 'gamm/pool/837'

AND action = 'lp_tokens_minted' --add both assets

AND pool_id[0] = '837'

AND tx_status = 'SUCCEEDED'

GROUP BY 1 , 2 , 3

),

BNB_db AS (