🧠 Methodology

To deal with this dashboard, we use the near.core schema and the fact_receipts, fact_actions_events_function_call, fact_transactions, ez_dex_swaps, fact_transfers and fact_prices tables.

To check the activity of the accounts created with NETH on other chains, we use the schemas arbitrum.core, ethereum.core, optimism.core and polygon.core and their fact_event_logs table

To check the accounts created with NETH and their activities, we check the following items:

Total and Weekly number of accounts created with NETH
Date of creation of accounts created with NETH
Total and Weekly number of transactions by these accounts
Total and Weekly number of transactions by these accounts based on their type of activity (Swap, Transfer and etc)
Total and Weekly number and volume of swaps performed by these accounts
Checking the activity of account wallets created by NETH on other chains (Ethereum, Polygon, Optimism and Arbitrum)

Obtaining account creation transaction with NETH on Near:

To get the transaction related to account creation via NETH on Near, we use the fact_receipts table. The way to create an account through NETH is that users connect their MetaMask wallet in neth.app and send 0.5 Near to the temporary address created, the account is created in the following order:

Called method create_account in contract near (Batch Transaction)
- New account (account_name) created
- New key (ed2551...Z8fY) added for account_name with permission FullAccess
- Transferred 0.4 Ⓝ to account_name
Delete temporary account
- Delete account (temporary_account_address) and transfer remaining funds to account_name
Called method set in contract nethmap.near (Set ETH Address)
Called method setup in contract account_name

To create an account through NETH, users connect to the address nethmap.near, and the list of created accounts is obtained with the following command:

select 
	count(distinct actions:predecessor_id) as "Number of Account"
  	from near.core.fact_receipts
  	where receiver_id = 'nethmap.near'
	and actions:receipt:Action:actions[0]:FunctionCall:method_name = 'set'
	and block_timestamp::date >= '2022-12-19'
	and status_value:Failure is null

Obtaining transactions of accounts created with NETH

To get the transactions of each account created through NETH, we need to consider several points:

After each account is created and configured, 14 of the transaction records (fact_receipts table record for account) are related to account creation and setup and have nothing to do with the activity of the created account.
So, for every account created, starting from the first 14 records (not necessarily 14 transactions) from the time of creation to setup, we need to consider subsequent transactions as activity through the NETH account.
- Check this account
  - This account is related to creation and setup up to the 14th record (from bottom to top based on record time) and after that it is related to account activity (such as addMessage transaction).
The way to get the first 14 transactions is that we created for each account (the way to get the accounts was explained in the first section) based on the record time recorded in the fact_receipts table using the function row_number(). We arrange its transactions in ascending order, then I consider transactions that are the 15th record and later:
- ```
account_and_transactions as (
	select 
  		*,
  		row_number() over (partition by wallet_account order by block_timestamp) as row_number
  		from transactions_by_neth_account
),
final_results as (
	select 
  		*
  		from account_and_transactions 
  		where row_number >= 15 
)
```
After obtaining these transactions, we also determine their type of activity, which includes:
- Swap
- Transfer
- Remove Liquidity
- Add Liquidity
- Near Social

Obtaining the activity of accounts created with NETH in other chains

Each ethereum account related to the MetaMask wallet created through NETH in Near has an address that is the same in all chains such as Ethereum, Polygon, Arbitrum and Optimism. So we first get that address for each account and then we look for that address in those four chains and figure out which chain those addresses are the most active on and which chain the most users belong to.

How to get eth_address:

Using the following query, we obtain the eth_address of each account created through NETH:

with eth_account_address as (
	select 
  		lower(args:eth_address) as eth_address
  		from near.core.fact_actions_events_function_call
  		where block_timestamp::date >= '2022-12-19'
  		and args:eth_address is not null 
  		and method_name = 'setup'
  		and action_name = 'FunctionCall'
),

NEAR - Secrets of the NETH-erworld