with
token_transfers as (
select
date_trunc('day', block_timestamp) as day,
sum(raw_amount / pow(10, 18)) as daily_transfer
from
polygon.core.fact_token_transfers
where
from_address = '0x0000000000000000000000000000000000000000'
and contract_address = lower('0x15848C9672e99be386807b9101f83A16EB017bb5')
group by
day
)
select
*,
sum(daily_transfer) over (
order by
day
) as cumulative_xMetric_transferred
from
token_transfers