sssstatisticTOP Referrers (On-chain) Monthly
    Updated 2024-12-18

    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
    REFERRER
    Total Level 10 People Invited
    Total People Invited
    1
    0x7de501190ad282b7e9db78991b5a6a7e87d37643
    513
    2
    0x348b7b78ece1d0671c645359e8e2838f1f1c1a35
    55
    3
    0x65e332e45bfae40a00dc209b92c1813f53344b38
    37
    4
    0x723ceb055045433c642afcc2735e11bc9d9d7e73
    111
    5
    0xb78ed162f09a5c8cea907400e52573ad839389f8
    19
    6
    0x1af1283d9b8c3dc68a5b4cb96c6895e9a6f27ec0
    18
    7
    0xeddf919ccc15cd1dd3e6141cc82d024fbab3b6d9
    18
    8
    0xaaf48af954a8d642e2d9b49729a6a5fdfdf0a084
    16
    9
    0xff9bf326a82dcb7611845f935dade8119404d63a
    16
    10
    0x97619797cd15ddf8b77f73d60f7b41db9888cb2d
    16
    11
    0x9232f4dc137f8468a88d3ba49d1e6517c4d27618
    15
    12
    0x9cff158b80dae45f3d43290880400db94bf349ad
    15
    13
    0xc68329fdbb3aa3a9e6864f41d18f2f37f80b50fd
    15
    14
    0xa7d355ebed6bbc9583dc5201d2ca1d53226c2352
    15
    15
    0xd8fe315d39621f19b4ce0530cbc215ee66328160
    14
    16
    0xb3f2ebdd534fb981b71317d8802b75612fef8a23
    14
    17
    0x4fdb1cadecaf1bb9d7178d56ee4e7cb048bab8ab
    13
    18
    0x16cd629d263ed787e12d5605e19d7f3d080da9df
    11
    19
    0x144c5807d57ead56b92f6dedd8baed3fe2526ed8
    11
    20
    0x59488d5321a28d9df1484a6638ec77d4d94c6063
    11
    ...
    113
    6KB
    8s