SELECT 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 CONTRACT_ADDRESS ),

RANK_POOLS AS (

SELECT CONTRACT_ADDRESS, "Number of swaps"

FROM Uniswap_Polygon_Pools ORDER BY "Number of swaps" DESC LIMIT 5

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'

WHEN CONTRACT_ADDRESS = '0x9b08288c3be4f62bbf8d1c20ac9c5e6f9467d8b7' THEN 'WMATIC-USDT - 0x9b08288c3be4f62bbf8d1c20ac9c5e6f9467d8b7'

WHEN CONTRACT_ADDRESS = '0x50eaedb835021e4a108b7290636d62e9765cc6d7' THEN 'WETH-WBTC - 0x50eaedb835021e4a108b7290636d62e9765cc6d7'

END AS POOL_NAME

FROM RANK_POOLS