magwrapping & unwrapping mon - wmon
    Updated 8 days ago
    with actions as
    (SELECT
    a.BLOCK_TIMESTAMP,
    a.ORIGIN_FROM_ADDRESS,
    CAST(ethereum.public.udf_hex_to_int(data) AS NUMERIC) / 1e18 AS amount,
    a.tx_hash,
    a.ORIGIN_FUNCTION_SIGNATURE
    from monad.testnet.fact_event_logs a
    where
    a.TX_SUCCEEDED = 'TRUE'
    and ORIGIN_FUNCTION_SIGNATURE in ('0xd0e30db0','0x2e1a7d4d')
    and a.ORIGIN_TO_ADDRESS = '0x760afe86e5de5fa0ee542fc7b7b713e1c5425701'
    and a.CONTRACT_ADDRESS = '0x760afe86e5de5fa0ee542fc7b7b713e1c5425701')

    select
    date_trunc('day',block_timestamp) as date,
    count(distinct tx_hash) as transactions,
    sum(amount) as "WMON",
    case
    when ORIGIN_FUNCTION_SIGNATURE = '0xd0e30db0' then 'wrapped'
    when ORIGIN_FUNCTION_SIGNATURE = '0x2e1a7d4d' then 'unwrapped'
    end as action
    from actions
    where block_timestamp::date >= '2025-02-19 04:00:00'
    group by all
    Last run: 8 days ago
    DATE
    TRANSACTIONS
    WMON
    ACTION
    1
    2025-03-09 00:00:00.000149672591414.920945unwrapped
    2
    2025-03-10 00:00:00.000187598500214.751208unwrapped
    3
    2025-03-10 00:00:00.000452205529359.186818wrapped
    4
    2025-02-21 00:00:00.000120271018158.815924unwrapped
    5
    2025-03-02 00:00:00.000197893598560.758853unwrapped
    6
    2025-03-03 00:00:00.000393176569773.851838wrapped
    7
    2025-02-26 00:00:00.0001212677985835.236505wrapped
    8
    2025-02-22 00:00:00.00025194841452.981827unwrapped
    9
    2025-03-01 00:00:00.000239865786987.881301unwrapped
    10
    2025-02-23 00:00:00.0002798241422301.785342wrapped
    11
    2025-03-08 00:00:00.000471571502172.094065wrapped
    12
    2025-03-08 00:00:00.000197040489616.598058unwrapped
    13
    2025-02-25 00:00:00.000224789836176.731439unwrapped
    14
    2025-02-19 00:00:00.000104651412942.100457wrapped
    15
    2025-02-27 00:00:00.000791962884143.07743wrapped
    16
    2025-02-19 00:00:00.00024531562298.034617unwrapped
    17
    2025-03-01 00:00:00.000454203783095.137795wrapped
    18
    2025-03-04 00:00:00.000163990553642.163481unwrapped
    19
    2025-03-11 00:00:00.000234365461076.40588unwrapped
    20
    2025-03-12 00:00:00.000180932105662.301188wrapped
    44
    3KB
    20s