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

),

--Find all originating wallets. This is a list of wallets/users that have deposited money into Stake.com.

SELECT

ETH_FROM_ADDRESS as wallet,

count(*) as "Number of Deposits",

sum(amount) as "Sum of Deposits",

avg(amount) as "Avg Deposit"

from ethereum.core.ez_eth_transfers

where ETH_TO_ADDRESS in (select wallet from receive)

group by 1