Total Fee Generated | |
|---|---|
1 | 66670.980859104 |
rezarwzTotal Fee Generated
Updated 2025-02-26
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
›
⌄
with fee as (
SELECT
DECODED_LOG:amount / pow(10, 18) as fee_generated,
tx_hash
FROM
blast.core.ez_decoded_event_logs ev
where
ev.contract_address in(
'0x6a3796c21e733a3016bc0ba41edf763016247e72',
'0x739f0331594029064c252559436edce0e468e37a'
)
and event_name = 'FeeCharged'
union
all
SELECT
- DECODED_LOG:amount / pow(10, 18) as fee_generated,
tx_hash
FROM
blast.core.ez_decoded_event_logs ev
where
ev.contract_address = '0x397fceddfbeb4418b4062d42fc6200af829c6766'
and event_name = 'FeeRefunded'
)
SELECT
sum(FEE_GENERATED) as "Total Fee Generated"
FROM
fee
Last run: about 2 months ago
1
19B
6s