Delamir-6014uni 07 Genie
Updated 2022-12-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with Genie as (
select
from_address as users,
count(tx_hash) as total_TXs
from ethereum.core.fact_transactions
where
block_timestamp <= '2022-04-15'
and to_address in ('0xf97e9727d8e7db7aa8f006d1742d107cf9411412','0x31837aaf36961274a04b915697fdfca1af31a0c7'
,'0xcdface5643b90ca4b3160dd2b5de80c1bf1cb088','0x2af4b707e1dce8fc345f38cfeeaa2421e54976d5'
,'0x0a267cf51ef038fc00e71801f5a524aec06e4f07')
and eth_value > 0
group by 1
having total_TXs > 1
)
select
count(users) as Unique_wallets
from Genie