MrftiMagma overview
Updated 5 hours ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from Kintsu overview copy @ https://flipsidecrypto.xyz/studio/queries/0147cdf7-b1fa-45bd-a475-80831ca021ac
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