Debank - Withdrawers Rank table

freemartianDebank - Withdrawers Rank table

Updated 2024-02-20

-- forked from Debank - Depositors Rank table @ https://flipsidecrypto.xyz/edit/queries/28a6f6f8-a085-4aad-a750-01814c46c741

-- forked from Debank - Top Depositors @ https://flipsidecrypto.xyz/edit/queries/94565d8e-556d-4614-8a3e-cc8f6236ce68

-- forked from Debank - Interactive address @ https://flipsidecrypto.xyz/edit/queries/a472745e-95d1-4c93-910f-6f843235ad3d

with deposits as (

select

tx_hash,

block_timestamp,

from_address,

amount,

(CASE

when contract_address = '0xaf88d065e77c8cc2239327c5edb3a432268e5831' 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')

and ORIGIN_FUNCTION_SIGNATURE = '0xa9059cbb'

UNION

select

tx_hash,

block_timestamp,

from_address,

amount,

(CASE

when contract_address = '0x7f5c764cbc14f9669b88837ca1490cca17c31607' then 'USDC'

when contract_address = '0x94b008aa00579c1307b0ef2c499ad98a8ce58e58' then 'USDT'

end) as Symbol,

'Optimism' as Chain

from optimism.core.ez_token_transfers

where to_address = '0x824a2d0ae45c447caa8d0da4bb68a1a0056cadc6'

Last run: about 1 year ago

...

37653

2MB

584s