Pine Analyticsrobust-bronze
    Updated 2024-08-28
    SELECT
    date_trunc('week', block_timestamp) as week,
    count(DISTINCT ORIGIN_FROM_ADDRESS) as active_users

    FROM base.core.fact_event_logs
    WHERE CONTRACT_ADDRESS LIKE lower('0x0e22B5f3E11944578b37ED04F5312Dfc246f443C')
    GROUP by 1

    QueryRunArchived: QueryRun has been archived