Pine Analyticsripe-maroon
    Updated 2024-11-01
    SELECT
    week,
    count(*) as new_creators,
    sum(new_creators) over (order by week) as total_creators

    FROM (
    SELECT
    ORIGIN_FROM_ADDRESS,
    date_trunc('week', min(block_timestamp)) as week
    from base.core.fact_event_logs
    WHERE ORIGIN_TO_ADDRESS like lower('0x428aeF7fB31E4E86162D62d4530a4dd7232D953D')
    AND origin_function_signature like '0x195cf3ce'
    group by 1
    )
    GROUP BY 1
    order 2



    QueryRunArchived: QueryRun has been archived