with monthly_users as (

select

date_trunc('month', block_timestamp) as time,

count(distinct from_address) as users,

from ethereum.core.fact_transactions as transactions

left join ethereum.core.dim_labels labels on transactions.to_address = labels.address

where block_timestamp >= dateadd(year, -5, date_trunc('month',current_date()))

and block_timestamp < date_trunc('month',current_date())

and label_type in ('defi')

and status = 'SUCCESS'

group by 1

)

select

time,

users as active_users

from monthly_users