Day | Daily Transactions | Cummulative Daily Transactions | Unique Users | Transaction Success Rate | New Users | Returning Users | New Users Over Time | Succeeded Transactions | Failed Transactions | Daily Retention Rate | Churned Users | Churned Users (-) | Churned Users Over Time | Transaction Per User | Total Gas Fees | AVG Gas Fee Per User | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-03-27 00:00:00.000 | 359810 | 154429053 | 340452 | 99.862705 | 1263 | 339212 | 6523784 | 359316 | 494 | 64.712295 | 136610 | -136610 | 22334929 | 1.05686 | 467.10145058 | 0.001372003838 |
2 | 2025-03-26 00:00:00.000 | 446281 | 154069243 | 387132 | 99.715426 | 5635 | 381721 | 6522521 | 445011 | 1270 | 76.14843 | 98704 | -98704 | 22198319 | 1.152788 | 661.362379235 | 0.001708364019 |
3 | 2025-03-25 00:00:00.000 | 491929 | 153622962 | 413826 | 99.843473 | 6928 | 407809 | 6516886 | 491159 | 770 | 83.020956 | 68595 | -68595 | 22099615 | 1.188734 | 808.622120092 | 0.001954014779 |
4 | 2025-03-24 00:00:00.000 | 475483 | 153131033 | 403998 | 99.797259 | 7101 | 397441 | 6509958 | 474519 | 964 | 89.705169 | 35026 | -35026 | 22031020 | 1.176944 | 857.796800519 | 0.002123269918 |
5 | 2025-03-23 00:00:00.000 | 401710 | 152655550 | 340229 | 99.753554 | 7743 | 333035 | 6502857 | 400720 | 990 | 93.132582 | 22954 | -22954 | 21995994 | 1.180705 | 664.16256494 | 0.001952104509 |
6 | 2025-03-22 00:00:00.000 | 398797 | 152253840 | 334245 | 99.689065 | 7570 | 327228 | 6495114 | 397557 | 1240 | 90.938178 | 30503 | -30503 | 21973040 | 1.193128 | 782.087193243 | 0.002339862057 |
7 | 2025-03-21 00:00:00.000 | 427070 | 151855043 | 336610 | 99.727445 | 12714 | 324227 | 6487544 | 425906 | 1164 | 82.521785 | 64948 | -64948 | 21942537 | 1.268738 | 854.25244952 | 0.00253781067 |
8 | 2025-03-20 00:00:00.000 | 425344 | 151427973 | 371594 | 99.778767 | 4582 | 367187 | 6474830 | 424403 | 941 | 92.146179 | 26767 | -26767 | 21877589 | 1.144647 | 655.73182534 | 0.001764645891 |
9 | 2025-03-19 00:00:00.000 | 393013 | 151002629 | 340815 | 99.701282 | 6846 | 334197 | 6470248 | 391839 | 1174 | 92.22489 | 26458 | -26458 | 21850822 | 1.153156 | 818.929924419 | 0.002402857634 |
10 | 2025-03-18 00:00:00.000 | 392501 | 150609616 | 340291 | 99.750319 | 8636 | 331850 | 6463402 | 391521 | 980 | 68.34714 | 142787 | -142787 | 21824364 | 1.153428 | 695.469756617 | 0.002043750075 |
11 | 2025-03-17 00:00:00.000 | 502279 | 150217115 | 451103 | 99.777614 | 4107 | 447231 | 6454766 | 501162 | 1117 | 76.296896 | 113508 | -113508 | 21681577 | 1.113446 | 672.538664604 | 0.001490876063 |
12 | 2025-03-16 00:00:00.000 | 544664 | 149714836 | 478874 | 99.726804 | 9915 | 469147 | 6450659 | 543176 | 1488 | 77.078396 | 110161 | -110161 | 21568069 | 1.137385 | 716.174985741 | 0.001495539507 |
13 | 2025-03-15 00:00:00.000 | 533467 | 149170172 | 480599 | 99.850787 | 5388 | 475372 | 6440744 | 532671 | 796 | 76.485243 | 113173 | -113173 | 21457908 | 1.110004 | 687.831081912 | 0.001431195408 |
14 | 2025-03-14 00:00:00.000 | 535927 | 148636705 | 481285 | 99.705744 | 4035 | 477427 | 6435356 | 534350 | 1577 | 79.930133 | 99736 | -99736 | 21344735 | 1.113534 | 693.364033734 | 0.001440651659 |
15 | 2025-03-13 00:00:00.000 | 556356 | 148100778 | 496944 | 99.790242 | 4303 | 492865 | 6431321 | 555189 | 1167 | 80.658088 | 97643 | -97643 | 21244999 | 1.119555 | 733.904585953 | 0.001476835591 |
16 | 2025-03-12 00:00:00.000 | 573088 | 147544422 | 504826 | 99.804917 | 2919 | 502151 | 6427018 | 571970 | 1118 | 84.803584 | 75802 | -75802 | 21147356 | 1.135219 | 780.559667724 | 0.001546195457 |
17 | 2025-03-11 00:00:00.000 | 563133 | 146971334 | 498815 | 99.843909 | 4553 | 494500 | 6424099 | 562254 | 879 | 81.362614 | 95120 | -95120 | 21071554 | 1.128942 | 785.3168149 | 0.001574364875 |
18 | 2025-03-10 00:00:00.000 | 576288 | 146408201 | 510372 | 99.809817 | 6614 | 503989 | 6419546 | 575192 | 1096 | 79.604434 | 105534 | -105534 | 20976434 | 1.129153 | 809.903758677 | 0.00158688909 |
19 | 2025-03-09 00:00:00.000 | 650764 | 145831913 | 517436 | 99.709572 | 5768 | 511892 | 6412932 | 648874 | 1890 | 81.290253 | 96010 | -96010 | 20870900 | 1.257671 | 823.532164971 | 0.001591563333 |
20 | 2025-03-08 00:00:00.000 | 742892 | 145181149 | 513155 | 99.74007 | 7250 | 506080 | 6407164 | 740961 | 1931 | 67.250838 | 91454 | -91454 | 20774890 | 1.447695 | 950.826186195 | 0.001852902507 |
i_danRonin Game-Fi: Total Daily Metrics
Updated 6 days ago
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- 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'
WHEN to_address = '0x322b3d98ddbd589dc2e8dd83659bb069828231e0' THEN 'Sabong Saga'
WHEN to_address = '0xac78515ef7d0bb935bc86d4f8ce314038946b52f' THEN 'Sabong Saga'
Last run: 6 days ago
...
178
29KB
113s