date,

type,

points_minted,

total_points_minted,

SUM(points_minted) OVER () AS total_points_minted_overall

FROM (

SELECT

TRUNC(block_timestamp,'day') AS date,

event_data:source AS type,

SUM(event_data:amount) AS points_minted,

SUM(SUM(event_data:amount)) OVER (PARTITION BY event_data:source ORDER BY TRUNC(block_timestamp,'day')) AS total_points_minted

FROM

flow.core.fact_events

WHERE

block_timestamp > '2024-03-01'

AND event_contract = 'A.2093c0861ff1bd80.IncrementPoints'

AND event_type = 'PointsMinted'

AND event_data:userAddr = '{{wallet}}'

GROUP BY

1, 2

ORDER BY

1 DESC

) AS subquery;