SELECT

origin_from_address as trader,

SUM(CASE WHEN amount_in_usd IS NOT NULL THEN amount_in_usd ELSE amount_out_usd END) as total_volume_usd,

COUNT(DISTINCT tx_hash) as total_trades,

total_volume_usd / NULLIF(total_trades, 0) as avg_trade_size_usd,

MIN(block_timestamp) as first_trade,

MAX(block_timestamp) as last_trade

FROM avalanche.defi.ez_dex_swaps

WHERE (token_in = lower('0x7698A5311DA174A95253Ce86C21ca7272b9B05f8')

OR token_out = lower('0x7698A5311DA174A95253Ce86C21ca7272b9B05f8'))

AND block_timestamp >= DATEADD('day', -30, CURRENT_DATE)

GROUP BY 1

SELECT

trader,

ROUND(total_volume_usd, 2) as total_volume_usd,

total_trades,

ROUND(avg_trade_size_usd, 2) as avg_trade_size_usd,

first_trade,

last_trade,

DATEDIFF('day', first_trade, last_trade) + 1 as days_active

FROM wink_swaps

WHERE total_volume_usd > 0

ORDER BY total_volume_usd DESC

LIMIT 20;