illegal-gray

hessillegal-gray

Updated 2025-03-06

with layer_base as (select block_timestamp::Date as date,

tx_hash,

contract_address as token_address,

'0x' || substr(TOPIC_1,27) as null_address,

'0x' || substr(TOPIC_2,27) as user_address,

event_index,

TOPICS,

livequery.utils.udf_hex_to_int(DATA) as amount_raw,

from ink.core.fact_event_logs

where origin_from_address = lower('0xe93685f3bBA03016F02bD1828BaDD6195988D950')

having null_address = '0x0000000000000000000000000000000000000000')

final as ( select a.date,

a.tx_hash,

user_address,

token_address,

amount_raw,

regexp_substr_all(SUBSTR(INPUT_DATA, 11, len(INPUT_DATA)), '.{64}') AS segmented_data,

livequery.utils.udf_hex_to_int(segmented_data[2]) as src_chain,

case when src_chain = 30280 then 'Sei'

when src_chain = 30177 then 'Kava'

when src_chain = 30151 then 'Metis'

when src_chain = 223 then 'B2'

when src_chain = 30106 then 'Avalanche'

when src_chain = 30295 then 'Flare'

when src_chain = 30324 then 'Abstract'

when src_chain = 30109 then 'Polygon'

when src_chain = 30362 then 'Berachain'

when src_chain = 30312 then 'Ape'

when src_chain = 30294 then 'Gravity'

when src_chain = 30168 then 'Solana'

when src_chain = 30165 then 'Zksync_Era'

when src_chain = 30217 then 'Manta'

when src_chain = 30181 then 'Mantle'

when src_chain = 30138 then 'Fuse'

when src_chain = 30150 then 'Kaia'

Last run: about 1 month ago

752B

31s

flipside