niloCopy of Copy of Copy of ethereum weekly
    Updated 2022-12-20
    WITH new_T as (SELECT date_trunc ('week', BLOCK_TIMESTAMP) as TIME,TX_SENDER,COUNT (DISTINCT TX_GROUP_ID) as TXN FROM algorand.core.fact_transaction WHERE BLOCK_TIMESTAMP >= CURRENT_DATE - interval'6 months' GROUP BY 1,2)

    SELECT TIME,
    COUNT (DISTINCT TX_SENDER) as Users,
    sum (Users) over (order by TIME) as Cum_New_Users
    FROM new_T WHERE TXN >= 5 GROUP BY 1
    Run a query to Download Data