SELECT

DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS DAY,

SUM(CASE WHEN from_address = LOWER('0x0000000000000000000000000000000000000000')

THEN CAST(RAW_AMOUNT_PRECISE as NUMERIC)/1e18 ELSE 0 END) AS ezEIGEN_MINTED,

SUM(CASE WHEN to_address = LOWER('0x0000000000000000000000000000000000000000')

THEN CAST(RAW_AMOUNT_PRECISE as NUMERIC)/1e18 ELSE 0 END) AS ezEIGEN_BURNED

FROM ethereum.core.fact_token_transfers

WHERE CONTRACT_ADDRESS = LOWER('0xd4fcde9bb1d746Dd7e5463b01Dd819EE06aF25db')

GROUP BY DAY

SELECT

DAY,

ezEIGEN_MINTED,

ezEIGEN_BURNED,

SUM(ezEIGEN_MINTED - ezEIGEN_BURNED) OVER (ORDER BY DAY) AS CUMULATIVE_ezEIGEN

FROM DailyCount

ORDER BY DAY;