---------------------------- GENERATE SAMPLE SPACE ---------------------------------

with wallets as (

SELECT

DISTINCT wallet, pubkey

from (

SELECT DISTINCT pubkey, depositor as wallet

FROM ethereum.beacon_chain.ez_deposits

WHERE 1=1

qualify row_number() OVER (PARTITION BY pubkey ORDER BY block_timestamp DESC) =1

--AND WITHDRAWAL_ADDRESS = '0x15dace490e3bee63ba9c2695ea6d29a78360dd96'

UNION ALL

SELECT

DISTINCT t.pubkey, depositor as wallet

--, d.withdrawal_address

--, d.depositor

from ethereum.beacon_chain.ez_withdrawals w

LEFT JOIN (

SELECT

*

, row_number() OVER (PARTITION BY pubkey ORDER BY slot_number DESC) as ranks

from ethereum.beacon_chain.fact_validators

QUALIFY ranks=1

) t on w.validator_index = t.index

LEFT JOIN (

SELECT *

FROM ethereum.beacon_chain.ez_deposits

qualify row_number() OVER (PARTITION BY pubkey ORDER BY block_timestamp DESC) =1

) d ON t.pubkey = d.pubkey

WHERE 1=1

--AND t.pubkey = '0x8a4f2e7e2fea00a9ce77d669aeba2573137010db2f85e18c0265e492d3a9b5367e15f356abd58b2bfb3a3bddef9aece9'