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
),
AverageBalance as (
select
month,
avg(total_balance) as avg_balance
from MonthlyBalanceData
group by month
)
select
month as time,
avg_balance
from AverageBalance
order by time