aPrioriKINTSU_TVL
Updated 2025-03-13Copy Reference Fork
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
›
⌄
with event_logs_dim as
(
SELECT
BLOCK_TIMESTAMP,
ORIGIN_FROM_ADDRESS,
tx_hash,
data,
ORIGIN_FUNCTION_SIGNATURE
from monad.testnet.fact_event_logs
where ORIGIN_FUNCTION_SIGNATURE in ('0x3a4b66f1','0x30af6b2e')
and TX_SUCCEEDED = 'TRUE'
and CONTRACT_ADDRESS = '0x07aabd925866e8353407e67c1d157836f7ad923e'
),
lst_deposit_action_dim as
(
select
BLOCK_TIMESTAMP
,tx_hash
,value as stake_amount
from monad.testnet.fact_traces
where tx_hash in (select tx_hash from event_logs_dim group by 1)
and ORIGIN_FUNCTION_SIGNATURE='0x3a4b66f1'
and value>0
),
lst_redeem_action_dim as
(
select
BLOCK_TIMESTAMP
,tx_hash
,CAST(ethereum.public.udf_hex_to_int(data) AS NUMERIC) / 1e18 AS redeem_amount
from event_logs_dim
where ORIGIN_FUNCTION_SIGNATURE='0x30af6b2e'
QueryRunArchived: QueryRun has been archived