Monad Metrics GuildDaily Charts Regarding Nad domains
    Updated 3 days ago
    with names as (
    select
    block_timestamp,
    tx_hash,
    regexp_substr_all(substr(data, 3), '.{64}') as segmented,
    livequery.utils.udf_hex_to_int(segmented[3]) * 2 as one
    from monad.testnet.fact_event_logs
    where contract_address = lower('0x758D80767a751fc1634f579D76e1CcaAb3485c9c')
    and topic_0 = '0xe40c7379a992adbbc94835bd180c2a4a94473a43eea97f51a9a33b8f73015bf8'
    ),

    decoded_names as (
    select
    tx_hash,
    livequery.utils.udf_hex_to_string(left(segmented[4], one)) as name,
    len(name) as number_characters
    from names
    ),

    base_data as (
    select
    block_timestamp,
    tx_hash,
    '0x' || substr(topic_1, 27) as mint_address,
    '0x' || substr(topic_2 , 27) as minter,
    livequery.utils.udf_hex_to_int(substr(topic_3, 25)) as token_id
    from monad.testnet.fact_event_logs
    where contract_address = '0x3019bf1dfb84e5b46ca9d0eec37de08a59a41308'
    and topic_0 = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
    ),

    combined as (
    select
    b.block_timestamp,
    b.tx_hash,
    minter,
    Last run: 3 days ago
    DAY
    NUMBER_NAMES_MINTED
    DAILY_MON_USED
    MINTERS_DAILY
    1
    2025-02-07 00:00:00.000261
    2
    2025-02-11 00:00:00.00015452
    3
    2025-02-12 00:00:00.000261
    4
    2025-02-13 00:00:00.000131
    5
    2025-02-14 00:00:00.000261
    6
    2025-02-15 00:00:00.000131
    7
    2025-02-16 00:00:00.000131
    8
    2025-02-17 00:00:00.000161
    9
    2025-02-18 00:00:00.00040.112
    10
    2025-02-19 00:00:00.0003419142.612755
    11
    2025-02-20 00:00:00.000550751871.6345917
    12
    2025-02-21 00:00:00.000520521387.0246609
    13
    2025-02-22 00:00:00.000510021463.6343261
    14
    2025-02-23 00:00:00.000671371670.3359699
    15
    2025-02-24 00:00:00.000723441711.5261340
    16
    2025-02-25 00:00:00.000936372132.8981364
    17
    2025-02-26 00:00:00.0002351825093.36207963
    18
    2025-02-27 00:00:00.0001618883527.39143049
    19
    2025-02-28 00:00:00.0001198002536.3797171
    20
    2025-03-01 00:00:00.000547144712.0539899
    58
    3KB
    104s