PS0G1eth 1
    Updated 2022-11-25
    with new_user as (
    SELECT
    min(BLOCK_TIMESTAMP) as min_date,
    FROM_ADDRESS
    FROM ethereum.core.fact_transactions
    WHERE TO_ADDRESS in ('0x07ced903e6ad0278cc32bc83a3fc97112f763722', '0x2657101a6bb5538dd84b0b8c8e2deac667b9c66c',
    '0x13e9053d9090ed6a1fae3f59f9bd3c1fca4c5726')
    GROUP by 2
    )
    SELECT
    min_date::DATE as date,
    COUNT(DISTINCT FROM_ADDRESS) as newUser_cnt,
    sum(newUser_cnt) over (order by date) as cum_newUser_cnt
    FROM new_user
    GROUP by 1
    order by 1
    Run a query to Download Data