date_trunc ('day', block_timestamp) as date,

event_name as type,

count(distinct origin_from_address) as user_count,

count(distinct tx_hash) as tx_count,

count(distinct contract_name) as token_count,

count(distinct case when event_name = 'Deposit' THEN origin_from_address END) as depositors_count,

count(distinct case when event_name = 'Withdrawal' THEN origin_from_address END) as withdrawers_count,

count(distinct case when event_name = 'Deposit' THEN tx_hash END) as deposits_count,

count(distinct case when event_name = 'Withdrawal' THEN tx_hash END) as withdrawals_count,

from

swell.core.ez_decoded_event_logs

where

event_name in ('Withdrawal', 'Deposit') and

date >= '2025-01-01'

group by

date, type

order by

date asc