WITH transfers AS (

SELECT

date_trunc('week', block_timestamp) AS date,

CASE

WHEN from_address = '0x0000000000000000000000000000000000000000' THEN (RAW_AMOUNT / power(10, 8))

ELSE -(RAW_AMOUNT / power(10, 8))

END AS value1

FROM avalanche.core.fact_token_transfers

WHERE (

from_address = '0x0000000000000000000000000000000000000000'

OR to_address = '0x0000000000000000000000000000000000000000'

) AND contract_address = lower('0x152b9d0FdC40C096757F570A51E494bd4b943E50')

), cumulative_supply AS (

SELECT

*,

sum(value1) OVER (ORDER BY date) AS cumulative_supply

FROM transfers

SELECT

date,

sum(CASE WHEN value1 > 0 THEN value1 ELSE 0 END) AS weekly_mint,

sum(CASE WHEN value1 < 0 THEN -value1 ELSE 0 END) AS weekly_burn,

sum(value1) AS net_mint,

cumulative_supply

FROM cumulative_supply

GROUP BY date, cumulative_supply

ORDER BY date DESC;