hbd1994004 - TVL
Updated 2025-02-06
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
›
⌄
----------------------------------------------------Price----------------------------------------------------
with Price as (
select *
from $query('d479e778-d9fb-4429-b6f6-674f57216c22')),
--------------------------------------------------Initialize----------------------------------------------------
Initialize as (
select
BLOCK_TIMESTAMP,
TX_ID,
INSTRUCTION:accounts[0] as Astrolend_Group,
INSTRUCTION:accounts[1] as Astrolend_Account,
INSTRUCTION:accounts[2] as Authority,
INSTRUCTION:accounts[3] as Fee_Payer
from eclipse.core.fact_events
where program_id = 'Astro1oWvtB7cBTwi3efLMFB47WXx7DJDQeoxi235kA'
and SUCCEEDED = 'TRUE'
and substr(replace(substr(utils.udf_base58_to_hex(INSTRUCTION:data), 3, 1000), ''), 0, 16) = '3edc10f0a7ec486b'
order by 1),
---------------------------------------------------Deposit----------------------------------------------------
Deposit as (
select
a.BLOCK_TIMESTAMP,
a.TX_ID,
a.INSTRUCTION:accounts[0] as Astrolend_Group,
a.INSTRUCTION:accounts[1] as Astrolend_Account,
a.INSTRUCTION:accounts[2] as Signer,
a.INSTRUCTION:accounts[3] as Bank,
a.INSTRUCTION:accounts[4] as Signer_Token_Account,
a.INSTRUCTION:accounts[5] as Bank_Liquidity_Vault,
b.mint as Asset_Address,
d.token_symbol as Asset_Symbol,
b.amount/pow(10 , b.decimal) as Amount,
Auto-refreshes every 12 hours
QueryRunArchived: QueryRun has been archived