(SELECT

date_trunc('day', a.Date) as Date,

COALESCE(Active_Users, 0) as arb_active_users,

COALESCE(New_Users, 0) as arb_new_users

FROM

(

SELECT

date_trunc('day', block_timestamp) as Date,

COUNT(DISTINCT origin_from_address) as Active_Users

FROM arbitrum.defi.ez_dex_swaps

WHERE platform = 'uniswap-v3'

GROUP BY 1

) a

LEFT JOIN

(

SELECT

date_trunc('day', first_transaction_stamp) as Date,

COUNT(DISTINCT Sender) as New_Users

FROM (

SELECT

origin_from_address as Sender,

min(block_timestamp) as first_transaction_stamp

FROM arbitrum.defi.ez_dex_swaps

WHERE platform = 'uniswap-v3'

GROUP BY 1

) b

--WHERE Date >= current_date-365

GROUP BY 1

) c

ON a.Date = c.Date

ORDER BY 1 DESC),

Optimism AS (SELECT

date_trunc('day', a.Date) as Date,