INK GMs Leaderboard

mamad-5XN3k3INK GMs Leaderboard

Updated 2025-03-10

WITH gm_data AS (

SELECT

DATE_TRUNC('day', block_timestamp) AS day,

DECODED_LOG:"recipient" AS recipient,

DECODED_LOG:"user" AS sender

FROM ink.core.ez_decoded_event_logs

WHERE ORIGIN_TO_ADDRESS = '0x9f500d075118272b3564ac6ef2c70a9067fd2d3f'

AND TX_SUCCEEDED = 'TRUE'

AND ORIGIN_FUNCTION_SIGNATURE IN ('0xe884624b', '0xc0129d43')

-- Aggregate total sent, received, and unique interactions

user_stats AS (

SELECT

user,

COUNT(CASE WHEN user = sender THEN 1 END) AS total_sent,

COUNT(CASE WHEN user = recipient THEN 1 END) AS total_received,

GREATEST(COUNT(DISTINCT CASE WHEN user = sender THEN recipient END)-1 , 0) AS unique_gms_sent,

COUNT(DISTINCT CASE WHEN user = recipient THEN sender END) AS unique_gms_received,

COUNT(DISTINCT day) AS active_days

FROM (

SELECT sender AS user, recipient,sender, day FROM gm_data

UNION ALL

SELECT recipient AS user, recipient,sender, day FROM gm_data

) AS combined

GROUP BY user

-- Calculate daily streaks

user_activity AS (

SELECT sender AS user, day FROM gm_data

UNION

SELECT recipient AS user, day FROM gm_data

streak_computation AS (

Last run: about 2 months ago

	USER	DOMAIN	UNIQUE_GMS_SENT	UNIQUE_GMS_RECEIVED	TOTAL_SENT	TOTAL_RECEIVED	ACTIVE_DAYS	STREAK	SOCIAL_SCORE	STREAK_BONUS	SCORE
1	0x1f0ea6e0b3590e1ab6c12ea0a24d3d0d9bf7707d	widiskel.ink	0	463	46	11737	47	46	10.76	5.5	908.029
2	0x3e67e9c147fa18df710199d329f46bdaab128087	N/A	0	10033	16	78692	24	16	50.08	2.5	866.508
3	0xa6d2884a9714e584211d8e5a928ed6362eda528b	shalom.ink	1	24	42	427	44	42	2.95	5.1	334.629
4	0xf85767d6dc933e0110702146aa592d3f980a1ca4	0xalex.ink	1	17	43	266	44	43	2.56	5.2	321.73
5	0x30dab757a7afce23a307a038fb2b570818c195f9	shivkrupa.ink	9	9	40	380	43	40	3	4.9	306.219
6	0x6feccfaac8772b7199df816123b18053028df573	mikhaylo14.ink	0	101	43	115	44	43	5.02	5.2	305.493
7	0x10168db5cc6de163e18af68f387abc89c0591cf0	kkk97.ink	14	49	42	153	42	42	5.37	5.1	304.675
8	0x3c3402590b3882bae16dc932ac19a7f671c23170	shakthi.ink	5	16	43	142	46	43	3.12	5.2	301.779
9	0x0b09dabc3d857679f95ec8751b2bb07229733f98	anant66.ink	3	6	44	116	44	44	2.09	5.3	301.364
10	0x41e779087782839c165ea580f3bf17b0d49895ea	c4nt0ny.ink	6	21	45	38	46	45	3.52	5.4	295.274
11	0xeab804590011d0650fcb6c4da1870c6e9ca062d1	croth.ink	11	8	45	40	45	45	3.07	5.4	293.744
12	0x2a35ea45f23d8bea3f8737e161fcd730a4c5910b	velyar.ink	2	3	45	50	45	45	1.57	5.4	289.679
13	0xfd269ba2a8601799862fa607182ebeea8c9da38a	shivim1.ink	3	5	43	111	44	43	1.98	5.2	288.703
14	0xd1701b644927b042637f270f699f64d604f032df	ink97658.ink	14	50	43	50	43	43	5.41	5.2	288.483
15	0x4587638428fff1531c46b036339e94fa3ecd7924	maldsadgreg.ink	14	49	43	50	43	43	5.37	5.2	288.298
16	0xa56330d2365c0c00c793d4a576ac93f8aa9d68b3	jumufpotre.ink	14	49	43	50	43	43	5.37	5.2	288.298
17	0xbdca74382f3aff68f4d999b385e6a8583cb0ac3b	sosogg.ink	14	49	43	49	43	43	5.37	5.2	287.928
18	0xe7ba336064da59adfac00e44e9e8f4a165c1e4c1	rastara.ink	14	49	43	49	43	43	5.37	5.2	287.928
19	0x669cdecfeeadd54249329007add3af0ccc0dc235	vesrots.ink	14	49	43	49	43	43	5.37	5.2	287.928
20	0x0f93b411e171cad9e3497b8e2577bb374f92ec16	skyhhr.ink	14	49	43	49	43	43	5.37	5.2	287.928

...

5000

419KB

25s

flipside

flipside