SELECT

from_address,

MIN(block_timestamp) AS first_transaction_date

FROM

kaia.core.fact_transactions

GROUP BY

from_address

having first_transaction_date >= current_date - 60

select

label_type,

count(DISTINCT tx_hash) as transactions

from kaia.core.fact_transactions a join kaia.core.dim_labels b on a.to_address = b.address

where block_timestamp::Date >= current_date - 60

and from_address in (select from_address from user_first_transaction)

and label_type not in ('cex','chadmin')

group by 1