date_trunc('week', block_timestamp) as week,

sum(CASE when from_address like '0x0000000000000000000000000000000000000000' then RAW_AMOUNT_PRECISE / power(10,18) else 0 end) as mint_amount,

sum(CASE when to_address like '0x0000000000000000000000000000000000000000' then RAW_AMOUNT_PRECISE / power(10,18) else 0 end) as burn_amount,

mint_amount - burn_amount as net_supply,

sum(net_supply) over (order by week) as supply

from base.core.fact_token_transfers

WHERE contract_address LIKE lower('0xFF0C532FDB8Cd566Ae169C1CB157ff2Bdc83E105')

GROUP BY 1

ORDER by 1 DESC