MLDZMNDDU5
    Updated 2023-01-25
    with tt as (select
    USER_ADDRESS as users
    from ethereum.core.ez_current_balances
    where CONTRACT_ADDRESS='0x92d6c1e31e14520e676a687f0a93788b716beff5'
    and CURRENT_BAL>0
    )

    select
    date_trunc('day',BLOCK_TIMESTAMP) as date,
    event_name as first_actions,
    count(distinct tx_hash) as no_txn,
    count(distinct origin_from_address) as users
    from ethereum.core.fact_event_logs
    where origin_from_address in (select users from tt)
    and CONTRACT_ADDRESS='0x92d6c1e31e14520e676a687f0a93788b716beff5'
    and BLOCK_TIMESTAMP>='2022-12-01'
    group by 1,2
    having first_actions is not null
    QUALIFY DENSE_RANK() OVER (partition by date ORDER BY no_txn DESC) <= 5
    Run a query to Download Data