ML6Activity Average time
    Updated 2022-06-19
    with tbl1 as (
    select TX_FROM,min(BLOCK_TIMESTAMP) as ftransact
    from
    osmosis.core.fact_transactions
    group by 1)

    , tbl2 as (
    select PROPOSER,min(BLOCK_TIMESTAMP) as fsubmit
    from osmosis.core.fact_governance_submit_proposal
    group by 1 )

    select avg(fsubmit::date - ftransact::date)
    from tbl1
    inner join tbl2
    on proposer=tx_from
    Run a query to Download Data