SELECT

tx_hash,

block_timestamp,

origin_from_address AS trader,

COALESCE(amount_in_usd, amount_out_usd) AS trade_value_usd

FROM base.defi.ez_dex_swaps

WHERE '0xb1a03eda10342529bbf8eb700a06c60441fef25d' IN (token_in, token_out)

),

monthly_activity AS (

SELECT

DATE_TRUNC('month', block_timestamp) AS month,

COUNT(DISTINCT tx_hash) AS total_trades,

COUNT(DISTINCT trader) AS unique_traders,

SUM(trade_value_usd) AS total_trade_volume

FROM swap_transactions

GROUP BY 1

),

first_time_traders AS (

SELECT

DATE_TRUNC('month', first_trade_date) AS month,

COUNT(DISTINCT trader) AS new_traders

FROM (

SELECT

trader,

MIN(block_timestamp)::DATE AS first_trade_date

FROM swap_transactions

GROUP BY 1

)

GROUP BY 1

SELECT

monthly_activity.*,