SELECT

l.address,

l.address_name,

l.Project_name,

t.block_timestamp,

t.origin_from_address

FROM

arbitrum.core.dim_labels l

JOIN

arbitrum.core.ez_token_transfers t

ON l.address = t.origin_from_address

WHERE

contract_address = lower('0x95146881b86B3ee99e63705eC87AfE29Fcc044D9')

, new_addresses AS

(SELECT

origin_from_address,

min(block_timestamp) as first_tx_timestamp

FROM

Vertex_users

GROUP BY 1

SELECT

date_trunc('week', first_tx_timestamp) as week,

'new' as type,

count(origin_from_address) as n_users

FROM

new_addresses

GROUP BY week, type

UNION ALL