SELECT

block_timestamp,

trader AS user

FROM

arbitrum.vertex.ez_perp_trades

),

new_users AS (

SELECT

user,

MIN(block_timestamp) AS date

FROM

users

GROUP BY

user

SELECT

COUNT(*) AS new_user

FROM

new_users

where date::date = current_date - interval '1 day'