SELECT

s.origin_from_address AS SwapperAddress,

SUM(COALESCE(t.tx_fee, 0)) AS TotalFeeMATIC,

COUNT(DISTINCT s.tx_hash) AS TotalTrades

FROM

polygon.defi.ez_dex_swaps s

JOIN polygon.core.fact_transactions t ON s.tx_hash = t.tx_hash

WHERE

s.platform = 'quickswap-v3'

AND s.block_timestamp >= DATEADD(MONTH, -3, CURRENT_DATE)

GROUP BY

s.origin_from_address

),

fee_metrics AS (

SELECT

SUM(TotalFeeMATIC) AS TotalFeeMATIC,

AVG(TotalFeeMATIC) AS AvgFeePerTrader

FROM

fee_data

TotalFeeMATIC,

AvgFeePerTrader

fee_metrics;