fabre-basehop-bridgeuser-sv
Updated 2022-06-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with wallets as (
select
from_address wallet,
case
when to_address = lower('0xb98454270065a31d71bf635f6f7ee6a518dfb849') then 'WBTC'
when to_address = lower('0x3666f603Cc164936C1b87e207F36BEBa4AC5f18a') then 'USDC'
when to_address = lower('0x3E4a3a4796d16c0Cd582C382691998f7c06420B6') then 'USDT'
when to_address = lower('0x22B1Cbb8D98a01a3B71D034BB899775A76Eb1cc2') then 'MATIC'
when to_address = lower('0x3d4Cc8A61c7528Fd86C55cfe061a78dCBA48EDd1') then 'DAI'
else '' end as token
from ethereum.core.fact_token_transfers trans
where token != ''
UNION ALL
select ORIGIN_FROM_ADDRESS wallet, 'ETH' as token from
ethereum.core.ez_eth_transfers
where eth_to_address = lower('0xb8901acB165ed027E32754E0FFe830802919727f')
) select count(distinct wallet)
from wallets
Run a query to Download Data