MLDZMNDestination chains
    Updated 2022-06-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