Ronin Validator by region 2 copy

0xHaM-dRonin Validator by region 2 copy

Updated 2025-03-18

-- forked from Ronin Validator by region 2 @ https://flipsidecrypto.xyz/studio/queries/ca817cec-c202-4f64-8b06-28f043f3a1cb

-- forked from Stablejack active users by region 2 @ https://flipsidecrypto.xyz/studio/queries/db1be7f5-c081-49c9-be15-1d56fc759923

-- forked from adriaparcerisas / flow active users by region 2 @ https://flipsidecrypto.xyz/adriaparcerisas/q/ogqRvJwzhT_H/flow-active-users-by-region-2

WITH

-- Calculate the debut (first activity) of each user using the improved method

news AS (

select '0x6aaabf51c5f6d2d93212cf7dad73d67afa0148d0' as contract ,'Luganodes' as validator_name

union all

select '0xfc3e31519b551bd594235dd0ef014375a87c4e21' as contract ,'Nansen' as validator_name

union all

select '0x76310f62e47fc7f7ff3558a3afc88e2cf8fbb644' as contract ,'Zentry' as validator_name

union all

select '0x4e7ea047ec7e95c7a02cb117128b94ccdd8356bf' as contract ,'Ronin Catalyst' as validator_name

union all

select '0x05ad3ded6fcc510324af8e2631717af6da5c8b5b' as contract ,'MysticNode' as validator_name

union all

select '0xae53daac1bf3c4633d4921b8c3f8d579e757f5bc' as contract ,'EternityHub.tech' as validator_name

union all

select '0x32d619dc6188409cebbc52f921ab306f07db085b' as contract ,'Google' as validator_name

union all

select '0xf41af21f0a800dc4d86efb14ad46cfb9884fdf38' as contract ,'Sky Mavis GV' as validator_name

union all

select '0xedcafc4ad8097c2012980a2a7087d74b86bddaf9' as contract ,'BYAC' as validator_name

union all

select '0xca54a1700e0403dcb531f8db4ae3847758b90b01' as contract ,'artic x' as validator_name

union all

select '0x749f36cc1daeec1bced9f1f182c92851727d1e73' as contract ,'RonerDAO' as validator_name

union all

select '0xbeef86b900b6b791d1cc7746ce030aa8d4e4cafe' as contract ,'BlockAhead.dev' as validator_name

union all

select '0x6e46924371d0e910769aabe0d867590deac20684' as contract ,'StableNode' as validator_name

union all

select '0x61089875ff9e506ae78c7fe9f7c388416520e386' as contract ,'0xak.eth' as validator_name

union all

Last run: 29 days ago

	USER	REGION	N_ACTIVE_DATE
1	Owl.eth	US	62
2	Google	US	59
3	Luganodes	US	59
4	Yield Guild Games	US	58
5	Ronin Catalyst	US	57
6	BYAC	US	57
7	Sky Mavis GV	US	57
8	Coco__Bear	US	56
9	CyberKongz	US	56
10	DappRadar DAO	US	55
11	Community Gaming	US	55
12	Moku	US	54
13	StableNode	US	53
14	BlockAhead.dev	US	53
15	MysticNode	US	53
16	Animoca Brands	US	52
17	0xak.eth	US	52
18	Nansen	US	51
19	EternityHub.tech	US	48
20	artic x	US	48

...

110

3KB

14s