freemartianDebank - Total Withdraw Counts by chain
Updated 2023-11-22
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from Debank - Total Deposit Counts by chain @ https://flipsidecrypto.xyz/edit/queries/e1570481-daa6-4760-bd7b-7e85a4abb1df
-- forked from Debank - Daily Deposit stats @ https://flipsidecrypto.xyz/edit/queries/e0ee6efc-6a25-46fc-8715-507a79772c62
-- 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'
Run a query to Download Data