No Data to Display
aPriorishMonad_TVL
Updated 5 days 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
›
⌄
-- with stake_event_logs_dim as
-- (
SELECT
tx_hash,
ORIGIN_FUNCTION_SIGNATURE
from monad.testnet.fact_event_logs
where TX_SUCCEEDED
-- and ORIGIN_FUNCTION_SIGNATURE = '0xd5575982'
-- and ORIGIN_TO_ADDRESS = '0x2c9c959516e9aaedb2c748224a41249202ca8be7'
and CONTRACT_ADDRESS =lower('0x3a98250F98Dd388C211206983453837C8365BDc1')
and tx_hash='0x8233b4967fa7706c70c75b77704f0d6742666e7a9296b06e1d32e9eb76833c78'
group by 1,2
-- )
-- lst_deposit_action_dim as
-- (
-- select
-- BLOCK_TIMESTAMP
-- ,FROM_ADDRESS
-- ,TO_ADDRESS
-- ,tx_hash
-- ,value as stake_amount
-- from monad.testnet.fact_traces
-- -- where tx_hash in (select tx_hash from stake_event_logs_dim where ORIGIN_FUNCTION_SIGNATURE='0xd5575982')
-- where tx_hash in (select tx_hash from stake_event_logs_dim group by 1 )
-- and TO_ADDRESS=lower('0x3a98250F98Dd388C211206983453837C8365BDc1')
-- and value>0
-- ),
-- lst_redeem_action_dim as
-- (
-- select
-- BLOCK_TIMESTAMP
-- ,FROM_ADDRESS
Last run: 5 days ago
0
2B
13s