freemartianUSDC Withdraw Stats
Updated 2023-12-02
99
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 USDC Deposit Stats @ https://flipsidecrypto.xyz/edit/queries/4a086959-6984-4713-bc72-9056728c2b61
select
count(distinct to_address) as Depositors_Count,
count(tx_hash) as Deposits_Count,
sum(amount) as Deposits_Amount,
(CASE
when contract_address in ('0xaf88d065e77c8cc2239327c5edb3a432268e5831', lower('0xFF970A61A04b1cA14834A43f5dE4533eBDDB5CC8')) then 'USDC'
when contract_address = '0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9' then 'USDT'
end) as Symbol,
'Arbitrum' as Chain
from arbitrum.core.ez_token_transfers
where from_address = '0xad003006ceb0934012c289d1cfdb1db915998f74'
and contract_address in (
--'0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9',
'0xaf88d065e77c8cc2239327c5edb3a432268e5831')
and ORIGIN_FUNCTION_SIGNATURE = '0xa9059cbb'
group by contract_address, chain
UNION
select
count(distinct to_address) as Depositors_Count,
count(tx_hash) as Deposits_Count,
sum(amount) as Deposits_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 from_address = '0xad003006ceb0934012c289d1cfdb1db915998f74'
and contract_address in ('0x7f5c764cbc14f9669b88837ca1490cca17c31607')
--,'0x94b008aa00579c1307b0ef2c499ad98a8ce58e58')
Run a query to Download Data