tx_id,

count(distinct(currency)) as asset_count

from osmosis.core.fact_liquidity_provider_actions

where tx_status = 'SUCCEEDED'

and action = 'pool_joined'

group by 1,2)

select

date_trunc('week', block_timestamp) as week_date,

date_trunc('day', block_timestamp) as date,

when asset_count = 1 then 'Single Side LP'

else 'Both Assets LP'

end as join_type,

count(distinct(tx_id)) as tx_count,

sum(tx_count) over (partition by join_type order by week_date) as week_cumu_tx_count,

sum(tx_count) over (partition by join_type order by date) as date_cumu_tx_count

from dt1

group by 1,2,3

order by 1 desc