PredictionWallets Created Per Day AFP
    Updated 2022-05-10
    SELECT
    date_trunc('day',block_timestamp) as day,
    count(*) as new_wallets
    FROM algorand.account a
    LEFT JOIN algorand.block b
    ON a.created_at = b.block_id
    WHERE block_timestamp >= current_date -30
    AND block_timestamp < current_date
    GROUP BY day
    ORDER BY day
    Run a query to Download Data