LTirrell2. Algo governance -- all wallets up to 10-10
    Updated 2022-01-11
    -- - 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