SectorWallets Merged v1.2
Updated 2023-03-25
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- lower('0xCBD6832Ebc203e49E2B771897067fce3c58575ac'), --Rollbit
-- lower('0x8FfcC8863C590674544B1bbE0D194C2Aa5111127'), --BC.Game
-- lower('0xC94eBB328aC25b95DB0E0AA968371885Fa516215'), --Roobet
-- lower('0x094b4cf43908F0AdB3dBDb5025F52470AAc3B160') --sportsbet
--Stake lower('0x974CaA59e49682CdA0AD2bbe82983419A2ECC400')
--Stake_Polygon lower('0x019D0706D65c4768ec8081eD7CE41F59Eef9b86c')
--Find all Jump/Deposit wallets that Stake.com uses to funnel into their main wallet
With Receive_raw as (
select
ETH_FROM_ADDRESS as wallet,
sum(amount) as Receive
from ethereum.core.ez_eth_transfers
where ETH_TO_ADDRESS = lower('0x974CaA59e49682CdA0AD2bbe82983419A2ECC400') --Stake.com main wallet where funds are deposited
group by 1
UNION ALL
select
FROM_ADDRESS as wallet,
sum(amount) as Receive
from ethereum.core.ez_token_transfers
where TO_ADDRESS = lower('0x974CaA59e49682CdA0AD2bbe82983419A2ECC400') --Stake.com main wallet where funds are deposited
group by 1
)
--filter CEX and other wallets with high tx counts. Jump wallets will all have low tx counts.
, Receive_CEX_filter as (
select
from_address as wallet,
count(*) as Tot_txns
from ethereum.core.fact_transactions
where FROM_ADDRESS in (select wallet from Receive_raw)
Run a query to Download Data