ACCOUNT | Rice Bag | Percent | |
---|---|---|---|
1 | 0xe8f3ca605e29eeba962a527b360351a66c882d50 | 15549013620 | 8.292 |
2 | 0xe379f51d31a754d01a440819c384ba5126bbbd96 | 11694628499 | 6.2365 |
3 | 0x768edd76e031c306e914023e5111dfa00115b4ba | 7666322203 | 4.0883 |
4 | 0x4b09c6b3a9ca43d108bcb1e17eace8adc3abe1da | 5952673711 | 3.1745 |
5 | 0x20b6d03a0caedfe4409f75f14dfd94838b864199 | 5907577698 | 3.1504 |
6 | 0x3b9ef63b6566d7e4f18e1666e8536da697d001b0 | 4960561426 | 2.6454 |
7 | 0x723ceb055045433c642afcc2735e11bc9d9d7e73 | 4950054018 | 2.6398 |
8 | 0x915db307039201053e0e8ccc8941cefe9f2c8948 | 4664641189 | 2.4876 |
9 | 0x9ab8117c4bf86010fd378e7fb9d6b9986d9ffe21 | 4599793322 | 2.453 |
10 | #512 | 4509601296 | 2.4049 |
11 | #405 | 4509601296 | 2.4049 |
12 | #37 | 4509601296 | 2.4049 |
13 | #156 | 4509601296 | 2.4049 |
14 | 0x28d9682fd14e84129ec22e9e2201e335771da396 | 4059898973 | 2.1651 |
15 | 0xc9c11dda6a034af5bfbd8c86adac0a331299e52b | 3724102344 | 1.986 |
16 | 0xea6a3b3f6e3a48d71e19e327eeca7bd64ad7cefe | 3607681037 | 1.9239 |
17 | 0x9d7b5f8a7abbad6ee526b88082e42dc525a84a03 | 2976968028 | 1.5876 |
18 | #54 | 2868453755 | 1.5297 |
19 | 0x01a1bc8b2e4f069668f7e7b5579cba0b725b5a6b | 2603632380 | 1.3885 |
20 | 0xa43fb71a4ce839d8232b6b5b9703c000fe2fcc19 | 2573604875 | 1.3725 |
sssstatisticTOP Rice Bag
Updated 2025-01-14
99
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
›
⌄
With total AS (
select
SUM(
CASE event_name
WHEN 'ClaimPoint' THEN decoded_log ['points']
WHEN 'ClaimPointOfLand' THEN decoded_log ['totalPoints']
WHEN 'LandWithdrawRewardFromPool' THEN decoded_log ['points'] * -1
WHEN 'WithdrawRewardFromPool' THEN decoded_log ['points'] * -1
WHEN 'KickOutOfThePool' THEN decoded_log ['points'] * -1
ELSE 0
END / pow(10, 18)
) AS bag
from
blast.core.ez_decoded_event_logs
where
contract_address = '0xc48f6213a1a4d3ead79db812c2b91817980532c3'
and event_name in (
'ClaimPointOfLand',
'ClaimPoint',
'LandWithdrawRewardFromPool',
'WithdrawRewardFromPool',
'KickOutOfThePool'
)
)
select
coalesce(decoded_log ['account'], concat('#', decoded_log ['landId'])) AS account,
round(SUM(
CASE event_name
WHEN 'ClaimPoint' THEN decoded_log ['points']
WHEN 'ClaimPointOfLand' THEN decoded_log ['totalPoints']
WHEN 'LandWithdrawRewardFromPool' THEN decoded_log ['points'] * -1
WHEN 'WithdrawRewardFromPool' THEN decoded_log ['points'] * -1
WHEN 'KickOutOfThePool' THEN decoded_log ['points'] * -1
ELSE 0
END / pow(10, 18)
)) AS "Rice Bag",
Last run: about 1 month ago
...
5140
263KB
119s