date_trunc('day', block_timestamp) as date,

count(distinct tx_id) as count,

count(distinct address) as unique_user

from solana.core.fact_stake_pool_actions

where

date >= current_date - 7 and

action ilike 'order_unstake' and

succeeded = 'TRUE'

group by 1