action,

count(distinct tx_id) as txns_count,

count(distinct delegator_address) as users_count,

sum(amount/1e6) as volume

from osmosis.core.fact_staking

where tx_succeeded = 1

and block_timestamp > current_date - interval '6 months'

group by 1