total rewards claimed

permarytotal rewards claimed

Updated 4 days ago

WITH current_ron_price AS (

SELECT

hour::date AS date_price,

AVG(price) AS ron_usd_price

FROM ronin.price.ez_prices_hourly

WHERE symbol = 'RON'

GROUP BY 1

ORDER BY date_price DESC

LIMIT 1

validator_registry as (

-- Create a registry of validators with their names

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

union all

select '0xfc3e31519b551bd594235dd0ef014375a87c4e21', 'Nansen'

union all

select '0x76310f62e47fc7f7ff3558a3afc88e2cf8fbb644', 'Zentry'

union all

select '0x4e7ea047ec7e95c7a02cb117128b94ccdd8356bf', 'Ronin Catalyst'

union all

select '0x05ad3ded6fcc510324af8e2631717af6da5c8b5b', 'MysticNode'

union all

select '0xae53daac1bf3c4633d4921b8c3f8d579e757f5bc', 'EternityHub.tech'

union all

select '0x32d619dc6188409cebbc52f921ab306f07db085b', 'Google'

union all

select '0xf41af21f0a800dc4d86efb14ad46cfb9884fdf38', 'Sky Mavis GV'

union all

select '0xedcafc4ad8097c2012980a2a7087d74b86bddaf9', 'BYAC'

union all

select '0xca54a1700e0403dcb531f8db4ae3847758b90b01', 'artic x'

union all

select '0x749f36cc1daeec1bced9f1f182c92851727d1e73', 'RonerDAO'

union all

select '0xbeef86b900b6b791d1cc7746ce030aa8d4e4cafe', 'BlockAhead.dev'

Last run: 4 days ago

	CLAIMED_RON	CLAIMED_USD
1	2295251.57328982	1661357.02715914

37B

flipside