theericstonecrosschain user clusters
    Updated 2024-05-16
    --pairs of sender and recipient addresses on 2 chains
    with bridgepairs as (
    select
    destination_chain as chain1,
    source_chain as chain2,
    destination_address as address_chain1,
    source_address as address_chain2,
    count(1) as n_ties
    from crosschain.defi.ez_bridge_activity
    where block_timestamp > current_date - 90
    group by 1,2,3,4
    )
    select * from bridgepairs
    where address_chain1 IS NOT NULL
    and address_chain2 IS NOT NULL;
    QueryRunArchived: QueryRun has been archived