SELECT MIN(block_timestamp::date) AS date

FROM flow.defi.ez_bridge_transactions

WHERE bridge = 'blocto'

GROUP BY Flow_wallet_address

),

tbl AS (

SELECT TRUNC(date, 'day') AS day,

COUNT(*) AS New_users,

SUM(COUNT(*)) OVER (ORDER BY TRUNC(date, 'day')) AS cum_New_users

FROM new_user

WHERE date >= '2024-04-01'

GROUP BY 1

SELECT SUM(New_users) AS New_users

FROM tbl;