SELECT trader, block_timestamp

FROM arbitrum.vertex.ez_perp_trades

UNION ALL

SELECT trader, block_timestamp

FROM arbitrum.vertex.ez_spot_trades

),

trader AS (

SELECT COUNT(DISTINCT trader) AS traders

FROM data

WHERE block_timestamp >= current_date - interval '{{period}} days'

AND trader != '0x0000000000000000000000000000000000000000'

),

new AS (

SELECT COUNT(DISTINCT trader) AS new_trader

FROM (

SELECT trader, MIN(block_timestamp) AS first_trade_date

FROM data

GROUP BY trader

) first_trades

WHERE first_trade_date >= current_date - interval '{{period}} days'

SELECT *

FROM trader, new;