RamaharLilNouns Voters Trend
Updated 2022-06-18Copy Reference Fork
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 T1 as (select
m.block_timestamp,
m.tx_hash,
m.event_type,
m.nft_address,
m.tokenid,
m.nft_count,
n.from_address as minters
from ethereum.core.ez_nft_mints m
left join ethereum.core.fact_transactions n ON m.tx_hash = n.tx_hash
where nft_address = '0x4b10701bfd7bfedc47d50562b76b436fbb5bdb3b' ),
votingdetails as (select
DATE(block_timestamp) as dayz,
event_inputs:proposalId::float as proposal,
event_inputs:voter::string as voters,
event_inputs:votes::float as vote_counts
from ethereum.core.fact_event_logs
where
contract_address = '0x5d2c31ce16924c2a71d317e5bbfd5ce387854039'
and event_name = 'VoteCast'
and tx_status = 'SUCCESS'),
T2 as (select
minters,
sum(nft_count) as LilNounsAmount --wallets minted Lil Nouns amount
from T1
group by 1
order by 2 DESC ),
T3 as (select
minters,
LilNounsAmount,
proposal,
vote_counts
from T2
Run a query to Download Data