hessDaily Share of Users
Updated 2023-01-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with activity as ( select a.block_timestamp::date as date, case when method_name ilike '%nft%' then 'NFT'
when method_name ilike '%transfer%' then 'Transfers'
when method_name ilike '%swap%' then 'Swap'
when method_name in ('add_liquidity','remove_liquidity','balance_stable_pool','get_pools') or method_name like '%claim%' then 'Liquidity'
when method_name in ('near_deposit','withdraw','near_withdraw','deposit','deposit_and_stake','unstake_all') then 'Stake' else 'Other' end as type, tx_signer
from near.core.fact_transactions a join near.core.fact_actions_events_function_call b on a.tx_hash = b.tx_hash
where a.block_timestamp::date >= '2022-07-01'
UNION
select date(block_timestamp) as date, 'NFT' as type, TX_SIGNER
from near.core.ez_nft_mints
where block_timestamp >= '2022-07-01'
UNION
select date(block_timestamp) as date, 'Stake' as type, TX_SIGNER
from near.core.dim_staking_actions
where action = 'Stake'
and block_timestamp >= '2022-07-01' )
select date, type, count(DISTINCT(tx_signer)) as total_user
from activity
group by 1,2
Run a query to Download Data