Crazy_Kid1M New Algorand Wallets In May 2
    Updated 2022-05-19
    WITH block AS (SELECT address, created_at FROM algorand.account),

    time AS (SELECT block_timestamp, block_id FROM algorand.block WHERE date(block_timestamp) BETWEEN '2022-05-04' AND '2022-05-10'),

    wallets AS (SELECT * FROM block JOIN time on created_at = block_id),

    assets AS (SELECT swapper, swap_to_asset_id FROM algorand.swaps WHERE swapper IN (SELECT address FROM wallets))

    SELECT DISTINCT swap_to_asset_id, asset_name
    FROM assets JOIN algorand.asset on swap_to_asset_id = asset_id
    ORDER BY swap_to_asset_id
    Run a query to Download Data