Ali3NTop Ankr aMatic Destinations (By Contract Address)
    Updated 2022-09-21
    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