SELECT CONCAT('0x', SUBSTR(HEX_ENCODE(data), 25, 40)) as from_address,

MIN(block_timestamp) AS first_transaction

FROM sei.core_evm.fact_event_logs

where contract_address = lower('0x516e70AB91f817f4a7ba8aa02BEc44a6532c4E33')

and topics[0] = '0xd81a1e0b3e53a9626cad7adf81ed6e0515e18b63d2b6b4bb2748090335759873'

and block_timestamp::date >= '2024-05-01'

GROUP BY 1

),

BaseTable AS (

SELECT

CONCAT('0x', SUBSTR(HEX_ENCODE(data), 25, 40)) as from_address,

date_trunc('week', block_timestamp) AS transaction_week,

MIN(date_trunc('week', block_timestamp)) OVER (PARTITION BY from_address) AS earliest_date,

DATEDIFF('week', MIN(date_trunc('week', block_timestamp)) OVER (PARTITION BY from_address), date_trunc('week', block_timestamp)) AS difference

FROM

sei.core_evm.fact_event_logs

where block_timestamp::date >= '2024-05-01'

),

CountNewUsers AS (

SELECT

earliest_date,

COUNT(DISTINCT from_address) AS new_users

FROM

BaseTable

GROUP BY

earliest_date

),

CountReturningUsers AS (

SELECT

earliest_date,

difference,