Afonso_DiazOvertime
Updated 2024-11-20
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
date_trunc('{{ period }}', block_timestamp) as date,
count(distinct tx_hash) as transactions,
count(distinct service_id) as services,
sum(transactions) over (order by date) as cumulative_transactions
from
crosschain.olas.fact_service_events
where block_timestamp >= '2024-01-01'
group by 1
order by 1
QueryRunArchived: QueryRun has been archived