REFERRER | Total Level 10 People Invited | Total People Invited | |
---|---|---|---|
1 | 0x7de501190ad282b7e9db78991b5a6a7e87d37643 | 5 | 13 |
2 | 0x348b7b78ece1d0671c645359e8e2838f1f1c1a35 | 5 | 5 |
3 | 0x65e332e45bfae40a00dc209b92c1813f53344b38 | 3 | 7 |
4 | 0x723ceb055045433c642afcc2735e11bc9d9d7e73 | 1 | 11 |
5 | 0xb78ed162f09a5c8cea907400e52573ad839389f8 | 1 | 9 |
6 | 0x1af1283d9b8c3dc68a5b4cb96c6895e9a6f27ec0 | 1 | 8 |
7 | 0xeddf919ccc15cd1dd3e6141cc82d024fbab3b6d9 | 1 | 8 |
8 | 0xaaf48af954a8d642e2d9b49729a6a5fdfdf0a084 | 1 | 6 |
9 | 0xff9bf326a82dcb7611845f935dade8119404d63a | 1 | 6 |
10 | 0x97619797cd15ddf8b77f73d60f7b41db9888cb2d | 1 | 6 |
11 | 0x9232f4dc137f8468a88d3ba49d1e6517c4d27618 | 1 | 5 |
12 | 0x9cff158b80dae45f3d43290880400db94bf349ad | 1 | 5 |
13 | 0xc68329fdbb3aa3a9e6864f41d18f2f37f80b50fd | 1 | 5 |
14 | 0xa7d355ebed6bbc9583dc5201d2ca1d53226c2352 | 1 | 5 |
15 | 0xd8fe315d39621f19b4ce0530cbc215ee66328160 | 1 | 4 |
16 | 0xb3f2ebdd534fb981b71317d8802b75612fef8a23 | 1 | 4 |
17 | 0x4fdb1cadecaf1bb9d7178d56ee4e7cb048bab8ab | 1 | 3 |
18 | 0x16cd629d263ed787e12d5605e19d7f3d080da9df | 1 | 1 |
19 | 0x144c5807d57ead56b92f6dedd8baed3fe2526ed8 | 1 | 1 |
20 | 0x59488d5321a28d9df1484a6638ec77d4d94c6063 | 1 | 1 |
sssstatisticTOP Referrers (On-chain) Monthly
Updated 2024-12-18
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 timeline as (
SELECT
to_timestamp(value['start']) AS start_time,
to_timestamp(value['end']) AS end_time,
value['season'] AS season
from
table(
flatten(
PARSE_JSON(
'[
{"start":"2024-06-15 00:00:00", "end":"2024-07-15 00:00:00", "season": 2},
{"start":"2024-07-15 00:00:00", "end":"2024-08-15 00:00:00", "season": 3},
{"start":"2024-08-15 00:00:00", "end":"2024-09-15 00:00:00", "season": 4},
{"start":"2024-09-15 00:00:00", "end":"2024-10-15 00:00:00", "season": 5},
{"start":"2024-10-15 00:00:00", "end":"2024-11-15 00:00:00", "season": 6},
{"start":"2024-11-15 00:00:00", "end":"2024-12-15 00:00:00", "season": 7},
]'
)
)
) f
where season = {{param_RefsSeason}}
),
level_info AS (
select
count(*) as level,
origin_from_address
from
blast.core.ez_decoded_event_logs el
where
contract_address in (
'0xc48f6213a1a4d3ead79db812c2b91817980532c3'
)
and event_name in (
'LevelUpSamurai'
)
Last run: 2 months ago
...
113
6KB
8s