Crazy_KidActive Daily Wallets Algorand
    Updated 2022-03-01
    WITH jan2022 AS (SELECT date(block_timestamp) as date_jan_2022, COUNT(DISTINCT sender) as active_wallets_jan_2022,
    ROW_NUMBER() OVER (ORDER BY date_jan_2022) as row1
    FROM algorand.transactions
    WHERE date_jan_2022 BETWEEN '2022-01-01' AND '2022-01-31'
    GROUP BY date_jan_2022
    ORDER BY date_jan_2022),

    dec2021 AS (SELECT date(block_timestamp) as date_dec_2021, COUNT(DISTINCT sender) as active_wallets_dec_2021,
    ROW_NUMBER() OVER (ORDER BY date_dec_2021) as row2
    FROM algorand.transactions
    WHERE date_dec_2021 BETWEEN '2021-12-01' AND '2021-12-31'
    GROUP BY date_dec_2021
    ORDER BY date_dec_2021),

    jan2021 AS (SELECT date(block_timestamp) as date_jan_2021, COUNT(DISTINCT sender) as active_wallets_jan_2021,
    ROW_NUMBER() OVER (ORDER BY date_jan_2021) as row3
    FROM algorand.transactions
    WHERE date_jan_2021 BETWEEN '2021-01-01' AND '2021-01-31'
    GROUP BY date_jan_2021
    ORDER BY date_jan_2021)

    SELECT date_jan_2022, active_wallets_jan_2022, date_dec_2021, active_wallets_dec_2021, date_jan_2021, active_wallets_jan_2021
    FROM jan2022
    JOIN dec2021 ON row1 = row2
    JOIN jan2021 ON row1 = row3
    ORDER BY row1

    Run a query to Download Data