*,

sum(Daily_net_xmetric) over (ORDER by day) as total_xmetric_payed_out

FROM (

SELECT

date_trunc('day', block_timestamp) as day,

sum(raw_amount / power(10,18)) as Daily_net_xmetric

FROM polygon.core.fact_token_transfers

WHERE FROM_ADDRESS LIKE lower('0x0000000000000000000000000000000000000000')

AND contract_address LIKE lower('0x15848C9672e99be386807b9101f83A16EB017bb5')

GROUP BY 1