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')
    )
    select date_trunc('day', block_timestamp) as date_day,date_trunc('week', block_timestamp) as date_week
    ,date_trunc('month', block_timestamp) as date_mont
    ,count(origin_from_address) as number_of_staking
    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%') and block_timestamp>'2022-01-01'
    group by 1,2,3

    Run a query to Download Data