with
MonthlyBalanceData as (
select
date_trunc('month', block_timestamp) as month,
from_address as user,
sum(amount) as total_balance
from base.core.ez_token_transfers
where contract_address = '0x04d5ddf5f3a8939889f11e97f8c4bb48317f1938'
AND block_timestamp >= '2024-01-01'
group by month, user
),
CumulativeBalance as (
select
month,
sum(total_balance) as total_holders_balance
from MonthlyBalanceData
group by month
)
select
month as time,
total_holders_balance
from CumulativeBalance
order by time