lanoGas Fee Burned by Kaiaswap
Updated 2024-11-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with fee as (
SELECT tx.tx_hash, tx.effective_gas_price as price, tr.gas_used as gas
FROM kaia.core.fact_traces tr left join kaia.core.fact_transactions tx
on tr.tx_hash = tx.tx_hash
WHERE tr.to_address IN (
'0xd37243e3ee3064046380c57e1073cde53761369a',
'0x050bb0533a273b509ec502d5bf47dbb07d44c5bc',
'0x4037ce3f802336b0682a821378b7b1e0ff52737b',
'0xe833e5e3a52839ff2a167eb5f3077f254d9d63e9',
'0x5ff11b24e98c8faba612f79d5c2d6cd64407bec3'
) OR tr.from_address IN (
'0xd37243e3ee3064046380c57e1073cde53761369a',
'0x050bb0533a273b509ec502d5bf47dbb07d44c5bc',
'0x4037ce3f802336b0682a821378b7b1e0ff52737b',
'0xe833e5e3a52839ff2a167eb5f3077f254d9d63e9',
'0x5ff11b24e98c8faba612f79d5c2d6cd64407bec3'
)
)
select sum(price*gas/1e9) as "Kaiaswap Gas Fee Burned"
from fee
QueryRunArchived: QueryRun has been archived