count(distinct POOL_ADDRESS) as "Total Number of Active Pools"

FROM near.core.dim_staking_actions

WHERE action in ('Stake') and block_timestamp BETWEEN '{{From}}' and DATEADD(DAY, 7, '{{From}}')