select

address,

initcap(address_name) as address_name,

initcap(label) as project_name,

initcap(label_type) as label_type,

from ethereum.core.dim_labels

where label_type not in ('cex', 'token')

, project_events as (

select

date_trunc('month', block_timestamp) as time,

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, -2, date_trunc('month',current_date()))

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

and status = 'SUCCESS'

, users as (

select

users,

min(time) as min_date

from project_events

group by 1

, dates as (

select

distinct time as date

from project_events

where date >= dateadd(year, -2, date_trunc('month',current_date()))