Yousefi_1994Date of Last Proposal for each Realms DAOs
Updated 2022-08-17
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
----------------------------- Mango ---------------------------
with mango_proposal as (
select
proposal,
min(block_timestamp) as first_date
from solana.core.fact_proposal_votes
where realms_id = 'DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE'
and governance_platform = 'realms'
and succeeded = true
group by proposal
),
mango_proposal_row_number as (
select
proposal as "Last Proposal",
first_date as "Date of Last Proposal",
row_number() over(order by first_date desc) as row_num
from mango_proposal
),
----------------------------- Grape ---------------------------
grape_proposal as (
select
proposal,
min(block_timestamp) as first_date
from solana.core.fact_proposal_votes
where realms_id = 'By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip'
and governance_platform = 'realms'
and succeeded = true
group by proposal
),
grape_proposal_row_number as (
select
proposal as "Last Proposal",
first_date as "Date of Last Proposal",
row_number() over(order by first_date desc) as row_num
from grape_proposal
),
Run a query to Download Data