with a as (with swap as (select trader, count(distinct tx_hash) as minting_txn

from near.core.ez_dex_swaps enm

group by 1 ),

mint as (select tx_signer as trader, count(distinct tx_hash) as minting_txn

from near.core.ez_nft_mints

group by 1 ),

list as (select mint.trader as ad1, swap.trader as ad2

from swap inner join mint on mint.trader=swap.trader ),

bal as (-- forked from 60eda717-12c8-42f9-a1cd-a61aab79623c

tb AS (

select

TX_SIGNER AS user,

- sum(DEPOSIT / 1e24) AS amount

from

near.core.fact_transfers

group by

1

union ALL

select

TX_SIGNER AS user,

- sum(tx:actions[0]:FunctionCall:deposit / pow(10, 24)) AS amount

from

near.core.fact_actions_events_function_call A

inner join near.core.fact_transactions B on A.TX_HASH = B.TX_HASH

where

METHOD_NAME in ('stake', 'deposit_and_stake')

group by

1