0xBlackfish4a. Soo Total Stats
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
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with
lender as (
select
t.block_timestamp,
t.tx_id,
t.signers[0] AS lender,
inner_instructions[0]:instructions[0]:parsed:info:lamports / 1e9 AS loan_amount,
inner_instructions[0]:instructions[1]:parsed:info:lamports / 1e9 AS fee
from solana.core.fact_transactions t
left join solana.core.fact_events e ON t.tx_id = e.tx_id
and t.block_timestamp = e.block_timestamp
where program_id = 'SHARKobtfF1bHhxD2eqftjHBdVSCbKo9JtgK71FhELP'
and date(t.block_timestamp) between date('2022-11-01') and date('2023-10-31')
and substr(log_messages[1]::string, 27) = 'OfferLoan'
and e.succeeded = 'TRUE'
),
borrower as (
select
t.block_timestamp,
t.tx_id,
inner_instructions,
log_messages,
t.signers[0] AS borrower
from solana.core.fact_transactions t
left join solana.core.fact_events e ON t.tx_id = e.tx_id
and t.block_timestamp = e.block_timestamp
where program_id = 'SHARKobtfF1bHhxD2eqftjHBdVSCbKo9JtgK71FhELP'
and date(t.block_timestamp) between date('2022-11-01') and date('2023-10-31')
and substr(log_messages[1]::string, 27) = 'TakeLoan'
and e.succeeded = 'TRUE'
)
SELECT
COUNT (DISTINCT l.tx_id) AS lend_tx,
COUNT (DISTINCT b.tx_id) AS borrow_tx,
Run a query to Download Data