LittlerDataWhen did they arrive
Updated 2022-08-28Copy 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 voters as(
select
lower(voter) as voter,
count(proposal_id)
from ethereum.core.ez_snapshot
where proposal_id in ('0x276aeadbc8c68117dc677e6db275891281384e0dfe7c90d5b149389aa60eab32','QmfLwPbo5UwnyvkXo7emsSMDMFCr8UtJ76n87v9Rf7gEuH',
'0xd2145fbd7da19d3247e7b40d45cbea71bd8b6e1a860b6f3b1630f33e9587f585','0x4099606ae52125cc0f581dd0f7b0a4af6e0cf59527ac5a6fae9ab36fa1f8caf8',
'0x43ac378552db2eadf4ff031dd728c524cee09be64f3e9eed0e23810160860237')
group by voter),
dos as (
select
from_address,
min(block_timestamp)::date as day
from ethereum.core.fact_transactions
where from_address in (select voter from voters)
group by 1
)
select
day,
count(from_address)
from dos
group by 1
-- 0xaf3a6d69c62a7ff323da5958a515c5bd4efdfbcc29ba644e845cc66dbef9958c -> dunjia.eth -> Are you a robot?
-- 0xa9f1f8782ab83b1e3af941d12c491b2e44e70d7add4e701125c773d34e50020d -> birdspath.eth -> Are you a robot?
-- 0x471d496bf06f7444046d9fc532b01bffe1eb5aa942f68588e7c8f55f9a47aed9 -> alwayslovedaisy.eth - > Are you a robot?
-- 0x214d406dc0b5f29527cac5b2d4217697c910c7d368321a825e01f67d89f0eca4 -> hodlbeer.eth - >
-- 0x276aeadbc8c68117dc677e6db275891281384e0dfe7c90d5b149389aa60eab32 -> thegurudao - > [Proposal] What option will bots prefer?
-- QmfLwPbo5UwnyvkXo7emsSMDMFCr8UtJ76n87v9Rf7gEuH -> ens.eth -> What option will bots prefer?
-- 0x499aec6c39586a76a374e0019896b9865e171a6e0ff1ce8907ecc736a6e944af -> arrebol.eth -> What option will bots prefer?
--0x62bf3aa1c67d73ff85d363975d2aa4ff1f9f04cf743e2f4d35b7b3a0bb2206d4 -> 0xb777.eth -> What option will bots prefer?
-- 0x9afb8c5524e7488f59ae73b349079b93d17c884d0255c3ace7b4d1f2a86731c1 -> wrapbitcoin.eth ->[Proposal] What option will bots prefer?
Run a query to Download Data