select
block_timestamp::date as date,
count(distinct tx_id) as "Number Stake",
count(distinct delegator_address) as "Staker",
sum(amount) / pow(10,decimal) as "Amount WETH",
label
from osmosis.core.fact_superfluid_staking s inner join osmosis.core.dim_labels l
on s.validator_address = l.address
where split_part(currency, 'gamm/pool/', 2) = '704'
and tx_status = 'SUCCEEDED'
group by 1,5,decimal