with Price as (

select *

from $query('d479e778-d9fb-4429-b6f6-674f57216c22')),

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