flipside

    Snapshot 3.55
    mattkstewSnapshot 3.55
    Updated 2022-08-12
    with tab1 as (
    select
    PROPOSAL_TITLE,
    min(PROPOSAL_START_TIME) as start1,
    min(PROPOSAL_END_TIME) as end2 -- min won't effect they are always the same.
    from ethereum.core.ez_snapshot
    group by 1
    )

    select
    max(datediff('day', start1, end2))
    from tab1

    Run a query to Download Data