MLDZMNLends
Updated 2023-09-20
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
›
⌄
with lend as (select
tx_id,signers[0] as lender
from solana.core.fact_transactions s
join (select distinct block_timestamp, tx_id
from solana.core.fact_events where succeeded = True
and program_id = '5D9yi4BKrxF8h65NkVE1raCCWFKUs5ngub2ECxhvfaZe'
) events
using(tx_id, block_timestamp)
join lateral flatten (input => log_messages) logs
where BLOCK_TIMESTAMP >= current_date-{{Days_back}}
and logs.value in('Program log: Instruction: LoanFund','Program log: Instruction: OpenTermLoanFund')
)
select
s.tx_id,
s.BLOCK_TIMESTAMP as date,
lender,
amount,
'USDC' as token
from solana.core.fact_transfers s
left join lend l on s.tx_id=l.tx_id
where s.tx_id in (select tx_id from lend)
--and tx_to = '7Vqn5fdwckZadYVoH312aErP8PqNGNUx8WDrvKAHYfMd'
and mint='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
Run a query to Download Data