SELECT
token0_symbol,
token1_symbol,
CONCAT(token0_symbol,'-',token1_symbol) as concat_pair,
SUM(ABS(amount1_usd)) as swapped_amount_usd,
date_trunc('week',block_timestamp) as week,
COUNT(DISTINCT tx_id) as transaction_count
FROM uniswapv3.swaps
WHERE
amount1_usd<>0
AND block_timestamp >= getdate() - interval '60 days'
GROUP BY 1,2,5
ORDER BY 4 DESC
LIMIT 100