traders 3.2 | aureasarsanedes

Updated 4 days ago

WITH platform_users AS (

SELECT

PLATFORM,

SWAPPER

FROM

aptos.defi.ez_dex_swaps

WHERE

BLOCK_TIMESTAMP >= DATEADD(day, -{{days}}, CURRENT_DATE)

GROUP BY

PLATFORM, SWAPPER

)

SELECT

a.PLATFORM AS platform_1,

b.PLATFORM AS platform_2,

c.PLATFORM AS platform_3,

concat(a.PLATFORM,'-',b.PLATFORM,'-',c.PLATFORM) as platforms,

COUNT(DISTINCT a.SWAPPER) AS shared_users

FROM

platform_users a

JOIN

platform_users b

a.SWAPPER = b.SWAPPER

AND a.PLATFORM < b.PLATFORM

JOIN

platform_users c

a.SWAPPER = c.SWAPPER

AND b.PLATFORM < c.PLATFORM

GROUP BY

platform_1, platform_2, platform_3

having shared_users>=10

ORDER BY

shared_users DESC

Last run: 4 days ago

	PLATFORM_1	PLATFORM_2	PLATFORM_3	PLATFORMS	SHARED_USERS
1	cellana	liquidswap	pancake	cellana-liquidswap-pancake	1436
2	cellana	liquidswap	thala	cellana-liquidswap-thala	1103
3	liquidswap	pancake	thala	liquidswap-pancake-thala	839
4	cellana	pancake	thala	cellana-pancake-thala	826
5	animeswap	liquidswap	pancake	animeswap-liquidswap-pancake	681
6	liquidswap	pancake	sushi	liquidswap-pancake-sushi	646
7	animeswap	cellana	liquidswap	animeswap-cellana-liquidswap	637
8	cellana	liquidswap	sushi	cellana-liquidswap-sushi	621
9	cellana	pancake	sushi	cellana-pancake-sushi	617
10	animeswap	cellana	pancake	animeswap-cellana-pancake	570
11	animeswap	liquidswap	thala	animeswap-liquidswap-thala	483
12	cellana	sushi	thala	cellana-sushi-thala	483
13	animeswap	cellana	thala	animeswap-cellana-thala	479
14	liquidswap	sushi	thala	liquidswap-sushi-thala	477
15	pancake	sushi	thala	pancake-sushi-thala	446
16	animeswap	pancake	thala	animeswap-pancake-thala	435
17	animeswap	liquidswap	sushi	animeswap-liquidswap-sushi	368
18	animeswap	pancake	sushi	animeswap-pancake-sushi	362
19	animeswap	cellana	sushi	animeswap-cellana-sushi	361
20	animeswap	sushi	thala	animeswap-sushi-thala	314

3KB

flipside