Crazy_KidNew Active Users
    Updated 2022-05-09
    WITH dataset AS (SELECT DISTINCT from_address as wallets, min(block_timestamp) as block_timestamp
    FROM ethereum.udm_events
    WHERE to_label='paraswap' AND date(block_timestamp) BETWEEN '2022-03-01' and '2022-04-30' AND from_label_type IS NULL
    GROUP BY from_address)

    SELECT date(block_timestamp) as date, COUNT(wallets) as no_of_new_wallets
    FROM dataset
    GROUP BY date
    ORDER BY date
    Run a query to Download Data