cindieMango DAO dates
    Updated 2022-08-18
    with last_proposal as (
    select proposal as last_proposal,
    date(min(block_timestamp)) as date_of_last_proposal
    from
    solana.core.fact_proposal_votes
    where
    realms_id = 'DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE'
    group by 1
    order by 2 desc
    limit 1
    ), other_metrics as (
    select
    date(min(block_timestamp)) as realms_date_of_creation
    from solana.core.fact_proposal_votes
    where
    realms_id = 'DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE'
    )
    select * from last_proposal join other_metrics

    Run a query to Download Data