select
trunc(block_timestamp,'day') as date,
--event_data:source as type,
count(distinct tx_id) as claims,
sum(event_data:amount) as points_minted,
sum(points_minted) over (order by date) as total_points_minted,
count(distinct event_data:userAddr) as active_minters
from flow.core.fact_events
where
block_timestamp>'2024-03-01'
and event_contract='A.2093c0861ff1bd80.IncrementPoints'
and event_type='PointsMinted'
group by 1 order by 1 desc