With new_users AS (

SELECT

DISTINCT from_address as sender,

label_type as sector,

min(block_timestamp) as intial_transaction,

count(DISTINCT tx_hash) as transactions

FROM

kaia.core.fact_transactions s

LEFT JOIN kaia.core.dim_labels a on s.to_address = a.address

WHERE

block_timestamp :: date >= '{{Start_Date}}'

AND block_timestamp :: date <= '{{End_Date}}'

AND block_timestamp :: date <= current_date - 1

AND label_type NOT IN ('token', 'chadmin')

GROUP BY

1,

2

HAVING

sector IS NOT NULL

--date_trunc('day', intial_transaction) as "First Transaction Date",

sector as "Sector",

count(sender) as "New Users",

transactions as "Transactions"

new_users

GROUP BY

1,

3

ORDER BY

2 DESC