*,

sum(net_mint) over (order by hour) as total_supply

FROM (

SELECT

date_trunc('hour', block_timestamp) as hour,

date_trunc('day', block_timestamp) as day,

sum(CASE when from_address = '0x0000000000000000000000000000000000000000' then amount end) as mint,

sum(CASE when to_address = '0x0000000000000000000000000000000000000000' then amount end) as burn,

sum(CASE when from_address = '0x0000000000000000000000000000000000000000' then amount else 0 end) - sum(CASE when to_address = '0x0000000000000000000000000000000000000000' then amount else 0 end) as net_mint

from ethereum.core.ez_token_transfers

WHERE contract_address = lower('0x40d16fc0246ad3160ccc09b8d0d3a2cd28ae6c2f')

GROUP BY 1,2