select date_trunc('week', block_timestamp) as date,

'Mint' as type,

mint_amount/1e9 as amount

from solana.defi.fact_token_mint_actions

where mint = '4vMsoUT2BWatFweudnQM1xedRLfJgJ7hswhcpz4xgBTy'

and block_timestamp::date >= '2023-01-01'

UNION ALL

select date_trunc('week', block_timestamp) as date,

'Burn' as type,

burn_amount/1e9 as amount

from solana.defi.fact_token_burn_actions

where mint = '4vMsoUT2BWatFweudnQM1xedRLfJgJ7hswhcpz4xgBTy'

and block_timestamp::date >= '2023-01-01'

select date,

sum(zeroifnull(case when type = 'Mint' then amount end)) as "Mint Amount",

sum(zeroifnull(case when type = 'Burn' then -amount end)) as "Burn Amount",

"Mint Amount" + "Burn Amount" as net_amount,

sum("Mint Amount") over (order by date) as "Total Mint",

sum("Burn Amount") over (order by date) as "Total Burn",

sum(net_amount) over (order by date) as "Net Change"

from base

group by date

order by date desc