zakkisyed#4 Nouns: Voting activity
Updated 2022-07-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
select t1.timeperiod,t1.tokenid, t2.proposal_id
from
(
select date_trunc(day,block_timestamp) as timeperiod, tokenid
from ethereum.core.ez_nft_mints
where nft_address = lower('0x9C8fF314C9Bc7F6e59A9d9225Fb22946427eDC03')
) as t1
INNER JOIN (
select date_trunc(day,block_timestamp) as timeperiod,
event_inputs:proposalId::number as proposal_id
from ethereum.core.fact_event_logs
where contract_address=lower('0x6f3E6272A167e8AcCb32072d08E0957F9c79223d')
and event_name = 'VoteCast'
group by 2,1
order by 1 asc
) as t2
ON t1.timeperiod=t2.timeperiod
order by 3
Run a query to Download Data