TX_FROM,

min(BLOCK_TIMESTAMP::date) as first_tx

from osmosis.core.fact_transactions

group by 1

,first_vote as (

select

voter,

min(BLOCK_TIMESTAMP::date) as first_vote

from osmosis.core.fact_governance_votes

group by 1

,time_diff as (select

voter,

first_tx,

first_vote,

DATEDIFF(day,first_tx, first_vote ) as time_dif

from first_tx t join first_vote v on t.tx_from = v.voter

select

avg (time_dif) from time_diff