cindieMango DAO dates
Updated 2022-08-18Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
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