ramishoowNew NEAR Users
Updated 2022-09-07
9
1
2
3
4
5
›
⌄
with new_users as (select first_time_date as dt, new_user from (select min(block_timestamp) as first_time_date, tx_signer as new_user from near.core.fact_transactions
where tx_status = 'Success' group by new_user) having dt >= current_date - 90), new_user_with_action as (select q.block_timestamp, q.tx_hash, tx_signer, action_name, method_name
from near.core.fact_transactions q join near.core.fact_actions_events_function_call w on q.tx_hash = w.tx_hash where tx_signer in (select new_user from new_users)) select method_name as naame, count(distinct tx_hash) as num___interacts
from new_user_with_action where block_timestamp::date >= current_date - 90 group by 1 order by num___interacts desc limit 5
--Top practices for new users
Run a query to Download Data