Query editor
WITH base AS (select"from" as "user",e.name as ens_name,sum("value") / power(10, 18) as "Total ETH per user"from ethereum.transactions tleft join labels.ens eon t."from" = e.addresswhere "to" = 0xA62F9C5af106FeEE069F38dE51098D9d81B90572group by "from", e.nameorder by "Total ETH per user" desc),stake_dates AS (SELECT"from" AS "user",MIN(block_time) AS stake_dateFROM ethereum.transactionsWHERE "to" = 0xA62F9C5af106FeEE069F38dE51098D9d81B90572GROUP BY 1),withdrawals AS (SELECTaccount AS "user",SUM(actualAmount / 1e18) AS total_unstaked,MAX(evt_block_time) AS last_unstake_dateFROM stakestone_v1_ethereum.stonevault_evt_withdrawnfromstrategyGROUP BY account),last_activity AS (SELECTuser,MAX(ts) AS last_activity_timeFROM (SELECT "from" AS user, block_time AS tsFROM ethereum.transactionsWHERE "to" = 0xA62F9C5af106FeEE069F38dE51098D9d81B90572UNION ALLSELECT account AS user, evt_block_time AS tsFROM stakestone_v1_ethereum.stonevault_evt_withdrawnfromstrategy) xGROUP BY user),-- Withdrawals are internal traces, not top-level transactionsvault_withdrawers AS (SELECT DISTINCT "to" AS "user"FROM ethereum.tracesWHERE "from" = 0x9485711f11b17f73f2ccc8561bcae05bdc7e9ad9AND "to" IS NOT NULLAND success = trueAND tx_success = trueAND type = 'call'AND value > 0)SELECTb.user,b.ens_name,b."Total ETH per user" AS total_staked_all_time,