select

DATE_TRUNC('week', BLOCK_TIMESTAMP) AS Week,

ACCOUNT_ADDRESS as user_address,

sum(BALANCE - PRE_BALANCE) as balance_Change

from solana.core.fact_token_balances

where MINT = 'MEW1gQWJ3nEXg2qgERiKu7FAFj79PHvQVREQUzScPP5'

group by 1,2

),

holders_dates as (

select

date_trunc(week, DATE_DAY) as DATE_DAY,

user_address

from

crosschain.core.dim_dates

cross join change

where

DATE_DAY between (

select

min(Week) as min_date

from

change

)

and current_date()

),

balance AS (

SELECT

DATE_DAY,

holders_dates.user_address,

COALESCE(change.balance_Change, 0) AS balance_change

FROM

holders_dates

left join change on holders_dates.DATE_DAY = change.Week

and holders_dates.user_address = change.user_address

),

cumulative_balance AS (