tx_id,

from_address,

blockchain,

pool_name,

from_asset,

to_asset,

case when from_amount_usd is null then to_amount_usd else from_amount_usd end as amount_usd

from thorchain.defi.fact_swaps)

,

new_users as ( select min(block_timestamp::date) as date,

from swap

group by 2)

,

new as (select trunc(date,'week') as weekly ,

count(DISTINCT from_address) as "New Users",

sum("New Users") over (order by weekly asc) as "Cumulative New Users"

from new_users

group by 1)

select sum("New Users") as total,

avg("New Users") as avg

from new

where weekly >= '2024-01-01'