SELECT

TO_ADDRESS AS address

, SUM(AMOUNT) AS amount_in

FROM base.core.ez_token_transfers

WHERE CONTRACT_ADDRESS = lower('0x0b3e328455c4059EEb9e3f84b5543F74E24e7E1b')

AND block_timestamp <= '2024-12-31'

GROUP BY address

),

outflows AS (

SELECT

FROM_ADDRESS AS address

, SUM(AMOUNT) AS amount_out

FROM base.core.ez_token_transfers

WHERE CONTRACT_ADDRESS = lower('0x0b3e328455c4059EEb9e3f84b5543F74E24e7E1b')

AND block_timestamp <= '2024-12-31'

GROUP BY address

),

vt_holders AS (

SELECT

COALESCE(inn.address, out.address) AS wallet,

(COALESCE(inn.amount_in, 0) - COALESCE(out.amount_out, 0)) AS tokens_held, -- Calculate net balance

RANK() OVER (ORDER BY tokens_held DESC) AS rank

FROM inflows AS inn

FULL OUTER JOIN outflows AS out

ON inn.address = out.address

WHERE tokens_held > 10

ORDER BY tokens_held DESC

),

vvv_claimed AS (

SELECT

to_address

, amount

FROM base.core.ez_token_transfers

WHERE from_address = lower('0x0BD4078E15EeA5ac22a0e6f215C27286920FDA1A')