select date_Trunc ({{Time_Interval}},block_timestamp) as date,
blockchain,
count (distinct tx_hash) as requests,
sum (requests) over (partition by blockchain order by date asc) as Cumulative_Requests
from crosschain.olas.fact_mech_activity
group by 1,2
order by 1 desc