niloCopy of solana weekly
    Updated 2022-12-20
    WITH new_T as (SELECT min (BLOCK_TIMESTAMP) as TIME,TX_SENDER as users FROM algorand.core.fact_transaction WHERE BLOCK_TIMESTAMP >= CURRENT_DATE - interval'6 months' GROUP BY 2)

    SELECT date_trunc ('week', TIME) as DATE,
    COUNT (DISTINCT users) as New_Users,

    CASE
    WHEN New_Users < 100000 THEN 'Less than 100K New User'
    WHEN New_Users BETWEEN 100000 and 200000 THEN 'Between 100K and 200K New User'
    WHEN New_Users BETWEEN 200000 and 300000 THEN 'Between 200K and 300K New User'
    WHEN New_Users BETWEEN 300000 and 400000 THEN 'Between 300K and 400K New User'
    WHEN New_Users BETWEEN 400000 and 500000 THEN 'Between 400K and 500K New User'
    ELSE 'More than 500K New User' end as type,
    sum (New_Users) over (partition by type order by DATE) as Cum_New_Users
    FROM new_T GROUP BY 1
    Run a query to Download Data