eslamis-darkatactivity anali 14
    Updated 2022-09-29
    with metamask as (
    select distinct origin_from_address as unique_address
    from ethereum.core.fact_event_logs
    where lower(contract_address) = lower('0x881D40237659C251811CEC9c364ef91dC08D300C')
    )
    ,
    swap as (select count(origin_from_address) as number
    from ethereum.core.fact_event_logs
    join metamask on origin_from_address = unique_address
    join ethereum.core.dim_function_signatures on origin_function_signature = bytes_signature
    WHERE lower(text_signature) like ('%swap%')
    )
    ,
    deposit as(select count(origin_from_address) as number
    from ethereum.core.fact_event_logs
    join metamask on origin_from_address = unique_address
    join ethereum.core.dim_function_signatures on origin_function_signature = bytes_signature
    WHERE lower(text_signature) like ('%deposit%')
    )
    ,
    transfer as (
    select count(origin_from_address) as number
    from ethereum.core.fact_event_logs
    join metamask on origin_from_address = unique_address
    join ethereum.core.dim_function_signatures on origin_function_signature = bytes_signature
    WHERE lower(text_signature) like ('%transfer%')
    )
    ,
    staking as (
    select count(origin_from_address) as number
    from ethereum.core.fact_event_logs
    join metamask on origin_from_address = unique_address
    join ethereum.core.dim_function_signatures on origin_function_signature = bytes_signature
    WHERE lower(text_signature) like ('%stake%')
    )
    ,
    Run a query to Download Data