Number of Pools

JediSwapNumber of Pools

Updated 2024-02-15

SELECT

COUNT(DISTINCT(ev.PARAMETERS[2]:value)) AS pairAddress

FROM external.tokenflow_starknet.decoded_events ev

WHERE CHAIN_ID = 'mainnet'

AND NAME = 'PairCreated'

AND CONTRACT = '0x00dad44c139a476c7a17fc8141e6db680e9abc9f56fe249a105094c44382c2fd' --JediSwap Factory

--AND (ev.PARAMETERS[0]:value IN (SELECT starknetAddress FROM tokenList) OR ev.PARAMETERS[1]:value IN (SELECT starknetAddress FROM tokenList))

Last run: about 1 year ago

	PAIRADDRESS
1	537

23s

flipside