MLDZMNstdis1
99
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
›
⌄
with pro as (select
tx_signer,
s.tx_hash as proposal
from near.core.fact_transactions s
left join near.core.fact_actions_events_function_call a on a.tx_hash = s.tx_hash
left join near.core.dim_address_labels b ON b.address = s.tx_receiver
where s.block_timestamp>=dateadd('year', -2, current_date)
and s.tx_status = 'Success'
and method_name = 'add_proposal'
and label_type = 'dao'
),
tb1 as (
select
'Osmosis' as network,
VOTER,
count(distinct PROPOSAL_id) as no_proposals
from osmosis.core.fact_governance_votes
where TX_SUCCEEDED = 'TRUE'
group by 1,2
union all
select
'Solana' as network,
VOTER,
count(distinct PROPOSAL) as no_proposals
from solana.core.fact_proposal_votes
where BLOCK_TIMESTAMP >= dateadd('year', -2, current_date)
and SUCCEEDED = 'TRUE'
group by 1,2
union all
select
'NEAR' as network,
s.tx_signer as VOTER,
count(distinct proposal) as no_proposals
from near.core.fact_transactions s
Run a query to Download Data