KuramaGogo - exit previous depeg - TOTAL
Updated 2022-11-21Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with table_0 as (
select tx_hash, count(*) as num_transfers from polygon.core.fact_token_transfers
where origin_to_address = '0x7fcf0f2dcec385fcced98240a8a4bec8e91da7d1'
and origin_function_signature = '0xe9fad8ee'
and block_number <= '28036183'
group by tx_hash)
select
sum(raw_amount/pow(10,6)) as amount from polygon.core.fact_token_transfers
where tx_hash in (select distinct tx_hash from table_0 where num_transfers > 1 )
and to_address not in ('0x6e4e1498d8dad16c573ad83589f761a0e3dcdee7')
and from_address not in ('0x465862772f9c2e9d71982627bcfdc721a47deb22')
and contract_address = '0x2791bca1f2de4661ed88a30c99a7a9449aa84174'
and origin_function_signature = '0xe9fad8ee'
and block_number <= '28036183'
Run a query to Download Data