users_activities as (

select *

from

(select BLOCK_TIMESTAMP, trader as user

from arbitrum.vertex.ez_perp_trades

union all

select BLOCK_TIMESTAMP, trader

from arbitrum.vertex.ez_spot_trades

group by 1,2

),

users as (

select user, min(BLOCK_TIMESTAMP) as min_date

from users_activities

group by 1

),

dates as (

select distinct date_trunc(day,BLOCK_TIMESTAMP) as date

from users_activities),

DAUs as (

select date,

count(distinct b.user) as "DAUs"

from dates a

join users_activities b

on date_trunc(day,b.BLOCK_TIMESTAMP)= a.date

group by 1),

avg_DAUs as (

select a.date,

avg("DAUs") as "Average DAUs"

from dates a