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 "$gMON 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 = lower ('0x2c9C959516e9AAEdB2C748224a41249202ca8BE7')

and a.ORIGIN_TO_ADDRESS = lower ('0x2c9C959516e9AAEdB2C748224a41249202ca8BE7')

and a.ORIGIN_FUNCTION_SIGNATURE = '0xd5575982'

and a.TX_SUCCEEDED = 'TRUE'

SELECT

DATE_TRUNC(DAY, BLOCK_TIMESTAMP) AS date,

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

sum ("Total stake tx") over (order by date) as "Cumualtive stake tx",

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

sum ("Total unique stakers") over (order by date) as "Cumualtive stakers",

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

sum ("Total $MON staked") over (order by date) as "Cumualtive $MON staked",

SUM("$gMON Received") AS "Total $gMON minted",

sum ("Total $gMON minted") over (order by date) as "Cumualtive $gMON minted",

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

sum ("Total fee ($MON)") over (order by date) as "Cumualtive fee ($MON)"

FROM database

GROUP BY 1

order by 1