freemartianDebank - BSC withdraw
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
21
›
⌄
select
count(distinct to_address) as BSC_Withdrawers_Count,
count(tx_hash) as BSC_Withdraws_Count,
sum(amount) as BSC_Withdraws_Amount,
(CASE
when contract_address = '0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d' then 'USDC'
when contract_address = '0x55d398326f99059ff775485246999027b3197955' then 'USDT'
end) as Symbol
from bsc.core.ez_token_transfers
where from_address = '0xad003006ceb0934012c289d1cfdb1db915998f74'
and contract_address in
(lower('0x55d398326f99059fF775485246999027B3197955'),
'0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d')
and ORIGIN_FUNCTION_SIGNATURE = '0xa9059cbb'
group by contract_address
-- select * from bsc.core.ez_token_transfers
-- where tx_hash = '0x61c7c174d34dac1cfc18a6c7a245c0feed14486816a04d6d574478f764e3cc68'
Run a query to Download Data