SELECT

from_address AS sender,

to_address AS receiver,

CAST(amount AS FLOAT) AS amount,

DATE(block_timestamp) AS transfer_date

FROM ronin.core.ez_token_transfers

WHERE contract_address = LOWER('0x656fe582b4c6dc95c598ea54dc820eb36152e2f7')

),

running_balances AS (

SELECT

transfer_date,

account,

SUM(balance_change) OVER (

PARTITION BY account

ORDER BY transfer_date

ROWS UNBOUNDED PRECEDING

) AS total_balance

FROM (

SELECT receiver AS account, amount AS balance_change, transfer_date

FROM token_transfers

WHERE receiver != '0x0000000000000000000000000000000000000000'

UNION ALL

SELECT sender AS account, -amount AS balance_change, transfer_date

FROM token_transfers

WHERE sender != '0x0000000000000000000000000000000000000000'

) AS balances

),

daily_holders AS (

SELECT

transfer_date AS "Date",

COUNT(DISTINCT CASE WHEN total_balance > 0.000001 THEN account END) AS "Total CGX Holders"

FROM running_balances

GROUP BY transfer_date