2844Number of Unique Wallets
Updated 2022-04-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with DEX as (
select platform,tx_id
from ethereum.dex_swaps
where platform in ('sushiswap', 'uniswap-v2', 'uniswap-v3')
and block_timestamp >= '2022-01-01'
and direction = 'IN'
and amount_in > '0'
),
event as
(select origin_address as N_Wallet, tx_id
from ethereum.udm_events
where block_timestamp >= '2022-01-01'
)
select Dex.platform , count(distinct (event.N_Wallet )) as N_Wallets
from dex
join event on dex.tx_id=event.tx_id
group by platform
Run a query to Download Data