WITH database AS (

SELECT

a.BLOCK_TIMESTAMP,

a.TX_HASH,

a.ORIGIN_FROM_ADDRESS AS "Staker",

b.value AS "$MON Staked",

CAST(ethereum.public.udf_hex_to_int(data) AS decimal) / 1e18 AS "$sMON Received",

b.tx_fee AS "Fee ($MON)"

FROM

monad.testnet.fact_event_logs a

JOIN monad.testnet.fact_transactions b ON a.tx_hash = b.tx_hash

WHERE

a.CONTRACT_ADDRESS = '0x07aabd925866e8353407e67c1d157836f7ad923e'

AND a.ORIGIN_TO_ADDRESS = '0x07aabd925866e8353407e67c1d157836f7ad923e'

AND a.ORIGIN_FUNCTION_SIGNATURE = '0x3a4b66f1'

AND a.TX_SUCCEEDED = 'TRUE'

),

first_time_stakers AS (

SELECT

"Staker",

MIN(DATE_TRUNC(DAY, BLOCK_TIMESTAMP)) AS first_stake_date

FROM database

GROUP BY "Staker"

),

daily_metrics AS (

SELECT

DATE_TRUNC(DAY, d.BLOCK_TIMESTAMP) AS date,

COUNT(DISTINCT d.TX_HASH) AS "Total stake tx",

COUNT(DISTINCT d."Staker") AS "Total unique stakers",

SUM(d."$MON Staked") AS "Total $MON staked",

SUM(d."$sMON Received") AS "Total $sMON received",

SUM(d."Fee ($MON)") AS "Total fee ($MON)",