elsina2024-07-08: 24h new user
    Updated 2024-07-09
    with new_users AS (
    SELECT
    origin_from_address as user,
    MIN(block_timestamp) AS date
    FROM
    arbitrum.defi.ez_dex_swaps
    GROUP BY
    user
    )

    SELECT
    COUNT(*) AS new_user
    FROM
    new_users
    where date::date = current_date - interval '1 day'



    QueryRunArchived: QueryRun has been archived