Ronin Game-Fi: Game Daily Metrics

i_danRonin Game-Fi: Game Daily Metrics

Updated 5 days ago

-- forked from Ronin Game-Fi: Daily Metrics @ https://flipsidecrypto.xyz/studio/queries/9d119032-bf17-4622-b0ed-30e663480f4c

-- Daily GameFi Metrics on Ronin

WITH base_data AS (

SELECT

block_timestamp::DATE AS day

, 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'

Last run: 5 days ago

	Day	Game Contract	Game Name	Daily Transactions	Unique Users	Transaction Success Rate	New Users	Returning Users	Daily Retention Rate	Churned Users	AVG Transactions Per User	Total Gas Fees	AVG Gas Fee Per User
1	2025-03-27 00:00:00.000	0x02790f32ad7e7eaaecfb0ad21950829932f1a2ee	Pixel	198518	198518	100	86	198432	94.72731	10947	1	273.149339824	0.001375942433
2	2025-03-27 00:00:00.000	0xa62bbfe37d5fd209a83e17c385b0d1034ac41ade	The Machines Arena	80495	80488	100	2	80486	5.612583	52688	1.000087	56.203019074	0.0006982782411
3	2025-03-27 00:00:00.000	0x9d3936dbd9a794ee31ef9f13814233d435bd806c	Axie Infinity	64909	55582	99.605602	437	55145	44.916568	60410	1.167806	90.864252678	0.001634778394
4	2025-03-27 00:00:00.000	0x32950db2a7164ae833121501c797d79e7b79d74c	Axie Infinity	5377	1072	96.485029	413	659	3.344867	4190	5.015858	13.065737214	0.0121881877
5	2025-03-27 00:00:00.000	0x7eae20d11ef8c779433eb24503def900b9d28ad7	Pixel	2623	1397	100	284	1113	3.391747	5127	1.877595	2.637363348	0.001887876412
6	2025-03-27 00:00:00.000	0x58ad3594758b0f74478dbc07168812ddf460a07f	Apeiron	2273	2240	98.548174	2	2238	28.869565	409	1.014732	1.750486351	0.0007814671209
7	2025-03-27 00:00:00.000	0x3e0674b1ddc84b0cfd9d773bb2ce23fe8f445de3	Axie Infinity	2177	2070	99.954065	6	2064	34.874888	2915	1.051691	19.94080055	0.009633236981
8	2025-03-27 00:00:00.000	0x05b0bb3c1c320b280501b86706c3551995bc8571	Axie Infinity	1211	906	100	15	891	7.368726	3193	1.336645	3.876677471	0.004278893456
9	2025-03-27 00:00:00.000	0x0e268edc8750d50c440d715c935eba2e7c6ae775	Pixel HeroZ	1068	448	100	8	440	8.648369	1764	2.383929	1.311059004	0.002926470991
10	2025-03-27 00:00:00.000	0x19f70ecd63f40f11716c3ce2b50a6d07491c12fe	Lumiterra	353	349	98.866856	0	349	32.189707	672	1.011461	1.078169756	0.003089311621
11	2025-03-27 00:00:00.000	0xd97c9707528141b3b505eec03ee90aebf055a901	Kaidro	283	189	99.646643	0	189	29.651163	363	1.497354	0.6488641192	0.003433143488
12	2025-03-27 00:00:00.000	0x0a9e7795ab1d691986b8f944f99560a7ed9e0708	Kongz	270	14	100	0	14	7.936508	58	19.285714	2.243653846	0.160260989
13	2025-03-27 00:00:00.000	0x1136dac182ab639632a38540c6f33c01e02e51a6	Wild Forest	213	203	95.305164	2	201	15.047393	717	1.049261	0.2322637869	0.001144156586
14	2025-03-27 00:00:00.000	0x9c76fc5bd894e7f51c422f072675c876d5998a9e	Fishing Frenzy	16	14	100	10	4	0	146	1.142857	0.01977125958	0.001412232827
15	2025-03-27 00:00:00.000	0x59cfa86b6820901ebeddd60f131c473c15eae130	Ragnarok: Monster World	8	7	100	4	3	0	72	1.142857	0.008750464375	0.001250066339
16	2025-03-27 00:00:00.000	0x3c147f3eead0d6875e0b4fd54b071f268ab0fcff	Sabong Saga	7	6	100	2	4	3.571429	27	1.166667	0.05847414929	0.009745691548
17	2025-03-27 00:00:00.000	0x77ce5148b7ad284e431175ad7258b54a64816da6	Fishing Frenzy	6	6	100	4	2	0	117	1	0.007797211665	0.001299535277
18	2025-03-27 00:00:00.000	0x322b3d98ddbd589dc2e8dd83659bb069828231e0	Sabong Saga	2	2	100	1	1	0	5	1	0.003812837	0.0019064185
19	2025-03-27 00:00:00.000	0xac78515ef7d0bb935bc86d4f8ce314038946b52f	Sabong Saga	1	1	100	1	0	0	10	1	0.001157636497	0.001157636497
20	2025-03-26 00:00:00.000	0x02790f32ad7e7eaaecfb0ad21950829932f1a2ee	Pixel	207617	207617	100	427	207190	94.637809	11476	1	285.783318981	0.001376492864

...

2690

431KB

124s