day,

SUM(mint_stAPT) OVER (ORDER BY day ASC) AS mint_stAPT,

SUM(burn_stAPT) OVER (ORDER BY day ASC) AS burn_stAPT,

SUM(mint_stAPT - burn_stAPT) OVER (ORDER BY day ASC) AS supply_stAPT

FROM (

SELECT

date_trunc('day', BLOCK_TIMESTAMP) AS day,

SUM(CASE WHEN EVENT_TYPE = '0x1::coin::DepositEvent' THEN EVENT_DATA ['amount'] / 10e8 ELSE 0 END) AS mint_stAPT,

SUM(CASE WHEN EVENT_TYPE = '0x1::coin::WithdrawEvent' THEN EVENT_DATA ['amount'] / 10e8 ELSE 0 END) AS burn_stAPT

FROM

aptos.core.fact_events

WHERE

ACCOUNT_ADDRESS = '0xd11107bdf0d6d7040c6c0bfbdecb6545191fdf13e8d8d259952f53e1713f61b5'

GROUP BY date_trunc('day', BLOCK_TIMESTAMP)

) AS subquery

ORDER BY day;

-- SELECT tx_hash, event_data['amount']/10e8 from aptos.core.fact_events

-- WHERE ACCOUNT_ADDRESS = '0xd11107bdf0d6d7040c6c0bfbdecb6545191fdf13e8d8d259952f53e1713f61b5' and

--EVENT_TYPE = '0x1::coin::DepositEvent' AND BLOCK_TIMESTAMP > '2021-01-01'

-- MINT: 0xd11107bdf0d6d7040c6c0bfbdecb6545191fdf13e8d8d259952f53e1713f61b5::stapt_token::MintEvent

-- BURN: 0xd11107bdf0d6d7040c6c0bfbdecb6545191fdf13e8d8d259952f53e1713f61b5::stapt_token::BurnEvent

-- SUM(CASE WHEN EVENT_TYPE = '' EVENT_DATA['added_x_val'] / 10e8 ELSE 0 END) AS total_added_stAPT,