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