flipside

    soa7
    ramojosoa7
    Updated 2022-08-28
    with tab1 as (
    select
    PROPOSAL_TITLE,
    min(PROPOSAL_START_TIME) as start1,
    min(PROPOSAL_END_TIME) as end2
    from ethereum.core.ez_snapshot
    group by 1
    )

    select
    avg(datediff('day', start1, end2))
    from tab1
    Run a query to Download Data