DAY | PROTOCOL_FEE_IN_LAMPORTS | |
|---|---|---|
1 | 2025-04-16 00:00:00.000 | 42627721 |
2 | 2025-04-15 00:00:00.000 | 138383356 |
3 | 2025-04-14 00:00:00.000 | 154574399 |
4 | 2025-04-13 00:00:00.000 | 126326246 |
5 | 2025-04-12 00:00:00.000 | 185777888 |
6 | 2025-04-11 00:00:00.000 | 164946611 |
7 | 2025-04-10 00:00:00.000 | 117594506 |
8 | 2025-04-09 00:00:00.000 | 259713436 |
9 | 2025-04-08 00:00:00.000 | 194785965 |
10 | 2025-04-07 00:00:00.000 | 6628708814 |
11 | 2025-04-06 00:00:00.000 | 5571878403 |
smritiMarginFi protocol fee
Updated 2025-04-16
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
›
⌄
SELECT
DATE_TRUNC('day', ft.block_timestamp) AS day,
SUM(ft.fee) AS protocol_fee_in_Lamports
FROM solana.core.fact_transactions ft
INNER JOIN (
SELECT DISTINCT tx_id
FROM solana.core.fact_decoded_instructions
WHERE
program_id = 'MFv2hWf31Z9kbCa1snEPYctwafyhdvnV7FZnsebVacA'
AND block_timestamp >= CURRENT_DATE - INTERVAL '10 days'
) d ON ft.tx_id = d.tx_id
WHERE block_timestamp >= CURRENT_DATE - INTERVAL '10 days'
AND ft.succeeded = 'true'
GROUP BY 1
ORDER BY day DESC
Last run: about 2 months ago
11
420B
60s