SELECT

MIN(block_timestamp::date) AS first_event_date,

origin_from_address,

block_timestamp,

TX_HASH,

service_id

FROM

crosschain.olas.fact_service_events

GROUP BY

origin_from_address, block_timestamp, TX_HASH, service_id

SELECT

COUNT(DISTINCT origin_from_address) AS total_new_users,

COUNT(DISTINCT TX_HASH) AS total_tx_count,

COUNT(DISTINCT service_id) AS total_services

FROM

event_data

WHERE

TRUNC(block_timestamp, 'day') >= '2024-01-01';