distinct origin_from_address as address

from ethereum.core.fact_event_logs

where CONTRACT_ADDRESS='0xb4bd4628e6efb0cb521d9ec35050c75840320374')

select

event_name,

count(distinct origin_from_address) as number_of_users

from ethereum.core.fact_event_logs

where origin_from_address in (select address from frETH)

and origin_to_address != '0xb4bd4628e6efb0cb521d9ec35050c75840320374'

and block_timestamp::date = (select min(block_timestamp)::date from ethereum.core.fact_event_logs where contract_address = '0xb4bd4628e6efb0cb521d9ec35050c75840320374')

group by 1

having event_name is not null

order by 2 desc

limit 10