legomanExamples of Swaps involving LOTS of addresses
Updated 2023-02-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- Exclude the routers and find txs with more than one sender/receiver
with union_data as (
select tx_hash, sender as address
from ethereum.uniswapv3.ez_swaps
where sender not in('0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45', '0xe592427a0aece92de3edee1f18e0157c05861564', '0xdef1c0ded9bec7f1a1670819833240f027b25eff', '0x1111111254fb6c44bac0bed2854e76f90643097d' )
union all
select tx_hash, recipient as address
from ethereum.uniswapv3.ez_swaps
where recipient not in('0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45', '0xe592427a0aece92de3edee1f18e0157c05861564', '0xdef1c0ded9bec7f1a1670819833240f027b25eff', '0x1111111254fb6c44bac0bed2854e76f90643097d' )
),
tx_counts as (
select tx_hash, count(distinct address) as addresses
from union_data
group by tx_hash
)
select tx_hash, addresses as "Addresses involved"
from tx_counts
where addresses > 15
limit 100
Run a query to Download Data