select owner wallet,

balance

from (

select owner,

balance,

row_number() over (partition by owner order by BLOCK_TIMESTAMP desc) as rn

from solana.core.fact_token_balances

where mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'

-- and BLOCK_TIMESTAMP::date >= '2024-01-01'

and balance > 1e-9

) ranked

where rn = 1

),

MSOL_PRICE as (

select

date_trunc(day,hour)::date date ,

symbol ,

median (price) price_usd

from solana.price.ez_prices_hourly

where token_address ='mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'

and date_trunc(day,hour)::date >= current_date

group by 1 ,2

),

SOL_price as (

SELECT

date_trunc('day', hour)::date as date,

symbol,

median(price) as price_usd

FROM solana.price.ez_prices_hourly

WHERE symbol = 'SOL'

AND date_trunc('day', hour)::date = CURRENT_DATE

GROUP BY 1, 2

),

txns as (

with stake_txns as (