EVENTS | VOTERS | AVG_VOTES | |
|---|---|---|---|
1 | 333780 | 23504 | 14.200987 |
Pine AnalyticsBribe Overall (1)
Updated 2025-01-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with tab1 AS (
SELECT DISTINCT tx_hash
FROM base.core.fact_event_logs --
WHERE tx_hash in (
SELECT tx_hash
FROM base.core.fact_transactions
WHERE to_address LIKE '0x16613524e02ad97edfef371bc883f2f5d6c480a5'
)
AND origin_function_signature like '0x7ac09bf7'
)
SELECT
count(DISTINCT tx_hash) as events,
count(DISTINCT from_address) as voters,
events/voters as avg_votes
FROM base.core.fact_transactions
WHERE tx_hash in (SELECT * from tab1)
Last run: 15 days ago
1
26B
480s