with txsTb as (

SELECT

BLOCK_TIMESTAMP,

TX_HASH,

SENDER,

EVENT_ADDRESS

FROM aptos.core.fact_events a

JOIN aptos.core.fact_transactions b using(BLOCK_TIMESTAMP, tx_hash)

WHERE a.PAYLOAD_FUNCTION ilike '%Kanalabs%'

AND a.EVENT_RESOURCE ilike 'Swap%'

, newUser as (

sender as new_user,

min(BLOCK_TIMESTAMP) as first_tx_timestamp

FROM txsTb

GROUP by 1

date_trunc('{{Time_Interval}}' , BLOCK_TIMESTAMP)::date as date,

count(DISTINCT TX_HASH) as n_txs,

count(DISTINCT sender) as n_active_users,

count(DISTINCT new_user) as n_new_users,

n_active_users - n_new_users as recurring_users,

sum(n_txs) over (order by date) as cum_n_txs,

sum(n_new_users) over (order by date) as cum_new_users

FROM txsTb

LEFT JOIN newUser on BLOCK_TIMESTAMP::date = first_tx_timestamp::date

WHERE date >= '2023-01-01'

AND date < current_date()

GROUP by 1

ORDER by 1 DESC