theericstonecrosschain user clusters
Updated 2024-05-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
--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