Ali3NTop Ankr aMatic Destinations (By Contract Address)
Updated 2022-09-21Copy Reference Fork
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
›
⌄
with t1 as (
select case when contract_address = '0x9ee91f9f426fa633d227f7a9b000e28b9dfd8599' then 'Lido stMATIC'
when contract_address = '0xfa68fb4628dff1028cfec22b4162fccd0d45efb6' or contract_address = '0xf03a7eb46d01d9ecaa104558c732cf82f6b6b645' then 'Stader MaticX'
when contract_address = '0x99534ef705df1fff4e4bd7bbaaf9b0dff038ebfe' then 'Ankr aMATICb'
when contract_address = '0x26dcfbfa8bc267b250432c01c982eaf81cc5480c' then 'Ankr aMATICc'
when contract_address = '0x38b7bf4eecf3eb530b1529c9401fc37d2a71a912' or contract_address = '0x7ed6390f38d554b8518ef30b925b46972e768af8' then 'ClayStack csMATIC'
else null end as derivate,
origin_to_address,
address_name,
tx_hash,
origin_from_address
from ethereum.core.fact_event_logs t1 full outer join ethereum.core.dim_labels t2 on t1.origin_to_address = t2.address
where origin_to_address not in
('0xcfd4b4bc15c8bf0fd820b0d4558c725727b3ce89',
'0x376b467dff007dd8d3f24404caddff7f72257fe4',
'0x91730940dce63a7c0501cedfc31d9c28bcf5f905',
'0x9ee91f9f426fa633d227f7a9b000e28b9dfd8599',
'0xfa68fb4628dff1028cfec22b4162fccd0d45efb6',
'0xf03a7eb46d01d9ecaa104558c732cf82f6b6b645')
and derivate is not null
and origin_to_address != contract_address
union all
select case when contract_address = '0x9ee91f9f426fa633d227f7a9b000e28b9dfd8599' then 'Lido stMATIC'
when contract_address = '0xfa68fb4628dff1028cfec22b4162fccd0d45efb6' or contract_address = '0xf03a7eb46d01d9ecaa104558c732cf82f6b6b645' then 'Stader MaticX'
when contract_address = '0x99534ef705df1fff4e4bd7bbaaf9b0dff038ebfe' then 'Ankr aMATICb'
when contract_address = '0x26dcfbfa8bc267b250432c01c982eaf81cc5480c' then 'Ankr aMATICc'
when contract_address = '0x38b7bf4eecf3eb530b1529c9401fc37d2a71a912' or contract_address = '0x7ed6390f38d554b8518ef30b925b46972e768af8' then 'ClayStack csMATIC'
else null end as derivate,
origin_to_address,
address_name,
tx_hash,
origin_from_address
from polygon.core.fact_event_logs t1 full outer join polygon.core.dim_labels t2 on t1.origin_to_address = t2.address
where origin_to_address not in
('0xcfd4b4bc15c8bf0fd820b0d4558c725727b3ce89',
'0x376b467dff007dd8d3f24404caddff7f72257fe4',
Run a query to Download Data