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'

"Staker",

sum ("$MON Staked") as "Total $MON Staked",

count (distinct TX_HASH) as "Stake tx"

from database

group by 1

order by 2 desc

limit 100