msafadoostsmaller holders votes
Updated 2022-06-17
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
›
⌄
WITH holders AS (
SELECT max(BLOCK_TIMESTAMP),
--TOKENID,
NFT_TO_ADDRESS,
COUNT(TOKENID) AS counts
FROM ethereum.core.ez_nft_transfers
WHERE NFT_ADDRESS = lower('0x4b10701Bfd7BFEdc47d50562b76b436fbB5BdB3B')
AND NFT_TO_ADDRESS NOT IN (
'0xd5f279ff9eb21c6d40c8f345a66f2751c4eea1fb',
'0x55e0f7a3bb39a28bd7bcc458e04b3cf00ad3219e'
)
GROUP by 2 HAVING(counts < 2)
ORDER by 3 DESC
)
select --DATE(BLOCK_TIMESTAMP),
--ORIGIN_FROM_ADDRESS,
COUNT(ORIGIN_FROM_ADDRESS)
from ethereum.core.fact_event_logs
where ORIGIN_TO_ADDRESS = '0x5d2c31ce16924c2a71d317e5bbfd5ce387854039'
AND EVENT_NAME = 'VoteCast'
AND ORIGIN_FROM_ADDRESS IN (
SELECT NFT_TO_ADDRESS FROM holders
)
--GROUP by 1
--ORDER by 2 DESC
Run a query to Download Data