headitmanageractive timwe
Updated 2022-06-19
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with newuser as (select min(block_timestamp::date) as first_transaction,tx_from from osmosis.core.fact_transactions
group by tx_from)
, governance as (select min(block_timestamp::date) as first_vote,voter from osmosis.core.fact_governance_votes
group by voter )
,avgdays as (select avg(datediff('day',first_transaction,first_vote)) as avg_days ,
max(datediff('day',first_transaction,first_vote)) as max_days
from newuser inner join governance
on newuser.tx_from=governance.voter)
select * from avgdays
Run a query to Download Data