tx_from as user

from axelar.core.fact_transactions

UNION all

select BLOCK_TIMESTAMP,

SENDER as user

from axelar.core.fact_transfers

UNION all

select CREATED_AT as block_timestamp,

sender_address as user

from axelar.axelscan.fact_transfers

UNION all

select block_timestamp,

ATTRIBUTE_VALUE as user

from axelar.core.fact_msg_attributes

where ATTRIBUTE_KEY in ('fee_payer','sender')

,

new as ( select min(block_timestamp::date) as date,

from users

group by 2)

select date,

count(DISTINCT user) as "New Users",

sum("New Users") over (order by date asc ) as "Cumulative New users"

from new

where date >= '2024-01-01'

group by 1

order by 1 asc