WITH yeni as ( SELECT TX_RECEIVER as wallet, SUM(deposit / pow(10, 24)) as val FROM near.core.fact_transfers WHERE STATUS = 'TRUE' GROUP BY 1 UNION ALL SELECT TX_SIGNER as wallet, -1 * SUM(deposit / pow(10, 24)) as val FROM near.core.fact_transfers WHERE STATUS = 'TRUE' GROUP BY 1 UNION ALL SELECT TX_SIGNER as wallet, -1 * SUM(transaction_fee / pow(10,24)) as val FROM near.core.fact_transfers WHERE STATUS = 'TRUE' GROUP BY 1 UNION ALL SELECT TRADER as wallet, SUM(AMOUNT_OUT) as val FROM near.core.ez_dex_swaps WHERE TOKEN_OUT = 'NEAR' GROUP BY 1 UNION ALL SELECT TRADER as wallet, -1 * SUM(AMOUNT_IN) as val FROM near.core.ez_dex_swaps WHERE TOKEN_IN = 'NEAR' GROUP BY 1 -- +UnStake UNION ALL SELECT tx.TX_signer as wallet, SUM(TRY_PARSE_JSON(fc.ARGS):MIN_EXPECTED_NEAR::INTEGER / POW(10, 24)) as val FROM near.core.fact_transactions tx JOIN near.core.fact_actions_events_function_call fc ON fc.tx_hash = tx.tx_hash WHERE (METHOD_NAME ilike 'liquid_unstake' or METHOD_NAME ilike 'instant_unstake') GROUP BY 1 HAVING val > 0 UNION ALL SELECT tx.TX_signer as wallet, -1 * SUM(fc.deposit / POW(10, 24)) as val FROM near.core.fact_transactions tx JOIN near.core.fact_actions_events_function_call fc ON fc.tx_hash = tx.tx_hash WHERE METHOD_NAME IN ('deposit_and_stake', 'stake') GROUP BY 1 HAVING val > 0 UNION ALL SELECT TRY_PARSE_JSON(ac.VALUE):ACCOUNT_ID::STRING as wallet, SUM(TRY_PARSE_JSON(ac.VALUE):AMOUNT::INTEGER / POW(10, 24)) AS val FROM NEAR.CORE.FACT_ACTIONS_EVENTS_FUNCTION_CALL, table(flatten(TRY_PARSE_JSON(NEAR.CORE.FACT_ACTIONS_EVENTS_FUNCTION_CALL.ARGS):ACCOUNTS)) ac WHERE METHOD_NAME IN ('multisend_from_balance', 'multisend_from_balance_unsafe') GROUP BY 1 ), balances as ( SELECT wallet, SUM(val) as balance FROM yeni group by wallet having balance > 0 ) select count(distinct wallet) as wallets, CASE WHEN balance > 0.1 and balance <= 0.5 THEN 'b.0.1-0.5' WHEN balance > 0.5 and balance <= 1 THEN 'c.0.5-1' WHEN balance > 1 and balance <= 5 THEN 'd.1-5' WHEN balance > 5 and balance <= 10 THEN 'e.5-10' WHEN balance > 10 and balance <= 50 THEN 'f.10-50' WHEN balance > 50 and balance <= 100 THEN 'g.50-100' WHEN balance > 100 and balance <= 500 THEN 'h.100-500' WHEN balance > 500 and balance <= 1000 THEN 'i.500-1K' WHEN balance > 1000 and balance <= 5000 THEN 'j.1K-5K' WHEN balance > 5000 and balance <= 10000 THEN 'k.5K-10K' WHEN balance > 10000 and balance <= 100000 THEN 'l.10K-100K' WHEN balance > 100000 THEN 'm.> 100K' END as category from balances where category is not null group by category order by category

Near- 12. The Whales of NEAR