008 - Main Action Overview

hbd1994008 - Main Action Overview

Updated 2025-02-06

----------------------------------------------------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,

Last run: about 2 months agoAuto-refreshes every 24 hours

	Main Action	Actions	Unique Users	Volume ($)	Average Volume ($)	Median Volume ($)	Maximum Volume ($)	Minimum Volume ($)	Assets
1	Deposit	74195	39916	34071186.9417604	459.211361167	50.13759328	194281.536637467	0	4
2	Withdraw	28859	16313	21087800.235784	730.718328278	50.946845631	111299.702058854	0	4
3	Borrow	27330	14329	12846612.6983322	470.055349372	36.682319664	197888.20396261	9.99952e-7	4
4	Repay	12968	6779	9025220.07819455	695.96083268	27.667758821	136628.531312734	0	4

359B

311s

flipside