SELECT date, sum(case when action = 'Mint' then amnt else -1*amnt end) as net_minted,

sum(net_minted)over (order by date) as circulating_supply

SELECT 'Mint' as action,

date_trunc('week',block_timestamp) as date,

sum(decoded_log:value)/pow(10,18) as amnt,

count(DISTINCT decoded_log:beneficiary) as n_users

FROM avalanche.core.fact_decoded_event_logs

WHERE contract_address = '0x7ee65fdc1c534a6b4f9ea2cc3ca9ac8d6c602abd'

AND event_name = 'Mint'

group by date

SELECT 'Burn' as action,

date_trunc('week',block_timestamp) as date,

sum(decoded_log:value)/pow(10,18) as amnt,

count(DISTINCT decoded_log:account) as n_users

FROM avalanche.core.fact_decoded_event_logs

WHERE contract_address = '0x7ee65fdc1c534a6b4f9ea2cc3ca9ac8d6c602abd'

AND event_name = 'Burn'

group by date

group by 1

ORDER by date DESC