freemartianDebank - Optimism Withdraws
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
›
⌄
-- forked from Debank - Optimism Deposits @ https://flipsidecrypto.xyz/edit/queries/9f7b617f-3480-470d-a0f9-a321331bcf89
select
count(distinct to_address) as Optimism_Withdrawers_Count,
count(tx_hash) as Optimism_Withdraw_Count,
sum(amount) as Optimism_DWithdraw_Amount,
(CASE
when contract_address = '0x7f5c764cbc14f9669b88837ca1490cca17c31607' then 'USDC'
when contract_address = '0x94b008aa00579c1307b0ef2c499ad98a8ce58e58' then 'USDT'
end) as Symbol
from optimism.core.ez_token_transfers
where from_address = '0xad003006ceb0934012c289d1cfdb1db915998f74'
and contract_address in ('0x7f5c764cbc14f9669b88837ca1490cca17c31607', '0x94b008aa00579c1307b0ef2c499ad98a8ce58e58')
and ORIGIN_FUNCTION_SIGNATURE = '0xa9059cbb'
group by contract_address
-- select * from optimism.core.ez_token_transfers
-- where tx_hash = '0x4416fe5a17286ff4c66dd3c82a8200d9d6658b9b8b284fd5c6d23c032ec11660'
Run a query to Download Data