MLDZMNDestination chains
Updated 2022-06-22Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with tb1 as (select ----Bridge Transactions (Across)
*,
regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}') AS segmented_data,
ethereum.public.udf_hex_to_int(segmented_data[2]) as id
from ethereum.core.FACT_EVENT_LOGS
where CONTRACT_ADDRESS = lower('0x4D9079Bb4165aeb4084c526a32695dCfd2F77381')
and ORIGIN_FUNCTION_SIGNATURE='0x49228978'
and TX_STATUS='SUCCESS'
and BLOCK_TIMESTAMP>=CURRENT_DATE-14
)
select
case
when id=1 then 'Mainnet'
when id=10 then 'Optimism'
when id=137 then 'Polygon'
when id=288 then 'Boba'
when id=42161 then 'Arbitrum'
else null end as chains,
count(distinct tx_hash) as no_txn
from tb1
group by 1 having chains is not null
Run a query to Download Data