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 eEIGEN_MINTED,

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

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

FROM ethereum.core.fact_token_transfers

WHERE CONTRACT_ADDRESS = LOWER('0xE77076518A813616315EaAba6cA8e595E845EeE9')

GROUP BY DAY

SELECT

DAY,

eEIGEN_MINTED,

eEIGEN_BURNED,

SUM(eEIGEN_MINTED - eEIGEN_BURNED) OVER (ORDER BY DAY) AS CUMULATIVE_eEIGEN

FROM DailyCount

ORDER BY DAY;