MLDZMNDDU5
Updated 2023-01-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
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