(SELECT
POOL_NAME,
'Optimsm' as blockchain,
COUNT(DISTINCT TX_HASH) as tx_count,
COUNT(DISTINCT ORIGIN_FROM_ADDRESS) as user_count,
SUM(AMOUNT_IN_USD) as volume
FROM optimism.sushi.ez_swaps
WHERE BLOCK_TIMESTAMP >= '2022-06-01'
GROUP BY 1
HAVING volume > 0
ORDER BY volume DESC
LIMIT 10)