SELECT date_trunc('week', block_timestamp) as week,

COUNT(DISTINCT tx_id) as num_txs,

row_number() over (order by week DESC) as row_number

FROM uniswapv3.swaps

GROUP BY 1

SELECT *

FROM weekly

WHERE row_number > 1