SELECT

DATE_TRUNC('week', BLOCK_TIMESTAMP)::date AS week_start_date,

event_name AS "Event",

COUNT(DISTINCT tx_hash) AS "Txns Count",

COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS "Users Count",

COUNT(DISTINCT OWNER_ADDRESS) AS "Owner Count"

FROM

crosschain.olas.ez_service_staking

event_name = 'ServiceStaked' -- Include only staking events

AND BLOCK_TIMESTAMP >= '2023-05-08' -- Start from 2023-05-08

GROUP BY

week_start_date, event_name

ORDER BY

week_start_date ASC; -- Order by date in ascending order