with txns as (
select
amount/1e6 as token_amount,
*
from osmosis.core.fact_liquidity_provider_actions
where pool_id in (605,606)
and action in ('pool_joined')
and block_timestamp >= CURRENT_DATE - 7
)
select
liquidity_provider_address,
count(distinct tx_id) as n_txns,
sum(token_amount) as t_amount
from txns
group by 1
order by 3 desc
limit 10