DAY | EVENTS | EVENT_COUNT | |
|---|---|---|---|
1 | 2025-04-25 00:00:00.000 | offerLoan | 2055 |
2 | 2025-04-25 00:00:00.000 | rescindLoan | 1526 |
3 | 2025-04-25 00:00:00.000 | extendLoanV3 | 272 |
4 | 2025-04-25 00:00:00.000 | takeLoanV3 | 237 |
5 | 2025-04-25 00:00:00.000 | repayLoanV3 | 210 |
6 | 2025-04-25 00:00:00.000 | 131 | |
7 | 2025-04-25 00:00:00.000 | forecloseLoanV3 | 66 |
8 | 2025-04-25 00:00:00.000 | extendLoanV3Compressed | 4 |
9 | 2025-04-25 00:00:00.000 | repayLoanV3Compressed | 4 |
10 | 2025-04-25 00:00:00.000 | closeNftList | 2 |
11 | 2025-04-25 00:00:00.000 | closeOrderBook | 2 |
12 | 2025-04-25 00:00:00.000 | takeLoanV3Compressed | 1 |
13 | 2025-04-26 00:00:00.000 | offerLoan | 1959 |
14 | 2025-04-26 00:00:00.000 | rescindLoan | 1306 |
15 | 2025-04-26 00:00:00.000 | extendLoanV3 | 278 |
16 | 2025-04-26 00:00:00.000 | 136 | |
17 | 2025-04-26 00:00:00.000 | takeLoanV3 | 104 |
18 | 2025-04-26 00:00:00.000 | repayLoanV3 | 81 |
19 | 2025-04-26 00:00:00.000 | forecloseLoanV3 | 34 |
20 | 2025-04-26 00:00:00.000 | extendLoanV3Compressed | 7 |
rw2023All events COUNT decoded
Updated 2025-05-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
SELECT
DATE_TRUNC('day', block_timestamp) AS day,
event_type as events,
COUNT(*) AS event_count
FROM
solana.core.fact_decoded_instructions
WHERE
program_id = 'SHARKobtfF1bHhxD2eqftjHBdVSCbKo9JtgK71FhELP'
AND block_timestamp >= CURRENT_DATE - INTERVAL '1 MONTH'
GROUP BY
day, events
ORDER BY
day, event_count DESC;
Last run: 2 months ago
...
346
16KB
2s