0-MIDuser dis
    Updated 2024-01-08
    with tab1 as (
    select ORIGIN_FROM_ADDRESS
    ,count(distinct TX_HASH) as bridges
    from ethereum.defi.ez_bridge_activity
    where BLOCK_TIMESTAMP>='2023-01-01' and BLOCK_TIMESTAMP<='2023-12-31'
    and DESTINATION_CHAIN='zksync era mainnet'
    group by 1 )
    select bridges
    ,count(distinct ORIGIN_FROM_ADDRESS) as bridgers
    from tab1
    group by 1


    QueryRunArchived: QueryRun has been archived