-- SOL addresses

WITH wallets_with_significant_balance AS (

-- Find all records where wallets have >5M tokens between Nov 19-Dec 31

SELECT

owner,

block_timestamp,

balance

FROM solana.core.fact_token_balances

WHERE mint = '3E2z4KX7y457xJqK9RQeJhA29oPdoUvAAD3Ea3zQyuG3'

AND block_timestamp >= '2024-11-19 00:00:00.000'

AND block_timestamp < '2024-12-31 00:00:00.000'

AND balance > 5000000

),

earliest_significant_balances AS (

-- For each wallet, find the earliest timestamp where they had a significant balance

SELECT

owner as whale,

MIN(block_timestamp) as earliest_timestamp

FROM wallets_with_significant_balance

GROUP BY owner

),

whale_balances_nov AS (

-- Get the balance at that earliest timestamp where they had a significant amount

SELECT

esb.whale,

ftb.balance as balance_nov