0-MIDtoken br w
    Updated 2024-09-10

    with tab1 as (
    select TOKEN_ADDRESS
    ,TX_SENDER
    ,TX_HASH
    from aptos.defi.fact_bridge_activity
    where PLATFORM='wormhole'
    ),
    tab2 as (
    select TOKEN_ADDRESS
    ,SYMBOL
    from aptos.core.dim_tokens
    )
    select SYMBOL as token
    ,count(distinct TX_SENDER) as bridgers
    ,count(distinct TX_HASH) as bridges
    from tab1
    left join tab2
    on tab1.TOKEN_ADDRESS=tab2.TOKEN_ADDRESS
    group by 1
    order by 2 desc
    limit 10



    QueryRunArchived: QueryRun has been archived