SELECT

block_timestamp,

origin_from_address,

tx_hash,

pool_name,

CASE

WHEN amount_in_usd IS NOT NULL AND amount_out_usd IS NOT NULL THEN (amount_in_usd + amount_out_usd) / 2

ELSE COALESCE(amount_in_usd, amount_out_usd)

END AS amount

FROM

avalanche.defi.ez_dex_swaps

WHERE

platform = 'pangolin' AND

(amount_in_usd IS NOT NULL OR amount_out_usd IS NOT NULL)

),

first_tx_of_each_users AS (

SELECT

origin_from_address,

MIN(block_timestamp) AS min_date

FROM

base

GROUP BY

origin_from_address

),

new_users AS (

SELECT

date_trunc('day', min_date) AS date,

COUNT(DISTINCT origin_from_address) AS new_user_count

FROM

first_tx_of_each_users

GROUP BY

date

),