Ronin Game-Fi: Games Metrics

i_danRonin Game-Fi: Games Metrics

Updated 5 days ago

-- Daily GameFi Metrics on Ronin

WITH base_data AS (

SELECT

to_address AS game_contract

, CASE WHEN to_address = '0x02790f32ad7e7eaaecfb0ad21950829932f1a2ee' THEN 'Pixel'

WHEN to_address = '0x7eae20d11ef8c779433eb24503def900b9d28ad7' THEN 'Pixel'

WHEN to_address = '0x0e268edc8750d50c440d715c935eba2e7c6ae775' THEN 'Pixel HeroZ'

WHEN to_address = '0x1136dac182ab639632a38540c6f33c01e02e51a6' THEN 'Wild Forest'

WHEN to_address = '0x0a9e7795ab1d691986b8f944f99560a7ed9e0708' THEN 'Kongz'

WHEN to_address = '0x9eb8857d07a833b47cc95a1f5c8331d627622511' THEN 'Kongz'

WHEN to_address = '0x58ad3594758b0f74478dbc07168812ddf460a07f' THEN 'Apeiron'

WHEN to_address = '0xd97c9707528141b3b505eec03ee90aebf055a901' THEN 'Kaidro'

WHEN to_address = '0x19f70ecd63f40f11716c3ce2b50a6d07491c12fe' THEN 'Lumiterra'

WHEN to_address = '0x9d3936dbd9a794ee31ef9f13814233d435bd806c' THEN 'Axie Infinity'

WHEN to_address = '0x32950db2a7164ae833121501c797d79e7b79d74c' THEN 'Axie Infinity'

WHEN to_address = '0x05b0bb3c1c320b280501b86706c3551995bc8571' THEN 'Axie Infinity'

WHEN to_address = '0x3e0674b1ddc84b0cfd9d773bb2ce23fe8f445de3' THEN 'Axie Infinity'

WHEN to_address = '0xa62bbfe37d5fd209a83e17c385b0d1034ac41ade' THEN 'The Machines Arena'

WHEN to_address = '0x59cfa86b6820901ebeddd60f131c473c15eae130' THEN 'Ragnarok: Monster World'

WHEN to_address = '0xda1c8c1d7df35ecf91186e3cb410ecdb4fb29a3a' THEN 'Ragnarok: Monster World'

WHEN to_address = '0x3825ff6b6ad0f460660547e5890425ee821bd02c' THEN 'Fableborne'

WHEN to_address = '0xd887014121ddbad4494093689997125dde30612a' THEN 'Fableborne'

WHEN to_address = '0xc69f7434d4b336e68acbbde4101b7990e7d6b3b3' THEN 'Fishing Frenzy'

WHEN to_address = '0xd42364171036dd7dabe2ba5efc368c896d03ce89' THEN 'Fishing Frenzy'

WHEN to_address = '0x4079da822e8972982b8569e38cdf719a21069934' THEN 'Fishing Frenzy'

WHEN to_address = '0x87a699a08d57142d46c909b7f2df49d44d87211f' THEN 'Fishing Frenzy'

WHEN to_address = '0x77ce5148b7ad284e431175ad7258b54a64816da6' THEN 'Fishing Frenzy'

WHEN to_address = '0xca3f4ee13c4def532b16b90ec5246138ef6d92bf' THEN 'Fishing Frenzy'

WHEN to_address = '0x9c76fc5bd894e7f51c422f072675c876d5998a9e' THEN 'Fishing Frenzy'

WHEN to_address = '0xdda950223ead838c21838109a2f550c964a23c5b' THEN 'Fishing Frenzy'

WHEN to_address = '0x8ea2f68444Eda7d6D673F1B399aEe6D069982db5' THEN 'Cambria'

WHEN to_address = '0x4561d810467116972e434f89351bf5eb9b8c2ad6' THEN 'Cambria'

WHEN to_address = '0x279f238ec237eb7e12b64386e4ec99c4d50c00eb' THEN 'Cambria'

WHEN to_address = '0x322b3d98ddbd589dc2e8dd83659bb069828231e0' THEN 'Sabong Saga'

WHEN to_address = '0xac78515ef7d0bb935bc86d4f8ce314038946b52f' THEN 'Sabong Saga'

WHEN to_address = '0x3c147f3eead0d6875e0b4fd54b071f268ab0fcff' THEN 'Sabong Saga' END

Last run: 5 days ago

	NAME	TOTAL_TRANSACTIONS	UNIQUE_USERS	TRANSACTION_SUCCESS_RATE	TOTAL_GAS_FEES_RON	AVG_GAS_FEES_PER_USER	AVG_TRANSACTIONS_PER_USER	TRANSACTION_TO_USER_PERCENTAGE
1	Pixel	58582762	3820916	99.98488	77543.255960782	0.02029441526	15.332125	6.522253
2	Axie Infinity	25576422	385690	99.415841	47642.666735436	0.1235258024	66.313418	1.50799
3	The Machines Arena	17903744	373712	99.835264	22110.351514651	0.05916414649	47.907865	2.08734
4	Wild Forest	15451582	755425	99.975549	15739.955110086	0.02083589385	20.454158	4.888982
5	Apeiron	13046308	234929	99.97295	9552.361876131	0.04066063311	55.532982	1.800732
6	Kaidro	9362444	6100	99.912694	14123.666169235	2.31535511	1534.826885	0.065154
7	Fableborne	7062393	110278	96.799428	4853.60580836	0.04401245768	64.041722	1.561482
8	Lumiterra	5280539	396806	99.737224	16734.179013822	0.04217219249	13.307609	7.514498
9	Pixel HeroZ	1140400	48430	99.819537	1605.175318122	0.03314423535	23.547388	4.246756
10	Kongz	523826	96544	99.884885	3175.083890028	0.03288742843	5.425775	18.430548
11	Ragnarok: Monster World	335179	74605	97.280558	503.556359487	0.00674963286	4.492715	22.258256
12	Fishing Frenzy	113754	10325	99.827698	487.946147261	0.04725870676	11.017337	9.076604
13	Cambria	45453	1386	99.878996	74.004026185	0.05339395829	32.794372	3.049304
14	Sabong Saga	4247	1129	95.479162	24.426068006	0.02163513552	3.761736	26.583471

1KB

31s

flipside