with tb1 as ( select block_timestamp,

tx_id,

blockchain,

pool_name,

ifnull(from_address,native_to_address) as trader,

from_asset,

to_asset,

case when from_amount_usd >= to_amount_usd then to_amount_usd else from_amount_usd end as amount1,

case when from_amount_usd is null then to_amount_usd else from_amount_usd end as amount2,

case when amount1 is null then amount2 else amount1 end as amount

from thorchain.defi.fact_swaps

where affiliate_address in ('td','ti','tr','te')

,

tb2 as ( select min(block_timestamp) as days,

trader

from tb1

group by 2 )

select trunc(days,'day') as day,

count(DISTINCT trader) as "New Traders",

sum("New Traders") over (order by day asc) as "Cumulative New Traders"

from tb2

where day::date >= '2024-01-01'

group by 1