freemartianDebank - Arbitrum Deposits
Updated 2023-07-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
count(distinct from_address) as Arbitrum_Depositors_Count,
count(tx_hash) as Arbitrum_Deposits_Count,
sum(amount) as Arbitrum_Deposits_Amount,
(CASE
when contract_address = '0xaf88d065e77c8cc2239327c5edb3a432268e5831' then 'USDC'
when contract_address = '0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9' then 'USDT'
end) as Symbol
from arbitrum.core.ez_token_transfers
where to_address = '0x40f480f247f3ad2ff4c1463e84f03be3a9a03e15'
and contract_address in ('0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9', '0xaf88d065e77c8cc2239327c5edb3a432268e5831')
and ORIGIN_FUNCTION_SIGNATURE = '0xa9059cbb'
group by contract_address
Run a query to Download Data