KuramaGogo - Distinct contract signatures
    Updated 2022-11-21
    -- signatures 0x7edbceb1 and 0x2f93b839 are not on the signatures table for some reason, but looking at two example transactions and going on polygonscan we can confirm that they are
    -- withdraw pending and stable reward respectively


    select distinct origin_function_signature,
    case when origin_function_signature = '0x7edbceb1' then 'withdraw pending'
    when origin_function_signature = '0x2f93b839' then 'stable reward'
    else b.text_signature end as signature from polygon.core.fact_token_transfers a
    left join ethereum.core.dim_function_signatures b
    on a.origin_function_signature = b.bytes_signature
    where origin_to_address = '0x7fcf0f2dcec385fcced98240a8a4bec8e91da7d1'
    Run a query to Download Data