SELECT DATE_TRUNC('WEEK', BLOCK_TIMESTAMP::DATE) AS "Week",CONTRACT_ADDRESS ,COUNT((CONTRACT_ADDRESS)) "Number of swaps"

FROM polygon.core.fact_event_logs

WHERE BLOCK_TIMESTAMP::DATE < '2022-10-15' AND TX_STATUS = 'SUCCESS' ---BLOCK_TIMESTAMP::DATE BETWEEN '2022-05-12' AND '2022-10-12'

AND ORIGIN_TO_ADDRESS IN ('0xe592427a0aece92de3edee1f18e0157c05861564','0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45') AND EVENT_NAME = 'Swap'

GROUP BY "Week", CONTRACT_ADDRESS ),

RANK_POOLS AS (

SELECT "Week", CONTRACT_ADDRESS, "Number of swaps",

RANK() OVER(PARTITION BY "Week" ORDER BY "Number of swaps" DESC) Rank

FROM Uniswap_Polygon_Pools

SELECT *,

CASE

WHEN CONTRACT_ADDRESS = '0x45dda9cb7c25131df268515131f647d726f50608' THEN 'USDC-WETH - 0x45dda9cb7c25131df268515131f647d726f50608'

WHEN CONTRACT_ADDRESS = '0x4c0bc5d34369d5f89e7f3aa551150dc7d281b4c7' THEN 'USDT-META - 0x4c0bc5d34369d5f89e7f3aa551150dc7d281b4c7'

WHEN CONTRACT_ADDRESS = '0x86f1d8390222a3691c28938ec7404a1661e618e0' THEN 'WETH-WMATIC - 0x86f1d8390222a3691c28938ec7404a1661e618e0'

WHEN CONTRACT_ADDRESS = '0xa374094527e1673a86de625aa59517c5de346d32' THEN 'WMATIC-USDC - 0xa374094527e1673a86de625aa59517c5de346d32'

END AS POOL_NAME

FROM RANK_POOLS

WHERE Rank = 1