Ant-DAO-MentArrays
Updated 2025-03-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
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