freemartianDebank - Polygon Withdraw
Updated 2023-07-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
select
count(distinct to_address) as Polygon_Withdrawers_Count,
count(tx_hash) as Polygon_Withdraw_Count,
sum(amount) as Polygon_Withdraw_Amount,
(CASE
when contract_address = '0x2791bca1f2de4661ed88a30c99a7a9449aa84174' then 'USDC'
when contract_address = '0xc2132d05d31c914a87c6611c10748aeb04b58e8f' then 'USDT'
end) as Symbol
from polygon.core.ez_token_transfers
where from_address = '0xad003006ceb0934012c289d1cfdb1db915998f74'
and contract_address in ('0xc2132d05d31c914a87c6611c10748aeb04b58e8f', '0x2791bca1f2de4661ed88a30c99a7a9449aa84174')
and ORIGIN_FUNCTION_SIGNATURE = '0xa9059cbb'
group by contract_address