Updated 2025-03-11
    with raw_data as (
    select
    regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}') as logs_topics
    from avalanche.core.fact_event_logs
    where tx_hash = '0xeeccc41a9d8735957504aae0edcc372ffdfae2d5e7b655678c4eab2c1c20600a'
    and block_number = 18808685
    )

    select
    '0x' || logs_topics[0] as event_sig,
    '0x' || logs_topics[1] as topic_data
    from raw_data




    QueryRunArchived: QueryRun has been archived