Count(*) AS "Transactions"

, Count(DISTINCT origin_from_address) AS "Swappers"

, COUNT(DISTINCT pool_name) AS "Pairs"

, SUM(CASE WHEN amount_in_usd IS NULL THEN amount_out_usd ELSE amount_in_usd END) AS "Volume"

, COUNT(DISTINCT symbol) AS "Tokens"

, MAX(CASE WHEN amount_in_usd IS NULL THEN amount_out_usd ELSE amount_in_usd END) AS "Largest Trade Amount"

, AVG(CASE WHEN amount_in_usd IS NULL THEN amount_out_usd ELSE amount_in_usd END) AS "Average Trade Amount"

FROM (

SELECT

platform

, symbol_in AS symbol

, origin_from_address

, pool_name

, amount_in_usd

, amount_out_usd

FROM avalanche.defi.ez_dex_swaps

WHERE platform = 'woofi'

AND block_timestamp >= '2025-01-01'

UNION ALL

SELECT

platform

, symbol_out AS symbol

, origin_from_address

, pool_name

, amount_in_usd

, amount_out_usd

FROM avalanche.defi.ez_dex_swaps

WHERE platform = 'woofi'

AND block_timestamp >= '2025-01-01'