with total_users as(
select count(distinct logs.ORIGIN_FROM_ADDRESS) as lido_users, date_trunc('day', txns.BLOCK_TIMESTAMP) as date
from ethereum.core.fact_transactions txns left join ethereum.core.fact_event_logs logs
on txns.tx_hash=logs.tx_hash
where
CONTRACT_ADDRESS= lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84')
and txns.ETH_VALUE!=0 and
logs.TX_STATUS='SUCCESS' and
date >= '2022-01-01'
group by date
order by lido_users desc
)
select * from total_users