LTirrell2. Algo governance -- all wallets up to 10-10
Updated 2022-01-11
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
›
⌄
-- - What percentage of non-closed wallets have committed to Algorand governance? How many wallets total is this?
-- - What percent of wallets committed to period 1?
-- - What percent of wallets committed to period 2?
-- - What percent of wallets committed to period 1 and period 2?
-- Some useful information came from discord here:
-- https://discord.com/channels/784442203187314689/912364770546573384/930140978218676284
-- https://discord.com/channels/784442203187314689/912364770546573384/929808160120778824
with datetime_info AS (
SELECT
block_id,
block_timestamp
FROM
algorand.block
),
gov_info as (
select
try_base64_decode_string(tx_message :txn :note) as gov,
block_id,
sender,
amount,
receiver,
tx_id,
asset_id,
tx_type,
tx_type_name
from
algorand.payment_transaction
where
gov like '%af/gov1%'
and block_id > 16520000 -- date close to when the first governance signup period opened (1 Octo 2020)
),
account_info as (
select
address,
Run a query to Download Data