*,

sum(net_mint) over (ORDER by day) as supply

FROM (

SELECT

date(block_timestamp) as day,

sum(CASE when from_address LIKE '0x0000000000000000000000000000000000000000' then raw_amount / power(10, 18) else -1 * raw_amount / power(10, 18) end) as net_mint

FROM base.core.fact_token_transfers

WHERE contract_address LIKE lower('0x940181a94A35A4569E4529A3CDfB74e38FD98631')

AND (from_address LIKE '0x0000000000000000000000000000000000000000'

OR to_address LIKE '0x0000000000000000000000000000000000000000'

GROUP BY 1