Query editor
WITH YT_TXN AS (SELECT"from" AS sender, "to" AS recipient, "value" AS token_value, evt_block_dateFROM erc20_hyperevm.evt_transferWHERE contract_address = 0x3f6583ad479ab6020297ce12c9059d7480ab6e5aAND ("from" = 0x720a68bf0813853cd3ed74d2fd0f54edfc7a43e1OR"to" = 0x720a68bf0813853cd3ed74d2fd0f54edfc7a43e1)), TOTAL_RECEIVED AS (SELECTrecipient, evt_block_date, SUM(token_value) AS sum_receivedFROM YT_TXNGROUP BY 1, 2), TOTAL_SENT AS (SELECTsender, evt_block_date, SUM(token_value) AS sum_sentFROM YT_TXNGROUP BY 1, 2), weekly_change AS (SELECTtr.evt_block_date, (CAST(tr.sum_received AS INT256) - CAST(COALESCE(ts.sum_sent, 0) AS INT256)) / POWER(10, 18) AS token_changeFROM TOTAL_RECEIVED trLEFT JOIN TOTAL_SENT tsON tr.recipient = ts.sender)SELECTevt_block_date, token_change, SUM(token_change) OVER (ORDER BY evt_block_date ASC) AS token_balanceFROM weekly_change