Ali3NOver-Time Mech Rquests
    Updated 2024-08-04
    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