mattkstewosmosis 8
Updated 2023-01-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with tab1 as (
select
voter,
min(block_timestamp) as date1
from osmosis.core.fact_governance_votes
group by 1 )
, tab2 as (
select
date_trunc('week', date1) as date1 ,
count(*) as count1
from tab1
group by 1 )
select
date1,
sum(count1) over (order by date1 )
from tab2
Run a query to Download Data