KuramaGogo - withdraw post depeg
Updated 2022-11-21
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
-- 2 transactions here: 0x465862772f9c2e9d71982627bcfdc721a47deb22 sends to wallet X
-- Wallet X sends to the user wallet
-- hence, 2 transfers per transaction
-- hence, we keep the one in which the sender is not 0x465862772f9c2e9d71982627bcfdc721a47deb22 so we've got the right receiver
select to_address,
sum(raw_amount/pow(10,6)) as amount from polygon.core.fact_token_transfers
where origin_to_address = '0x7fcf0f2dcec385fcced98240a8a4bec8e91da7d1'
and origin_function_signature = '0x2e1a7d4d'
and block_number <= '28799165'
and from_address not in ('0x465862772f9c2e9d71982627bcfdc721a47deb22')
group by to_address
Run a query to Download Data