princefarzamgovernance vs. non-governance
    Updated 2022-02-10
    WITH Time as(
    SELECT
    block_timestamp,
    block_id
    FROM algorand.block
    ),
    Addresses as(
    SELECT
    ADDRESS,
    CREATED_AT
    FROM algorand.account
    ),
    ADDR_IN_GOVERN_PERIOD1 as (
    SELECT
    date_trunc('day', T.block_timestamp) AS day,
    COUNT(DISTINCT AD.ADDRESS) AS UNIQUE_ADDRESSES_IN_GOVERN_PERIOD1
    FROM Addresses AD INNER JOIN Time T ON AD.CREATED_AT=T.block_id
    WHERE day::date >= '2021-09-20'
    AND day::date <= '2021-10-14'
    GROUP BY day
    ORDER BY day ASC
    ),
    ADDR_IN_GOVERN_PERIOD2 as (
    SELECT
    date_trunc('day', T.block_timestamp) AS day,
    COUNT(DISTINCT AD.ADDRESS) AS UNIQUE_ADDRESSES_IN_GOVERN_PERIOD2
    FROM Addresses AD INNER JOIN Time T ON AD.CREATED_AT=T.block_id
    WHERE day::date >= '2021-12-24'
    AND day::date <= '2022-01-07'
    GROUP BY day
    ORDER BY day ASC
    ),
    ADDR_IN_ALL_PERIODS as (
    SELECT
    Run a query to Download Data