lagandispenserNumber of new Algorand wallets
    Updated 2022-06-14
    -- WHERE block_timestamp >= '2022-05-1'
    -- AND block_timestamp <= '2021-05-31'

    SELECT count(address) as total_new_wallets ,
    date_trunc('day',b.block_timestamp) as DAY
    FROM algorand.account a LEFT JOIN algorand.block b
    ON a.created_at = b.block_id
    WHERE block_timestamp >= '2022-05-1'
    AND block_timestamp <= '2022-05-31'
    GROUP BY DAY
    Run a query to Download Data