0xHaM-dLending Event by Asset
Updated 2025-01-10
999
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 Lending Event Over Time @ https://flipsidecrypto.xyz/studio/queries/3330f11d-4df1-4cca-8796-11d898833e31
with token_info as (
SELECT
SYMBOL,
TOKEN_ADDRESS,
DECIMALS
from aptos.core.dim_tokens
)
,
LendingAddLiquidity as (
SELECT
BLOCK_TIMESTAMP,
TX_HASH,
SENDER,
EVENT_DATA:amount/pow(10, DECIMALS) as amount,
EVENT_DATA:app as app,
SYMBOL,
EVENT_DATA:token as token_add
FROM aptos.core.fact_events
JOIN aptos.core.fact_transactions using(TX_HASH)
JOIN token_info on token_add = TOKEN_ADDRESS
WHERE PAYLOAD_FUNCTION in (
'0x17f1e926a81639e9557f4e4934df93452945ec30bc962e11351db59eb0d78c33::aries::lend'
,'0x17f1e926a81639e9557f4e4934df93452945ec30bc962e11351db59eb0d78c33::meso_lending::lend_coin'
)
-- WHERE TX_HASH in (
-- '0x17f1e926a81639e9557f4e4934df93452945ec30bc962e11351db59eb0d78c33' -- ::aries::lend
-- '0x6136b92a6b2cd1eb29b23767a1cce24e63e447b40c99981ce129915ec958b8e6' --::meso_lending::lend_coin
-- )
AND SUCCESS = TRUE
AND TX_TYPE = 'user_transaction'
AND EVENT_MODULE = 'lending_events'
AND EVENT_RESOURCE = 'LendingAddLiquidity'
)
, LendingRemoveLiquidity as (