flipside

    Metaplex Foundation Date of Last Proposal
    Soheil_MKMetaplex Foundation Date of Last Proposal
    Updated 2022-08-14
    With T1 as (
    SELECT
    distinct PROPOSAL,
    min(BLOCK_TIMESTAMP) as mindate
    from solana.core.fact_proposal_votes
    where PROGRAM_NAME='GmtpXy362L8cZfkRmTZMYunWVe8TyRjX5B7sodPZ63LJ'
    group by 1
    order by 2 desc
    )

    SELECT
    max(mindate)::date as date
    from T1

    Run a query to Download Data