jkhuhnke11Osmosis Governance Voters Vs All Wallets
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
›
⌄
WITH govy_transfers AS (
SELECT
block_timestamp :: date AS day,
tx_from
FROM osmosis.core.fact_transactions
WHERE tx_from IN (
SELECT
DISTINCT voter
FROM osmosis.core.fact_governance_votes
)
),
non_govy_transfers AS (
SELECT
block_timestamp :: date AS day,
tx_from
FROM osmosis.core.fact_transactions
WHERE tx_from NOT IN
(
SELECT
DISTINCT voter
FROM osmosis.core.fact_governance_votes
)
)
SELECT
g.day,
count(DISTINCT g.tx_from) AS govy_swapper,
count(DISTINCT n.tx_from) AS no_govy_swapper
FROM govy_transfers g
LEFT OUTER JOIN non_govy_transfers n
ON g.day = n.day
GROUP BY g.day
Run a query to Download Data