freemartianDebank - Ethereum Deposits
Updated 2023-07-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- select * from ethereum.core.ez_token_transfers
-- where tx_hash = '0x0f0e50bce58f6aae982580692c27ab74381cdcf19216d8715de68ae9ec765eef'
select
count(distinct from_address) as Ethereum_Depositors_Count,
count(tx_hash) as Ethereum_Deposits_Count,
sum(amount) as Ethereum_Deposits_Amount,
(CASE
when contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' then 'USDC'
when contract_address = '0xdac17f958d2ee523a2206206994597c13d831ec7' then 'USDT'
end) as Symbol
from ethereum.core.ez_token_transfers
where to_address = '0x205e94337bc61657b4b698046c3c2c5c1d2fb8f1'
and contract_address in ('0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48', '0xdac17f958d2ee523a2206206994597c13d831ec7')
and ORIGIN_FUNCTION_SIGNATURE = '0xa9059cbb'
group by contract_address
Run a query to Download Data